The answer key for the Lyric Writing Test, including correct responses and instructional thought processes for teachers.
Comprehensive teacher guide for Lesson 26, focusing on introductory spreadsheet formulas (=SUM, =AVERAGE, =COUNT) and the concept of cell referencing. Fixed minor spacing issues in pacing list.
Dynamic slides for Lesson 25, explaining real-time data syncing between forms and sheets, the importance of file organization, and the technical steps for freezing header rows. Fixed tracking and spacing issues in headers and action items.
A student technical reference for Lesson 25, explaining the automated link between forms and spreadsheets, the concept of the 'database chain', and a checklist for the Data Sprint activity.
A detailed teacher facilitation guide for Lesson 25, focusing on linking forms to spreadsheets, the concept of real-time syncing, and the technical skill of freezing rows for data management.
Dynamic slides for Lesson 24, featuring the biased question hook, definitions of quantitative and qualitative data, and technical setup for survey deployment. Fixed tracking, layout spacing, and checklist completeness.
A student reference sheet and checklist for professional survey design. Covers quantitative vs. qualitative data, how to avoid bias, and the 5-question framework for market research. Optimized for a single page.
A detailed teacher facilitation guide for Lesson 24, focusing on survey design principles, avoiding bias, and the technical setup of market research forms. Fixed placeholder text and redundant labels.
Dynamic slides for Lesson 23, introducing the 'Data Grid' concept with the Jellybean Challenge, Battleship navigation, and technical instruction for resizing and fill colors. Fixed tracking, contrast, and diagram alignment.
A professional student reference sheet for Lesson 23, explaining the 'Battleship' address system, column/row orientation, and essential formatting shortcuts for Google Sheets and Excel. Optimized for a single-page print.
A detailed teacher facilitation guide for Lesson 23, introducing spreadsheet software via the Jellybean Challenge, Battleship navigation analogies, and basic table formatting.
Dynamic slides for Lesson 22, featuring the shoe-based hook, pillar definitions (Demographics/Psychographics), and User Persona activity instructions.
