Lesson 7

Spreadsheet Computations

Lesson Narrative

This lesson is optional. The purpose of this sequence of three lessons is to introduce spreadsheet functionality to students who are unfamiliar with it. It is assumed that students know nothing about spreadsheets. If students have already learned to use spreadsheets as computation tools previously, this sequence of lessons can be safely skipped.

In this lesson, students learn to use a spreadsheet to perform basic operations with numbers. They also begin to notice the power of spreadsheets in such calculations by using the dynamic nature of the autocalculating features. In future lessons, students will have the opportunity to access spreadsheets to aid in calculating values such as mean, median, and standard deviation. 

Learning Goals

Teacher Facing

  • Use a spreadsheet to calculate values in word problems.

Student Facing

Let's use spreadsheets as calculators.

Required Materials

Required Preparation

Acquire internet-enabled devices. It is ideal if each student has their own device.

Learning Targets

Student Facing

  • I can use a spreadsheet as a calculator to find solutions to word problems.