Sign In

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.

Teacher-Facing Resources

Type:Lesson

Estimated Time:13 minutes

Grades:4-5

Score Type:Automatically Graded

Work completed by a student will be automatically graded and the grade will be sent to the Learning Management System (LMS) 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:

Create Presentations

Technology Education > Information Technology > Digital Communications > Create PresentationsCritical Thinking and Decision Making Process

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

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

Technology Education > Digital Literacy > Student Use > Data Collection for Decision MakingGeneral

Mathematics > Geometry > Formulas > GeneralGeneral

Mathematics > Geometry > GeneralGeneral

Mathematics > Measurement > GeneralInternet

Science > Concepts and Processes > Tools / Instruments > Software Tools > InternetListening / Pay Attention

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

Technology Education > Information Technology > Connects to Other Disciplines > MathematicsMeasure/Calculate

Mathematics > Geometry > Perimeter > Measure/CalculatePerimeter

Mathematics > Geometry > Formulas > PerimeterProblem Solving

Technology Education > Information Technology > Student Use > Problem SolvingSpreadsheets

Mathematics > Number Operations > Computation/Technology > SpreadsheetsSpreadsheets

Mathematics > Statistics Probability > Computation/Technology > SpreadsheetsSpreadsheets

Library Media > Information Technology > Software Applications > SpreadsheetsSpreadsheets

Technology Education > Information Technology > Software Applications > SpreadsheetsSymbols

Mathematics > Number Operations > Operations > SymbolsUse appropriate tools strategically

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