Google Classroom
Simple Spreadsheet and Pie Chart
Students Create a Simple Spreadsheet and Pie Chart
Scenario: Students have decided to make and sell fresh fruit smoothies at the next important school event.
Assignment: Students choose at least 8 items from the Fruit Stand Shopping List for their fresh fruit smoothie creations.
Students create a simple spreadsheet and pie chart using the free Google Sheets template to illustrate their choices.
Google Sheets - Simple Pie Chart Template
Students enter their own title and spreadsheet data. Students create a chart using their data. Students add a relevant picture.
This template is great for use with Chromebooks, Google Classroom, and distance learning!
Usage: Students download the graphic organizer and make a personal copy for themselves.
To Download: Sign in to your school gmail account. This is a GOOGLE slides template. You MUST be signed into a gmail account to download it. While signed in to your Google / Gmail account, click the download link, then choose "Make a copy" when prompted. This will put a copy of the graphic organizer directly in your Google Drive storage.
If you tried to download this template but instead you seem to be stuck with a "View Only" copy in your browser that says "Request Edit Access" or similar, then stop right there. Find and click "File" on the top menu, (top left?) and then choose to "Make a copy". That will get you a copy that is editable.
Download: google-sheets-simple-pie-chart-template
Simple Pie Chart - Finished Example:
You can download this to use for teaching. Change the numbers, pictures, titles as quick examples of how to create the spreadsheet and chart.
Download: google-sheets-simple-pie-chart-finished-example
Fruit Stand Shopping List
Students choose 8 or more items from this list to create their spreadsheet data.
Download: google-sheets-fruit-stand-shopping-list
Student Instructions: Google Sheets
Creating a Simple Chart
Students use these instructions to guide their Google spreadsheets creations. These instructions cover the basics of entering and formatting a chart title, entering data, and creating a chart.
Download: google-sheets-student-instructions-creating-a-simple-chart
Google Sheets Video Tutorial
How to Make Your First Chart
Learn how to create a simple google spreadsheet with a chart. This video covers the basics of entering and formatting a chart title, entering data, and creating a chart.
Time to Learn = 75 seconds