English - final grade - Google Sheets

	A	B	C	D	E	F	G	H
1

2
3			If you need a hand with calculating your final English grade, type your subject percentages into the green cells.
4
5
6
7
8	WARNING! when typing a decimal point, you always must use "." instead of "," !
9
10
11	Freshmen
12
13	Groups A,B,C and D
14
15	Winter semester
16
17		CB (+GR)	GS	SP/PS	LW	Average in %	grade
18		88.5	92	100	76.3	87.27%	2
19
20
21	Summer semester
22
23		CB + (GR)	GS	LW	SP/PS	SST	Average in %	grade
24		92	96.3	88.7	95.5	0	64.74%	4
25
26
27	Groups E and F
28
29	Winter semester
30
31		CB	GR	LW	SP	Average in %	grade
32		93.5	82.9	93.5	98	92.06%	1
33
34
35	Summer semester
36
37		CB	LW	GS	SST	Average in %	grade
38		86	86.7	95.4	91.1	90.02%	1
39
40
41
42	Sophomores
43
44
45
46	Winter semester
47
48		CB	ALS	Average in %	grade
49		84.3	100.6	92.45%	1
50
51
52	Summer semester
53
54		CB	ALS	Project	Average in %	grade
55		92	89.9	80	88.76%	2
56
57
58
59
60
61	Juniors
62
63	Winter semester
64
65		CB	BLI	Average in %	grade
66		87.7	71.3	79.50%	2
67
68
69	Summer semester
70
71		CB	BLI	SST	Average in %	grade
72		99.5	100	46.5	89.10%	1
73
74
75
76	Seniors
77
78	Winter semester
79
80		CB	CRW	Average in %	grade
81		84	93.8	87.43%	2
82
83
84	Summer semester
85
86		CB	CRW	SST	Average in %	grade
87		90.3	94.6	86.1	90.54%	1
88
89
90
91
92	Super Seniors
93
94	Winter semester
95
96		CB	RS	WST	Average in %	grade
97		95	102.1	73.4	90.65%	1
98
99
100	Summer semester