ALEX Classroom Resource

  

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).


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).


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.


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.

Insight Unpacked Content
Evidence Of Student Attainment:
Students:
  • will identify ways that computers help people and make things easier.
Teacher Vocabulary:
  • communicate
  • map
  • directions
  • research
Knowledge:
Students know:
  • computing devices can be used to simplify many tasks in life.
Skills:
Students are able to:
  • identify how computing devices can make tasks such as communicating, directions, and research easier.
Understanding:
Students understand that:
  • computing devices can make tasks easier.
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.

Insight Unpacked Content
Evidence Of Student Attainment:
Students:
  • will determine which digital tool that would work best to complete a specific task.
Teacher Vocabulary:
  • video
  • audio
  • word processing
Knowledge:
Students know:
  • how to determine which tools and applications would be best to complete certain tasks such as word processing, video, audio, presentation, drawing, and/or calculating.
Skills:
Students are able to:
  • choose an appropriate digital tool to complete a given task.
Understanding:
Students understand that:
  • certain digital tools lend themselves to communicate certain ideas better.
  • the way in which they like to communicate ideas and information may be different than another person.
Digital Literacy and Computer Science
DLIT (2018)
Grade: 2
14) Collect, create, and organize data in a digital chart or graph.

Insight Unpacked Content
Evidence Of Student Attainment:
Students:
  • will enter data into a spreedsheat and use that data to construct a chart or graph.
  • will rearragne and change data in a spreedsheet.
  • will design charts and graphs using a spreedsheet.
Teacher Vocabulary:
  • graph
  • chart
  • data
Knowledge:
Students know:
  • spreadsheets can be used to collect data.
  • charts and graphs can be created using a spreadsheet or by hand to represent data.
Skills:
Students are able to:
  • enter data into a spreadsheet to create a chart or graph.
  • manipulate data in a spreadsheet.
  • design charts and graphs using color, labels, titles etc.
Understanding:
Students understand that:
  • charts and graphs may be used to represent data and to determine answers to questions.
  • the design of the chart or graph may be edited according to the user's preferences.
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