ESS IB scores.xlsx

	A	B	C	D	E	F	G
1
2	Teacher	year	# Students	class avg	global average	difference	diff*# of students
3	John	2005	20	5.35	4.72	0.63	12.6
4	John	2006	15	4.87	4.42	0.45	6.8
5	John	2007	27	4.72	4.07	0.65	17.6
6	Mandy	2008	21	4.56	4.14	0.42	8.8
7	Mandy	2009	26	4.71	4.02	0.69	17.9
8	Ben	2010	19	5.68	4.13	1.55	29.5
9	Ben	2011	28	5.85	4.15	1.70	47.6
10	Ben	2012	35	5.85	4.12	1.73	60.6
11	Ben	2013	37	5.54	4.22	1.32	48.8
12	Ben	2014	25	5.76	4.19	1.57	39.3
13	Ben	2015	30	6.00	4.20	1.80	54.0
14	Ben	2016	29	5.40	4.10	1.30	37.7
15	Ben	2017	33	5.70	4.20	1.50	49.5
16	Ben	2018	29	5.45	4.15	1.29	37.4
17	Ben	2019	31	5.30	4.20	1.10	34.1
18	Ben	2020	31	5.74	4.20	1.03	31.9
19	Ben	2021	33	5.75	4.71	1.04	34.3
20	Ben	2022	35	5.71	4.46	1.25	43.8
21	Ben	2023	34	5.23	4.23	1.00	34.0
22	Ben	2024	24	5.31	4.19	1.12	26.9
23	Ben	2025	31	5.6	4.27	1.33	41.2
24
25
26
27	Avg		30.2	5.62	4.23	1.35	40.6
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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		2005	0	0.63
77		2006	0	0.45
78		2007	0	0.65
79		2008	0	0.42
80		2009	0	0.69
81		2009	2	0.69
82		2009	0	0.69
83		2010	0	1.55
84		2011	0	1.70
85		2012	0	1.73
86		2013	0	1.32
87		2014	0	1.57
88		2015	0	1.80
89		2016	0	1.30
90		2017	0	1.50
91		2018	0	1.29
92		2019	0	1.10
93		2020	0	1.03
94		2021	0	1.04
95		2022	0	1.25
96		2023	0	1.00
97		2024	0	1.12
98		2025	0	1.33
99
100