Investigate a problem, conduct a survey, and propose a solution using Google Sheets or Excel spreadsheet lessons.
- Project Includes:
- Teacher Guide, Student Workbook, Customizable Resources, Assessment Tools, Extension Activities, Sample Files, Templates, Parent Letters, Certificates
- Tech Integration:
- Business Studies, Language Arts, Math, Visual Arts
- Tech Skill:
- Data Management, Graphics, Spreadsheet, Word Processing
- Google, Microsoft 365, Office 2019, Office 2016, Office 2013, Office Online
- Excel, PowerPoint, Word, Docs, Forms, Sheets, Slides
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.
Features & Benefits
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
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.