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		81.9	95	95	90	88.92%	2
19
20
21	Summer semester
22
23		CB + (GR)	GS	LW	SP/PS	SST	Average in %	grade
24		94.8	95	100		93	85.85%	2
25
26
27	Groups E and F
28
29	Winter semester
30
31		CB	GR	LW	SP	Average in %	grade
32		87	87.5	93.5	86.4	88.96%	2
33
34
35	Summer semester
36
37		CB	LW	GS	SST	Average in %	grade
38		88.1	95.3	97.8	89.2	89.87%	1
39
40
41
42	Sophomores
43
44
45
46	Winter semester
47
48		CB	ALS	Average in %	grade
49		78.6	90	84.30%	2
50
51
52	Summer semester
53
54		CB	ALS	Project	Average in %	grade
55		85.4	90.9	93	88.93%	2
56
57
58
59
60
61	Juniors
62
63	Winter semester
64
65		CB	BLI	Average in %	grade
66		95.4	85.1	90.25%	1
67
68
69	Summer semester
70
71		CB	BLI	SST	Average in %	grade
72		90	95	80	90.00%	1
73
74
75
76	Seniors
77
78	Winter semester
79
80		CB	CRW	Average in %	grade
81		70.6	76.5	72.67%	3
82
83
84	Summer semester
85
86		CB	CRW	SST	Average in %	grade
87		81.9	98.6	47.75	79.25%	2
88
89
90
91
92	Super Seniors
93
94	Winter semester
95
96		CB	RS	WST	Average in %	grade
97		83.3	97.5	68	82.97%	2
98
99
100	Summer semester