Excel 2010 Tutorial - NBA stats Using the AVERAGE math function

Grade Levels
Product Rating
Not yet rated
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
1.63 MB   |   20 pages

PRODUCT DESCRIPTION

In this engaging beginner level activity, we will use the world of sports to illustrate how to use the AVERAGE function in Excel. Specifically, students build a spreadsheet that calculates averages based on a fictional 10 game cross sample of NBA players scoring stats. Formatting skills are reviewed here as the exercise requires the creation of headings, the formatting of shapes, the use of borders, as well as different font sizes and colors.

This lesson can be used in other versions of Excel and is a classroom tested exercise. I usually give this assignment within the first couple of classes of an Excel unit, after having covered basic data entry and after the students are familiar with basic math functions such as SUM and AutoSum.

Please feel free to contact me with questions or comments regarding this assignment! I hope that you find it useful and I look forward to hearing from you.

Included in this package:
- a .pdf instruction file (not much step by step hand holding in this one)
- a .pdf teacher instruction file (lots of step by step and screenshots. Depending on the class/level this is a good option)
- a sample Excel answer file that includes a tab with a finished answer and another tab that is a good starting point to demo the skills involved in this activity. The demo tab has the data entry completed but none of the formatting or math.

Tips:
- Take the time to do one yourself prior to presenting to the students so you are familiar with the steps.
- I recommend you start by opening the demo tab in the provided Excel file and then present all of the math and formatting.
- After that, students can be given the instructions and off they go!

Others you might like:
Excel 2010 Tutorial - Using Sparklines to graph data trends
Excel 2010 Tutorial - Intro to Excel, data entry and formatting
Excel 2010 Tutorial -Creating a Grocery List using the AutoSum function, formulas
Total Pages
20
Answer Key
N/A
Teaching Duration
90 Minutes

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$3.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (56 Followers)
$3.00
Digital Download
ADD ONE TO CART
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
Excel 2010 Tutorial - NBA stats Using the AVERAGE math function
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up