×
Home Gr. Level Lesson Plans Page Generators Copy and Paste
Generators
Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Sheets
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Google Sheets Lesson Plan
Halloween Candy Spreadsheet and Chart

Assignment: Students use Google Sheets to create a simple spreadsheet with a chart showing the types and quantities of candies they are donating for a good cause.

This spreadsheet and chart activity is a great learning tool for students to collect data and visually analyse results.

Candy Donations Spreadsheet Finished Example:

Halloween candy Donations Chart

Number Generator - Students can use this simple online number generator to quickly create their own unique data for their charts.

Click to generate some random
numbers to enter into your chart.

Snickers
Hershey Bars
Candy Corn
Hershey Kisses
Starburst
Sour Patch Kids
Skittles
M & M's
Rollos
Nerds
Tootsie Rolls
Jolly Rancher
4
3
21
16
9
11
22
17
4
5
8
13

Assignment Requirements:

  1. Enter the title of your spreadsheet in Row 1.
  2. Enter your text (words) in column A.
  3. Enter your numbers in column B.
  4. Create a chart using your text and numbers fronm columns A and B.
  5. Insert one picture related to your topic.

Example

Excel Spreadsheet Rubric for Grading Assignments

Download: rubric-for-spreadsheet-with-chart.pdf

Spreadsheet Rubric for Grading Assignments

Excel Spreadsheet Rubric for Grading Assignments