Transcript EXCEL MINI-PROJECT

EXCEL MINI-PROJECT
You will be creating your own grade book. This is a
mini project that we will continue. Today we will
revise how to use the SUM and AVERAGE functions
and learn MIN, MAX AND COUNT
1. Create a header that says YOUR NAME GRADE BOOK (Go
to slide number 3 for instructions – 10 PTS)
2. Starting with Column B row 2 put the following titles in
what ever order you choose ( Math, Science Reading,
Elective, Language Arts) (10PTS).
Insert 5 fictitious grades for each subject (10 PTS).
3. In column A beside your first grade please type your
assignments. You can put Assignment 1, 2, 3, 4, 5 or you
can label you assignments, Homework, Class work,
Projects etc.
4. On Cell A8 type TOTAL SUM OF ALL GRADES
5. ON CELL A9 type LOWEST GRADE
6. On Cell A10 type HIGHEST GRADE
7. On Cell A11 type AVERAGE GRADE
8. On Cell E12 type OVERALL GRADE AVERAGE
Creating your header
• Go to the insert menu tab on the ribbon
• To the far right you will see a HEADER &
FOOTER option (select)
1.
In Cell B8 type your SUM FUNCTION
o
2.
Find the SUM total of all your grades per subject area (ex. Add up all
Math grades etc) (Go to slide 5 for instructions on functions – 20 pts)
Find the minimum value of grades per subject area using MIN
function in cell B9. (20 PTS)
3. Find the maximum value of grades per subject area using MAX in
cell B10 (20 PTS).
4. Find the AVERAGE of your individual grades- B11(20 pts)
5. Find your overall grade average in cell G12- use the AVERAGE
function for all your grades(30 PTS)
6. Please ensure that you color fill the titles of your title row (5 PTS).
( ROW 2)
7. Please ensure that you color fill your assignment column (5 PTS).
8. Change the fonts and font sizes (5 PTS).
9. Make sure your overall grade title is in bold and in italics merging
over 3 cells (10 PTS)
10. MAXIMUM GRADE = 165 PTS
Finding SUM
• All functions in Excel must begin with the
equal sign (=)
• Type the = SUM ( in the cell that you want to
display your sum totals)
• Intelli-sense will display the word SUM
• Click on displayed function. High light the
cells that you want to add.
• Enter ( you should now see you sum totals)
Finding MIN, MAX, AVERAGE
• These functions are done similarly to the SUM
functions.
• Count the amount of data that you have in
your grade book using COUNT function
• Count the amount of Text and Numbers in
your spreadsheet using COUNT A
• Count the Amount of Blank spaces in your
spread sheet using COUNT BLANK