+1(978)310-4246 credencewriters@gmail.com
  

Description

I have attached the instructions for the assignment below. Also attached is the excel document where the assignment will be done. Thank you!

Name
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Student 19
Student 20
Student 21
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Student 31
Student 32
Student 33
Student 34
Student 35
Student 36
Student 37
Student 38
Student 39
Student 40
Student 41
Student 42
Student 43
Student 44
Student 45
Student 46
Student 47
Student 48
Student 49
Student 50
Student 51
Student 52
Student 53
Student 54
Exam 1
Exam 2
90
96
89
89
97
91
56
89
93
50
50
98
84
55
90
96
95
79
85
93
78
93
89
67
90
92
90
93
90
88
93
94
89
93
50
90
88
94
85
91
89
97
94
91
84
94
96
94
50
71
86
89
96
80
88
97
96
97
88
89
85
89
96
89
86
100
90
89
94
100
95
89
88
64
92
95
91
90
97
91
96
97
83
86
93
91
50
93
50
83
91
98
87
89
84
88
95
95
76
91
87
93
53
80
50
90
95
87
Exam 3
93
96
92
96
93
62
55
91
100
89
96
98
63
92
94
98
99
87
93
93
91
96
92
85
99
90
70
91
91
96
97
90
50
93
50
96
95
98
88
94
83
95
90
98
83
95
67
99
50
50
89
88
98
58
Exam Percent Project
57
100
72
73
95
16
28
90
100
74
98
100
0
83
88
100
98
100
75
75
28
100
84
88
100
98
100
76
76
100
47
93
1
62
0
47
34
100
100
93
84
49
100
98
84
92
61
87
0
58
85
62
97
27
Project Percent
Student 55
Student 56
Student 57
Student 58
Student 59
Student 60
Student 61
Student 62
Student 63
Student 64
Student 65
Student 66
Student 67
Student 68
Student 69
Student 70
Student 71
Student 72
Student 73
Student 74
Student 75
Student 76
Student 77
Student 78
Student 79
Student 80
Student 81
Student 82
Student 83
Student 84
Student 85
Student 86
Student 87
Student 88
Student 89
Student 90
Student 91
Student 92
Student 93
Student 94
Student 95
Student 96
Student 97
Student 98
Student 99
Student 100
Student 101
Student 102
Student 103
Student 104
Student 105
Student 106
Student 107
Student 108
Student 109
95
90
89
50
87
50
89
94
99
86
50
94
87
89
85
88
88
92
98
80
89
96
98
93
84
50
89
84
79
99
91
96
88
50
95
89
91
88
50
50
50
96
94
87
91
99
92
89
92
85
93
87
92
93
90
88
60
91
54
87
55
82
97
91
95
95
93
94
82
93
88
85
94
95
88
85
95
68
94
81
92
89
50
94
97
85
98
87
85
96
50
87
90
56
57
86
100
92
93
90
96
95
84
98
94
92
86
92
65
61
99
94
96
50
60
50
90
97
96
92
99
93
92
88
93
89
88
96
98
61
76
95
93
89
88
66
93
95
91
96
87
97
86
98
86
50
92
83
50
50
82
98
98
97
88
99
89
86
95
69
97
93
94
50
50
100
51
73
25
70
0
68
100
100
56
99
53
94
97
72
98
26
97
100
37
84
100
100
89
55
61
67
98
64
100
60
100
100
39
71
54
41
46
61
0
66
93
100
84
60
100
64
85
73
39
88
70
74
24
27
Student 110
Student 111
Student 112
Student 113
Student 114
Student 115
Student 116
Student 117
Student 118
Student 119
Student 120
Student 121
Student 122
Student 123
Student 124
Student 125
Student 126
Student 127
Student 128
Student 129
Student 130
Student 131
Student 132
Student 133
Student 134
Student 135
Student 136
Student 137
Student 138
Student 139
Student 140
Student 141
Student 142
Student 143
Student 144
Student 145
Student 146
Student 147
Student 148
Student 149
Student 150
Student 151
Student 152
Student 153
Student 154
Student 155
Student 156
Student 157
Student 158
Student 159
Student 160
Student 161
Student 162
Student 163
Student 164
83
87
87
90
80
82
86
92
88
93
91
82
50
91
94
85
87
95
50
82
86
81
95
81
92
92
87
78
98
87
84
95
88
92
86
53
93
88
82
98
90
82
90
90
98
89
50
86
88
91
80
78
93
85
80
85
94
92
91
89
94
86
63
80
83
92
91
79
90
90
83
50
66
93
90
95
81
98
90
92
94
92
59
99
89
98
96
86
90
91
89
88
96
96
67
95
87
97
81
98
94
50
80
90
92
60
51
95
96
84
56
96
93
96
90
82
92
92
91
80
94
64
82
95
96
85
50
50
95
93
90
89
94
89
99
97
95
50
96
96
97
98
81
98
94
92
94
97
94
97
91
59
90
87
71
89
80
85
95
67
50
50
98
94
54
83
98
49
17
89
23
92
96
78
100
98
63
45
63
70
49
28
77
71
41
77
28
71
47
74
98
56
32
98
77
77
100
80
100
100
75
89
97
94
94
78
40
78
33
100
53
32
27
55
54
73
0
78
100
17
Student 165
Student 166
Student 167
Student 168
Student 169
Student 170
Student 171
Student 172
Student 173
Student 174
Student 175
Student 176
Student 177
Student 178
Student 179
Student 180
Student 181
Student 182
Student 183
Student 184
Student 185
Student 186
Student 187
Student 188
Student 189
Student 190
Student 191
Student 192
Student 193
Student 194
Student 195
Student 196
Student 197
Student 198
Student 199
Student 200
Student 201
Student 202
Student 203
Student 204
Student 205
Student 206
Student 207
Student 208
Student 209
Student 210
Student 211
Student 212
Student 213
Student 214
Student 215
Student 216
Student 217
Student 218
Student 219
93
86
90
92
92
88
89
84
91
84
93
87
94
89
89
89
91
93
83
91
50
89
87
87
95
92
88
92
88
85
92
89
95
88
83
91
50
91
34
84
88
73
94
82
97
85
96
90
89
90
45
80
82
86
84
98
85
89
92
87
92
50
62
87
88
91
93
97
92
92
89
96
96
85
93
92
87
85
94
93
90
89
93
95
92
87
89
91
97
89
93
52
62
89
91
93
58
89
93
96
92
91
50
91
93
67
93
61
93
86
97
57
89
94
89
93
92
84
95
98
95
92
95
85
91
88
91
96
87
90
65
85
87
91
96
88
91
91
96
96
98
86
92
96
82
68
50
93
91
82
94
50
97
93
98
92
97
94
93
89
50
89
88
89
89
96
40
89
91
100
0
42
100
70
96
90
100
88
87
47
96
100
100
63
100
45
46
61
66
94
73
58
64
92
96
52
100
49
69
63
65
19
58
98
46
89
92
28
95
100
93
100
45
85
95
0
83
94
81
90
Student 220
Student 221
Student 222
Student 223
Student 224
Student 225
Average
Max
Min
Median
Mode
Standard Deviation
Count of 90 or above
Count of less than 70
94
24
50
89
87
93
94
94
93
93
89
94
95
96
91
88
88
97
100
100
67
16
57
73
Grade Percentage Letter Grade Plus-Minus Letters
Percent
Letter
Total
Percent
Grade Point Average
0
4,33
1
2
2,33
2,66
3
3,33
3,66
4
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. Exams 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
exam scores; then divide by the total number of exam 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. Complete the assessment using the file you create – upload your file to question 1, then answer the remaining 4
questions based on your file.
Your completed file should look similar to this:
K
N
s
M
Percent Letter
0E
0.6 D
0.7 C
0.77 C
0.8 B-
0.83 B
0.87 B
0.9 A-
0.93 A
0.97 A.
0
P
Total Percent
15 6.7%
16 7.1%
20 8.9%
17 7.6%
18 8.0%
36 16.0%
28 12.4%
33 14.7%
29
12.9%
13 5.8%
225
Q
R
Grade Point Average
0
0
1 16
2. 40
2 33 39.61
2.66 47.88
3 108
3.33
93.24
3.66 120.78
4 116
4.33 56.29
2834667
A
1 Name
2 Student 1
3 Student 2
4 Student 3
5 Student 4
6 Student 5
7 Student 6
8 Student 7
9 Student 8
10 Student 9
11 Student 10
12 Student 11
13 Student 12
14 Student 13
15 Student 14
16 Student 15
17 Student 16
18 Student 17
19 Student 18
20 Student 19
21 Student 20
22 Student 21
23 Student 22
24 Student 23
25 Student 24
26 Student 25
27 Student 26
B С D
E
F
G
H
1
J
Exam 1 Exam 2 Exam 3 Exam Percent Project Project Percent Percent Letter Grade Plus-Minus Letters
90 88 93 72 3% 57
11% 83.7% B
B
96 97 96 77.1% 100
20% 97.1% A
A+
89 96 92
73.9% 72
14% 88.3% B
B+
89 97 96 75.2% 73
15% 89.8% B
B+
97 88 93
74.1% 95
19% 93.1% A
A
91 89 62
64.5% 16
3% 67.7% D
D
56 85 55 52.3% 28
6% 57.9% E
E
89 89 91
71.7% 90
18% 89.7% B
B4
93 96 100 77.1% 100
20% 97.1% A
A+
50 89 89 60.8% 74
15% 756% C
С
50 86 96 61.9% 98
20% 81.5% B
B
98 100 98 78.9% 100
20% 98.9% A
A+
84 90 63 63.2% 0
0% 63.2% D
D
55 89 92 62.9% 83
17% 79.5% C
C+
90 94 94 74.1% 88
18%
91.7% A
A
96 100 98
78.4% 100
20% 98.4% A
A+
95 95 99
77.1%
98
20% 96.7% A
A
79 89 87 68.0% 100
20%
88.0% B
B+
85 88 93
70.9% 75
15% 85.9% B
B
93 64 93
66.7% 75
15% 81.7% B
B-
78 92 91 69.6% 28
6% 75.2% C
с
93 95 96
75.7% 100
20% 95.7% A
A
91 92
72.5% 84
17% 89.3% B
B+
67 90 85
64.5% 88
18% 82.1% B
B-
90 97 99
76.3% 100
20% 96.3% A
A
92 91 90 72.8% 98
20% 92.4% A
A
887
P:
Grade Distribution
40
35
30
25
Number of
20
Students
15
10
5

Purchase answer to see full
attachment

error: Content is protected !!