This class uses weighting, which you will need to account for in the calculation. Tests are worth 80% of the grade, and the class project is worth 20% of the grade. To calculate the final grade percentage you will need to add up the test scores; then divide by the total number of test points and then multiply by the weighted percentage. In a similar manner, calculate the percentage for the project. Then add the two totals together to get the final grade. Remember, students cannot earn more than 100%!!

2. Once you have the grade percentages, then calculate the letter grades and plus/minus letter grades.

3. Next, complete the data for columns M through R showing the grade percentages (Note** do NOT use adjusted percentages!!), the corresponding plus/minus letter that equates to, how many students had that grade, what percentage that is of total students, the grade point and the average.

4. Using the letter grades and total students (columns N and O), create a Grade Distribution graph.

5. Use the technics you learned in the module to complete the file, then complete the assessment questions using the file you create.

Please state the formula for the blank rows and bottom columns!

225 Student 224 228 Max 229Min 230 Median 231 Mode 232 Standard Deviation 233 Count of 90 or above 234 Count of less than 70 225 Student 224 228 Max 229Min 230 Median 231 Mode 232 Standard Deviation 233 Count of 90 or above 234 Count of less than 70