Activity Detail

If you are using a TI-73, TI-83, TI-84 or TI-89, there may be particular math or science applications you will need to download to use certain activities. If you are using TI-Nspire technology, please update your TI-Nspire handheld operating system or computer software to view the latest activities. The latest TI-Nspire operating system was released in June 2009.
Browse by Subject Submit Activity Saved Activities Advanced Search
  


add to saved activities



print this activity
 
What Is Your Grade (Part 1)
 


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.

    Follow the Activity procedures:
  • 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


    Other Downloads




    view standards alignment
    view textbook alignment

    Subject Area:
    Math : Statistics : Data Analysis

    Author:
    Texas Instruments

    Level:
    9-12

    Activity Time:
    60 Minutes

    Device:
    TI-83 Plus Family, TI-84 Plus Family

    Apps:
    CellSheet™

    Software:
    TI Connect™

    Accessories:
    TI Connectivity Cable

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

    Report an issue with this activity