Letter Grade Calculator

	B	C	D	F	G
1	Letter Grade Calculator Template
2
3	Student ID	Test Score	Grade	Mapping Table
4	ST_001	73	B-
5	ST_002	69	B-	Letter Grade	Score from
6	ST_003	94	A	F	0
7	ST_004	60	C+	D	35
8	ST_005	69	B-	C-	45
9	ST_006	75	B	C	50
10	ST_007	53	C	C+	55
11	ST_008	84	B+	B-	65
12	ST_009	68	B-	B	75
13	ST_010	71	B-	B+	80
14	ST_011	0	F	A-	85
15	ST_012	65	B-	A	90
16	ST_013	56	C+	A+	95
17	ST_014	52	C
18	ST_015	26	F
19	ST_016	43	D
20	ST_017	100	A+
21	ST_018	64	C+
22	ST_019	89	A-
23	ST_020	66	B-
24	ST_021	39	D
25	ST_022	31	F
26	ST_023	48	C-
27	ST_024	63	C+
28	ST_025	67	B-
29	ST_026	85	A-
30	ST_027	86	A-
31	ST_028	58	C+
32	ST_029	87	A-
33	ST_030	66	B-
34	ST_031	23	F
35	ST_032	71	B-
36	ST_033	28	F
37	ST_034	50	C
38	ST_035	28	F
39	ST_036	95	A+
40	ST_037	16	F
41	ST_038	89	A-
42	ST_039	93	A
43	ST_040	42	D
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