The Tech Lady

Author, Host of The Suite Talk, Google Certified Trainer & Educator, Gold Product Expert, GEG NJ Leader & Mentor, Wakelet, Book Creator, WeVideo, Mote, IORad, Ozobot Ambassador, EdPuzzle Coach, Teacher

Thursday, February 23, 2017

Formatting Improvements in Google Sheets




Support for rotated text, accounting number formats, and more in Google Sheets
Posted: 22 Feb 2017 01:18 PM PST
We’re working hard to ensure that Google Sheets meets your business needs. As part of that effort, today we’re introducing several enterprise-friendly features that you’ve been asking for in Sheets on the web, Android, and iOS:

Rotated text
You can now rotate the text in a cell in Sheets (Format > Text rotation). This is especially useful when you need to fit long header names into thin columns, or when you simply want to fit more text on a single screen.


Accounting number formats
We’re making it easier to read your budgets, expense reports, and other spreadsheets containing monetary amounts by aligning the currency symbols within them (Format > Number > Accounting). We’re also making improvements to the way numbers, decimal points, and repeated characters line up to make them simpler to scan and analyze.


More border styles
You can now choose from several new border styles in Sheets, including various thicknesses and double borders, which are commonly used in financial statements like balance sheets (Toolbar > Borders > Border styles).

Additional improvements on mobile
In addition to the features described above, we’re also launching the following improvements to our mobile apps:
  • Support for using a mouse with the Sheets Android app
  • Ability to view and select existing custom colors in the Sheets Android app
  • Ability to drag and drop rows and columns in the Sheets Android and iOS apps
  • Formatting suggestions in Explore in the Sheets iOS app
For more details, check out the Help Center articles below.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release
  • All mobile features
  • Additional border styles on the web
Launching to Rapid release, with Scheduled release coming on March 6, 2017
  • Rotated text on the web
  • Accounting number formats on the web
Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users
Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Sunday, February 19, 2017

Did you try Bloxels yet?





Have you heard of a hands-on game for kids to experiment, build, and learn through video game creation and at the same time acquire computer science skills?  Bloxels will provide all of these experiences for students.  While students are creating their own video games, they are engaged, collaborating, and acquiring crucial skills that will help them be successful in their future.

Bloxels is a game that uses a game board and the Bloxels app, which can be found at the Apple Store, or Google Play store.  It will allow students to build, capture, design, play and share their video games. Additionally, students can create a game or room layouts, pixel art, animations, backgrounds, and characters.  Bloxels is considered to be a  platformer game which similar to Mario Brothers by Nintendo.

This game will expose students to many computer science concepts such as coding, problem solving, critical thinking, logical thinking, creativity, collaboration, communication, and provide them with innovative opportunities. Applying these skills are very important in today's society and will be beneficial throughout their lives, especially in the job market when they graduate from school.

What's included in the box set?




The game board is a physical board that has 13 rows x 13 columns, for a total of 169 boxes or rooms.  It also comes with 9 different colored cubes where each color represents a different purpose.  See the chart below.




Create an Account

In order for students to utilize this platform, they will need to download the app to their device and create an account.  I recommend that the students create an account so that they can save their progress.  The teacher or parent will receive an email to confirm the account.  Once this is completed, students can save their progress to their account.  If an account is not created, the students can still create and build, however they will be in guest mode, where the progress is not saved.

Let's Get Started
I would recommend that students work in small groups of 2-3 and each group should have their own Bloxels Set.  Students can work together on creating characters, backgrounds, layouts, and animations.  This is possible because the app can capture what is completed on the physical board using the device's camera, while a student uses the app to create.

For example, student A can create a character on the physical board, and student B can create a room layout in the app.  Student A simply captures the character layout on the physical board using the device's camera.  Now, the group has 1 character and 1 room layout completed.
My Experience
I found students who used Bloxels were completely engaged!  They worked well together to complete their game.  They used problem solving and critical thinking skills to connect and layout the rooms, animate the characters, provide dialog and rewards, and plan for enemies.
I am new to this game and I used it with ten 8th grade STEM students. They were able to navigate the interface easily and teach me more about the game.  They were able to complete many rooms and characters, create checkpoints in rooms, create power-ups and animations, and plan for enemy attacks.  
I explained to them that Computer Science is logical thinking and that it is a repetitive process.  In order for the game to be successful, they needed to create the layout, test the layout, and fix any problems with the layout.  This is a process that all programmers or coders use on a daily basis.  In addition, they needed to portray patience, and that failure is an opportunity to learn.
Here is a short slideshow of some pictures I took during class.

What's next?  STEM, STEAM implementation
I plan on using Bloxels with students in all subjects, especially in science, math, and art class.  This game portrays digital storytelling and can be used at any grade level in any subject area.  

Here are a few examples:  

History
Students can create a game to replicate a scene from the Civil War that includes soldiers, and enemy characters, and a scene.  

Math
Assign a numerical value to each color cube and have students create a game and have them write and solve the equation.  

Science
Students can create a game to replicate the effects of global warming, storms, volcanoes, states of matter.

Language Arts
Students can create a game to show the journey of a character in a novel. 

Art
Students can create a game to show different concepts of Art through a specific time period.
  
The possibilities are endless!

My Recommendation

I would highly recommend trying this game.  I was able to get 4 sets of the game by creating a Donors Choose project.  My project was fully funded by strangers from around the country.  I was truly amazed with people's generosity and at the same time, very thankful.  Donors Choose sent me the materials within 2 weeks of my project being funded. It was an easy process and I would do it again!

Check out the process on creating a project on Donors Choose by visiting their website.  It is definitely worth a try!  

In Conclusion
By allowing students to take control of their learning, they will take ownership in their assignments, become student leaders and have a sense of pride in their assignment. This game and technology allows students to be successful and allows them to utilize 21st century skills that will help them be successful lifelong learners.
Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, February 15, 2017

GSfE Update: Link to Cell Ranges in Google Sheets




Google release a new feature of Google Sheets that will allow you to link to cell ranges.  This is a great new feature if you have large spreadsheets and need to go to a specific area in a sheet or to a different sheet.

I create an animation on linking to cell ranges in Google Sheets.

You can also read more about it on the G Suite Update blog.

Enjoy!


Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, February 14, 2017

Customize Digital Badges



I provide a lot of professional development to staff at my school district throughout the year. While other facilitators may provide treats or other types of rewards for their attendees, instead, I reward them with a customized digital badge.

Last year, I started to distribute digital badges for all of the attendees in my professional development sessions.  Although I received little feedback from them, I still sent it out.  I felt they deserved it and can proudly display their badge and brag about it.  

So how did I do it? First, I used a Google Form to collect their information, including their name, and email address and all of the responses get recorded into a Google Spreadsheet.  

Then, I used the Bitmoji extension to create my avatar. This extension can be found on the Chrome Web store.  I created a new Google document and activated the extension in the browser.  I searched the library to find a Bitmoji that had a positive message or emotion.  There are tons to choose from.   




Once you choose your category, pick the specific Bitmoji from the category by dragging it into the Google document.  Capture it using a screen capturing tool such as Windows Snipit, Jing, Nimbus or Snagit and be sure to save the file to your device or to Google Drive.

Finally, I used Credly to create the customized badge. This application gives you the option to customize the badge shape, icon, text, border and colors.  I found this tool to be user friendly and quick to learn.  I would highly recommend that you try it by creating a free account.

After you create your badge, it is time to give credit it to the attendees or students in your class via email.  Simply go to 'Give' from the menu, select 'Choose an Existing Credit', fill in the recipient's first and last names and email address as shown below.  Once completed, simply click 'Send Credit'. The recipient will receive your digital badge.

  

Once you start creating badges, you will get addicted! I use them all the time to reward teachers, and students on their accomplishments in my class or professional development sessions. 

Here is a short animation on using Bitmoji and Credly to create customized digital badges.

Enjoy!









Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, February 9, 2017

GSfE Update: Insert Google Drive Videos into Slides



Google has released a new update that will allow you to insert videos from Google Drive into Google Slides.  Prior to this update you were limited to only inserting videos from YouTube.  With this new update, you will have the option to be able to loop the video, start it and end it at a specific time, and mute the audio.  To get these options, simply right click on the video.

I created a short animation on this new feature.  

Enjoy!



Click here to read the official G Suite for Education update blog post. 




Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, February 2, 2017

What you should know about the Chrome Browser


Gmail no longer supporting Chrome Browser version 53 and below
Posted: 01 Feb 2017 09:35 AM PST
Starting February 8, 2017, we will show a banner at the top of the Gmail interface for users who are still on Google Chrome Browser v53 and below to encourage upgrading to the latest version of Chrome, currently on version 55. Chrome Browser v55 contains several important security updates.

Gmail users that are still on Windows XP and Windows Vista are the most likely to be affected, because v49 was the last released version which supported those operating systems. As previously announced in April 2015 and November 2015, these systems are no longer maintained by Microsoft, and we strongly encourage you to migrate to more secure and supported systems.

What happens if users continue to use Chrome Browser v53 and below? 
  • If you continue to use older versions of Chrome Browser now that support has ended, Gmail will be more vulnerable to security risks and users will not have access to new features and bugfixes.
  • Gmail will continue to function on Chrome Browser v53 and below through the end of the year. Users who remain on Chrome v53 and below could be redirected to the basic HTML version of Gmail as early as Dec 2017.
Recommendation
  • If you manage Chrome Browser for your users, we strongly encourage you to update users to the latest version of Chrome. Depending on what operating system your users are on, you may need to migrate them to a supported system to get the latest version and features.
Please note: Google does not typically announce when we discontinue support for older versions of Chrome browser because of our current supported browser policy, which states that only the most recent version of Chrome is supported. This announcement was made given the expected impact on Windows XP and Windows Vista users and known security risks.


Launch Details 

Release track:
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1-3 days for feature visibility)

Impact:
Admins and users

Action:
Change management suggested/FYI
Admin action suggested/FYI for those who manage Chrome Browser for their users.

More Information
Help Center: Supported browsers for G Suite
Help Center: Control auto-updates in Chrome


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, February 1, 2017

Teacher Tips from Google for Education




Every Tuesday Google for Education releases tips on three of their apps, Google Expeditions, Google Forms, and Google Classroom.  All of these tips are very helpful and are submitted by everyday users.  

Click on the links to access the information.  The tips are cumulative, so you can go back and reference tips from weeks ago.

Enjoy!

Google Classroom https://goo.gl/WcJdpp  Google Forms https://goo.gl/f36Hjz  Google Expeditions https://goo.gl/sWtqWC 






Posted by Kimberly Mattina
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

The Tech Lady Logo

The Tech Lady Logo

Image

Image

About Me

Hi, my name is Kimberly Mattina and I a Technology Teacher who is passionate about technology, Computer Science EDU, and helping other educators effectively integrate technology into the classroom. My show, The Suite Talk supports this movement using the #PayitForward hashtag.

My goal is to blog about new and interesting technology tools, tips, ideas and my experiences using technology. I hope you enjoy reading my blog.


The Suite Talk

The Suite Talk

Twitter Feed

Tweets by @The_Tech_Lady

  • 186 What‘s IncludEDU with Ryan Evans
  • 185 The magic beneath the surface of edutech with Patrick Hausammann
  • 184 An overview of Pixton EDU with Tristan Heron

Blog Archive

  • ►  2021 (7)
    • ►  May (2)
    • ►  April (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2020 (17)
    • ►  October (1)
    • ►  August (2)
    • ►  July (2)
    • ►  May (2)
    • ►  April (3)
    • ►  March (6)
    • ►  February (1)
  • ►  2019 (14)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (4)
  • ►  2018 (16)
    • ►  November (1)
    • ►  October (2)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  May (3)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ▼  2017 (37)
    • ►  November (2)
    • ►  October (1)
    • ►  September (4)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (4)
    • ►  April (7)
    • ►  March (5)
    • ▼  February (7)
      • Formatting Improvements in Google Sheets
      • Did you try Bloxels yet?
      • GSfE Update: Link to Cell Ranges in Google Sheets
      • Customize Digital Badges
      • GSfE Update: Insert Google Drive Videos into Slides
      • What you should know about the Chrome Browser
      • Teacher Tips from Google for Education
    • ►  January (4)
  • ►  2016 (54)
    • ►  December (4)
    • ►  November (2)
    • ►  October (5)
    • ►  September (4)
    • ►  August (3)
    • ►  June (2)
    • ►  May (7)
    • ►  April (6)
    • ►  March (8)
    • ►  February (6)
    • ►  January (7)
  • ►  2015 (140)
    • ►  December (8)
    • ►  November (10)
    • ►  October (8)
    • ►  September (14)
    • ►  August (4)
    • ►  July (13)
    • ►  June (16)
    • ►  May (10)
    • ►  April (17)
    • ►  March (14)
    • ►  February (11)
    • ►  January (15)
  • ►  2014 (131)
    • ►  December (15)
    • ►  November (11)
    • ►  October (12)
    • ►  September (6)
    • ►  August (7)
    • ►  July (12)
    • ►  June (19)
    • ►  May (13)
    • ►  April (14)
    • ►  March (11)
    • ►  February (6)
    • ►  January (5)
  • ►  2013 (21)
    • ►  December (4)
    • ►  November (2)
    • ►  October (3)
    • ►  September (2)
    • ►  August (2)
    • ►  June (1)
    • ►  May (2)
    • ►  April (1)
    • ►  March (3)
    • ►  January (1)
  • ►  2012 (18)
    • ►  December (2)
    • ►  November (3)
    • ►  October (3)
    • ►  September (10)





Google for Education Gold Product Expert

Google for Education Gold Product Expert


Vote for Me


Bammy! Award Nominee

Bammy! Award Nominee

VoiceBoks Award

VoiceBoks Award
Voted #1 for Top Tech and Internet Savvy Blogs from VoiceBoks
Theme images by gaffera. Powered by Blogger.