Question
This file is a grade sheet for a class. You need to calculate final grades for the professor, using the following guidelines: 1. This class
This file is a grade sheet for a class.
You need to calculate final grades for the professor, using the following guidelines:
1. This class uses weighting, which you will need to account for in the calculation. quizzes 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 quiz scores; then divide by the total number of quiz 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.
Your completed file should look similar to this:
z \begin{tabular}{|r|r|r|r|} \hline 83 & 89 & 82 & 63 \\ \hline 91 & 93 & 68 & 65 \\ 50 & 52 & 55 & 19 \\ \hline 91 & 62 & 93 & 58 \\ \hline 34 & 89 & 91 & 98 \\ 84 & 91 & 82 & 48 \\ \hline 88 & 93 & 94 & 89 \\ \hline 73 & 58 & 50 & 92 \\ 94 & 89 & 97 & 28 \\ \hline 82 & 93 & 93 & 95 \\ \hline 97 & 96 & 98 & 100 \\ 85 & 92 & 92 & 93 \\ \hline 96 & 91 & 97 & 100 \\ \hline 90 & 50 & 94 & 45 \\ 89 & 91 & 93 & 85 \\ \hline 90 & 93 & 89 & 95 \\ \hline 45 & 67 & 50 & 0 \\ 80 & 93 & 89 & 83 \\ \hline 82 & 61 & 88 & 94 \\ 86 & 93 & 89 & 81 \\ 84 & 86 & 89 & 90 \\ \hline 94 & 94 & 95 & 100 \\ \hline 24 & 94 & 96 & 100 \\ 50 & 93 & 91 & 67 \\ \hline 89 & 93 & 88 & 16 \\ \hline 87 & 89 & 88 & 57 \\ \hline 93 & 94 & 97 & 73 \\ \hline & & & \end{tabular} Standard Deviation Count of 90 or above z \begin{tabular}{|r|r|r|r|} \hline 83 & 89 & 82 & 63 \\ \hline 91 & 93 & 68 & 65 \\ 50 & 52 & 55 & 19 \\ \hline 91 & 62 & 93 & 58 \\ \hline 34 & 89 & 91 & 98 \\ 84 & 91 & 82 & 48 \\ \hline 88 & 93 & 94 & 89 \\ \hline 73 & 58 & 50 & 92 \\ 94 & 89 & 97 & 28 \\ \hline 82 & 93 & 93 & 95 \\ \hline 97 & 96 & 98 & 100 \\ 85 & 92 & 92 & 93 \\ \hline 96 & 91 & 97 & 100 \\ \hline 90 & 50 & 94 & 45 \\ 89 & 91 & 93 & 85 \\ \hline 90 & 93 & 89 & 95 \\ \hline 45 & 67 & 50 & 0 \\ 80 & 93 & 89 & 83 \\ \hline 82 & 61 & 88 & 94 \\ 86 & 93 & 89 & 81 \\ 84 & 86 & 89 & 90 \\ \hline 94 & 94 & 95 & 100 \\ \hline 24 & 94 & 96 & 100 \\ 50 & 93 & 91 & 67 \\ \hline 89 & 93 & 88 & 16 \\ \hline 87 & 89 & 88 & 57 \\ \hline 93 & 94 & 97 & 73 \\ \hline & & & \end{tabular} Standard Deviation Count of 90 or aboveStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started