# BCIS Excel Final Exam Review Gradebook Exercise

Document Sample

```					BCIS Excel Final Exam Review Gradebook Exercise

1. Fill in the empty cells in the Gradebook spreadsheet with the correct formulas, not
a. The Daily Avg field is calculated by adding up all of the daily grades.
b. The Test Avg is calculated by the typical method of averaging grades. Use
the most efficient method assuming there could be many more test grades.
c. The Average field is calculated by counting the Daily Avg as 20% of the
total average, the Test Avg as 65% of the total average, and the Final
Exam as 15% of the total average.
d. The Class Average is the average of all student averages.
e. The Pass/Fail column contains a “Pass” if the student average is greater
than a 79, or “Fail” if it is less than an 80.
2. Insert a row at the top of the spreadsheet and add the title “Mrs. Garza’s
3. Center the title in the middle of the spreadsheet.
4. Change the font size of the title to 14 points.
5. Make the title bold.
6. Make the Daily Avg, Test Avg, Final Exam, and Average column headings bold
and italicized.
7. Make all column headings over numeric data right justified in the cell.
8. Format the Average field to 2 decimals.
9. Sort the Student Names in ascending order.
10. Insert a row at the top of the spreadsheet entering your name in cell A1 and your
class period in C1.
11. Adjust all columns’ width as necessary so all labels and date are displayed
entirely.
12. Produce a column chart to compare each student’s Daily Avg, Test Avg, and
similar to the one below.
13. Fill the graph with a light blue color
14. Print both values and formulas in landscape. Print the chart on the same page as
the worksheet. Save as FinalReview2.Make sure to go in Page Setup and select
“Fit on 1 page”

120
100
80                                          Daily Avg
60                                          Test Avg
40                                          Final Exam
20
0
e

er
s
it h

te
d
Do

ne

ol

wy

hi
Sm

ll F
Jo

W
hn

Sa
Bi
ne

y
y
Jo

ar
nc

m
Ja

M
To
Na

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 28 posted: 9/29/2012 language: Unknown pages: 1
How are you planning on using Docstoc?