Item Number: JNR-CANDY
Technology Integration: Business Studies, Language Arts, Math, Visual Arts
Technology Skill: Data Management, Spreadsheet, Word Processing
Program: Excel Online, Excel Survey, Google Apps, Google Docs, Google Forms, Google Sheets, Google Slides, Office 365 Online, Word Online
Includes: Google Apps or Office 365 Online Lessons with Problem Solving Activities, TechnoCandy Teacher Guide, Printable Student Workbook, Paperless Worksheets, Extension Activities, Report Template, Package Template, TechnoCandy Parent Letter, TechnoCandy Certificate, TechnoCandy Skill Summary, Report Checklist, Report Marking Sheet, Sample Spreadsheet Workbook, Spreadsheet Quiz, Sample Report, Package Design samples
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 Google Apps or Office 365 Online Activities:
Play Spreadsheet Bingo, Have Fun with Cell References, Chart Activities, Explore Pie and Line Graphs, Draw Packaging, Make a Survey