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.
Estimated Time:13 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: cell address, data, formula, spreadsheet, summation function, table
Create PresentationsTechnology Education > Information Technology > Digital Communications > Create Presentations
Critical Thinking and Decision Making ProcessTechnology Education > Information Technology > Student Use > Critical Thinking and Decision Making Process
Data Collection for Decision MakingLibrary Media > Information Technology > Student Use > Data Collection for Decision Making
Data Collection for Decision MakingTechnology Education > Digital Literacy > Student Use > Data Collection for Decision Making
GeneralMathematics > Geometry > Formulas > General
GeneralMathematics > Geometry > General
GeneralMathematics > Measurement > General
InternetScience > Concepts and Processes > Tools / Instruments > Software Tools > Internet
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
MathematicsTechnology Education > Information Technology > Connects to Other Disciplines > Mathematics
Measure/CalculateMathematics > Geometry > Perimeter > Measure/Calculate
PerimeterMathematics > Geometry > Formulas > Perimeter
Problem SolvingTechnology Education > Information Technology > Student Use > Problem Solving
SpreadsheetsMathematics > Number Operations > Computation/Technology > Spreadsheets
SpreadsheetsMathematics > Statistics Probability > Computation/Technology > Spreadsheets
SpreadsheetsLibrary Media > Information Technology > Software Applications > Spreadsheets
SpreadsheetsTechnology Education > Information Technology > Software Applications > Spreadsheets
SymbolsMathematics > Number Operations > Operations > Symbols
Use appropriate tools strategicallyMathematics > Process Standards > Common Core > Use appropriate tools strategically
Formulas in spreadsheet formula bars begin with an equal sign. You might want to point out how this setup might look different than formulas students work out on paper. Emphasize that either way, the effect is the same because an equal sign simply means that the equations or amounts on each side of the equal sign are the same.
In this lesson, students find the perimeters of polygons. Students use the perimeter information to find out how much fencing the zoo needs in order to update the enclosures in the zoo's marsupial exhibit. You might want to reinforce with students how to find a polygon's perimeter. Students also subtract the length of one shared fence, so you might want to discuss why they would do this to find the total perimeters of two adjoining shapes.
The data used in this lesson involves polygons and marsupials. Marsupials are pouched animals. A couple interesting facts about marsupials are that koala babies are the size of jellybeans. Among the kangaroo types, wallabies are the smallest, wallaroos are midsized, and kangaroos are the largest.
|S.5.b||Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.|
|1B-DA-06||Organize and present collected data visually to highlight relationships and support a claim. (P7.1)|
|1B-DA-07||Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea. (P7.1)|
|ELA-Literacy.SL.4.2||Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.|
|ELA-Literacy.SL.5.2||Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.|
|Math.Practice.MP5||Use appropriate tools strategically.|