Sign in to view assessments and invite other educators
Sign in using your existing Kendall Hunt account. If you don’t have one, create an educator account.
Help us improve by sharing suggestions or reporting issues.
The purpose of this activity is for students to learn and practice how to use a spreadsheet to do calculations using some common operations, including some illustrations of how parentheses can be used to indicate order of operations.
Ensure that each student has access to a spreadsheet. If using the digital version of the materials, there is a spreadsheet in the Math Tools.
Display the same type of spreadsheet students are using (or the student task) on your projector, and demonstrate how to use it as a calculator. Be sure to communicate the following.
Consider displaying these commands for all to see and leaving them visible while students work on the activity.
Use a spreadsheet to compute each of the following. Type each computation in a new cell, instead of erasing a previous computation.
If students want to modify their formula, they should try to double click on the cell. If students forget which symbol to use for an operation or how to use the keyboard to type it, draw their attention to the display from the Launch.
Ask students to compare their answers with a partner and resolve any discrepancies. Help students understand how to use parentheses to get the spreadsheet to perform the desired calculation. For example, to compute
Note that the average of 2, 7, 8, and 11 can be calculated by typing =(2+7+8+11)/4 but also by typing =MEAN(2,7,8,11) or =Average(2,7,8,11), depending on the spreadsheet software.
Internet-enabled device
The purpose of this activity is for students to understand how to use references to cells to calculate values. In later lessons, students may wish to use spreadsheets to perform similar calculations on different numbers and using references can save time so that students do not need to retype all the calculations.
Display a blank spreadsheet. In cell B3, type a 2 and press enter. Point to that cell and ask students how to refer to that cell. Tell students that people often call B3 the "address" of the cell, and 2 the "contents" of the cell.
Internet-enabled device
The purpose of this activity is to demonstrate that spreadsheets can be efficient when repeating similar calculations with different values. A single spreadsheet formula can refer to the contents of cells and the calculation will automatically update when the values change.
If time is short, the first two questions can be skipped or you can tell students to choose only one of them. It's important that all students complete the last two questions to illustrate why a spreadsheet can be more useful than a handheld calculator when you need to repeat the same calculation for different values.
For each problem: