Education Technology

What Is Your Grade (Part 2)

Subject Area
Math: Statistics: Data Analysis
Level
9-12
Activity Time
60 Minutes
Software
TI Connect™
TI Calculator
TI-84 series
Other Materials
This is Activity 2 from the EXPLORATIONS Book:
Exploring Mathematics with the CellSheet™ Application
Resource Types
Lessons

What Is Your Grade (Part 2)

Activity Overview

In this activity, students use the CellSheet Application to determine the missing value in a weighted mean. They use the application to write a formula to find the weighted mean and also learn to use the copy and paste features.

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 11 - 18 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 and create a new spreadsheet
  • Enter the assignment type, corresponding score for the assignments, and weight of each assignment in separate columns
  • Enter three test scores leaving the fourth test score blank
  • Enter the formula for weighted value of each assignment (score for an assignment multiplied by the weight of an assignment)
  • Enter different scores for the fourth test
  • Find out the test score that will result in a specified overall grade
  • 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
  • Subject Area
    Math: Statistics: Data Analysis
    Level
    9-12
    Activity Time
    60 Minutes
    Software
    TI Connect™
    TI Calculator
    TI-84 series
    Other Materials
    This is Activity 2 from the EXPLORATIONS Book:
    Exploring Mathematics with the CellSheet™ Application
    Resource Types
    Lessons
    iPad is a trademark of Apple Inc., registered in the U.S. and other countries.
    Vernier EasyData,Vernier EasyLink and Vernier EasyTemp are registered trademarks of Vernier Science Education.