2022-11-12

Victoria - “The Education State”

  • Victoria is being branded as Australia’s Education state by Government of Victoria, in recent years.

  • Following presentation in form of series of data visualizations covers detailed analysis of each Victorian Local Government Area (LGA), key performance measures (KPI’s) on school education, for the year 2022.

  • KPI’s analyzed includes Total number (No.) of schools, No. of Full Time Enrolled (FTE) students and Student density Ratio ie FTE students enrolled per school for each Category type, ie. Government (Gov.), Catholic and Independent (Indep.) schools.

  • Data is collected from: Source: Statistics on Victorian schools. 11/10/2022. Retrieved October 24, 2022 from Statistics on Victorian schools and teaching website https://www.vic.gov.au/statistics-victorian-schools-and-teaching.

## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:plyr':
## 
##     arrange, count, desc, failwith, id, mutate, rename, summarise,
##     summarize
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ tibble  3.1.8     ✔ purrr   0.3.4
## ✔ tidyr   1.2.1     ✔ stringr 1.4.1
## ✔ readr   2.1.2     ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::arrange()   masks plyr::arrange()
## ✖ purrr::compact()   masks plyr::compact()
## ✖ dplyr::count()     masks plyr::count()
## ✖ dplyr::failwith()  masks plyr::failwith()
## ✖ dplyr::filter()    masks stats::filter()
## ✖ dplyr::id()        masks plyr::id()
## ✖ dplyr::lag()       masks stats::lag()
## ✖ dplyr::mutate()    masks plyr::mutate()
## ✖ dplyr::rename()    masks plyr::rename()
## ✖ dplyr::summarise() masks plyr::summarise()
## ✖ dplyr::summarize() masks plyr::summarize()
## Loading required package: sp
## 
## rgeos version: 0.5-9, (SVN revision 684)
##  GEOS runtime version: 3.9.1-CAPI-1.14.2 
##  Please note that rgeos will be retired by the end of 2023,
## plan transition to sf functions using GEOS at your earliest convenience.
##  GEOS using OverlayNG
##  Linking to sp version: 1.5-0 
##  Polygon checking: TRUE 
## 
## 
## Checking rgeos availability: TRUE
## Please note that 'maptools' will be retired by the end of 2023,
## plan transition at your earliest convenience;
## some functionality will be moved to 'sp'.
## 
## Google's Terms of Service: https://cloud.google.com/maps-platform/terms/.
## 
## Please cite ggmap if you use it! See citation("ggmap") for details.
## 
## 
## Attaching package: 'plotly'
## 
## 
## The following object is masked from 'package:ggmap':
## 
##     wind
## 
## 
## The following objects are masked from 'package:plyr':
## 
##     arrange, mutate, rename, summarise
## 
## 
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## 
## 
## The following object is masked from 'package:stats':
## 
##     filter
## 
## 
## The following object is masked from 'package:graphics':
## 
##     layout
## 
## 
## Registering fonts with R
## Warning: package 'gridExtra' was built under R version 4.2.2
## 
## Attaching package: 'gridExtra'
## 
## The following object is masked from 'package:dplyr':
## 
##     combine
##        LGA_name  Gov_Schools_Enrols Gov_Schools_No. Catholic_Schools_Enrols
##  ALPINE    : 1   Min.   :   20      Min.   : 2.00   Min.   :    0          
##  ARARAT    : 1   1st Qu.: 1438      1st Qu.:10.00   1st Qu.:  314          
##  BALLARAT  : 1   Median : 4702      Median :14.50   Median : 1824          
##  BANYULE   : 1   Mean   : 8068      Mean   :19.46   Mean   : 2642          
##  BASS COAST: 1   3rd Qu.:12534      3rd Qu.:28.00   3rd Qu.: 4077          
##  BAW BAW   : 1   Max.   :46216      Max.   :64.00   Max.   :11587          
##  (Other)   :74                                                             
##  Catholic_Schools_No. Indep_Schools_Enrols Indep_Schools_No.
##  Min.   : 0.000       Min.   :    0.00     Min.   : 0.000   
##  1st Qu.: 2.000       1st Qu.:   72.75     1st Qu.: 1.000   
##  Median : 5.000       Median :  868.00     Median : 2.000   
##  Mean   : 6.225       Mean   : 1984.01     Mean   : 2.888   
##  3rd Qu.: 9.000       3rd Qu.: 3186.50     3rd Qu.: 4.000   
##  Max.   :21.000       Max.   :13465.20     Max.   :18.000   
##                                                             
##  Total_Schools_Enrols Total_Schools_No.
##  Min.   :   20        Min.   : 2.00    
##  1st Qu.: 2071        1st Qu.:13.00    
##  Median : 8573        Median :23.50    
##  Mean   :12694        Mean   :28.57    
##  3rd Qu.:20283        3rd Qu.:42.00    
##  Max.   :63454        Max.   :88.00    
## 
## Warning: Ignoring unknown parameters: fill, face
## Warning in grid.Call.graphics(C_text, as.graphicsAnnot(x$label), x$x, x$y, :
## font family not found in Windows font database

## Warning: readShapeSpatial is deprecated; use rgdal::readOGR or sf::st_read
## Warning: readShapePoly is deprecated; use rgdal::readOGR or sf::st_read
## [1] "SpatialPolygonsDataFrame"
## attr(,"package")
## [1] "sp"
##  [1] "ufi"        "ftype_code" "lga_name"   "state"      "scale_usec"
##  [6] "labeluse_c" "ufi_cr"     "lga_name3"  "cartodb_id" "created_at"
## [11] "updated_at"
## [1] SWAN HILL                   TOWONG                     
## [3] MOUNT BAW BAW ALPINE RESORT SOUTH GIPPSLAND            
## [5] SOUTHERN GRAMPIANS          WELLINGTON                 
## 87 Levels: ALPINE ARARAT BALLARAT BANYULE BASS COAST BAW BAW ... YARRIAMBIACK
## [1] ALPINE     ARARAT     BALLARAT   BANYULE    BASS COAST BAW BAW   
## 80 Levels: ALPINE ARARAT BALLARAT BANYULE BASS COAST BAW BAW ... YARRIAMBIACK
## # A tibble: 6 × 7
##    long   lat order hole  piece group    id    
##   <dbl> <dbl> <int> <lgl> <fct> <fct>    <chr> 
## 1  147. -36.4     1 FALSE 1     ALPINE.1 ALPINE
## 2  147. -36.4     2 FALSE 1     ALPINE.1 ALPINE
## 3  147. -36.5     3 FALSE 1     ALPINE.1 ALPINE
## 4  147. -36.5     4 FALSE 1     ALPINE.1 ALPINE
## 5  147. -36.5     5 FALSE 1     ALPINE.1 ALPINE
## 6  147. -36.5     6 FALSE 1     ALPINE.1 ALPINE
## # A tibble: 6 × 8
##    long   lat order hole  piece group    id     lga_name
##   <dbl> <dbl> <int> <lgl> <fct> <fct>    <chr>  <chr>   
## 1  147. -36.4     1 FALSE 1     ALPINE.1 ALPINE ALPINE  
## 2  147. -36.4     2 FALSE 1     ALPINE.1 ALPINE ALPINE  
## 3  147. -36.5     3 FALSE 1     ALPINE.1 ALPINE ALPINE  
## 4  147. -36.5     4 FALSE 1     ALPINE.1 ALPINE ALPINE  
## 5  147. -36.5     5 FALSE 1     ALPINE.1 ALPINE ALPINE  
## 6  147. -36.5     6 FALSE 1     ALPINE.1 ALPINE ALPINE
## [1] "SpatialPolygonsDataFrame"
## attr(,"package")
## [1] "sp"
## [1]  2.0 12.8 18.0 29.8 44.0 88.0
## [1]    20.00  1681.66  5095.62 11143.68 22128.04 63453.70
## [1]   10.0000  135.8925  257.8343  404.4230  546.7040 1005.9965

Total School nos. (categorical), Victoria - 2022

Total FTE students enrols (categorical), Victoria - 2022

Distribution of Schools, Victoria LGA’s

Students density Ratio, Victoria LGA’s

  • Analysis, of Total nos. of schools across all Victorian LGA’s (arranged in descending order), with their corresponding categorical ranks, highlights few important facts such as uneven distribution of schools across Victorian LGA’s.

  • Total nos. of Government schools are highest across all Victorian LGA’s, followed by Catholic schools. Higher nos. of gov. schools supports Victorian government vision to be pioneer in quality school education.

  • While Independent schools nos. are less they are proportionately dominant in few specific LGA’s, such as: BOROONDARA, YARRA RANGES, GLEN EIRA.

  • Student density Ratio ie. FTE students per school is a key index to measure school development facilities. It is a reflection of shared educational, staff, infrastructure, by enrolled students in school.

  • Categorical analysis of student density Ratio, highlights the fact that Independent schools have highest no. of students enrolled per school, far greater than Averages for most Victorian LGA’s.

  • Both Government and Catholic schools seems to perform well on key criteria of students ratio per school.

Victoria map of nos. of Schools - 2022

Victoria map of students Ratio - 2022

Conclusion

  • Mapping of Total nos. of schools and student density ratio of all Victorian LGA’s, helps to better visualize and understand spatial distribution of Victorian schools. Shared school facilities by students are important for their development and educational needs in education system.

  • Mostly, Victoria schools are spread in Melbourne vicinity, few LGA’s such as GREATER GEELONG, YARRA RANGES, etc. have highest no. of schools. In contrast, key population growth LGA’s such as Wyndham, Melton, Monash, Moonee Valley, etc. seems to be laggards in terms of total nos. of schools.

  • Wyndham LGA schools, on an average have a student density ratio of more than 1000 students for each school and is definitely not an ideal representation of Victorian educational standards.

  • As per 2021 Census, Victoria is set to become Australia’s most populous state by year 2029-2030, and hence revamping of school education system for its citizens development, is much necessitated need of an hour.

  • Victoria gov. shall make brisk efforts to plan and bridge school educational gaps, by opening new schools in laggards LGA’s to continue to showcase its model of “The Education State” to its citizens.