Junior

TechnoCandy

Investigate a problem, conduct a survey, and propose a solution using Google Sheets or Excel spreadsheet lessons.

(8 Reviews)

$49.00 / year

Choose License Type: Contact us for district and school pricing.

Price information is unavailable.

To learn more about TechnoKids Computer Curriculum please contact us.

contact us

Description

Spreadsheet Lessons for Elementary Grades

Spark student interest with fun and engaging spreadsheet lessons and word processing activities for beginners. In TechnoCandy, students embark on a real-world mission to enhance candy sales. They investigate the problem by conducting a survey and researching candy packaging. They use a spreadsheet to organize, calculate, and graph data. Then they develop a plan to boost sales by adjusting candy colors. Based on the evidence, students recommend a solution in a written report. This project seamlessly teaches spreadsheet skills in one meaningful, integrated project.

Authentic Spreadsheet Lessons for Kids Ages 8-11

Students build technology skills with a real-world task: reviving declining sales at a candy company. The inquiry-based approach captivates children, turning the project into a motivating learning opportunity.

Empower Learning through Active Engagement

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. Teach inquiry and analytic research methods by challenging students to solve a business problem. Develop confident risk-takers. Through decision-making simulations, students build essential personal skills like perseverance, self-management, initiative, and responsibility. TechnoCandy prepares students for the future by cultivating personal and social skills in addition to academics.

Easy-to-Follow Instructions

Resources include a comprehensive Teacher Guide with illustrated, step-by-step instructions to ensure easy navigation. Additional resources provided are assessment tools, optional extension activities, templates, and sample completed spreadsheets and reports. A fun Bingo game is included to make learning cell references enjoyable. Course includes age-appropriate lessons for students to learn either Google Sheets or Excel spreadsheet skills.

Integrate STEM into Lesson Plans

Create a blended learning environment. Combine technology with math though activities that focus on organizing, problem-solving, graphing, calculating, and sorting data. Connect mathematics to everyday challenges. Students make decisions based on real world data that they collected, making spreadsheets relevant.

 

Additional information

Ages

8, 9, 10, 11

Grades

grade 3, grade 4, grade 5, grade 6

Program

Excel, Forms, Sheets, Docs, Slides, PowerPoint, Word

Tech Integration

business studies, language arts, math, visual arts

Tech Skill

data analysis, graphics, spreadsheet, word processing

License

Starter, Class, Classrooms

Starter License Includes

online teacher guide, online student workbook, get started, course slides, printable assessment tools, sample files, templates, extension activities, certificates, parent letters

Class License Includes

online teacher guide, getting started tips, course calendar, online student workbook, online assignments, printable assessment tools, online quizzes, student reporting, sample files, extension activities, certificates, parent letters, templates

Classroom License Includes

online teacher guide, getting started tips, course calendar, class management tools, online student workbook, online assignments, printable assessment tools, online quizzes, student reporting, sample files, extension activities, certificates, parent letters, templates

Product Type

Course

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.

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

TechnoCandy | Spreadsheet Lessons

Download

Investigate a problem, conduct a survey, and propose a solution using Google Sheets or Excel spreadsheet lessons.

8 reviews for TechnoCandy

  1. new.technokids.com

    The students love TechnoCandy! This is my 3rd year teaching it. I love that the teachers guide is easy to follow with its step by step directions.
    Cicero East School,Chicago
    April 10,2018
  2. new.technokids.com

    My students love TechnoCandy, this is my 4th year teaching this. They learn about spreadsheets, inserting charts, and the use of auto fill. They really look forward to being able to eat the candy at the end of the assignment.
    Middle School,Whitney
    September 29,2017
  3. new.technokids.com

    What a great program to teach Excel to the students! They all love it and have so much fun. They don’t even realize that they’re actually learning a program. The BINGO game was such a hit that we played until every student had their “cards” filled completely. Thank you for an amazing program!
    Homeschool,Oakdale
    October 07,2016
  4. new.technokids.com

    It was a nice way to introduce Google Sheets to my 3rd – 5th graders!
    Forest View Elementary,Everett
    March 22,2016
  5. new.technokids.com

    Great project. My kids really liked the Excel Bingo to start the lessons. Great step by step approach to learning Excel.
    Butler Catholic School,Butler
    January 29,2016
  6. new.technokids.com

    I’ve just downloaded and gone through the materials. I will be using them to teach tomorrow. I love the content and easy to follow instructions.
    Big Little Matrix,Hunters Hill
    October 13,2015
  7. new.technokids.com

    Love TechnoKids! I have used the projects with both my 5th and 6th grade students. Very easy for them to follow.
    St. James School,Cincinnati
    May 28,2015
  8. new.technokids.com

    I love the TechnoKids projects. I will be sure to place another order soon for the next school year!
    OCES,Henderson
    May 15,2014
Add a review

Your email address will not be published. Required fields are marked *

Our Ed Tech Blog for Teachers

View All

FAQ

Have questions? We’re here to help.

View All FAQ

How long does it take to teach a course?

Every course includes a schedule. It lists the time recommended for each assignment. Typically, it takes between 30-60 minutes to complete an assignment depending on the grade level. Based on this time frame, a typical course takes between 360-600 minutes to complete. This is about 6-8 weeks if your students have computer class twice a week. However, if your students have computer class every day, a course can be completed in about 2-3 weeks.

How do I decide which assignments to teach?

You may not have the time to teach an entire TechnoKids course. The good news is that TechnoKids offers flexibility. Many courses can be shortened by omitting assignments or lengthened by including skill reviews and extension activities. You can easily adapt the course to suit your schedule. Refer to the Ideas for Implementation section in the teacher guide for suggestions.

Does the course integrate into other subjects?

TechnoKids courses are inter-disciplinary. This means the lesson plans blend computing skills with general content areas such as language arts, geography, or business studies. If you do not have a dedicated digital literacy class, refer to the Technology Integration Suggestions section in each teacher guide for ideas on how you can include the course in other subject areas.

Is the course a subscription?

Yes. When you purchase a course, you have access to the instructional materials for 12 months. After that time, should you want to continue, you will need to renew the subscription.

Is the course online?

Yes. You must sign into TechnoHub to access the course content from your bookshelf. The teacher guide and student workbook for a course are available online only. However, resources such as assessment tools, handouts, course slides, templates, and samples are downloadable.