You need to create a workbook to track the grades in your class. Your gradebook needs to include:
- A large merged cell with your name and the subject.
- The names of at least twenty students listed down the left columns.
- Name should be in three columns:
- Each student should have a four-digit id#.
- Twenty-five assignments that pertain to the class.
- For each assignment you need to give the points possible.
- Your assignments should have different values, some values may be used multiple times, but not for all assignments.
- You also need to calculate the average score for each assignment.
- A summary section to the right of the individual grades that includes summary information for each student:
- Total points
- Percentage
- Letter Grade
- On a separate worksheet you will need to list your grading scale for letter grades (ABCDF).
- Nicely formatted data that makes the spreadsheet easy to read. This should include cell borders and background color changes.
- You need to use conditional formatting to highlight high scores and low scores.
- You need to format your assignment names so that they are turned 90 degrees.
In class we will be working on formulas that:
- Take a list of names that is in full name format and separate it into two columns
- Take two columns of names and combine it for a full name
- Create a random id-number
- Create random grades in the proper range
- Look up the letter grade
I will also take some time to work on more advanced conditional formatting and other issues we come across while working on this assignment.
