Australian schools can complete the Australian Early Development Census (AEDC) every three years to report on childhood development at their organisation.
If your organisation is participating The decision to participate in the survey you should have already received a data submission templateis made by Schools. This topic provides instructions for running a SQL script that will export student and parent/guardian data used in the pre-population step of the data submission.
To export AEDC data:
- Download Download the appropriate SQL file for your version of Synergetic :
• AEDC2021_DataExtract_v70_V1.0.sql
• AEDC2021_DataExtract_v69_V1.0.sql
from the Hotfix page. See AEDC Hotfix page. - Open the relevant file in SQL Server Management Studio.
The AEDC2021_DataExtract.sql file is displayed.
- Update the fields highlighted below.
.png?version=1&modificationDate=1616599199477&cacheVersion=1&api=v2&width=800)
You can update
Update:
• @RunDate field with the current date you want to run as at.
Note: The date must be entered in the format d mmm yyyy (e.g. 1 Apr 2021).
• @YearLevel field to the year level to be exported. - Click
.png?version=1&modificationDate=1616599712637&cacheVersion=1&api=v2&height=24)
.
The results of the query are displayed in the Results tab. - Copy the data into the AEDC template.
- Submit to the AEDC as per their instructions.
Note: The data collection period for the 2021 AEDC opens on 3rd May and closes on the 25th June.