Project Includes

  • Teacher Guide
  • Student Workbook
  • Customizable Resources
  • Assessment Tools
  • Extension Activities
  • Sample Files
  • Templates
  • Parent Letters
  • Certificates

TechnoBiz

Item Number: JNR-BIZ
Technology Integration: Language Arts, Math
Technology Skill: Desktop Publishing, Spreadsheet, Word Processing
Program: Excel, Word
Includes: Spreadsheet Lesson Plans – Teacher Guide, Printable Student Workbook, Paperless Worksheets, Review Questions, Extension Activities, TechnoBiz Parent Letter, TechnoBiz Certificate, Summary of Skills Checklist, Report Marking Sheet, Survey Template, Report Template, Survey Sample, Excel Bingo Resources

Session 1: An Introduction to Excel
Acquire basic spreadsheet skills while participating in Excel Bingo.
Session 2: Color Survey
Collect worksheet data by conducting a survey of candy color preferences.
Session 3: Graph the Survey Results
Create and format a graph of candy survey results using Excel.
Session 4: Research Candy Packaging
Research and record packaging data results in a worksheet.
Session 5: Graph Packaging Results
Use a comparison bar graph to illustrate candy packaging results.
Session 6: Write a Report
Summarize findings and propose a solution in a report.

Optional Spreadsheet Lesson Plans

  • Guess the Picture: Fill cells with color.
  • Shopping Spree: Buy toys and total expenses.
  • Secret Messages: Guess the code.
  • Sports Survey: Practice graphing skills.

Project Based Learning and Excel Activities

Integrate technology with mathematics. Introduce elementary students to Excel and spreadsheets using a problem solving model. Can they develop a plan to increase candy sales?

  • 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 totals using the autosum feature
  • Recommend a solution to a problem in a report.

TechnoBiz is extremely effective for helping the kids learn how to operate Excel. It is also very quick and easy for me to prepare and teach. I appreciate all that you’ve done to help our kids learn.

M. Kaempfer,
Orangewood Christian School,
FL, USA

Customer Reviews

Elementary students analyze candy preferences to develop a plan to improve candy sales. Spreadsheet lesson plans focus on authentic computer and math skills, including how to organize, graph, and calculate data.

TechnoBiz is extremely effective for helping the kids learn how to operate Excel. It is also very quick and easy for me to prepare and teach. I appreciate all that you’ve done to help our kids learn.

M. Kaempfer,
Orangewood Christian School,
FL, USA