Frank Wilson

This page is part of a collection of profiles of people involved in SERC-hosted projects The profiles include an automatically generated list of each individual's involvement in the projects. If you are a community member you may view your page and add a bio and photo by visiting your account page

Materials Contributed through SERC-hosted Projects

Activity

A Look at High School Dropout Rates: Average Rates of Change and Trend Lines part of Spreadsheets Across the Curriculum:General Collection:Examples
In this Spreadsheets Across the Curriculum activity, students calculate the average rate of change and graph a scatter plot of status high school dropout rate for 1975-2002. They compare the average rate of change determined by the total net difference divided by the length of the time period to the slope of the trend line fitted to the data on the scatter plot. In the end-of-module "Show You Know" assignment, the students analyze data for the event highschool dropout rate over the same time period, and they compare the two measures, status vs. event dropout rates. The module combines interpretation of rate of change in the context of a real-world time-series data set with instruction on elementary spreadsheet computation and graphing.