Model It Up in Google Sheets

Learning Resource Type

Classroom Resource

Subject Area

Mathematics

Digital Literacy and Computer Science

Grade(s)

K, 1, 2

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.

Digital Literacy and Computer Science (2018) Grade(s): KG

DLCS18.K.6
Recognize ways in which computing devices make certain tasks easier.

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 (2018) Grade(s): 1

DLCS18.1.10
Identify an appropriate tool to complete a task when given guidance and support.

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 (2018) Grade(s): 2

DLCS18.2.14
Collect, create, and organize data in a digital chart or graph.

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.

Mathematics (2019) Grade(s): KG

MA19.K.8
Represent addition and subtraction up to 10 with concrete objects, fingers, pennies, mental images, drawings, claps or other sounds, acting out situations, verbal explanations, expressions, or equations.

Vocabulary

Expression
Equation

Knowledge

Students know:

how to represent addition and subtraction using models, pictures or symbolic representations.
how to explain representations of quantities.

Skills

Students are able to:

Represent quantities and operations physically, pictorially, or symbolically.
Use informational and mathematical language to communicate the connections among addition and subtraction.

Understanding

Students understand that:

both putting together and adding to can be viewed as addition.
both taking apart and taking from can be viewed as subtraction.

Mathematics (2019) Grade(s): KG

MA19.K.10
Decompose numbers less than or equal to 10 into pairs of smaller numbers in more than one way, by using concrete objects or drawings, and record each decomposition by a drawing or equation.

Vocabulary

Decompose
Equation

Knowledge

Students know:

"equal to" and the concept of equality meaning "the same as."
Addition is putting together numbers and subtraction is taking apart numbers.

Skills

Students are able to:

Represent quantities physically, pictorially, and symbolically.

Understanding

Students understand that:

quantities may be named in a variety of ways.

Mathematics (2019) Grade(s): 1

MA19.1.6
Add and subtract within 20.

Vocabulary

Fluency

Knowledge

Students know:

Strategies for finding sums and differences within 20.

Skills

Students are able to:

Use addition and subtraction strategies.

Understanding

Students understand that:

Addition and subtraction strategies can be used to compute sums and differences, and how.

CR Resource Type

Lesson/Unit Plan

Resource Provider

ShakeUpLearning

License Type

Attribution Non-Commercial No Derivatives

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

Approved Date

2019-07-02

Model It Up in Google Sheets

Learning Resource Type

Subject Area

Grade(s)

Overview

DLCS18.K.6 Recognize ways in which computing devices make certain tasks easier.

Vocabulary

Knowledge

Skills

Understanding

DLCS18.1.10 Identify an appropriate tool to complete a task when given guidance and support.

Vocabulary

Knowledge

Skills

Understanding

DLCS18.2.14 Collect, create, and organize data in a digital chart or graph.

Vocabulary

Knowledge

Skills

Understanding

MA19.K.8 Represent addition and subtraction up to 10 with concrete objects, fingers, pennies, mental images, drawings, claps or other sounds, acting out situations, verbal explanations, expressions, or equations.

Vocabulary

Knowledge

Skills

Understanding

MA19.K.10 Decompose numbers less than or equal to 10 into pairs of smaller numbers in more than one way, by using concrete objects or drawings, and record each decomposition by a drawing or equation.

Vocabulary

Knowledge

Skills

Understanding

MA19.1.6 Add and subtract within 20.

Vocabulary

Knowledge

Skills

Understanding

CR Resource Type

Resource Provider

License Type

URL (web address)

Approved Date

DLCS18.K.6
Recognize ways in which computing devices make certain tasks easier.

DLCS18.1.10
Identify an appropriate tool to complete a task when given guidance and support.

DLCS18.2.14
Collect, create, and organize data in a digital chart or graph.

MA19.K.8
Represent addition and subtraction up to 10 with concrete objects, fingers, pennies, mental images, drawings, claps or other sounds, acting out situations, verbal explanations, expressions, or equations.

MA19.K.10
Decompose numbers less than or equal to 10 into pairs of smaller numbers in more than one way, by using concrete objects or drawings, and record each decomposition by a drawing or equation.

MA19.1.6
Add and subtract within 20.