Item Number: JNR-CANDY
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.
EASY-TO-FOLLOW INSTRUCTIONS: 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.
Technology Integration: Business Studies, Language Arts, Math, Visual Arts
Technology Skill: Data Management, Graphics, Spreadsheet, Word Processing
Version: Google, Office 2019, Office 2016, Office 2013, Office Online
Program: Excel, PowerPoint, Word, Docs, Forms, Sheets, Slides
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.
Use TechnoCandy with unlimited users at your site. A site is a physical location such as classroom, school, learning center, daycare, library, or home. If you teach at multiple sites, you will need to purchase one set for each location. Access everything you need from TechnoHub, and transfer the files to all devices at your site. View the PDF teacher guides and workbooks digitally or print as many as you need. Files CANNOT be posted in public domain.