Exporting data for WA Kinder PRA Attendance

Modified on Mon, 16 Feb at 3:19 AM

TABLE OF CONTENTS

Recommended process for this report
Configure Zunia for WA Kinder PRA Attendance

The WA Kinder PRA Attendance report provides the required data of Kindergarten year group for the Preschool Reform Agreement data collection. Data is to be collected at the student unit level record for Term 2 from 2024 onwards.

Zunia is not able to support all the data requirements of the PRA report. Schools will have to populate the template manually using a combination of 3 possible methods:

Manually populating data from Zunia
Exporting to Spreadsheet using the Export Data Tool
Calculating fields (requiring computation by the school)

Recommended process for this report

Create a PRA spreadsheet with the required Kinder PRA specifications as column headers (the table sets out the column headers for this report)
Use this guide to extract the required data, using a combination of the methods described above.
Add the Zunia data to the relevant columns in your spreadsheet and then do all the calculations for the remaining columns and manually populate the fields.
Submit your report once all the fields are populated with the correct data

Configure Zunia for WA Kinder PRA Attendance

Column	Heading	Method	Configuration
A	Year	Manual entry	Enter the current Academic Year in YYYY format into every row.
B	Term	Manual entry	Enter 1-digit to represent the current academic term into every row.
C	SchoolCode	Manual entry	Enter the school code (4-digits) into every row.
D	SchoolName	Manual entry	Enter the name of the school (maximum 70 characters) into every row.
E	SchoolWeeks	Manual entry	Enter a number to represent the number of weeks the program is offered for the year into every row.
F	QualStaff	Manual entry	Enter a flag to indicate if the program is delivered by a qualified teacher using 1 character; either Y or N into every row.
G	StudFirstName	Export data	This value is defined using the Personal Information > Given Name stored on the Profile tab of Student Profile and has a maximum length of 40 characters.
H	StudLastName	Export data	This value is defined using the Personal Information > Surname stored on the  Profile  tab of Student Profile and has a maximum length of 40 characters.
I	StudDOB	Export data	This value is defined using the Personal Information > Date of Birth stored on the Profile tab of Student Profile. This field has a format of YYYYMMDD and a maximum length of 8 characters.
J	StudGender	Export data	This value is defined using the Personal Information > Gender stored on the Profile tab of Student Profile. The values of the Gender field are defined using the Gender lookup. This field has a maximum length of 1 character with a value of either: M = Male F = Female X = Other
K	StudIndig	Export data	This value is defined using the Indigenous Student and Torres Strait Islander fields on the Profile > Student Flags > Student tab of Student Profile. This field has a value of: 1 when the Indigenous Student field is selected 2 when the Torres Strait Islander field is selected 3 when both fields are selected 4 when neither field is selected 9 when the status is not-stated
L	StudAddr	Export data	This value is defined using the Addresses > Home Address stored on the Profile tab of Community Members.
M	StudTown	Manual entry	Enter every individual student’s suburb, copy and pasted from the student’s address exported in column L into every row.
N	StudState	Manual entry	Enter every individual student’s state, copy and pasted from the student’s address exported in column L into every row.
O	StudPcode	Manual entry	Enter every individual student’s postcode, copy and pasted from the student’s address exported in column L into every row.
P	StudYearLevel	Export data	This value is defined using the School > Timeline Events > Year Level stored on thel School tab of Student Profile.
Q	StudRepeat	Manual entry	Enter a value of either Y or N to indicate whether a student is repeating this year level into every row.
R	StudEnrol	Export data	This field is defined using the Enrolment > Start date stored on the Profile tab of Student Profile.
S	StudLeave	Export data	This field is defined using the Enrolment > Leaving date stored on the Profile tab of Student Profile.
T	SessionsTotal	Calculation	Calculate the total number of kinder sessions available for the reporting period - given the student’s attendance pattern regardless of enrolled dates - and manually enter the number into every row. First refer to WA Gov documentation has provided you and determine what Sessions are at your school.
U	SessionAvgHours	Calculation	Calculate the average hours per half-day session offered at kinder level and manually enter the number into every row. This can then be averaged for all students or for each student’s individual attendance pattern. Note PKG and KIN expected to be different.
V	SessionsAvail	Calculation	Calculate the number of available kinder sessions for a student given their attendance pattern and enrolled date and manually enter into every row.
W	SessionsAttend	Manual entry	Enter the number of sessions attended for the reporting period into every row.
X	TermStart	Manual entry	Enter the term start date in YYYYMMDD format into every row.
Y	TermEnd	Manual entry	Enter the term end date in YYYYMMDD format into every row.
Z	TermClosure	Calculation	Calculate the number of kinder sessions not attended based on the student’s attendance pattern when a school is closed for safety reasons (e.g. COVID, fire etc) and enter the number into every row.
AA	TermPupilFree	Calculation	Calculate the number of kinder sessions not attended based on the student’s attendance pattern due to pupil free days and enter the number into every row.
AB	TermPubHol	Calculation	Calculate the number of kinder sessions not attended based on the student’s attendance pattern due to public holidays and enter the number into every row.