Excel Template for Reporting Grade Comparisons 17-18 rev11018.xlsx
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
- Note the tabs at the bottom of this spreadsheet.
- The second tab titled "Count (Rqd)" is required.
- For assistance, email
eportfolio@cdl.edu
2
Instructions for Reporting Course Grade Comparisons
3
4
Count (Rqd) Tab (second tab below):
5

Count your course's letter grades and enter the number of As, Bs, etc. into the appropriate table cells. (No percentages).
Chunk the A+, A, A- letter grades into one count, etc. for the other grades, except C grades. The exception is C-. If you have no C-, then place a "0" in those cells. *Do NOT delete any row under any circumstances.*
Fill in the Non-Passing grade on the line at the bottom of the table.
6
If C- is Non-Passing Grade: Enter the number of C-s in the C- row. At the base of the table next to "Note," record the Non-Passing Grade as C- .
7
Combine the count for C+ and C and then, update the total in the C count row; Please fill in the C- grade row in the table (row 6). If it is zero, mark that. Please do not delete the row in the table.
At the base of the table next to "Note," record the Non-Passing Grade as D
8
Finally: Make separate screenshots of the completed table and the graph to upload into two separate boxes under Stage 4.
9
10
11
Optional Percentage Template: (third tab below)
12
Convert your Grade Distribution Count to Percentages: Using the grade distribution counts you provided in the previous sheet, convert each letter grade count to a percentage (count divided by total) (e.g, A=6 (letter count) divided by 42 (total) = .142; move the decimal place to the right 2 places and identify the percentage (no decimal places).
13
(In the table) Update the #% for each letter grade distribution (no decimal places)
14
15
Optional Passing and Non-Passing Grade Template: (fourth tab below)
16
Identify the Percentages for Passing Grades: Using the percentages you used in the "Optional Percentages" template, add the percentages for passing grades and put the overall percentage in row 3 of the table (Pre Redesign and Redesigned); e.g, If C- is non-passing add the percentages for A, B, and C
17
Identify the Percentages for Non-Passing Grades: Using the percentages you used in the "Optional Percentages" template, add the percentages for non-passing grades and put the overall percentage in row 4 of the table (Pre Redesign and Redesigned); e.g, If C- is non-passing add the percentages for C-, D, F, W, & WU
18
19
20
21
5-31-18
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100