A collection of tools for school data in Victorian schools.
Project description
vicedtools
This is a collection of utility tools for working with school data in Victorian schools.
The utilities have been designed to be state-less. Where tools have been created to export data then they have been designed to work with the native export formats provided by the relevant sites so that processing functions also integrate with existing data stores.
Currently includes tools for:
- automating the exporting of data from Compass, ACER's OARS site, the VCAA data service (NAPLAN) and VASS (VCE results).
- tools for working with ACER's OARS site, such as working with PAT data
- extracting NAPLAN data from the SSSR data.js file
- uploading data to Google Cloud storage and BigQuery for use with Looker Studio
The core export functions are provided by the CompassSession, OARSSession, VASSSession and DataServiceSession classes.
Getting started
Installation
Install from pip
pip3 install vicedtools
To use the bundled scripts for performing exports and aggregating exported data, make a copy of 'config-sample.toml', update it with your credentials, and then set the VICEDTOOLS_CONFIG environment variable to point to the config file.
Usage
Exporting from VASS
Create a session and select a year.
from vicedtools import VASSSession
grid_password = [('1', '1'), ('8', '1'), ('4', '5'), ('5', '5'), ('1', '8'),
('8', '8')]
s = VASSSession(username=username,
password=password,
grid_password=grid_password)
year = "2021"
s.change_year("year")
Exports from the main VASS interface.
s.personal_details_summary(f"personal details summary {year}.csv")
s.school_program_summary(f"school program summary {year}.csv")
s.gat_summary(f"gat scores {year}.csv")
s.school_scores(f"school scores {year}.csv")
s.external_results(f"external scores {year}.csv")
s.moderated_coursework_scores(f"moderated coursework scores {year}.csv")
Some data is only available once the VCE data service is updated.
s.predicted_scores(f"predicted scores {year}.csv")
Exporting from OARS
Create a session.
from vicedtools import OARSSession, OARSBasicAuthenaticator
oars_authenticator = OARSBasicAuthenaticator(oars_username, oars_password)
s = OARSSession(oars_school_code, oars_authenticator)
Exporting student details.
candidates = s.get_candidates()
with open("oars_candidates.json", 'w') as f:
json.dump(candidates, f)
Export staff details.
s.get_staff_xlsx("oars_staff.xlsx")
Export test results.
sittings = s.get_all_pat_sittings("01=01-2020", "31-12-2021")
with open("sittings 01-01-2020 31-12-2021.json", 'w') as f:
json.dump(sittings, f)
Exporting NAPLAN results from the VCAA data service
Create a session.
from vicedtools.naplan import DataserviceSession, DataServiceBasicAuthenticator
dataservice_authenticator = DataServiceBasicAuthenticator(
dataservice_username, dataservice_password)
s = DataserviceSession(dataservice_authenticator)
Export outcome Excel files.
s.export_naplan("2021, "./naplan results/")
Export the SSSR.
s.export_sssr("2021, "./naplan sssr/")
Bundled command-line utilities
The following command-line utilities are bundled with the package.
- compassreportstobq
- compassstudentdetailstobq
- compassstudentenrolmenttobq
- createcompassreportssummaries
- createcompasssubjectsmetadatacsv
- createnaplansummary
- createoarsstudentimports
- createpatparentlettertable
- ewritescorestobq
- ewritesittingstoscores
- exportcompassacademicgroups
- exportcompassclasses
- exportcompassenrolments
- exportcompasslearningtask
- exportcompasslearningtasks
- exportcompassprogressreport
- exportcompassprogressreportcycles
- exportcompassprogressreports
- exportcompassreport
- exportcompassreportcycles
- exportcompassreports
- exportcompasssds
- exportcompassstudenthouseholdinformation
- exportcompassstudents
- exportcompasssubjectmetadata
- exportnaplanoutcomes
- exportnaplansssr
- exportoarsmetadata
- exportoarssittings
- exportoarsstaff
- exportoarsstudents
- exportvassexternalscores
- exportvassgatscores
- exportvassmoderatedscores
- exportvasspredictedscores
- exportvassschoolprogram
- exportvassschoolscores
- exportvassstudentdetails
- naplanoutcomestobq
- patmostrecentobq
- patscorestobq
- patscorestomostrecent
- patsittingstoscores
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for vicedtools-0.0.8.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 592d1c8e0ecfc1ca82893cfead78073762de05b820d3df68e9b15fd234bf4aca |
|
MD5 | db2fa6ac8146ddc73377c81deaef4cde |
|
BLAKE2b-256 | 1dd31f9bfbf1bf7a47cd3ba81bb5e980f9d5a03a4ce749f76db5c3b02e2fb264 |