Resource preview
Select an image to preview. Open it to zoom.
Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet | 21st Century Technology Skills | Grades 9–12
This is the student response sheet where students record observations, questions, evidence and their final claim–evidence–reasoning explanation for the Scaffolded Phenomena-Based Lesson in the 21st Century Technology Skills (grades 9–12) chapter Spreadsheet Formulas & Functions, built around the phenomenon The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap. This scaffolded version adds sentence frames and extra supports for students who need them. It is sold separately from the other two parts of the set.
- What's inside: SCAFFOLDED Student Response Sheet (editable .docx + PDF, about 794 words, 6 pages); answer key / model answers for the teacher.
- Resource type: Phenomena-Based Lesson – Student Response Sheet. Format: editable Microsoft Word file plus a ready-to-print PDF.
Classroom use: Open with the phenomenon slide show, let students record ideas on the response sheet, and lead the discussion with the teacher guide. Built for 21st Century Technology Skills, grades 9–12.
Complete the set: Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation; Spreadsheet Formulas & Functions Scaffolded Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Teacher Discussion Guide.
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
- Phenomena Lesson
- Grade
- 9–12
- Course
- 21st Century Technology Skills
- Delivery
- Digital download