What Is Your Grade (Part 1)

Author

Texas Instruments

Alignment

Standards Alignment

Textbook Alignment

Subject Area

Math: Statistics: Data Analysis

Level

9-12

Activity Time

60 Minutes

Software

TI Connect™

TI Calculator

TI-83 Plus Family

TI-84 series

Applications

CellSheet™ for TI-83 Plus and TI-84 Plus

Other Materials

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

Resource Types

Lessons

Report an Issue

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

Download Files

Download All Files (ZIP)

Before the Activity Files

Teacher Notes Appendix B PDF Teacher Notes PDF

Author

Texas Instruments

Alignment

Standards Alignment

Textbook Alignment

Subject Area

Math: Statistics: Data Analysis

Level

9-12

Activity Time

60 Minutes

Software

TI Connect™

TI Calculator

TI-83 Plus Family

TI-84 series

Applications

CellSheet™ for TI-83 Plus and TI-84 Plus

Other Materials

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

Resource Types

Lessons

Report an Issue

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.

Control your cookie preferences

You can control your preferences for how we use cookies to collect and use information while you're on TI websites by adjusting the status of these categories.

Category	Description	Allow
Analytics and performance cookies	These cookies, including cookies from Google Analytics, allow us to recognize and count the number of visitors on TI sites and see how visitors navigate our sites. This helps us improve the way TI sites work (for example, by making it easier for you to find information on the site).
Advertising and marketing cookies	These cookies enable interest-based advertising on TI sites and third-party websites using information you make available to us when you interact with our sites. Interest-based ads are displayed to you based on cookies linked to your online activities, such as viewing products on our sites. We may also share this information with third parties for these purposes. These cookies help us tailor advertisements to better match your interests, manage the frequency with which you see an advertisement, and understand the effectiveness of our advertising.
Functional cookies	These cookies help identify who you are and store your activity and account information in order to deliver enhanced functionality, including a more personalized and relevant experience on our sites. If you do not allow these cookies, some or all site features and services may not function properly. If you do not allow these cookies, some or all of the site features and services may not function properly.
Social media cookies	These cookies allow identification of users and content connected to online social media, such as Facebook, Twitter and other social media platforms, and help TI improve its social media outreach.
Strictly necessary	These cookies are necessary for the operation of TI sites or to fulfill your requests (for example, to track what items you have placed into your cart on the TI.com, to access secure areas of the TI site, or to manage your configured cookie preferences).	Always On

Category

Description

Allow

Analytics and performance cookies

These cookies, including cookies from Google Analytics, allow us to recognize and count the number of visitors on TI sites and see how visitors navigate our sites. This helps us improve the way TI sites work (for example, by making it easier for you to find information on the site).

Advertising and marketing cookies

These cookies enable interest-based advertising on TI sites and third-party websites using information you make available to us when you interact with our sites. Interest-based ads are displayed to you based on cookies linked to your online activities, such as viewing products on our sites. We may also share this information with third parties for these purposes. These cookies help us tailor advertisements to better match your interests, manage the frequency with which you see an advertisement, and understand the effectiveness of our advertising.

Functional cookies

These cookies help identify who you are and store your activity and account information in order to deliver enhanced functionality, including a more personalized and relevant experience on our sites. If you do not allow these cookies, some or all site features and services may not function properly.

Social media cookies

These cookies allow identification of users and content connected to online social media, such as Facebook, Twitter and other social media platforms, and help TI improve its social media outreach.

Strictly necessary

These cookies are necessary for the operation of TI sites or to fulfill your requests (for example, to track what items you have placed into your cart on the TI.com, to access secure areas of the TI site, or to manage your configured cookie preferences).

Always On

What Is Your Grade (Part 1)

CellSheet™ for TI-83 Plus and TI-84 Plus

What Is Your Grade (Part 1)

Before the Activity Files

CellSheet™ for TI-83 Plus and TI-84 Plus

Control your cookie preferences

Products

Product Support

Teacher Resources

Administrator Resources

Lessons and Activities

General Information