PPL_Grades.xlsx

	A	B	C	D	E	F	G	H	I	J
1	學號	Assignment1 12.5%	Assignment2 12.5%	Midterm(Original)	Midterm+10 30%	Final 40%	Attendence 5%	Bonus	Total 100%	Score

2	108201529	57.5	47	71.8	81.8	80	5	10	84.6025	85
3	108201532	58	43	59.8	69.8	69	5		66.165	66
4	108201542	60	20	64.9	74.9	67	5		64.27	64
5	108303015	68.5	43	86.8	96.8	76	5		78.3775	78
6	108303203	82.5	89	71.8	81.8	68	5		78.1775	78
7	108303205	57.6	39	67	77	40	5		51.375	53
8	108303303	79.5	89	66.3	76.3	72	5		77.7525	78
9	108303509	67	35	64.4	74.4	54	5		61.67	62
10	108303601	65.5	43	67	77	68	5		68.8625	69
11	108403007	94	94	92	102	82	5		91.9	92
12	109201024	84	86	69.8	79.8	83	5		83.39	83
13	109201025	87	83	82.8	92.8	91	5	10	100.49	100
14	109201026	80	63	75.8	85.8	96	5		87.015	87
15	109201504	84	97	84	94	106	5		98.225	98
16	109201526	83	62	85	95	69	5		79.225	79
17	109201532	81	62	93.9	103.9	100	5		94.045	94
18	109201551	59.5	50	66.8	76.8	51	5		62.1275	62
19	109202524	60	60	81.7	91.7	99	5	10	97.11	97
20	109302007	74	46	83.9	93.9	74	5		77.77	78
21	109302027	71.1	46	51	61	51	5		58.3375	58
22	109302545	87.5	86	76.4	86.4	89	5		88.2075	88
23	109303001	84	87	90.4	100.4	79	5		88.095	88
24	109303524	64.5	93	73.8	83.8	90	5		85.8275	86
25	109403009	79.5	91	100	110	75	5	6	95.3125	95
26	109403019	76	100	105	115	101	5		101.9	100
27	109403020	66	86	96	106	76	5		86.2	86
28	109403021	66	97	96	106	85	5		91.175	91
29	109403521	78	84	84	94	85	5	9	96.45	96
30	109403524	64.8	91	82.4	92.4	85	5	6	92.195	92
31	109403525	69.5	78	86	96	75	5		82.2375	82
32	109501518	79.5	100	95.4	105.4	103	5	3	103.2575	100
33	109502004	56	90	84.4	94.4	83	5		84.77	85
34	109502019	77.5	100	68.3	78.3	71	5		79.0775	79
35	109502517	88	92	70	80	86	5	14	99.9	100
36	109502530	81.5	57	64.9	74.9	74	5		74.3825	74
37	109503526	81.5	86	74.8	84.8	70	5		79.3775	79
38	109503530	84.5	74	79	89	70	5		79.5125	80
39	109504501	62	68	75.4	85.4	78	5		78.07	78
40	109601003	63	54	82	92	81	5		79.625	80
41	109601005	63	68	91.4	101.4	101	5		92.195	92
42	109602007	88	89	57.3	67.3	62	5		72.115	72
43	109602009	72	83	52.3	62.3	46	5		61.465	61
44	109602521	59	97	69.8	79.8	70	5		76.44	76
45	109602531	60	96	67.3	77.3	86	5		82.09	82
46	109607003	77	85	96.4	106.4	100	5		97.17	97
47	109607004	71	94	80.8	90.8	75	5	47	129.865	100
48	110201520	51.3	93	66	76	59	5		69.4375	69
49	110201532	83.5	97	85.4	95.4	106	5		98.5825	99
50	110202001	70.5	66	82.4	92.4	81	5		82.1825	82
51	110302031	85.5	94	96.4	106.4	101	5		99.7575	100
52	110305509	71	89	76.4	86.4	102	5		91.72	92
53	110403041	55.35	91	87	97	87	5		87.19375	87
54	110403507	73	85	87	97	78	5	10	95.05	95
55	110403508	65.5	67	97.4	107.4	77	5		84.5825	85
56	110403512	86.5	97	101	111	98	5		100.4375	100
57	110403515	72.5	96	89.4	99.4	76	5		86.2825	86
58	110403516	96.5	97	99	109	106	5		104.2875	100
59	110403517	79.5	91	82.4	92.4	59	5		77.6325	78
60	110403519	74	94	98	108	99	5		98	98
61	110502001	83.5	97	89.4	99.4	81	5		89.7825	90
62	110502002	86.5	97	86.4	96.4	84	5		90.4575	90
63	110502003	87.5	91	93.4	103.4	104	5	10	109.9325	100
64	110502005	76.5	85	98	108	91	5	10	103.9875	100
65	110502006	79	83	74.4	84.4	83	5		83.77	84
66	110502007	63	87	92.4	102.4	88	5	10	99.67	100
67	110502009	86.5	94	94.4	104.4	103	5		100.0825	100
68	110502010	88.5	97	87.3	97.3	88	5		92.5775	93
69	110502011	72	75	90.4	100.4	85	5		87.495	87
70	110502012	86.5	100	91.8	101.8	88	5	10	104.0525	100
71	110502013	82.5	76	69.3	79.3	68	5		75.8025	76
72	110502015	56	74	77.4	87.4	78	5		78.67	79
73	110502017	82.5	75	78.8	88.8	62	5		76.1275	76
74	110502201	86	86	83.8	93.8	91	5		91.04	91
75	110502501	89	100	86.4	96.4	92	5	3	97.345	97
76	110502502	87.5	86	82.4	92.4	82	5		87.2075	87
77	110502503	87.5	89	77	87	94	5		90.7625	91
78	110502504	76.5	83	67.3	77.3	58	5		71.3275	71
79	110502505	84.5	75	68.4	78.4	75	5		78.4575	78
80	110502506	87.5	100	88.4	98.4	89	5	10	103.5575	100
81	110502507	85.5	100	88.4	98.4	104	5	1	100.3075	100
82	110502508	64.5	75	82.8	92.8	87	5		85.0775	85
83	110502509	67	74	83.4	93.4	80	5		82.645	83
84	110502510	67.5	75	78.4	88.4	88	5		84.5325	85
85	110502511	85	69	75	85	92	5		86.55	87
86	110502512	82.5	94	76.8	86.8	88	5		88.3025	88
87	110502513	85.5	87	93.4	103.4	91	5		93.9825	94
88	110502514	82.5	89	74.4	84.4	62	5		76.5575	77
89	110502516	75.5	92	72.4	82.4	88	5	15	100.8575	100
90	110502517	64	94	84.4	94.4	97	5		91.87	92
91	110502518	64	68	89.9	99.9	80	5	19	102.47	100
92	110502519	85.5	83	79.4	89.4	90	5	10	98.8825	99
93	110502520	88.5	88	72.4	82.4	82	5	10	94.5825	95
94	110502521	67.5	81	70	80	90	5		83.5625	84
95	110502522	65.5	61	85	95	82	5		82.1125	82
96	110502523	78.5	97	92.4	102.4	89	5	11	104.2575	100
97	110502524	63.5	97	46.8	56.8	53	5		63.3025	63
98	110502525	66	100	72.5	82.5	80	5		82.5	83
99	110502526	61	97	82.8	92.8	78	5		83.79	84
100	110502527	62.5	97	52.5	62.5	80	5		75.6875	76