Model It Up in Google Sheets

  Classroom Resource Information  

Title:

Model It Up in Google Sheets

URL:

https://docs.google.com/document/d/1Bul_XP7GVsJEBJ9WzcGwIXkxRdqEgRS3ajQwyRDn9_Y/edit

Content Source:

Other
ShakeUpLearning
Type: Lesson/Unit Plan

Overview:

In this learning experience designed for littles (grades Pre-K through 2nd), Christine Pinto, Kindergarten teacher and co-author of Google Apps for Littles,  uses Google Sheets templates to help her students learn basic addition and give them early exposure to equations. Students can "make five", "make ten", "make twenty", following the colors in the Google Sheets cells.

The kids make their models by using single digit numbers according to the color key to color the cells. First, they fill in the blank cells with a color by typing the number that corresponds to the color. For example, they could fill three boxes with green, two with orange. Then they add their equation to the yellow box to show how it makes 5 (3 (green) plus 2 (orange) equals five). Then they check their answer in the blue box following the example.

Learning Outcomes :

  • Students will be able to create equations that equal 5, 10, or 20.

  • Students will be able to decompose a number and understand the purpose of the equal sign.

  • Students will gain a foundational understanding for multiplication.

  • Students will be able to write mathematical expressions.

Content Standard(s):
Mathematics
MA2015 (2016)
Grade: K
8 ) Represent addition and subtraction with objects, fingers, mental images, drawings, sounds (e.g., claps), acting out situations, verbal explanations, expressions, or equations. (Drawings need not show details, but should show the mathematics in the problem. This applies wherever drawings are mentioned in the Standards.) [K-OA1]

Mathematics
MA2015 (2016)
Grade: K
10 ) Decompose numbers less than or equal to 10 into pairs in more than one way, e.g., by using objects or drawings, and record each decomposition by a drawing or equation (e.g., 5 = 2 + 3 and 5 = 4 + 1). [K-OA3]

Mathematics
MA2015 (2016)
Grade: 1
6 ) Add and subtract within 20, demonstrating fluency for addition and subtraction within 10. Use strategies such as counting on; making ten (e.g., 8 + 6 = 8 + 2 + 4 = 10 + 4 = 14); decomposing a number leading to a ten (e.g., 13 - 4 = 13 - 3 - 1 = 10 - 1 = 9); using the relationship between addition and subtraction (e.g., knowing that 8 + 4 = 12, one knows 12 - 8 = 4); and creating equivalent but easier or known sums (e.g., adding 6 + 7 by creating the known equivalent 6 + 6 + 1 = 12 + 1 = 13). [1-OA6]

Digital Literacy and Computer Science
DLIT (2018)
Grade: K
6) Recognize ways in which computing devices make certain tasks easier.

Examples: Communication, doctor's visits/medical records, maps and directions.

Digital Literacy and Computer Science
DLIT (2018)
Grade: 1
10) Identify an appropriate tool to complete a task when given guidance and support.

Examples: Choosing a word processing tool to write a story, choosing a spreadsheet for a budget.

Digital Literacy and Computer Science
DLIT (2018)
Grade: 2
14) Collect, create, and organize data in a digital chart or graph.

Tags: addition, decompose, model, spreadsheets, subtraction
License Type: Attribution Non-Commercial No Derivatives
For full descriptions of license types and a guide to usage, visit :
https://creativecommons.org/licenses
Accessibility
Comments
  This resource provided by:  
Author: Aimee Bates