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.
Authentic Spreadsheet Lessons for Kids
Students build technology skills with a real-world task: how to improve declining sales at a candy company. The inquiry approach engages children and provides a meaningful and highly motivating learning opportunity.
Create Powerful Learning Experiences
Hook student interest and reinforce curriculum objectives with active learning. As students research the problem using a survey and then design a solution, they build problem solving strategies, grow their critical thinking skills, and develop creativity.
Resources include a Teacher Guide and Student Workbook with illustrated, step-by-step instructions. Additional tools provided are customizable assessment files, optional extension activities, templates, and sample completed projects.
Stem Integration Lesson Plans
Create a blended learning environment. Combine technology with math: organizing data, problem-solving, graphing, calculating, and sorting. Connect mathematics to everyday challenges. Make spreadsheets relevant with a fun and practical project.
Create Confident Risk-Takers
Making decisions using simulations promotes essential personal skills. To prepare students for the future, build personal qualities such as perseverance, self-management, initiative, and responsibility.
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 10Make 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.
View Sample Candy Report
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.
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 packaging to collect data
Develop a plan based on evidence
Recommend a solution; explain reasoning in a written report
Organize data in a spreadsheet using multiple sheets
Interpret results using a single and double bar graph
Format cells to make data easy to read
Calculate data using formulas
Sort data alphabetically and numerically
Write a Review
The students love TechnoCandy! This is my 3rd year teaching it. I love that the teachers guide is easy to follow with its step by step directions.
My students love TechnoCandy, 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.
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!
It was a nice way to introduce Google Sheets to my 3rd - 5th graders!
Great project. My kids really liked the Excel Bingo to start the lessons. Great step by step approach to learning Excel.
I've just downloaded and gone through the materials. I will be using them to teach tomorrow. I love the content and easy to follow instructions.
Love TechnoKids! I have used the projects with both my 5th and 6th grade students. Very easy for them to follow.
I love the TechnoKids projects. I will be sure to place another order soon for the next school year!