Resource preview
Select an image to preview. Open it to zoom.
Spreadsheet Formulas & Functions 5E Lesson Plan | 21st Century Technology Skills | Grades 9–12
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