Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

It Was My Birthday, Make Me a Spreadsheet

alice keeler birthday spreadsheet
It Was My Birthday, Make Me a Spreadsheet

alice keeler birthday spreadsheet

The Answer is Always a Spreadsheet

It’s my birthday today (Oct 6) and it would make me super happy if you tried making a spreadsheet! I LOVE SPREADSHEETS! Here are some tips and suggestions for things to try.

/create

sheets.google.com/create

A quick way to make a spreadsheet is to use sheets.google.com/create. It instantly lets you start spreadsheeting! You can also go to sheets.google.com and try out some pre made templates!

Pixel Art

alicekeeler.com/pixelart

Type single digit numbers into the Pixel art template to create a picture. Your students will love making pixel art.
pixel art alice keeler



Use Real Data

Why use contrived numbers when we can use real data!

research.google.com/tables

This site is a regular Google search (look up anything) but it only returns results with data! LOOK CAREFULLY in each search result there is a blue “Show more.” Click on this to reveal the most amazing button ever! “Export to Google Sheets!!!” This automatically copies the data into a spreadsheet for you!
Export to a spreadsheet

Try the Explore Button

In the bottom right of Google Sheets is a star icon that says “Explore.” CLICK IT! This automagically creates charts and graphs for you.
Explore button

The Explore tool uses machine learning to predict what questions you have about your data and what graphs you might want. Try out the formatting option to alternate colored rows.

TemplateTab

One of my favorite spreadsheet tools to use is TemplateTab. This allows you to paste a roster of student names onto the first sheet and design a graphic organizer on the second sheet. Use the TemplateTab menu at the top (next to the help menu) to run TemplateTab and create a copy of the graphic organizer for each student on the roster… IN THE SAME SPREADSHEET! My motto is why open 30 documents when I can just open one!

alicekeeler.com/templatetab 

YouTube video




Other TemplateTab Blog Posts

TemplateTab: Reuse Template
Google Classroom: TemplateTab for Groups
Updated TemplateTab: Make Copies
Elise Legaspi Shares How She Uses TemplateTab with Students
TemplateTab: Collaborate with Students using Spreadsheets
TemplateTab Plus: Send a Rubric to Each Student

Share Your Spreadsheet

One easy way to share your Google Sheets spreadsheet is to use my AnyoneCanView Chrome extension. After installing the Chrome extension, click on the icon while in your spreadsheet. This will automatically change the sharing permissions from private to anyone with the link can view. It ALSO automatically copies the link to your clipboard. So in one single click you’re ready to share the spreadsheet. Paste the link into a tweet and share with everyone your spreadsheet you made today!

AnyoneCanView Chrome Extension




© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.