Excel+Project

=Keeping a Grade Book in Excel=

This project will take place over several weeks. At the completion of this project you will have an Excel spreadsheet that can track your grades in several of your classes.

Week 1 - Basic Data Entry
At the bottom of the directions is a picture showing you what the document should look like. Where the question marks are in the picture will be your actual grade for the assignment. Throughout the sample the name John Smith is used. Substitute your name.


 * 1) In cell A1, using your name, type the title John Smith's Grades - Mr. Miller's class
 * 2) Cell A3: Grade Categories
 * 3) Cell A4: Classwork
 * 4) Cell A5: Diving In
 * 5) Cell A6: Quizzes
 * 6) Cell A7: Tests
 * 7) Cell A9: Date
 * 8) Cell B9: Category
 * 9) Cell C9: Name
 * 10) Cell D9: Possible
 * 11) Cell E9: Earned
 * 12) Cell F9: Grade
 * 13) Starting in row 10 you will enter in the assignments listed in the picture, they include the following:
 * 14) GMetrix Practice Test 1 (Training)
 * 15) GMetrix Practice Test 2 (Training)
 * 16) GMetrix Practice Test 1 (Testing)
 * 17) GMetrix Practice Test 2 (Testing)
 * 18) Typing Web
 * 19) Ribbon Location - Word
 * 20) Word Certification Exam
 * 21) Make sure on each line above you include the date, category, possible points, YOUR earned grade for that assignment
 * 22) Apply the theme called **Slice**
 * 23) Select Cell A1:F1 and Merge and center the text
 * 24) Apply the Fill Color: **Dark Blue, Accent 1, Lighter 60%**
 * 25) Resize Column A to 17
 * 26) Resize Column B to 10.5
 * 27) Set Column C size to 30
 * 28) Select A9:F9 and apply the Heading 3 Style
 * 29) Select row 1
 * 30) Change Font size to 16 and Bold
 * 31) Set the Row Height to 30
 * 32) Set the Vertical Alignment to center
 * 33) Add a Header:
 * 34) Top Left corner: Your Name
 * 35) Top Right Corner: The current date
 * 36) Make sure your date column is using the Short Date format (as shown in the picture)
 * 37) Extra Credit (10 points) : Include all assignments from Engrade for Mr. Miller's class
 * 38) Save the File as Excel Grade Book project and submit to Schoology - Diving In - Excel Project - Week 1



Week 2 - Calculations
In the spreadsheet you created last week we are going to add some calculations to the spreadsheet:
 * 1) In the F Column (starting in F10) calculate the grade for each assignment by dividing the earned amount by the possible amount. (You can copy the formula down the entire column)
 * 2) Set the format of column F to percentage rounded to the nearest whole percent.
 * 3) In cell C3 Enter **Syllabus percentage**.
 * 4) In cell D3 enter in **Earned**
 * 5) In cell F3 enter in **Grade**
 * 6) Enter in the percentages as found in the syllabus in cells C4:C7
 * 7) In cell C4 include the percentage of the classwork grade. (You will need to look on the syllabus which can be found here.
 * 8) In cell C5 include the percentage of the Diving in grade. (Found in the syllabus)
 * 9) In cell C6 include the percentage of the Quizzes grade. (Found in the syllabus)
 * 10) In cell C7 include the percentage of the Tests grade. (Found in the syllabus)
 * 11) Select cell C3 and set the alignment to right
 * 12) Select cells C4:C7 and set the format to Percent with no decimal places
 * 13) In cells D4:D7 calculate the average of each grade.
 * 14) In cell D4 Average the classwork grades. Hint: Use Autosum, select Average and then select all the grades (column F) that are categorized as classwork.
 * 15) In cell D5 Average the Diving In grades. Hint: Use Autosum, select Average and then select all the grades (column F) that are categorized as Diving In.
 * 16) In cell D6 Average the Quizzes grades. Hint: Use Autosum, select Average and then select all the grades (column F) that are categorized as Quizzes.
 * 17) In cell D7 Average the Tests grades. Hint: Use Autosum, select Average and then select all the grades (column F) that are categorized as Tests.

The picture below will show you approximately what your sheet will look like but the calculations will be specific to your grade and may not match the picture.