Google Sheets for Data Analysis
Hoppen into Science
13 Followers
Grade Levels
7th - 11th
Subjects
Resource Type
Formats Included
- Google Drive™ folder
- Excel Spreadsheets
Hoppen into Science
13 Followers
Made for Google Drive™
This resource can be used by students on Google Drive or Google Classroom. To access this resource, you’ll need to allow TPT to add it to your Google Drive. See our FAQ and Privacy Policy for more information.
Also included in
New to your science classroom or looking for a way to start your school year with something besides a syllabus or repetitive get-to-know-you games? Look no further! Linked here are different ways to start the school year by getting into the content first, then switching to learning more about the stPrice $10.35Original Price $11.50Save $1.15
Description
- Lesson Overview:
- This is exceptionally helpful in creating student confidence in Google Sheets, and will be a helpful tool for students throughout the school year - I see students use it more frequently than a calculator or graph paper in my classroom, and some math teachers asked me NOT to teach this because students now say “can I use Google Sheets instead?”This activity focuses on the use of Google Sheets in statistical analysis (mean, median, mode) and the construction of graphs (bar, line, and pie). Teachers will first demonstrate how to solve for mean, median, and mode across two data sets through direct instruction. Each student will try that skill on their own Google Sheet. Then, the teacher will demonstrate how to create graphs by selecting relevant data, and then adding appropriate x-axis, y-axis, and graph titles with a key. Students will then try that skill on their own Google Sheets. Through this direct instruction and an appendix to the assignment that reiterates relevant tools, students will complete four practice problems within their Google Sheets.
- Additional Linked Resources:
- Lesson Overview (Google Doc)
- Google Doc with student instructions and an appendix for key tools in Google Sheets
- Google Sheet with sample data on five tabs - one guided demonstration tab to show students how to graph, and 4 “Try It” tabs for students to practice on
- There are two copies of this Google Sheet - one for high students and one for low students to ensure differentiation
- Answer Key for the Google Sheets
- NGSS Alignment:
- SEP: Analyze data using tools, technologies, and/or models (e.g., computational, mathematical) to make valid and reliable scientific claims or determine an optimal design solution.
- SEP: Apply concepts of statistics and probability (including determining function fits data, slope, intercept, and correlation coefficient for linear fits) to scientific and engineering questions and problems, using digital tools when feasible.
Total Pages
Answer Key
N/A
Teaching Duration
1 hour
Last updated Jul 15th, 2022
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.
Reviews
Questions & Answers
13 Followers
