Interpreting Graphs using Microsoft Excel
Reviewed by members of Editorial board for inclusion in MERLOT.Editor Review (not reviewed)
- User Rating:
- Discussion (2 Comments)
- Learning Exercises (none)
- Personal Collections (none)
- Accessibility Info (none)
Browse in Categories
Discussion for Interpreting Graphs using Microsoft Excel
Elizabeth Kupiecki (Teacher (K-12))
This lab uses buggy cars and simple measuring techniques of using a ruler and stopwatch for students to collect data. There is an inquiry based element to this lab in that students decide with their group what type of data to collect an how to collect the data.
The lesson is valuable because the focus is on students analyzing the data they collect. This analysis will lead to a deeper understanding of motion (including velocity) and will help with students to practice critical thinking. In addition the use of excel will help students become familar with using technology as a data-analysis tool.
Further, the lesson could be engaging for a diverse group of students as their are elements of socialization, kinesthetic learning, and visual learning. Group work will help to scaffold understanding for students of various skill levels.
The link to the pdf was functional and worked well.
Kyle Heffelbower (Teacher (K-12))
The lesson plan write up is worded wonderfully to aid in application of the lessons. This lesson incorporates instructional video and complex groupwork in order to electronically develop a graph of the motion. The spreadsheet skills from a program like Excel are mostly transferable to other spreadsheet programs. I find this lesson easily implementable and a great aid in understanding spreadsheet software.
I found no technical issues.