Grades

4-5

**Grades:** 4 - 5

ISTE:

S.5.b

CSTA:

1B-DA-06

1B-DA-07

CCSS:

ELA-Literacy.SL.4.2

ELA-Literacy.SL.5.2

Math.Practice.MP5

During this engaging and interactive digital lesson, learners will receive direct instruction and practice adding and subtracting data using formulas in spreadsheet tables. Learners will experience using cell names and addresses to create formulas, entering data in a cell, and using the sum command.

Type:Lesson

Estimated Time:13 minutes

Score Type:Auto Score

This lesson automatically provides a score to your gradebook

Available Languages: English, Spanish

Vocabulary: cell address, data, formula, spreadsheet, summation function, table

Primary Objectives:

- Student gains additional experience using the sum command.
- Student gains experience entering data into a spreadsheet.
- Student learns the advantages of using cell names in formulas rather than numbers.
- Student learns the correlation between what is typed into a cell and what appears on the screen.
- Student learns to enter formulas in cells.

Secondary Objectives:

- Student analyzes and interprets information in tables.
- Student identifies some traits of different types of marsupials.
- Student practices adding and subtracting.
- Student practices using formulas to solve problems.
- Student practices using tables to organize information.
- Student recognizes different polygon shapes and calculates their perimeters.

Subjects:

Critical Thinking and Decision Making Process

Information Technology > Student Use > Critical Thinking and Decision Making ProcessData Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision MakingData Collection for Decision Making

Digital Literacy > Student Use > Data Collection for Decision MakingGeneral

Mathematics > Geometry > GeneralGeneral

Mathematics > Geometry > Formulas > GeneralGeneral

Mathematics > Measurement > GeneralListening / Pay Attention

Language Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay AttentionMathematics

Information Technology > Connects to Other Disciplines > MathematicsMeasure/Calculate

Mathematics > Geometry > Perimeter > Measure/CalculatePerimeter

Mathematics > Geometry > Formulas > PerimeterProblem Solving

Information Technology > Student Use > Problem SolvingSpreadsheets

Information Technology > Software Applications > SpreadsheetsSpreadsheets

Mathematics > Statistics Probability > Computation/Technology > SpreadsheetsSpreadsheets

Mathematics > Number Operations > Computation/Technology > SpreadsheetsSpreadsheets

Information Technology > Software Applications > SpreadsheetsSymbols

Mathematics > Number Operations > Operations > SymbolsUse appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically