ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
2
3
The file is an example / template of an Excel implemented report with the literacy evaluation results.

The results of the evaluation are displayed for each students and also aggregated metrics by teacher / class.
This Excel tool is best downloaded and opened in Excel rather than used within Google Drive as a Google Sheet.

The following are descriptions and instructions for each of the 4 sheets:

1. Sheet Data is populated with the initial results of each evaluated student (containing also information about the teacher, the school, the class, county and region)
2. Sheet Data T1 is populated with the final results of each evaluated student containing similar information as in the Data sheet

The example datasets are anonymized and customized for the evaluation instruments used by Teach for Romania but can be adapted for any type of evaluations with numerical results: grades, percentages, etc.

3. Sheet Report contains the template of the initial evaluation report.
The results are displayed for each student and aggregated by class / teacher (WARNING: due to Excel-Google Sheets compatibility issues, the graphs are not displayed properly).

By selecting from the drop down list in G10 cell a class / teacher, the results will be loaded dynamically from the Data sheet dataset.
All the Excel formulas and formatting used are available and can be used for any customization needs.

4. Sheet Report T1 contains the template of the final evaluation report (it also contains comparisons with the initial evaluation).
The results are displayed for each student and aggregated by class / teacher (WARNING: due to Excel-Google Sheets compatibility issues, the graphs are not displayed properly).

By selecting from the drop down list in G10 cell a class / teacher, the results will be loaded dynamically from the Data T1 and Data sheets datasets.
All the Excel formulas and formatting used are available and can be used for any customization needs.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100