Students combine their skills to write a single script that takes a raw CSV file and outputs a clean version. They test their script on a new, unseen dataset to verify its robustness. This introduces the concept of reproducible research.
Teachers learn to break complex tasks into smaller, manageable steps using classroom routines and Iowa Core standards as examples.
An extra credit project challenging students to live plastic-free for two weeks while researching the impacts of bioaccumulation and exploring sustainable alternatives. Students document their journey and findings in a formal scientific lab report.
Students learn to craft compelling marketing messages by developing a Value Proposition using a specific formula and applying visual text hierarchy principles to design website 'Hero Text'.
Students finalize their Unit 3 Portfolio, checking for technical errors and exporting their report as a professional PDF for final submission.
Students synthesize their Unit 3 research by creating a professional Market Analysis Report, integrating personas and charts from previous lessons.
Students learn the fundamentals of financial forecasting, calculating revenue vs. profit, and using absolute cell referencing ($) to project business growth over time.
Students learn to transform raw spreadsheet data into impactful Pie and Bar charts to visualize market trends and customer intent.
Students learn to use sorting, filtering, and conditional formatting in Google Sheets to identify target audience trends and organize large datasets efficiently.
Students transition from data entry to data analysis by learning essential Google Sheets formulas like =SUM, =AVERAGE, and =COUNT, as well as the efficiency of the Fill Handle.
Students gain 'x-ray vision' over large datasets by learning to sort and filter information. They explore conditional formatting to visualize trends and identify specific target segments within their market research data.
Students transition from data entry to data analysis by mastering fundamental spreadsheet formulas. They learn the power of the equals sign, cell referencing, and essential functions like =SUM, =AVERAGE, and =COUNT to automate business calculations.
Students explore the efficiency of automated data collection by linking their market research forms to live spreadsheets. They learn the concept of real-time data syncing and master the 'Freezing Rows' skill to manage large datasets effectively.
Students learn the art of professional survey design to gather market intelligence. They distinguish between quantitative and qualitative data, identify biased questioning, and build a multi-format survey in Google Forms or Microsoft Forms to collect clean data from their target audience.
This lesson introduces students to the fundamental structure of spreadsheet software. They learn about cells, rows, columns, and addresses while performing basic data entry and formatting to align with their brand identity.
Students transition from brand design to market analysis by distinguishing between demographic data (external facts) and psychographic data (internal values). They apply these concepts by building a formal User Persona for their brand, justifying their earlier design choices based on audience data.