Manuals for Data Navigator – Data Navigator for Schools

Author

Affiliation

Barnett Waddingham LLP

DC contribution rate plot for support staff on Expenditure pensions page

For general information on how to read a benchmark histogram, see here.

10 October 2024

DC contribution rate plot for teaching staff on Expenditure pensions page

For general information on how to read a benchmark histogram, see here.

10 October 2024

TPS exit strategy plot on Expenditure pensions page

For general information on how to use the plot controls, see here.

10 October 2024

Membership of TPS plot on Expenditure pensions page

For general information on how to use the plot controls, see here.

10 October 2024

Target benefit spend plot on Expenditure pensions page

For general information on how to use the plot controls, see here.

10 October 2024

TPS enrollment plot on Expenditure pensions page

For general information on how to read a benchmark histogram, see here.

10 January 2024

Business rates paid plot on Expenditure business rates page

For general information on how to read a benchmark histogram, see here.

10 January 2024

Business rates plot on Expenditure business rates page

For general information on how to read a benchmark histogram, see here.

10 January 2024

Rateable value plot on Expenditure business rates page

For general information on how to read a benchmark histogram, see here.

10 January 2024

Expected price sensitivity plot on Marketing summary page

Price sensitivity

For general information on how to read a benchmark histogram, see here.

10 January 2024

Knowledge of price sensitivity plot on Marketing summary page

Price sensitivity

For general information on how to read a benchmark histogram, see here.

10 January 2024

Your data table on ‘Survey response - Expenditure’ page

Survey response

This table has four columns which show your responses to Section E of the survey:

28 November 2023

Your data table on ‘Survey response - Income’ page

Survey response

This table has four columns which show your responses to Section D of the survey:

28 November 2023

Your data table on ‘Survey response - Marketing and attraction’ page

Survey response

Marketing and attraction

This table has four columns which show your responses to Section C of the survey:

28 November 2023

Your data table on ‘Survey response - Pupils’ page

Survey response

This table has four columns which show your responses to Section B of the survey:

28 November 2023

Your data table on ‘Survey response - School’ page

Survey response

This table has four columns which show your responses to Section A of the survey:

28 November 2023

Your data table on ‘Survey response - Surplus’ page

Survey response

This table has three columns which show your responses to Section F of the survey:

28 November 2023

Table of number of schools by region

This table shows the number of schools in each geographic region. The region of your school is shown in bold.

27 November 2023

Rank

The rank column in a table indicates where in the benchmark group of schools your school lies. For example, a rank of 70% means 30% of schools rank above you and 70% below…

29 September 2023

Affluence filter

The affluence score is calculated for each school based on the Acorn classification from CACI, which takes into account the demographic and geographic information about your…

27 September 2023

Year group filter

This filter allows you to filter the benchmark based on the year groups using the slider. The slider lets you choose a range of year groups.

27 September 2023

SoFA Surplus plot on Finances summary page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Educational income on Income educational page

For general information on how to use the plot controls, see here.

26 September 2023

Educational income on Income educational page

For general information on how to use the plot controls, see here.

26 September 2023

Concessions breakdown on Income fees page

For general information on how to use the plot controls, see here.

26 September 2023

Concessions as a percentage of gross fees on Income fees page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Fees and income on Income fees page

This table has five columns which show:

26 September 2023

Fee development on Income fees page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Net fees as percentage of gross fees on Income fees page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Fee incomes on Income fees page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Total income breakdown on Income summary page

For general information on how to use the plot controls, see here.

26 September 2023

Total income less fees breakdown on Income summary page

For general information on how to use the plot controls, see here.

26 September 2023

Total income on Income summary page

For general information on how to read a benchmark histogram, see here.

26 September 2023

Bank interest on Income investments page

For general information on how to use the plot controls, see here.

26 September 2023

Dividends on Income investments page

For general information on how to use the plot controls, see here.

26 September 2023

Investments on Income investments page

For general information on how to use the plot controls, see here.

26 September 2023

Other investments on Income investments page

For general information on how to use the plot controls, see here.

26 September 2023

Other income on Income other page

For general information on how to use the plot controls, see here.

26 September 2023

Other income on Income educational page

For general information on how to use the plot controls, see here.

26 September 2023

Total income

The total income figure is taken from survey questions from Section D: Income, and totalled from the following questions:

26 September 2023

Density plot charts

Density plots are used to present data in the Data Navigator for Schools dashboard.

22 September 2023

Dopwnload to CSV

The data within tables in the app can be downloaded as a a comma separated values file by using this button. The downloaded file can be opened in your spreadsheet…

22 September 2023

Gross income

The gross income is defined as:

22 September 2023

Grouped bar charts

Grouped bar charts are used to present data throughout the Data Navigator for Schools dashboard.

22 September 2023

Line charts

Line charts are used to present data in the Data Navigator for Schools dashboard.

22 September 2023

Pupil summary table on School page

This table has five columns which show data Section B: General Pupil Information:

22 September 2023

Stacked bar charts

Stacked bar charts are used to present data throughout the Data Navigator for Schools dashboard.

22 September 2023

Tables

A table is a way to arrange data into rows and columns. The data in the table can be downloaded by using the the “Download as CSV” button located above the table.

22 September 2023

Total number of pupils

The total number of pupils is defined as:

22 September 2023

Year groups

The table below lists the different school stages and how these match to the different year groups based on UK regions:

22 September 2023

Long term borrowing plot on Expenditure borrowing page

For general information on how to use the plot controls, see here.

21 September 2023

Long term borrowing plot on Expenditure borrowing page

For general information on how to read a benchmark histogram, see here.

21 September 2023

Short term borrowing plot on Expenditure borrowing page

For general information on how to use the plot controls, see here.

21 September 2023

Short term borrowing plot on Expenditure borrowing page

For general information on how to read a benchmark histogram, see here.

21 September 2023

Total borrowing plot on Expenditure borrowing page

For general information on how to use the plot controls, see here.

21 September 2023

Total borrowing plot on Expenditure borrowing page

For general information on how to read a benchmark histogram, see here.

21 September 2023

Capital expenditure per pupil for future years plot on Expenditure Capital Expenditure page

For general information on how to use the plot controls, see here.

21 September 2023

Total capital expenditure breakdown plots on Expenditure Capital Expenditure page

For general information on how to use the plot controls, see here.

21 September 2023

Capital expenditure per pupil for current year plot on Expenditure Capital Expenditure page

For general information on how to read a benchmark histogram, see here.

21 September 2023

Capital expenditure per pupil for future years plot on Expenditure Capital Expenditure page

For general information on how to use the plot controls, see here.

21 September 2023

Sales and marketing expenditure plot on Expenditure sales and marketing page

For general information on how to read a benchmark histogram, see here.

21 September 2023

Sales and marketing breakdown plot on Expenditure sales and marketing page

For general information on how to use the plot controls, see here.

21 September 2023

Long term borrowing summary table on Expenditure Borrowing Costs page

This table has five columns which show:

20 September 2023

Short term borrowing summary table on Expenditure Borrowing Costs page

This table has five columns which show:

20 September 2023

Total borrowing summary table on Expenditure Borrowing Costs page

This table has five columns which show:

20 September 2023

Catering costs plot on Expenditure Running Costs page

For general information on how to read a benchmark histogram, see here.

20 September 2023

Consumables costs plot on Expenditure Running Costs page

For general information on how to read a benchmark histogram, see here.

20 September 2023

Running cost summary table on Expenditure Running Costs page

This table has five columns which show:

20 September 2023

Other running costs plot on Expenditure Running Costs page

For general information on how to read a benchmark histogram, see here.

20 September 2023

Total running costs plot on Expenditure Running Costs page

For general information on how to read a benchmark histogram, see here.

20 September 2023

Utilities costs plot on Expenditure Running Costs page

For general information on how to read a benchmark histogram, see here.

20 September 2023

Pupil summary table on Education summary page

This table has five columns which show data Section B: General Pupil Information:

19 September 2023

Staff summary table on Education summary page

This table has five columns which shows benchmark data from Section B: General Pupil Information:

19 September 2023

Marketing and attraction rates on Marketing page

For general information on how to read a benchmark histogram, see here.

19 September 2023

Offers accepted relative to offers extended on Marketing page

The data is taken from 25. Admissions information relating to places in the current school year from 1 September. It looks at the rate calculated as:

19 September 2023

New starters relative to inquires on Marketing page

The data is taken from 25. Admissions information relating to places in the current school year from 1 September. It looks at the rate calculated as:

19 September 2023

New joiners on Marketing page

For general information on how to use the plot controls, see here.

19 September 2023

Destination of leavers on Marketing page

For general information on how to use the plot controls, see here.

19 September 2023

Attraction on Marketing page

This table displays the data entered for question 25. Admissions information relating to places in the current school year from 1 September .

19 September 2023

Affluence distribution on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled for junior on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled for nursery on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled for senior on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled for sixth form on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capacity filled by age group on School page

For general information on how to use the plot controls, see here.

18 September 2023

Distribution of percentage of girls on School page

For general information on how to read a benchmark histogram, see here.

18 September 2023

Capital expenditure plot on Finances summary page

For general information on how to use the plot controls, see here.

15 September 2023

Cash reserve plot on Finances summary page

For general information on how to read a benchmark histogram, see here.

15 September 2023

TPS enrollment plot on Expenditure staff page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Expenditure breakdown plot on Expenditure summary page

For general information on how to use the plot controls, see here.

14 September 2023

Staff cost plot on Expenditure staff page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Non-teaching staff cost plot on Expenditure staff page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Teaching support staff cost plot on Expenditure staff page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Teaching staff cost plot on Expenditure staff page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Total expenditure plot on Expenditure summary page

For general information on how to read a benchmark histogram, see here.

14 September 2023

Expenditure breakdown plot on Expenditure summary page

For general information on how to use the plot controls, see here.

14 September 2023

Total expenditure

The total expenditure figure is taken from survey questions from Section E: Expenditure, and totalled from the following questions:

14 September 2023

Staff costs plot on Education summary page

For general information on how to read a benchmark histogram, see here.

13 September 2023

Pupil staff ratio plot on Education summary page

For general information on how to read a benchmark histogram, see here.

13 September 2023

5-year projection plot on Forecasting Projections page

For general information on how to use the plot controls, see here.

13 September 2023

Forecasting Projections inputs

The input boxes allow you to make assumptions about how a particular income or expenditure variable changes over the course of the 5-year projection. The input boxes have…

13 September 2023

5-year projection summary tables on Forecasting Projections page

The table above show the progression of key metrics of your school’s finances over the course of the 5-year projection. These metrics are:

13 September 2023

Forecasting sliders

These sliders let you decide how much to increase or decrease the scenario variables by a percentage amount above or below the current value:

21 August 2023

Waterfall visual

A waterfall chart is a visual way to show how various factors, both positive and negative, contribute to a final total. It starts with a baseline value and uses columns to…

17 August 2023

Income and expenditure plot on Finances summary page

For general information on how to read a waterfall plot, see here .

10 August 2023

Estimated impact on surplus plot on Forecasting Snapshot page

For general information on how to read a waterfall plot, see here .

10 August 2023

Forecast summary table on Forecasting Snapshot page

This table has six columns which show:

10 August 2023

Benchmark histograms

Histograms are used extensively to present benchmark data throughout the Data Navigator for Schools dashboard.

10 August 2023

Net income

The net income is defined as:

10 August 2023

Plot controls

When you hover on any plot you are presented with a small menu of controls:

10 August 2023

Fees plot on Finances summary page

For general information on how to read a benchmark histogram, see here.

9 August 2023