Education Technology

# Activities

• ##### Subject Area

• Math: Statistics: Data Analysis

9-12

60 Minutes

• ##### Device
• TI-83 Plus Family
• TI-84 Plus
• TI-84 Plus Silver Edition

TI Connect™

• ##### Accessories

TI Connectivity Cable

• ##### Other Materials
This is Activity 1 from the EXPLORATIONS Book:
Exploring Mathematics with the CellSheet™ Application

#### Activity Overview

In this activity, students will use the CellSheet Application and set up a spreadsheet. They will determine the mean of a set of values and find a minimum value to be added to a set of values to obtain a given mean.

#### Before the Activity

• Set up the CellSheet on the calculator using the TI Connect™
• See the attached PDF file for detailed instructions for this activity
• Print pages 1 - 6 from the attached PDF file for your class
• #### During the Activity

Distribute the pages to your class.

• Open the CellSheet Application on the calculator
• Create a new CellSheet file
• Enter the four test grades in the cells
• Use the formula and calculate the average grade
• Enter different test grades for the fifth test and determine the average grade
• Identify the fifth test grade for which the average grade is a particular value
• Create a new template to find the mean of six test grades
• Use your new skill to solve more problems on the CellSheet Application
• #### After the Activity

Students will complete the worksheet and answer questions. Review student results:

• As a class, discuss questions that appeared to be more challenging
• Re-teach concepts as necessary