Student Metadata EDA

Demographics, Data Quality, and Linkage Analysis

Published

February 10, 2026

1. Data Overview

Dataset Dimensions

Student Metadata: 7,967 students x 27 columns

Cleaned Responses: 6,362 unique students

PAT Outcomes: 714 students with scores

Teacher Ratings: 2,358 students with ratings

Column Types

column	type	category
atsi_status	character	Background
disability_level	character	Background
disability_type	character	Background
has_disability	logical	Background
is_lbote	logical	Background
data_consent	logical	Consent
age_years	numeric	Demographics
grade_raw	character	Demographics
class_name	character	Identifiers
org_identifier	character	Identifiers
org_unit	character	Identifiers
org_unit_identifier	character	Identifiers
organisation	character	Identifiers
student_id	character	Identifiers
any_parent_employed	logical	SES
birth_month	integer	SES
birth_month_suspect	logical	SES
birth_year	integer	SES
birth_year_suspect	logical	SES
has_ses_data	logical	SES
p1_education	integer	SES
p1_nonschool_education	integer	SES
p1_occupation	integer	SES
p2_education	integer	SES
p2_nonschool_education	integer	SES
p2_occupation	integer	SES
year_level	character	SES

2. Missingness Analysis

Overall Missingness Rates

column	missing_rate	missing_pct	n_missing	status
disability_type	1.0000000	100.0%	7967	> 50% missing
disability_level	1.0000000	100.0%	7967	> 50% missing
any_parent_employed	0.9741433	97.4%	7761	> 50% missing
p1_education	0.9328480	93.3%	7432	> 50% missing
p1_nonschool_education	0.9280783	92.8%	7394	> 50% missing
p1_occupation	0.9279528	92.8%	7393	> 50% missing
p2_education	0.8422242	84.2%	6710	> 50% missing
p2_nonschool_education	0.8341910	83.4%	6646	> 50% missing
p2_occupation	0.8297979	83.0%	6611	> 50% missing
is_lbote	0.6873353	68.7%	5476	> 50% missing
atsi_status	0.6872097	68.7%	5475	> 50% missing
class_name	0.0591189	5.9%	471	< 10% missing
age_years	0.0330112	3.3%	263	< 10% missing
birth_month	0.0267353	2.7%	213	< 10% missing
birth_year	0.0258567	2.6%	206	< 10% missing
data_consent	0.0210870	2.1%	168	< 10% missing
grade_raw	0.0071545	0.7%	57	< 10% missing
student_id	0.0000000	0.0%	0	Complete
org_unit	0.0000000	0.0%	0	Complete
organisation	0.0000000	0.0%	0	Complete
org_identifier	0.0000000	0.0%	0	Complete
org_unit_identifier	0.0000000	0.0%	0	Complete
year_level	0.0000000	0.0%	0	Complete
birth_month_suspect	0.0000000	0.0%	0	Complete
birth_year_suspect	0.0000000	0.0%	0	Complete
has_disability	0.0000000	0.0%	0	Complete
has_ses_data	0.0000000	0.0%	0	Complete

Data Completeness by School

Data completeness varies significantly across schools. The overall completeness score is calculated as the average of five key fields:

ATSI status known
LBOTE status known
SES data available (any parent education/occupation)
Age data available
Data consent recorded

A score of 100% means all five fields are complete for all students in that school; 0% means none are recorded.

Schools with complete demographic data (>90%): 22

Schools with sparse data (<10%): 0

3. School & Class Structure

Schools by Organisation

Students per School

Students per school:

# A tibble: 1 × 6
    min    q1 median  mean    q3   max
  <int> <dbl>  <dbl> <dbl> <dbl> <int>
1     2    22   42.5  53.1  72.8   253

Class Sizes

Total classes: 618

Class size summary:

   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
   1.00    7.00   11.00   12.13   16.00   59.00

Classes per School by Year Level

=== Classes per school by year level ===

Foundation classes per school:

   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
  0.000   1.000   2.000   1.842   3.000   9.000


Year 1 classes per school:

   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
  0.000   1.000   2.000   2.151   3.000   8.000

Top 15 schools by number of classes
School	F Classes	Y1 Classes	F Avg Size	Y1 Avg Size
Gilgai Plains Primary School	9	7	16.3	14.6
Bentleigh West Primary School	6	5	10.3	11.0
Kin Kora State School	5	6	6.0	5.7
Mackay West State School	5	6	6.2	6.2
Rosalie Primary School	4	5	9.2	5.2
Templestowe Heights Primary School	4	5	11.8	10.8
Wimba Primary School	5	4	4.6	2.2
Brighton Primary School	4	4	8.2	3.8
Butler Primary School	2	6	13.0	6.2
Carnegie Primary School	4	4	6.2	8.0
Gainsborough State School	0	8	0.0	8.5
Makybe Rise PS	4	4	14.5	12.2
Mount Lockyer PS	3	5	15.0	10.6
Our Lady Queen of Peace Greystanes	4	4	6.0	6.5
Beaumaris Primary School	4	3	11.8	12.3

4. Student Demographics

Year Level Distribution

Grade Raw Values (Audit)

Age Distribution

# A tibble: 3 × 6
  year_level_screener     n mean_age sd_age min_age max_age
  <chr>               <int>    <dbl>  <dbl>   <dbl>   <dbl>
1 foundation           3013     5.43  0.450    3.42    11.5
2 year1                3152     6.44  1.94     3.67   112. 
3 <NA>                 1588     5.91  0.725    3.42    13.8

ATSI Status

LBOTE Status

Disability

Students with disability information: 0 (0.0%)

5. Socioeconomic Indicators

Data Availability

Students with any SES data: 1373 (17.2%)

Parent Education Codes

Parent Occupation Codes

SES by Organisation

6. Data Linkage Assessment

Student Overlap Across Datasets

dataset	n_students	in_metadata	pct_in_metadata	not_in_metadata
Metadata	7967	7967	1.0000000	0
Responses	6362	6360	0.9996856	2
PAT Scores	714	714	1.0000000	0
Teacher Ratings	2358	2358	1.0000000	0

Metadata Students in Response Data

Metadata students found in responses: 6360 / 7967 (79.8%)

Metadata students with PAT scores: 714 / 7967 (9.0%)

Metadata students with teacher ratings: 2358 / 7967 (29.6%)

Linkage by Year Level

Year level is not available for linkage breakdown in this metadata extract.

Linkage by Organisation

7. Summary

Key Findings

=== DATASET OVERVIEW ===

Total students: 7,967

Schools: 150

Classes: 633

Education systems: 18

=== YEAR LEVEL ===

Foundation: NA (NA)

Year 1: NA (NA)

=== DATA COMPLETENESS ===

Age data available: 97.3%

ATSI status known: 31.3%

LBOTE status known: 31.3%

SES data available: 17.2%

Data consent recorded: 97.9%

=== DATA QUALITY FLAGS ===

Students with disability info: 0

=== LINKAGE ===

In response data: 79.8%

Have PAT scores: 714 students ( 9.0% of metadata)

Have teacher ratings: 2,358 students ( 29.6% of metadata)

Data Quality Issues to Address

High missingness in demographic fields: ATSI (~69% missing), LBOTE (~69% missing)
Very sparse SES data: Only ~21% of students have any parent education/occupation data
Variable data quality by school: Some schools have near-complete data, others have none
Limited outcome data: Only ~700 students have PAT scores, ~2,500 have teacher ratings

Report generated: 2026-02-10 00:16:44.325711