This engaging and interactive digital lesson provides direct instruction and practice with copying and pasting formulas in spreadsheets. Learners will use functions and gain additional experience working with formulas and tables.
Estimated Time:10 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: copy and paste, data, formula, function, spreadsheet, table
ArithmeticMathematics > Number Operations > Mean > Arithmetic
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 > Number Operations > General
GeneralMathematics > Algebra > Formulas > General
Info/Data CollectionMathematics > Process Standards > Problem Solving > Info/Data Collection
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
MathematicsTechnology Education > Information Technology > Connects to Other Disciplines > Mathematics
SpreadsheetsLibrary Media > Information Technology > Software Applications > Spreadsheets
SpreadsheetsMathematics > Number Operations > Computation/Technology > 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 this lesson, students calculate the costs of feeding lizards in a zoo exhibit. Students should be familiar with using basic operators, calculating monetary amounts, and entering formulas into spreadsheets.
The process of cutting, copying, and pasting is the same in spreadsheet programs as in other programs. Students should be familiar with these basic tasks before taking the lesson. One notable difference is that when you paste a formula, the formula calculates data relative to its position. In other words, when you paste a formula, the formula stays the same but the cell names in the formula change to calculate a relative set of data.
The syntax used for formulas and functions from one software title to another may differ. For example, a cell range in some spreadsheet software is specified with a colon between the two cells like this: A1:D8, while in others it is specified by two periods like this: A1..D8. In most cases, the differences are slight and syntax is quite similar from one software title to another. Before applying skills with an activity, be sure to review the syntax used in the software title available to your students and make any clarifications necessary with your students.
This lesson also involves using a formula to find an average. Students should be familiar with the mathematical process of averaging a set of numbers.
|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.|