TechnoSales

TechnoSales is a project for beginners. The spreadsheet lesson plans teach students the parts of the Excel window, terminology, and how to complete basic tasks.

Once familiar with Microsoft Excel, students play “You Found My X-Cell”, a game played in partners which reinforces essential spreadsheet skills.

To select a bake sale product that the majority of customers will want to buy, students survey fellow classmates to learn about their dessert preferences. Then they enter the results into a spreadsheet. Using the detailed graphing lesson plans, students generate a bar graph. Essential graphing concepts are stressed:

• add a title to the graph
• label the X and Y axis
• analyze the graph

Students conduct another survey to learn about flavor preferences. This information is organized into another Microsoft Excel worksheet, but this time the data is transformed into a pie graph. Students analyze the survey results to make decisions about popular and unpopular flavors.