## 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] Alabama Alternate Achievement Standards AAS Standard: M.AAS. K.8- Represent addition as "add to/put together" and subtraction as "take from/take apart" with objects, fingers, mental images, drawings, sounds (e.g., claps), acting out situations, or verbal explanations (limited to five). ELJ 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] Alabama Alternate Achievement Standards AAS Standard: M.AAS.K.10- Demonstrate, using a model with objects, composing and decomposing numbers (limited to ten and less). ELJ 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] Alabama Alternate Achievement Standards AAS Standard: M.AAS.1.6- Add and subtract numbers 1 to 15 using objects, pictures, and fingers. ELJ 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. ELJ 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. ELJ Digital Literacy and Computer Science DLIT (2018) Grade: 2 14) Collect, create, and organize data in a digital chart or graph. ELJ
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