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.
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. Curriculum ships on a USB drive. Transfer the files to all devices at your site. Print as many teacher guides and workbooks as you need. Files CANNOT be posted in public domain.