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.