Access keys | Skip to primary navigation | Skip to secondary navigation | Skip to content | Skip to footer |
Problems viewing this site
Home > Census instructions > Workbook

Additional data requirements workbook

New in 2020

Getting started

Security warnings

'Enable content' This workbook has macros embedded within. To use this workbook, you will need to select 'Enable content' at the top of the open workbook. See image below:

Security warnings


Content within the workbook

This workbook contains multiple tabs, as shown below:

Adobe Reader Version Detected

If you have full-time students at the school who were present at school for less than 11 days between the first day of the school year and Census Day, select the Full-time students checkbox. The Full-time students tab will appear.

If you have part-time students at the school who were present at the school for less than the minimum period for part-time students between the first day of the school year and Census Day, select the Part-time students checkbox. The Part-time students tab will appear.

All other tabs are shown by default.

'Introduction' tab

The ‘Introduction’ tab has three (3) areas to be completed before progressing to the next tab.

Type of student

Start by selecting below whether you have full-time and/or part-time students who should be entered on this form. If you do not have students who were present at school for less than 11 days (full-time students) or less than the minimum period (part-time), leave both of the checkboxes blank.

Screen shot of Full-time and part-time students check boxes

If you select ‘Full-time students’ a new tab will appear at the bottom of your workbook as circled below.

Screen shot of full-time students tab in excel

If you select ‘Part-time students’ a new tab will appear at the bottom of your workbook as circled below.

Screen shot of part-time students tab in excel

If you select 'Full-time students' and ‘Part-time students’ both tabs will appear at the bottom of your workbook as circled below.

Screen shot of full-time and part-time students tab in excel


School details

Complete each of the fields with the relevant information ensuring that the name of the school is exactly as listed on the Register of Non-State Schools. The centre code, also known as CIS code, was provided in the letter sent to your principal. This code is also available from the register.

Screen shot of school details fields on excel spreadsheet

Relevant period

Enter the date of the first day students are to attend your school in 2020 in the field circled below.

Screen shot of Relevant period field on excel spreadsheet

Once this is populated, it will update the Relevant period (RP). The relevant period is the number of days between the first day that students are to attend the school in the calendar year and Census Day (including both first and Census Day).

Screen shot of Relevant period on excel spreadsheet

Once this tab has been completed move to the next tab available.

'Full-time students' tab

Enter each full-time student who was present at school for less than 11 days between the first day of the school year and Census Day. Enter details in each column to work out if they are eligible for inclusion in the full time count of the census. Columns that are automatically calculated are bold.

Columns 1- 5

Screen shot of columns 1 - 5

Column 6 - 9

Screen shot of columns 6 - 9

Columns 10 -12

Screen shot of columns 10 - 12

Columns 13 - 15

Screen shot of columns 13 - 15

Part-time students' tab

Enter each part-time student who was present at school for less than the minimum period between the first day of the school year and Census Day to work out if they are eligible for inclusion in the part-time count of the Census. Columns that are automatically calculated are bold.

Columns 16 - 21

Screen shot of columns 16 - 21

Columns 22 - 25

Screen shot of columns 22 - 25

Coumns 26 - 28

Screen shot of columns 26 - 28

Columns 29 - 31

Screen shot of columns 29 - 31

'Systems and processes' tab

Select what type of system(s) are used at the school from the drop-down menu.

Screen shot of systems and process screen

The options are:

Once you have selected one of the options, all relevant fields required to be completed will be shown. As you complete this section and move through the various cells (yellow), you either enter the information or select from the drop-down option available.

Electronic

If 'Electronic' system has been selected, the following fields will be available for completion.

Screen shot of electronic system

Paper-based

If 'Paper-based' system has been selected, the following fields will be available for completion.

Screen shot of paper system

Combined electronic and paper-based

If 'Combined electronic and paper-based'system has been selected, the following fields will be available for completion.

Screen shot of combined electronic and paper-based system

Submitting the workbook with the Census form

Once you have completed the workbook, submit the workbook together with the Census form via NSSAB Online Services.

Last updated 7 February, 2020

On this page