Data Navigator for Schools - Manuals for Data Navigator

Author

Affiliation

Barnett Waddingham LLP

DC contribution rate plot for support staff on Expenditure pensions page

This plot shows the distributions of DC pension contributions for support staff with the option to look at:

10 October 2024

DC contribution rate plot for teaching staff on Expenditure pensions page

This plot shows the distributions of DC pension contributions for teaching staff with the option to look at:

10 October 2024

TPS exit strategy plot on Expenditure pensions page

This plot shows the exit strategies being considered by schools, which is calculated from survey question 65. If…

10 October 2024

Membership of TPS plot on Expenditure pensions page

This plot shows the number of schools which are members of TPS, which is calculated from survey question 60. Is the school a member…

10 October 2024

Target benefit spend plot on Expenditure pensions page

This plot shows the target benefit spend on the TPS for schools, which is calculated from survey question 66. If known, what is your estimated overall…

10 October 2024

TPS enrollment plot on Expenditure pensions page

This plot shows the distributions of TPS enrolment proportions, which is calculated from survey question 67. Of existing and eligible…

10 January 2024

Business rates paid plot on Expenditure business rates page

This plot shows the distribution of business rates paid for schools, which is calculated from survey question 50. How much do you pay in business rates.

10 January 2024

Business rates plot on Expenditure business rates page

This plot shows the distribution of business rates as a percentage for schools. This is calculated as the monetary value of business rates paid, from survey question 50. How much do you pay in…

10 January 2024

Rateable value plot on Expenditure business rates page

This plot shows the distribution of rateable value for schools, which is calculated from survey question 49.…

10 January 2024

Expected price sensitivity plot on Marketing summary page

Price sensitivity

This plot shows the distribution of price sensitivity knowledge for schools, which is calculated from survey question 59. On the scale below, how would you…

10 January 2024

Knowledge of price sensitivity plot on Marketing summary page

Price sensitivity

This plot shows the distribution of price sensitivity knowledge for schools, which is calculated from survey question 58. How strongly do you agree that your School understands the price…

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…

29 September 2023

Affluence filter

The affluence score is calculated for each school based on the Acorn…

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

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

This plot shows the breakdown of long term borrowing costs for your school and the benchmark. The data in this chart has been calculated from survey question 46. Cost of Long Term Borrowing in the last…

21 September 2023

Long term borrowing plot on Expenditure borrowing page

This plot shows the distributions of total long term borrowing costs with the option to look at:

21 September 2023

Short term borrowing plot on Expenditure borrowing page

This plot shows the breakdown of short term borrowing costs for your school and the benchmark. The data in this chart has been calculated from survey question 45. Cost of Short Term Borrowing in the last accounting…

21 September 2023

Short term borrowing plot on Expenditure borrowing page

This plot shows the distributions of total short term borrowing costs with the option to look at:

21 September 2023

Total borrowing plot on Expenditure borrowing page

This plot shows the breakdown of short and long term borrowing costs for your school and the benchmark. The data in this chart has been calculated from survey questions; 45. Cost of Short Term Borrowing in the last accounting year to 31…

21 September 2023

Total borrowing plot on Expenditure borrowing page

This plot shows the distributions of total short and long term borrowing costs with the option to look at:

21 September 2023

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

This plot shows the capital expenditure per pupil over time for your school and the benchmark in a density plot.

21 September 2023

Total capital expenditure breakdown plots on Expenditure Capital Expenditure page

This plot shows the…

21 September 2023

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

This plot shows the distributions of total capital expenditure with the option to look at:

21 September 2023

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

This plot shows the capital expenditure per pupil over time for your school and the benchmark.

21 September 2023

Sales and marketing expenditure plot on Expenditure sales and marketing page

This plot shows the distributions of sales and marketing costs with the option to look at:

21 September 2023

Sales and marketing breakdown plot on Expenditure sales and marketing page

This plot shows the breakdown of sales and marketing costs for your school and the benchmark. The data in this chart has been calculated from survey question 43. Sales, Marketing…

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

This plot shows the distributions of catering costs with the option to look at:

20 September 2023

Consumables costs plot on Expenditure Running Costs page

This plot shows the distributions of consumables costs with the option to look at:

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

This plot shows the distributions of other running costs with the option to look at:

20 September 2023

Total running costs plot on Expenditure Running Costs page

This plot shows the distributions of total running costs with the option to look at:

20 September 2023

Utilities costs plot on Expenditure Running Costs page

This plot shows the distributions of utilities costs with the option to look at:

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

This plot shows the distributions of TPS enrolment proportions, which is calculated from survey question 48. If applicable, of existing and eligible…

14 September 2023

Expenditure breakdown plot on Expenditure summary page

This plot shows the breakdown of expenditure for your school and the benchmark with the option to look at:

14 September 2023

Staff cost plot on Expenditure staff page

This plot shows the distributions of staff costs with the option to look at:

14 September 2023

Non-teaching staff cost plot on Expenditure staff page

This plot shows the distributions of non-teaching staff costs with the option to look at:

14 September 2023

Teaching support staff cost plot on Expenditure staff page

This plot shows the distributions of teaching support staff costs with the option to look at:

14 September 2023

Teaching staff cost plot on Expenditure staff page

This plot shows the distributions of teaching staff costs with the option to look at:

14 September 2023

Total expenditure plot on Expenditure summary page

This plot shows the distributions of total expenditure with the option to look at:

14 September 2023

Expenditure breakdown plot on Expenditure summary page

This plot shows the breakdown of total expenditure for your school and the benchmark. The data in this chart has been calculated using the survey question detailed 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…

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

This plot shows the distributions of fees with the option to look at:

9 August 2023