Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet

A lesson plan that includes a PowerPoint learning module for students. The purpose of the instructional activity is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when deciding how to measure qualitative data and assign a rating, and how to use weighted averages in a real-life example such as this. Other examples are compared to the dating situation.