Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet cover

Spreadsheet Formulas & Functions 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

$0.00
Skip to product information

Resource preview

Select an image to preview. Open it to zoom.

Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet cover
  • Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet cover
  • Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet sample page
  • Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Student Response Sheet sample page
Spreadsheet Formulas & Functions 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

Spreadsheet Formulas & Functions 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

$0.00

This is the student response sheet where students record observations, questions, evidence and their final claim–evidence–reasoning explanation for the 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. It is sold separately from the other two parts of the set.

  • What's inside: Student Response Sheet (editable .docx + PDF, about 738 words, 5 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.

Sample question“• Tier 2 Mechanism: How do Relative (A1), Absolute (A1), and Mixed (A1 vs. A1) references behave when copied Right (across columns) versus Down (down rows), and when should an analyst use MEDIAN inste”

Complete the set: Spreadsheet Formulas & Functions Phenomena-Based Lesson: The $0.00 Autofill Payroll Disaster, The Broken VLOOKUP Column Insert & The PEMDAS Trap Presentation; Spreadsheet Formulas & Functions 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
More 21st Century Technology Skills resourcesFree resources