Spreadsheet Formulas & Functions 5E Lesson Plan cover

Spreadsheet Formulas & Functions 5E Lesson Plan | 21st Century Technology Skills | Grades 9–12

Free
Skip to product information

Resource preview

Select an image to preview. Open it to zoom.

Spreadsheet Formulas & Functions 5E Lesson Plan cover

Spreadsheet Formulas & Functions 5E Lesson Plan | 21st Century Technology Skills | Grades 9–12

Free

Member exclusive

Create a free account to unlock this resource.

Create free account / Sign in

Members Section

Spreadsheet Formulas & Functions 5E Lesson Plan is a complete 5E (Engage, Explore, Explain, Elaborate, Evaluate) lesson plan for 21st Century Technology Skills (grades 9–12) on Spreadsheet Formulas & Functions.

  • What's inside: 5E Lesson Plan (editable .docx + PDF, about 3,581 words, 13 pages); answer key / model answers for the teacher.
  • Resource type: 5E Lesson Plan. Format: editable Microsoft Word file plus a ready-to-print PDF.

Classroom use: Follow the five phases over one to two class periods; the plan lists objectives, materials, and teacher moves for each phase. Built for 21st Century Technology Skills, grades 9–12.

Sample question“What is the difference between typing a raw number into a cell versus typing an equal sign (=) followed by a formula? What happens to cell coordinates when you copy a formula from row 2 down to row 10”

Pairs with: Spreadsheet Formulas & Functions Slide Show Presentation; Spreadsheet Formulas & Functions Guided Notes; Spreadsheet Formulas & Functions Lesson Quiz; Spreadsheet Formulas & Functions Vocabulary Words & Definitions.

Standards

Aligned to national Business, Computer & Information Technology standards (NBEA) for 21st Century Technology Skills, with embedded academic literacy and career-readiness skills.

Opening the files

These files are delivered in Microsoft Office formats (Word and/or PowerPoint). If you open a worksheet that includes tables in Apple Pages or another non-Microsoft app, table formatting may not display correctly. For best results, use Microsoft Word or PowerPoint (or upload the file to Google Docs). If you run into any formatting issues, contact us and we can send a PDF version.

At a glance

Resource type
5E Lesson Plan
Grade
9–12
Course
21st Century Technology Skills
Delivery
Digital download