Content Standard(s):1. Formulate questions that can be addressed with data and collect, organize, and display relevant data to answer them 2. Select and use appropriate statistical methods to analyze data
ISTE NETS-S þ Creativity and Innovation þ Communication and Collaboration þ Research and Information Fluency þ Critical Thinking, Problem Solving, & Decision Making þ Digital Citizenship þ Technology Operations and Concepts
Instructional Objective(s): · Students will gather data from various online sources. · Students will create Microsoft Excel spreadsheets using acquired information. · Students will correctly label axes on graphs created with spreadsheets. · Students will identify trends present in scatter plots.
ACTION
Before-Class Preparation: · Reserve computer lab for class use. · Prepare a list of acceptable websites for collection of data. · Prepare tutorial videos for students (as needed). · Prepare sample data for student practice with scatter plots.
During Class
Time
Instructional Activities
Materials and Resources
30 – 40 minutes
Students will collect data from approved websites.
Computer labs Spreadsheet software
10 – 20 minutes
Students will watch a video on creating scatter plots and create a sample scatter plot with data.
Computer labs Scatter plots tutorial video Spreadsheet software Sample scatter plot data
30 – 40 minutes
5 – 10 minutes
Students will create tables and scatter plots from data collected. Students will also identify trends displayed by data.
Students will journal on their wikis about what they have discovered including the correlations discovered on the scatter plots.
Ongoing Assessment: As students create sample scatter plots, provide a checklist for students to monitor their progress.
Accommodations and Extensions: Have students upload their spreadsheets to docs.google.com and allow them to work on the tasks at home.
Back-up Plan: Instead of having students create the sample scatter plots as small groups, display the video to the whole-group and have all students create the sample scatter plots. Students may create scatter plots on paper instead of using the computer lab. Additionally, you may decide to schedule an in-class rotation of the computer stations you have available.
EVALUATION
Lesson Plan Reflections and Notes: If you have a blog or class webpage, provide the acceptable data links on it to ensure students are going to the appropriate sites.
5 – 10 minutes
Students will journal on their wikis about what they have discovered including the correlations discovered on the scatter plots.
Spreadsheet software
www.wikispaces.com
Students may create scatter plots on paper instead of using the computer lab. Additionally, you may decide to schedule an in-class rotation of the computer stations you have available.