Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Try This It’s Easy – Google Sheets: Count Stuff

Count Google Sheets

Try This It’s Easy – Google Sheets: Count Stuff

Count Google Sheets count

Use Spreadsheets

image
TK teacher Christine Pinto displays the spreadsheet charts her 4-year-olds made in Google Sheets.

Spreadsheets are an incredibly valuable life skill. Students of any age can use them. Essentially you have a grid to put stuff in, doesn’t have to be numbers. Help students to sort and organize information by doing tasks in Google Sheets.

Count

In Google Sheets, highlight a range of data (stuff). Automatically the count of the items will appear in the bottom right-hand corner.
Count in Google Sheets



Chart

Google Sheets can create charts from items that are highlighted in the spreadsheet. Use the Insert menu to insert a chart.
insert chart google sheets

Google Sheets will automatically suggest a chart based on the data. But is this the best chart? Under the “Chart types” tab are more options. Ask students to justify their chart choice. Why does that best “clearly communicate their ideas?”
Google sheets chart types

Chart Options

Notice on the chart is a small drop down arrow in the upper right. You will need to click on the chart first to activate the arrow. This allows you to edit the chart and do advanced options. You can “Save image” to use the chart in other applications, a PNG file will be downloaded to your computer.
Edit the chart

Insert Chart into Slides

If you are using Google Docs or Google Slides you can insert the charts from Google Sheets easily. Use the Insert menu in Google Docs or Google Slides and choose “Chart” and “From Sheets….” Browse for the spreadsheet you were using and any charts in the spreadsheet will be an option to insert into your Google Doc or Google Slides presentation. The chart is connected to the spreadsheets so edits to the spreadsheet that affect the chart will be updated.
insert chart from sheets

The chart does not automatically update in Google Docs or Slides. After updating the spreadsheet, an option to “Update” the chart will appear.
update the chart in Google Slides



Collaborative Discussions

I love to use Google Sheets to collaborate, brainstorm and ask questions. I share a spreadsheet in Google Classroom as “Students can edit file” which means they can all type on the same spreadsheet at the same time. Students can type their response into a cell somewhere on the spreadsheet. Click on a single cell, hover mouse over the edge until it turns into a hand. Hold down the mouse and drag the student response to a new location to gather up like ideas.

Templates

I use these templates to help facilitate collaborative spreadsheets.

discussionTab allows me to take a list of questions and put each question on a different sheet.
alicekeeler.com/discussiontab.

rosterTab allows me to create a named tab for each student on my roster.
alicekeeler.com/rostertab

templateTab does the same thing as rosterTab but allows you to design a graphic organizer that is copied for each student.
alicekeeler.com/templatetab

Want to Know More?

Check out my online Go Slow workshops: alicekeeler.com/goslow




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