TPT
Total:
$0.00

Excel Graphing Easter Fruit Snacks with Digital Student Directions

;
Caryn Dingman
120 Followers
Grade Levels
3rd - 6th, Homeschool
Resource Type
Standards
Formats Included
  • PDF
  • Google Apps™
  • Excel Spreadsheets
Pages
21 pages
$4.00
$4.00
Share this resource
Report this resource to TPT
Caryn Dingman
120 Followers
Includes Google Apps™
The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).

Description

How About a Little Excel-lent Graphing to Add to Your Digital Learning Resources?

Let’s Go Paperless!

This digital, paperless Easter Fruit Snacks Data Collection and Excel Graphing Activity

can be an engaging way to:

* integrate math, technology, and Next Generation Science and Engineering Practices

* extend and enrich a math topic of study

* introduce or give students additional practice creating sheets and charts using Excel

* give students a real, personal, and unique way to compare data that’s fun and delicious!

I originally created this Excel data collection and graphing activity as a way to integrate technology into my Math classes, extending and enriching instruction.

Teachers and families are facing new challenges as we all find our way to provide

meaningful, digital, paperless learning experiences with the changes COVID-19 has

brought to our interactions.

I revised and updated my paper directions to continue to showcase student

confidence and competence using available technology in a digital way.

This classroom-tested product file includes:

* Easter Fruit Snacks Data Collection and Excel Graphing Activity Student Directions,

with a checklist format using Google Slides, to be able to share with your students

through Google Classroom, Schoology, etc.

* Directions to explain how to copy the Student Directions into your own Google

Drive - this process does NOT need TPT to have access to your Google Drive

* Step-by-Step Directions for using Excel to create the Easter Fruit Snacks Graph, to

display for students during a Zoom, Google, or Microsoft Teams meeting, or on your Smartboard in the classroom

* Rubric, using a self-grading Google Form, to be able to grade each of your

student’s graphs

* Teacher management suggestions based on my classroom experiences using this graphing project

* The checklist format of the project directions is meant to encourage you to have students work in small, manageable bits of time. Ask your students to spend about 10-15 minutes at a time, over a number of days, following the project steps until it is completed.

* The checklist format will help your student know exactly what steps were completed and what steps still need to be done.

* I’ve used this project with younger students, or students needing adaptations, in small groups as well; reading the project checklist directions aloud to those small groups for a 10 or 15-minute rotating center turn. This adaptation can be managed in a virtual learning setting as well.

* The Easter fruit snack pouches are 0.5 ounces. Your student can use the data from 1 or 2 fruit snack pouches to graph as desired. The brand I purchased was Welch’s.

* After making any corrections or edits as needed, teachers could save each student’s Excel graph in pdf form. Create a digital class book to showcase these beauties and share with families electronically! A strong home-to-school connection can still be maintained in a virtual learning platform.

Total Pages
21 pages
Answer Key
Included with rubric
Teaching Duration
N/A
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Standards

to see state-specific standards (only available in the US).
Draw a scaled picture graph and a scaled bar graph to represent a data set with several categories. Solve one- and two-step “how many more” and “how many less” problems using information presented in scaled bar graphs. For example, draw a bar graph in which each square in the bar graph might represent 5 pets.
Make a line plot to display a data set of measurements in fractions of a unit (1/2, 1/4, 1/8). Solve problems involving addition and subtraction of fractions by using information presented in line plots. For example, from a line plot find and interpret the difference in length between the longest and shortest specimens in an insect collection.
Make a line plot to display a data set of measurements in fractions of a unit (1/2, 1/4, 1/8). Use operations on fractions for this grade to solve problems involving information presented in line plots. For example, given different measurements of liquid in identical beakers, find the amount of liquid each beaker would contain if the total amount in all the beakers were redistributed equally.
Recognize a statistical question as one that anticipates variability in the data related to the question and accounts for it in the answers. For example, “How old am I?” is not a statistical question, but “How old are the students in my school?” is a statistical question because one anticipates variability in students’ ages.
Understand that a set of data collected to answer a statistical question has a distribution which can be described by its center, spread, and overall shape.

Reviews

Questions & Answers

120 Followers