Item Number: JNR-SALES

Technology Integration: Language Arts, Math

Technology Skill: Desktop Publishing, Spreadsheet, Word Processing

Program: Excel, Word

Includes: Graphing Lesson Plans, Teacher Guide, Printable Student Workbook, Paperless Worksheets, Review Questions, Extension Activities, TechnoSales Parent Letter, TechnoSales Certificate, Summary of Skills Checklist, TechnoSales Marking Sheet, Bake Sale Workbook Sample, Bake Sale Report Sample, Bake Sale Report Template

Session 1: Introduction to Excel

Learn basic spreadsheet skills in the game "You Found my X-Cell".

Session 2: What Desserts do Students Prefer?

Interpret survey results with a bar graph.

Session 3: Are There Differences between Desserts Boys and Girls Prefer?

Use problem solving to select a bake sale item based on demographics.

Session 4: What Flavors of Dessert do Students Like?

Create a pie graph. Select bake sale item particulars.

Session 5: How Many Dessert Items do You Need?

Based on past sales; calculate financial goals, pricing, quantity, and production.

Session 6: Bake Sale Report

Explain decisions for bake sale in a report created in Microsoft Word.

Optional Graphing Lesson Plans

Add Pictures: Create a one-of-a-kind bar graph.
Change the Chart: Compare pie, line, and bar graphs.
Pie Graphs: Hints and tips on advanced formatting.
About the Sale: Reflect on the results of the sale.

Plan a Bake Sale with Excel
Conduct Surveys and Graph Results
Extension Activities Challenge Students
Play Fun Excel Games

Plan and Organize a Bake Sale using Excel

Integrate technology with mathematics graphing lesson plans. Plan a bake sale and build computer skills with step by step instructions to create surveys, graphs, charts, and reports using Excel and Word.

  • Relate mathematics to real-world situations
  • Develop problem-solving strategies
  • Use technology to conduct investigations
  • Organize survey data in a worksheet
  • Analyze the results of a survey
  • Format content in a spreadsheet
  • Predict outcomes and compare to actual results
  • Graph data and analyze the information
  • Calculate data using formulas to set goals
  • Produce a report to suggest a solution to a problem

Customer Reviews

Make connections to mathematics in the real world by planning a bake sale. To make the fundraiser a success, students plan the desserts to sell, set financial goals, and calculate product quantities. TechnoSales graphing lesson plans include all the resources teachers need.

Write a Review


Love TECHNOkids! I have used Sales with both my 5th and 6th grade students. Very easy for them to follow.

Vicki L, Cincinnati, OH, St. James School


The TechnoSales materials are great. I'm not having any difficulties. The instructions are easy to follow.

G. Simpson , NJ, USA, Durand Academy

The TechnoSales materials are great. I'm not having any difficulties. The instructions are easy to follow.

mathematics lessons spreadsheets reviewer

G. Simpson,
Durand Academy,

Other TechnoKids Junior Projects

Google Apps Package

16 projects with lessons for Grades 1-12. Project based activities for Google Docs, Sheets, Drawings, Slides, and Forms.

View Details

Microsoft Plus Package

Computer lessons include project based activities that use Microsoft Office. Make learning meaningful.

View Details

Office 365 Package

14 projects with lessons for Grades 1-12. Project based activities for Word Online, Excel Online, Excel Survey, and PowerPoint Online.

View Details

Microsoft Complete Package: Microsoft Plus + Office 365 Projects

Project based activities for Microsoft Office and Office 365 Online. More than 50 projects that integrate technology into curriculum.

View Details

Junior Projects