iGeneration - 21st Century Education (Pedagogy & Digital Innovation)

Create Fake Data in Google Sheets Today is my birthday (I’m 42!) so of course, we need a spreadsheet blog post. Remember “The answer is always a spreadsheet.” For my birthday (today only) get my online Google Sheets workshop for only $6. Use the code oct6 Fake Names When creating examples I need fake student …

Did you know that you could add a dropdown list of options to a cell (or cells, plural) in Google Sheets?  This is nice for creating something like a “multiple-choice option,” but is al…

Frayer Model in Google Slides The Frayer model is a graphic organizer to help students make connections with vocabulary words. Here is a template in Google Slides. Template alicekeeler.com/frayermodel Individual or Collaborative Why open 30 documents when you can open one! Using Google Slides allows each student to add a slide, put their name in …

Free resource of educational web tools, 21st century skills, tips and tutorials on how teachers and students integrate technology into education

We know that data in spreadsheets isn’t always neatly distributed across entire rows and columns; oftentimes, for instance, sheets contai

Try this function for Google Sheets to convert a text string into a cell reference. When you need to construct not type your formula, use INDIRECT

A Student’s Guide to Using Google Sheets Using a spreadsheet is a life skill. In the real world, successful people use spreadsheets. I have created a Google Doc with 4 essential skills that if students can do just these 4 things they can use spreadsheets for assignments. Provide this guide to students along with the …

As a high school teacher with 150+ students, it can be challenging to give personal attention to each student. I remember one time a parent calling me with a concern about her kid and I thought “he’s doing fine” but upon digging into the evidence the mom was right to call me with concern. I …

The Google Sheets team made a lot of people very happy recently. There were exclamations of joy, “Yasss!”, “Finally…” and “I thought thi

Have you ever been annoyed trying to wrap the text in a Form's Response Sheet each time a new row of data appears? Do you wish the shee

Free resource of educational web tools, 21st century skills, tips and tutorials on how teachers and students integrate technology into education

Free resource of educational web tools, 21st century skills, tips and tutorials on how teachers and students integrate technology into education