1 of 17

Check Out This

Cool Sheet!

bit.ly/coolsheet

2 of 17

Hello!

bit.ly/coolsheet

I am Justin Birckbichler.

4th Grade Teacher

Google for Education Certified Innovator and Trainer

sheets@justinbirckbichler.com

@Mr_B_Teacher

3 of 17

@Mr_B_Teacher #coolsheet

bit.ly/coolsheet

The Power of the Spreadsheet

  • More than a data tracker
  • Collaborative
  • Accessible anywhere
  • Especially powerful if paired with Google Forms

4 of 17

Sheets Terminology

bit.ly/coolsheet

Cell (E7)

Add on Menu

Formulas

Text Bar

5 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Problem:

I want to quickly and visually see my data..

“

6 of 17

Solution:

Conditional Formatting

bit.ly/coolsheet

7 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Your Mission Part 1

Click on this sheet and do the following:

  • Use Conditional Formatting to make A scores in Blue, B in Green, C in Yellow, and D and below in Red. (100-90 A, etc)

8 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Problem:

I want Sheets to automatically count things up for me.

“

9 of 17

Solution:

=COUNTIF Formula

bit.ly/coolsheet

10 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Your Mission Part II

Go back to your sheet

  • Use CountIf to Count the number of scores above 85 and the number of scores below 84.

11 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Problem:

I want all of the information for each student on its own tab.

“

12 of 17

Solution:

Row Call

bit.ly/coolsheet

13 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Your Mission Part III

Go back to the sheet

  • Use RowCall to sort each student’s individual results

14 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Problem:

I want to make a lot of individualized assignments quickly.

“

15 of 17

Solution:

AutoCrat

bit.ly/coolsheet

16 of 17

bit.ly/coolsheet

@Mr_B_Teacher #coolsheet

Your Mission Part IV

Make a blank sheet and use AutoCrat for the following:

  • Matt needs work on regrouping and division
  • Nancy needs work on elapsed time
  • Marsha doesn’t understand geometry
  • Tanya needs help with multiplication
  • Each student needs to visit all 3 stations (2 on their skill and one extra)

Math Resources:

IXL: A1 Subtraction, B1 Addition, C1 Multiplication, D1 Division, E1 Elapsed Time, F1 Geometry

​

MobyMax: Module 1: Polygons, Module 2: Clocks, Module 3: Multiplication

​

Manipulatives: Base Ten Blocks, White Boards, Little Counters

17 of 17

Thanks!

bit.ly/coolsheet

Any questions?

You can find me at:

@Mr_B_Teacher

sheets@justinbirckbichler.com