Item Number: JNR-CANDY
Technology Integration: Business Studies, Language Arts, Math, Visual Arts
Technology Skill: Data Management, Spreadsheet, Word Processing
Program: Excel, Excel Online, Excel Survey, Google, Google Docs, Google Forms, Google Sheets, Google Slides, Microsoft Office, Office 365 Online, PowerPoint, PowerPoint Online, Word, Word Online
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
Assignment 1: Spreadsheets and You
Recognize the practical application of spreadsheets. Set a goal for learning.
Assignment 2: Explore Spreadsheets
Explore Google Sheets or Excel Online to learn spreadsheet terminology and acquire basic skills.
Assignment 3: Understand the Problem
Develop an understanding of the problem. Make a plan to collect information.
Assignment 4: Conduct a Survey
Conduct a survey about color preferences.
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
Calculate data using the Sum function.
Assignment 7: Graph the Survey Results
Graph survey data. Interpret the results.
Assignment 8: Research the Candy
Investigate candy packaging. Record predictions and actual amounts of colored candies.
Assignment 9: Record Research Results
Organize research results in a new sheet. Calculate totals using the Sum function.
Assignment 10: Make a Comparison Chart
Sort data. Create a comparison graph. Analyze research findings.
Assignment 11: Report Solution to the Problem
Recommend a solution to the problem based on the evidence. Use graphs to support reasoning.
Assignment 12: Submit the Report
Complete a checklist. Submit report.
Optional Spreadsheet Lessons:
- Play Spreadsheet Bingo: Practice spreadsheet skills.
- Have Fun with Cell References: Foster creativity.
- Experiment with Sum: Compare calculations.
- Explore Pie and Line Graphs: Make different types of graphs.
- Draw Packaging: Design a candy package.
- Make a Survey: Ask a question. Display results. (Google only)