Weighted Averages (ARC)

Michael Fulkerson, University of Central Oklahoma
Kristi Karber, University of Central Oklahoma

This lesson focuses on weighted averages and their applications. This set of materials includes a short lecture, an in-class activity, and an out-of-class activity. Students will practice computing a weighted average in the context of figuring an overall class grade. Students will use a spreadsheet to calculate a weighted average and explore the effects of various changes in the data. They will follow directions on how to enter formulas related to weighted averages based on key pieces of information provided. Students will also generalize their knowledge to the context of financial portfolios as they compute a weighted average return.

Lesson Plan

Lecture Notes

In-Class Activity

In-Class Solutions

Excel Instructions

Out-of-Class Activity

Out-of-Class Solutions

 

This work is licensed under CC BY-NC-SA 4.0