## Range and Measures of Central Tendency

### Wanda MartinSanta 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 real-world 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.
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 step-by-step calculations on the board and discussing how they arrived at their analysis.

7. Re-teach 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

#### Attached Files

PowerPoint Presentation – PowerPoint presentation explaining range and measures of central tendency     File Extension: ppt

Table – Excel example for table     File Extension: xls

Rubric – criteria for activity     FFile Extension: pdf

Practice – paper/pencil calculations     File Extension: pdf

Table Instructions     File Extension: pdf