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		92.3	93.8	96,5	90,2	#VALUE!	#VALUE!
19
20
21	Summer semester
22
23		CB + (GR)	GS	LW	SP/PS	SST	Average in %	grade
24		93.3	84.7	90	96.7	84.1	88.93%	2
25
26
27	Groups E and F
28
29	Winter semester
30
31		CB	GR	LW	SP	Average in %	grade
32		46	38	62	71.8	53.07%	4
33
34
35	Summer semester
36
37		CB	LW	GS	SST	Average in %	grade
38		100	100	100	100	100.00%	1
39
40
41
42	Sophomores
43
44
45
46	Winter semester
47
48		CB	ALS	Average in %	grade
49		94,5	91,9	#VALUE!	#VALUE!
50
51
52	Summer semester
53
54		CB	ALS	Project	Average in %	grade
55		94	85	91.4	89.88%	1
56
57
58
59
60
61	Juniors
62
63	Winter semester
64
65		CB	BLI	Average in %	grade
66		46.1	65.9	56.00%	3
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		85.7	92.8	88.19%	2
82
83
84	Summer semester
85
86		CB	CRW	SST	Average in %	grade
87		90.9	96.7	75	89.17%	1
88
89
90
91
92	Super Seniors
93
94	Winter semester
95
96		CB	RS	WST	Average in %	grade
97		83.6	92.3	85	86.63%	2
98
99
100	Summer semester