Beacon Lesson Plan Library
Range and Measures of Central Tendency
Wanda Martin Santa Rosa District Schools
Description
Students are introduced to range and measures of central tendency with a Microsoft PowerPoint presentation. After practice in calculating and analyzing data, students will create a table in Microsoft Excel.
Objectives
The student understands and applies the concepts of range and central tendency (mean, median, and mode).
The student analyzes realworld data by applying appropriate formulas for measures of central tendency and organizing data in a quality display, using appropriate technology, including calculators and computers.
Materials
Computer lab with Microsoft PowerPoint and Excel
Projector
Calculator
Notebook paper
Pencil
PowerPoint Presentation (Associated File)
Table (Associated File)
Rubric (Associated File)
=Practice (Associated File)
Table Instructions (Associated File)
Preparations
1. Reserve computer lab for 3 days.
2. Check that the computer systems and software are running properly.
3. Download the PowerPoint Presentation and check that it is running properly.
4. Download the Table and check that it is running properly.
5. Set up computer with projector for presentation and possible instruction in Excel.
6. Duplicate sufficient copies of Rubric, Practice, and Table Instructions for distribution to students.
Procedures
1. Pair students.
2. Present PowerPoint while students take notes. (See Associated File: PowerPoint Presentation)
3. Check for understanding by discussing and reviewing PowerPoint info.
4. Allow students to work the You Try It! on notebook paper that is at the end of the presentation.
5. Check for correctness and understanding by allowing students to share and compare their answers with the answers given in the presentation.
6. Allow students to share how they arrived at their answers by showing stepbystep calculations on the board and discussing how they arrived at their analysis.
7. Reteach if necessary.
8. Distribute and explain the Rubric. (See Associated File: Rubric)
9. Distribute the Practice. (See Associated File: Practice)
10. Students may use calculators. (Students should have received instructions on calculator use prior to this lesson.)
11. Partners should compare and check their work as they complete the sheet.
12. Circulate offering feedback and guidance when needed. Pull the class back together.
13. Show and explain example of a table in Excel. (See Associated File: Table)
14. Distribute and explain Table Instructions. (See associated file: Table Instructions)
15. Students will create a table in Excel. It should be formatted to look like the example. (This may require the teacher to give additional instruction on the use of the software in a previous lesson and include a quick review in this one.)
16. Circulate, offering feedback and guidance when needed.
17. Students can save work to server, hard drive, or floppy disk, and print.
18. Collect Practice, Table, and Rubric.
Assessments
This is a formative assessment and is ongoing throughout the activy.
Group formative assessment occurs during the You Try It! from the PowerPoint Presentation (See Associated File: PowerPoint Presentation.)
Individual formative assessment occurs as teacher circulates while partners complete the Practice and create the Table (See Associated Files: Practice and Table.)
This criteria for mastery is also listed on the Rubric in the Associated File.
Range:
used correct information
used correct method
calculated correctly
Mode:
used correct information
used correct method
calculated correctly
Median:
used correct information
used correct method
calculated correctly
Mean:
used correct information
used correct method
calculated correctly
Analysis:
explanation is conclusive with the findings of the data and expresses well understood mathematical concepts of range and measures of central tendency
Table:
Excel document contains correct format
includes all data correctly calculated
correctly formatted
