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 multiplying and dividing data using formulas in spreadsheet tables. Learners will experience using cell names and addresses to create formulas and entering data and numerical formulas in a cell.

Type:Lesson

Estimated Time:12 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 experience entering data into a spreadsheet.
- Student gains experience using numerical formulas in a spreadsheet.
- Student learns the advantages of using cell names in formulas rather than numbers.
- Student learns to enter cell names in formulas to perform mathematical calculations.

Secondary Objectives:

- Student analyzes and interprets information in tables.
- Student calculates the area in square feet.
- Student identifies some traits of different types of bears.
- Student practices multiplying, dividing, and adding.
- Student practices using formulas to solve problems.
- Student practices using tables to organize information.

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 MakingData Mining

Information Literacy > Reference and Research > Research Skills > Data MiningData Mining

Digital Literacy > Reference and Research > Research Skills > Data MiningGeneral

Mathematics > Geometry > Formulas > GeneralGeneral

Mathematics > Geometry > GeneralGeneral

Mathematics > Measurement > GeneralGeometric Relationships

Mathematics > Geometry > Geometric RelationshipsListening / Pay Attention

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

Information Technology > Connects to Other Disciplines > MathematicsMeasure/Calculate

Mathematics > Geometry > Area > Measure/CalculateProblem Solving

Information Technology > Student Use > Problem SolvingRectangle/Parallelogram

Mathematics > Geometry > Area > Rectangle/ParallelogramSpreadsheets

Mathematics > Number Operations > Computation/Technology > SpreadsheetsSpreadsheets

Information Technology > Software Applications > SpreadsheetsSpreadsheets

Information Technology > Software Applications > SpreadsheetsSymbols

Mathematics > Number Operations > Operations > SymbolsUse appropriate tools strategically

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