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.
Estimated Time:12 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: cell address, data, formula, spreadsheet, summation function, table
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
Data MiningLibrary Media > Information Literacy > Reference and Research > Research Skills > Data Mining
Data MiningTechnology Education > Digital Literacy > Reference and Research > Research Skills > Data Mining
GeneralMathematics > Geometry > Formulas > General
GeneralMathematics > Geometry > General
GeneralMathematics > Measurement > General
Geometric RelationshipsMathematics > Geometry > Geometric Relationships
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
MathematicsTechnology Education > Information Technology > Connects to Other Disciplines > Mathematics
Measure/CalculateMathematics > Geometry > Area > Measure/Calculate
Problem SolvingTechnology Education > Information Technology > Student Use > Problem Solving
Rectangle/ParallelogramMathematics > Geometry > Area > Rectangle/Parallelogram
SpreadsheetsMathematics > Number Operations > 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
In spreadsheet programs, multiplication and division symbols are shown as an asterisk (*) and forward slash (/) instead of the standard multiplication and division symbols that students might be used to seeing. You might want to ensure that students know what an asterisk and forward slash look like. You also might want to make sure that students know where to find the asterisk and forward slash symbols on a keyboard.
In this lesson, students find the area of enclosures. Students use the area information to find out how much space different types of bears need for a bear exhibit at a zoo. You might want to remind students that the formula used to calculate an area is area=height*width.
The data used in this lesson involves bears. Different types of bears require different areas of space for optimal living conditions. The required area for each type of bear is generally based on the bears' full-grown size.
|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.|