School Overview - compare screen

Good Test Set Loooooooong Word
Target for the Good Long Heading Test Set
Difference

Attainment 8 and Progress 8

Attainment 8 (avg grade)
23
23
3
Progress 8
23
23
3
KS2 prior attainment (avg level)
23
23
3
Learners with a positive Progress 8 score
23
23
3

English and Maths (basics)

Strong (9-5) pass
23
23
3
Standard (9-4) pass
23
23
3
Learners achieving Level 2 in English
23
23
3
Learners achieving Level 2 in English
23
23
3

EBacc

APS
23
23
3
Entered
23
23
3
Strong (9-5) pass
23
23
3
Standard (9-4) pass
23
23
3

Overall pass rate

Strong (9-5) pass
23
23
3
Standard (9-4) pass
23
23
3
5+ strong pass
23
23
3
5+ standard pass
23
23
3
5+ strong inc English and Maths
23
23
3
5+ standard inc English and Maths
23
23
3

Responsive Transition Matrix

The size of the matrix is automatically sized based on the different x and y axis chosen.

Perhaps the best location is as a dropdown under the existing grades tab, ie Matrix, then Grades, withe Matrix as the default?

Art
English
French
Subject with a really long name
.active
Quite a long name
.hov-1
.hov-1
.hov-1
Quite a long name
.hov-1
.hov-1
.hov-1
Learners' Actual
Learners' Estimated
Actual grade XX Estimated Grade YY
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6
PP SEND G+T
Gender
Male
Prior Attainment
Prior Attainment
High
Ethnicity
White/Black Caribbean
Gender
Male
Looked After
FSM Ever 6

Admin page

Headline measures and Overview page. Caters for drill-down

 
Attainment 8
Progress 8
Strong (9-5)
Estimated: 58.13
-0.12
 
Estimated: 0.28
Main measures
Attainment 8 (ave grade)
KS2 prior attainment (ave level)
0.12
Secondary measures
Learners included
153
Learners with adjusted Progress 8 scores
6
Progress 8 (unadjusted)
-0.16
Learners with a poitive Progress 8 score
46
Learners with a poitive Progress 8 score in all baskets
6
English
Estimated (ave)
5.60
Grade for both English qualifications (ave)
5.25
Maths
Estimated (ave)
5.60
Grade for both English qualifications (ave)
3.36
EBacc
Estimated (ave)
13.71
Slots filled (ave)
2.83
Estimated slots filled (ave)
2.9
Open
Estimated (ave)
13.71
Slots filled (ave)
2.83
Estimated slots filled (ave)
2.9
English
Learners with a positive progress score
15
Upper confidence limit
0.32
Lower confidence limit
0.10
Maths
Learners with a positive progress score
15
Upper confidence limit
0.32
Lower confidence limit
0.10
EBacc
Learners with a positive progress score
15
Upper confidence limit
0.32
Lower confidence limit
0.10
Open
Learners with a positive progress score
15
Upper confidence limit
0.32
Lower confidence limit
0.10
 
English and maths (basics)
Strong (9-5)
Estimated: 62%
Standard (9-4)
Estimated: 68%
Matrix
For grades 9 to 8

Without English
With English
Without Maths
5
With Maths
Other measures
Learners achieving English
172
Learners achieving Maths
21
English and Maths matrix                For grades 9 to 7
 
EBacc
APS
Estimated: 6.3
Entered
Strong (9-5)
Estimated: 46
Standard (9-4)
Estimated: 74
Other measures
Slots filled (ave)
2.2
English
6.54
Learners entered
146
Learners achieving a strong pass
101
Learners achieving a standard pass
139
Maths
6.54
Learners entered
146
Learners achieving a strong pass
101
Learners achieving a standard pass
139
Science
6.54
Learners entered
146
Learners achieving a strong pass
101
Learners achieving a standard pass
139
Human.
6.54
Learners entered
146
Learners achieving a strong pass
101
Learners achieving a standard pass
139
Lang.
6.54
Learners entered
146
Learners achieving a strong pass
101
Learners achieving a standard pass
139
 
Overall pass rate
5 Standard Passes
Estimated: 62%
4 Standard Passes
Estimated: 68%
Main measures
Learners with 1 or more qualifications
103
Entries (ave.) per learner for all qualification types
8.1
Entries (ave.) per learner for just GCSEs
7.3
Subjects
Learners achieving 2 or more languages
17
Learners taking 3 single sciences
32
Learners taking Combined Science
168
Learners achieving 99-77 in Combined Science
47
Learners achieving 99-55 in Combined Science
97
Learners achieving 99-44 in Combined Science
178
English
-0.12
Confidence limits
Upper
0.37
Lower
-0.12
Maths
-0.12
Confidence limits
Upper
0.37
Lower
-0.12
Science
-0.12
Confidence limits
Upper
0.37
Lower
-0.12
Humanities
-0.12
Confidence limits
Upper
0.37
Lower
-0.12
Language
-0.12
Confidence limits
Upper
0.37
Lower
-0.12

Tabs

Option boxes. From clarity.design

One of three columns

SVG data visualisation - Attainment



Comparing Two Tracking Points : Qualifications list AND Classes list

Comparing Two Tracking Points: Students list

Ytd
L-Graph
Grade
7
7
0.80
Progress
-0.29
-0.29
0.80
KS2 Prior
-0.29
-0.29
0.80
Residual
0.29
0.29
0.80
Counted in A8
Ytd
L-Graph
Grade
7
7
0.80
Progress
-0.29
-0.29
0.80
KS2 Prior
-0.29
-0.29
0.80
Residual
0.29
0.29
0.80
Counted in A8

Comparing Two Tracking Points: Individual Student record

Ytd
L-Graph
Qualifications
Class
Grade (and Points)
6.0
6.0
0.80
Progress
-1.12
-1.12
0.80
Residual
-0.71
-0.71
0.80
Counted in A8
Ytd
L-Graph
Qualifications
Class
Grade (and Points)
6.0
6.0
0.80
Progress
-1.12
-1.12
0.80
Residual
-0.71
-0.71
0.80
Counted in A8

Drill down from qualifications, to subjects. (Extracted from Dave's work, so contains Id's. etc.)

Ytd
L-Graph
Qualifications
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32
Ytd
L-Graph
Av. Attainment
5.5
5.7
-0.2
Progress
0.3
0.2
0.1
Grades
9 - 1
Cohort
190
192
2
Residual
0.52
0.62
-0.1
Type of pass
Strong
72%
80%
-10%
Standard
70%
90%
-20%
In A8
182
150
32

Data Row on the Student Details Form


For the student details form. The full form is here

Ytd
L-Graph
Qualifications
GCSE Art Graphics Longish Title
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade (and Points)
6 (6.0)
Progress
-0.12
Residual
-0.12
Counted in A8
Ytd
L-Graph
Qualifications
GCSE Art Graphics Longish Title
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade (and Points)
6 (6.0)
Progress
-0.12
Residual
-0.12
Counted in A8
Ytd
L-Graph
Qualifications
GCSE Art Graphics Longish Title
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade (and Points)
6 (6.0)
Progress
-0.12
Residual
-0.12
Counted in A8
Ytd
L-Graph
Qualifications
GCSE Art Graphics Longish Title
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade (and Points)
6 (6.0)
Progress
-0.12
Residual
-0.12
Counted in A8
Ytd
L-Graph
Qualifications
GCSE Art Graphics Longish Title
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade (and Points)
6 (6.0)
Progress
-0.12
Residual
-0.12
Counted in A8


Hyperlinks from Qualifications


Time Series

Ytd
Qualifications
2020/2021 Year 11 Review 5
Avg AttainmentGrade
8%
Progress
90%
2020/2021 Year 11 Review 5
Avg AttainmentGrade
8%
Progress
90%
2020/2021 Year 11 Review 5
Avg AttainmentGrade
8%
Progress
90%
2020/2021 Year 11 Review 5
Avg AttainmentGrade
8%
Progress
90%

Drill down from qualifications, to subjects (and also qualifications to subjects to classes). (Extracted from Dave's work, so contains Id's. etc.)

Ytd
L-Graph
Qualifications
Av. Attainment
5.5
Progress
0.02
Grades
9 - 1
Cohort
192
Residual
0.02
Type of pass
Strong
72%
Standard
90%
In A8
182
Ytd
L-Graph
Qualifications
Av. Attainment
4.8
Progress
-0.35
Grades
9 - 1
Cohort
136
Residual
-0.29
Type of pass
Strong
64%
Standard
88%
In A8
98
Ytd
L-Graph
Qualifications
Av. Attainment
6.3
Progress
1.26
Grades
9 - 1
Cohort
191
Residual
0.86
Type of pass
Strong
88%
Standard
95%
In A8
191

**Check if these are the correct rows ** Drill down from qualifications, to classes to students. (Extracted from Dave's work, so contains Id's. etc.)

Ytd
L-Graph
Name
Grade
6.2
Progress
-0.12
KS2 Prior
+5.28+
Residual
-0.12
Counted in A8
Ytd
L-Graph
Grade
6.2
Progress
-0.12
KS2 Prior
+5.28+
Residual
-0.12
Counted in A8
Ytd
L-Graph
Grade
6.2
Progress
-0.12
KS2 Prior
+5.28+
Residual
-0.12
Counted in A8
231

Drill down from qualifications, to Split-by-category (tab). (Extracted from Dave's work, so contains Id's. etc.)

Graph
Graph
Qualifications
Pupil Premium
PP
4.7
Non-PP
5.6
Special Educational Needs
SEN
5.5
Non-SEN
5.7
S
5.0
E
4.4
K
2.7
Prior attainment
(By KS2 level)
Prior Attainment at KS2
Overall
Low
3.6
Mid
5.0
High
6.6
Graph
Graph
Qualifications
Pupil Premium
PP
4.3
Non-PP
4.8
Special Educational Needs
SEN
4.8
Non-SEN
4.9
S
5.0
E
4.4
K
2.2
Prior attainment
(By KS2 level)
Prior Attainment at KS2
Overall
Low
3.6
Mid
4.8
High
5.2
Graph
Graph
Qualifications
Pupil Premium
PP
5.7
Non-PP
6.4
Special Educational Needs
SEN
6.3
Non-SEN
6.5
S
3.0
E
5.4
K
5.3
Prior attainment
(By KS2 level)
Prior Attainment at KS2
Overall
Low
3.6
Mid
5.8
High
7.7

Drill down from qualifications, to Grades (tab). This data row is also used when drilling down to classes.

Ytd
L-Graph
Qualifications
No. of grades
95
Av. Points
60
Residual
9
In A8
231
Grades attained
9
3
8
6
7
12
6
24
5
48
4
224
3
333
2
876
1
111
U
333
X
0

Drill down from qualifications, to Grades (tab), then to the list of learners.

Ytd
L-Graph
Class
11N/CS345
Teacher
MWW/DWW/WWW
Grade
6.2
KS2 Prior
+5.28+
Residual
-0.12
Counted in A8


Hyperlinks from Whole School


When drilling down/hyperlinking from the overview form, use the same titles e.g. 'Learners included', and a path like this: < Whole school / Attainment 8 & Progress 8 / Learners included. (Whole school should be a hyperlink.)


View 4. Drill down from Overview (the GREEN EBacc section) , to a data row.

Ytd (APS)
L-Graph
Entered
Slots filled
4
Av. Points
5.11
English
6
Maths
5
Science
6
Human.
5
Lang.
5

View 3. Drill down from Overview (the ORANGE English and maths (basics) ) section , to a data row.

Ytd ?
Graph ?
Basics Str. Pass
Basics Std. Pass
Eng KS2
4.6
Eng Qual
Literature
Av. Eng Points
5.11
Lang Points
5.11
Lit Points
5.11
Maths KS2
4.6
Maths Points
5.11

View 1. Drill down from Overview (the PURPLE Overall pass rate section) , to a data row.

Ytd (Av. Points)
L-Graph
No. of grades
6
Points total
33
Av. Points
5.5
Sub. Name
7.2

View 2. Drill down from Overview (the BLUE A8 P8 section) to a data row. It is only for the just the 'A8 main measure', the 'Main measures' and the 'Secondary measures.'

Ytd (Progress)
L-Graph
KS2
4.6
Attainment 8
Estimate
55.5
Actual
45.5
Progress 8
Actual
0.02
English
0.02
Maths
0.02
Ebacc
0.02
Open
0.02
Slots filled
5.11

View 5a-eng. Drill down from A8 P8 to a data row. It is only for the English sections of both expanding panels (attainment and progress).

Ytd (Attain)
L-Graph
Name
G+T
SEND
PP
KS2
4.6
Lang Points
5.11
Lit Points
5.11
Eng Points Doubled
Eng Attainment
Estimate
9.81
Actual
13.5
Eng Progress
Actual
0.02

View 5a-maths. Drill down from Overview (the BLUE A8 P8 section). It is only for the Maths sections of both expanding panels (attainment and progress).

Ytd (Attain)
L-Graph
KS2
4.6
Maths Attainment
Estimate
9.81
Actual
13.5
Maths Progress
Actual
0.02

View 6a-EBacc. Drill down from Overview (the BLUE A8 P8 section) to a data row. It is only for the EBacc sections of both expanding panels (attainment and progress).

Ytd (Attain)
L-Graph
KS2
4.6
EBacc Progress
Total Pts
16
Estimate
12.66
Progress
1.113
EBacc Points per slot
Slot 1
6 (CS)
Slot 2
5 (Fr)
Slot 3
5 (His)
EBacc Slots Occupied
Filled
3
Estimate
2.88
Difference
0.12

View 6b-open. Drill down from Overview (the BLUE A8 P8 section) to a data row. It is only for the Open sections of both expanding panels (attainment and progress).

Ytd
L-Graph
KS2
4.6
Open Progress
Total Pts
16
Estimate
12.66
Progress
1.113
Open Points per slot
Slot 1
6 (CS)
Slot 2
5 (Fr)
Slot 3
5 (His)
Open Slots Occupied
Filled
3
Estimate
2.88
Difference
0.12
Open Points by Qual Type
GCSE
12
Non-GCSE
6