Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

5 Google Sheets Essentials

5 Google Sheets Essentials

YouTube video

 

Get Your Students Rocking Google Sheets

Spreadsheets are an essential digital literacy. Any manager needs to use spreadsheets. Students of any age can use spreadsheets; check out Christine Pinto and how she has her kindergarteners write spreadsheet formulas. Get students started by learning these key skills:

Increase Column and Row Width

Get your cursor between the column or row indicators. Notice the arrow changes. Click down and DRAG! Select multiple rows or columns at once and resize one to resize the entire selection.

Set Word Wrap

“Middle, Middle, Middle.” Look in the toolbar for the centering icon. The 3 icons next to each other allow you to center horizontally, vertically, and set word wrap. The middle option on the 3rd icon sets the word wrap.
Wrap the text in google sheets

Create Column Headers

Always label what you are putting in the spreadsheet. It is not uncommon to use the first row to type out what is going to go in that column.

Freeze the First Row

When you have column headers you want to freeze that first row so that when you scroll the column headers are not lost. There are 2 ways to freeze the first row. Use the View menu to choose “Freeze” or look up in the “awesome box” to the left of column A and above row 1. Hover the mouse right above the row 1 indicator and it will change into a hand. Click and hold down on that freeze bar and drag it down to freeze the first row.
Freeze the first row

Merge Cells

“What can you NOT do in a spreadsheet?” is my response when asked, “What can you use spreadsheets for?” Spreadsheets are so versatile and useful you can do almost any assignment utilizing a spreadsheet. To make this true, merging cells is an essential skill. This allows you to create a giant box to put paragraphs of text. Highlight a region of cells and find the merge icon in the toolbar. This looks like a box with 2 arrows pointing towards each other. Click the merge icon and boom, you have a giant textbox.
Merge Cells



5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d