TechnoCandy

Item Number: JNR-CANDY

Technology Integration: Business Studies, Language Arts, Math, Visual Arts

Technology Skill: Data Management, Spreadsheet, Word Processing

Program: Microsoft Office, Word, Excel, PowerPoint, Google, Google Docs, Google Slides, Google Sheets, Google Forms, Office Online, Word Online, PowerPoint Online, Excel Online

Includes: Spreadsheet Lessons: Google Sheets or Microsoft Excel Lesson Plans with Problem Solving Activities, TechnoCandy Teacher Guide, Printable Student Workbook, Paperless Worksheets, Extension Activities

Handouts and Assessment Tools: TechnoCandy Parent Letter, TechnoCandy Certificate, TechnoCandy Skill Summary, Report Checklist, Report Marking Sheet, Spreadsheet Quiz

Samples: Spreadsheet Workbook, Report, Package Design, Report Template, Package Template

STEM Integration Lessons: math and problem solving with spreadsheet technology skills


Assignment 1: Spreadsheets and You

Recognize the practical application of spreadsheets. Set a goal for learning.

Assignment 2: Explore Spreadsheets

Learn spreadsheet terminology and acquire basic skills.

Assignment 3: Understand the Problem

Grasp the challenge facing the candy business. Formulate a plan to collect information.

Assignment 4: Conduct a Survey

Administer a survey about color preferences to research the problem.

Assignment 5: Record Survey Results in a Spreadsheet

Organize survey results in a spreadsheet. Format the data to make it easy to read.

Assignment 6: Calculate Survey Data

Compute totals using the Sum function.

Assignment 7: Graph the Survey Results

Represent data in a column chart. Customize the chart style. Interpret the survey results.

Assignment 8: Research the Candy

Investigate candy packaging. List predictions and actual amounts of colored candies.

Assignment 9: Record Research Results

Organize data in a new worksheet. Calculate totals using the Sum function.

Assignment 10: Make a Comparison Chart

Sort data. Create a double bar graph. Edit the title, legend, and axes. Analyze research findings.

Assignment 11: Report Solution to the Problem

Recommend a proposal based on the evidence. Support reasoning using graphs.

Assignment 12: Submit the Report

Verify the report is complete using a checklist. Revise the content. Print or share the document.

Optional Spreadsheet Lessons:

  • Play Spreadsheet Bingo: Practice spreadsheet skills.
  • Have Fun with Cell References: Foster creativity.
  • Experiment with Sum: Compare calculations.
  • Explore Chart Types: Make different types of graphs.
  • Draw Packaging: Design a candy package.
  • Conduct a Poll or Survey: Ask a question. Display results.
Conduct a Survey
Research Candy Package
Recommend a Solution
Spreadsheet Lessons for Beginners

Spreadsheet Activities for Beginners

Elementary students learn technology and math skills through problem solving in TechnoCandy. The spreadsheet lessons connect mathematics to a real-world situation that is simplified to make it understandable for children. Students are challenged to develop a solution that will increase candy sales. This project can be used to develop critical thinking, teach inquiry and analytic research methods, and build problem solving strategies.


  • Connect mathematics to everyday life
  • Investigate a problem using spreadsheets
  • Conduct a survey and research candy packaging to collect data
  • Develop a plan based on evidence
  • Recommend a solution and explain reasoning in a written report
  • Organize data in a spreadsheet using multiple sheets
  • Graph data in a single and double bar graph and interpret results
  • Format cells to make data easy to read
  • Calculate data using formulas
  • Sort data alphabetically and numerically

Customer Reviews

Spark student interest with engaging spreadsheet lessons and word processing for beginners. Students investigate a problem by conducting a survey and researching candy packaging. Then they develop a plan to boost candy sales by adjusting the color of candies in a package. TechnoCandy spreadsheet lessons show students how to organize, calculate, and graph data. Based on the evidence, students recommend a solution in a written report.


Write a Review



5.0

The students love Techno Candy! This is my 3rd year teaching it. I love that the teachers guide is easy to follow with it's step by step directions.

Melissa , Chicago, Cicero East School

5.0

My students love Techno Candy, this is my 4th year teaching this. They learn about spreadsheets, inserting charts, and the use of auto fill. They really look forward to being able to eat the candy at the end of the assignment.

michele walker, whitney, whitney middle school

5.0

What a great program to teach Excel to the students! They all love it and have so much fun. They don't even realize that they're actually learning a program. The BINGO game was such a hit that we played until every student had their "cards" filled completely. Thank you for an amazing program!

Stacie F., Oakdale, MN, Homeschool

5.0

It was a nice way to introduce Google Sheets to my 3rd - 5th graders!

Pam V, Everett, WA USA, Forest View Elementary

5.0

Great project. My kids really liked the Excel Bingo to start the lessons. Great step by step approach to learning Excel.

Kristen S, Butler, PA, BCS

5.0

I've just download and gone through the materials. I will be using them to teach tomorrow. I love the content and easy to follow instructions.

C. Wong, Hunters Hill, Australia, Big Little Matrix

5.0

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

Vicki L, Cincinnati, OH, St. James School

5.0

I love the Techno Kids projects.  I will be sure to place another order soon for the next school year!

T. Sauer, KY, USA, OCES


I love the content and easy to follow instructions.

google sheets lessons reviewer

C. Wong,
Big Little Matrix,
Hunters Hill, NSW, Australia


Other TechnoKids Junior Projects


Google Docs Package

A collection of Google Docs technology projects. Write stories, create presentations, design a newsletter, research information, graph data, and more.


View Details

TechnoToon

Create a graphic story that looks like a cartoon or animated comic strip using Google Slides or PowerPoint. Integrate creative writing with technology using digital storytelling lessons.


View Details

Photo of JNR-CANDY - TechnoCandy

TechnoCandy

Investigate a problem, conduct a survey, research packaging, and recommend a solution using Google Sheets or Microsoft Excel spreadhsheet lessons.


View Details

Photo of JNR-TRIVIA - TechnoTrivia

TechnoTrivia

Invent a fun trivia game. Learn how to make a Google Forms quiz. Build the questions and answer key.


View Details


Junior Projects