Spreadsheets: Project-Based Business Project for Grades 6-8

Lesson Title: Sell Me on It 

Grade Levels: 6-8 

Length of Lesson: 80 minutes 

Overview: In this project-based lesson, students will work in teams to create an advertisement for a product by creating and analyzing charts and graphs to reveal helpful information about their target audience and product. 

Objectives: 

• Students create and interpret a pie chart to identify what product qualities are valued among a target population. 
• Students create and interpret a line graph to determine what advertising platform they will use to market their assigned product. 
• Students synthesize data from all graphs to create an advertisement for their assigned product. 
• Students design an ad for an assigned product using creativity and originality. 
• Students write an explanation of their advertisement to specify how it reflects their analysis of their graphs.

Standards Alignment: 

Mathematics 

• Model with mathematics. 

• Use appropriate tools strategically. 

Language Arts 

• Writing Standards 
• Speaking and Listening Standards 

Science 

• Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table). 

ISTE 

• Computational Thinker: Students develop and employ strategies for understanding and solving problems in ways that leverage the power of technological methods to develop and test solutions. 
• Global Collaborator: Students use digital tools to broaden their perspectives and enrich their learning by collaborating with others and working effectively in teams locally and globally.