Lesson 8
Spreadsheet Shortcuts
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 last lesson about using spreadsheets, students learn to include cell references in formulas by clicking on a cell instead of typing its address and also how to continue patterns by dragging to generate a sequence of numbers based on a formula.
To engage in this lesson, students must have access to internet-enabled devices. Ideally, they should navigate to the digital version of the materials with the embedded applets. A direct link to each applet is also provided.
Learning Goals
Teacher Facing
- Use spreadsheet shortcuts such as clicking on cells or filling cells with a pattern.
Student Facing
Let's explore recursive formulas in spreadsheets.
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 shortcuts to fill in cells on a spreadsheet.
Print Formatted Materials
Teachers with a valid work email address can click here to register or sign in for free access to Cool Down, Teacher Guide, and PowerPoint materials.
| Student Task Statements | docx | |
| Cumulative Practice Problem Set | docx | |
| Cool Down | Log In | |
| Teacher Guide | Log In | |
| Teacher Presentation Materials | docx |