Sheets

Using Spreadsheets for ELA

Monday Google Meet starts 8/23/2021, 4:00:00 PM PST

THE ANSWER IS ALWAYS A SPREADSHEET! Let's take a look at how you can use spreadsheets with your students for English Language Arts assignments.

Rubrics - Google Classroom - Google Sheets

Sunday Google Meet starts 8/22/2021, 12:15:00 PM PST

SAVE your rubrics in Google Classroom to Google Sheets. This makes it much easier to organize, share, and reuse rubrics in Google Classroom.

Presented by Alice Keeler

Google Forms: ALL quizzes in ONE Google Sheets

Why have all your Google Forms go to different spreadsheets when they can be in the SAME spreadsheet. Let me talk you into this! We will practice linking multiple Forms to ONE spreadsheet (at least for the unit) so all the student results are easy to find!

Choose your own adventure with google tools

Students create "choose your own adventure" story using google tools.

Make a Word Search

Note: Word Searches are FUN not academic. In this webinar we will practice using http://alicekeeler.com/wordsearch to design a fun word search and export it for printing.

90 Min Google Sheets: Doing More

You know spreadsheet basics. Let's do more with spreadsheets! This will be interactive.

90 Min: Create a Mad Libs Spreadsheet

Why have students all using the same nouns, verbs, numbers, and other parts of speech? Take a worksheet and upgrade it by letting students choose names, places, things, and numbers. In this workshop you will CREATE a mad libs spreadsheet. Come with a topic in mind that you want students to practice that we can turn into a more engaging fun activity... of course with Google Sheets.

Macros for Dummies

Macros for Dummies: Google Sheets allows you to code Macros to automate tasks. Have a spreadsheet with multiple tabs that you want to delete the same column from each sheet? MACRO! If you need to repeat the same task multiple times... MACRO! This will be an intro to how to make your life so much easier by automating with Macros!

Pivot Tables - Advanced

Pivot tables in Google Sheets allow you to summarize your data. In this webinar we will look at pivot tables and how to use the filters feature to get even more information out of your pivot table.

SumIf in a spreadsheet

Add things up IF.... for example ... IF a student has a score, add their score to the total points. (otherwise do not include the points possible). In this webinar we will practice some spreadsheet skills including =SUMIF

Coding with Macros on Google Sheets

Macros

Quick Pivot Table: Google Sheets

YOU NEED THIS! If you do not know what a pivot table is let's practice one together. In this webinar we will practice together doing a basic pivot table. What does a pivot table do? It summarizes data. "How many times did Mary go to the bathroom" "What was the average score on each question?" "How many students answered C to question #7?" etc...

Using VLOOKUP in Google Sheets

Google Sheets for the win! VLOOKUP lets you LOOK UP information on the spreadsheet. I use it for the level up game. If they have 30 points, look up what level they are. Let's say you have a list of student names, their email address, Parent Name, Parent phone, and Parent email. You want to create a way to type a kids name and have it also tell you the contact info. So many uses! In this webinar you will practice using vlookup formulas and it will be your newest obsession!

Discussion Tab: Classroom Conversations

Use http://alicekeeler.com/discussiontab to create a spreadsheet that facilitates a discussion. It is really cool. In this webinar we will share ideas using a sample DiscussionTab and then you will make your own spreadsheet.

The spreadsheet template lets you write a list of questions and automatically adds that question to a new sheet in the spreadsheet and locks down the question so students can not accidentally delete it.

Using Pixel Art

Kids love Pixel Art! You can use this for almost any class, any subject. http://alicekeeler.com/pixelart is a fun activity that uses spreadsheets. Type single digit numbers to allow students to create a picture.

TemplateTab Webinar By Marcia Carrillo

Marcia Carrillo shares on how to use Alice's TemplateTab.

TemplateTab: Get Everyone On the Same Page

This is quite possibly the best thing I have ever coded. This takes a roster of your student names and duplicates a template within the same spreadsheet. In this workshop you will practice reusing a template you created from TemplateTab. How do you use it for multiple classes?

Tracking Student Progress Across Multiple Sheets

Google Meet starts 12/12/2020, 1:00:00 PM PST

Using Google Sheets spreadsheet, take a roster of students on one page and track progress for different activities across multiple sheets. In this webinar you will take a template with a roster and add sheets for each set of projects you are tracking. Member suggested by Alice Keeler

Conditional Formatting - The Sequel

Google Meet starts 12/6/2020, 1:00:00 PM PST

Use conditional formatting with custom formulas- take a step beyond conditional formatting.

Conditional Formatting in Google Sheets

Google Meet starts 11/24/2020, 2:00:00 PM PST

You need conditional formatting! It allows you to set rules for highlighting cells in a Google Sheets spreadsheet. You can set it up in advance of students filling out a Google Form. After they submit the Form their answers can light up green or red (or whatever you want). Conditional Formatting is how I make http://alicekeeler.com/pixelart work. In this webinar you will practice making conditional formatting in a spreadsheet.

The Power of the If statement

Google Meet starts 11/22/2020, 3:00:00 PM PST

I would like to understand better all the things you can do with an "if" statement in Google Sheets

Google Sheets using Pivot Tables

Google Meet starts 11/4/2020, 12:00:00 PM Pacific Standard Time

Pivot tables are helpful for a lot of reasons. Learn the basics and make your data meaningful.

Using Macros in Sheets

Google Meet starts 10/27/2020, 3:00:00 PM Pacific Daylight Time

Effectively recording and using Macros; Example uses and any shortcuts

Webinar: Using alicekeeler.com/discussiontab for collaborative discussions

Google Meet starts 9/9/2020, 3:00:00 PM Pacific Daylight Time

I coded http://alicekeeler.com/discussiontab to let you take a set of questions, like a twitter chat sorta, and have each student respond to the discussion. This of course uses a spreadsheet. In this workshop you will experience being on the same spreadsheet at the same time to facilitate a discussion. Then you will create your own discussion spreadsheet.

Word Search from Office Hours

During office hours I showed how to use http://alicekeeler.com/wordsearch to create a puzzle in Google Sheets.

Word Searches are NOT learning activities or assignments... but they ARE FUN! Have fun making a Word Search :)

Webinar: What you can, besides data, what Google Sheets

Using google sheets for puzzles, random story elements, self checking problems, generation story problems. I know there are other things you can do, but I don't know what to ask when I am not sure what can be done- but I bet Alice knows!

Webinar: Splitting Text in Google Sheets

Google Meet starts 9/12/2020, 12:00:00 PM Pacific Daylight Time

How many times have you had student first and last name together and you needed them split up? Join me for some spreadsheet fun as we manipulate how to organize student names in a spreadsheet.

Google Meet Link: https://meet.google.com/ind-kxcv-ftw