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:
Launch Details Release track: Launching to both Rapid release and Scheduled release
Available to all G Suite editions Rollout pace: Gradual rollout (potentially longer than 3 days for feature visibility) Impact: All end users |
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
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.
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
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.
Wednesday, February 15, 2017
GSfE Update: Link to Cell Ranges in Google Sheets
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!
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!
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.
Thursday, February 2, 2017
What you should know about the Chrome Browser
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?
Launch Details
Release track:
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.
Release track:
Available to all G Suite editions
Rollout pace:
Rollout pace:
Full rollout (1-3 days for feature visibility)
Impact:
Impact:
Admins and users
Action:
Action:
Change management suggested/FYI
Admin action suggested/FYI for those who manage Chrome Browser for their users.
Admin action suggested/FYI for those who manage Chrome Browser for their users.
More Information
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
Subscribe to:
Posts (Atom)