Exporting AEDC data

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 in the survey you should have already received a data submission template. 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:

1. Download the appropriate SQL file for your version of Synergetic:
   
   • AEDC2021_DataExtract_v70_V1.0.sql
   • AEDC2021_DataExtract_v69_V1.0.sql
   
   
2. Open the relevant file in SQL Server Management Studio.
   The AEDC2021_DataExtract.sql file is displayed.
   
3. Update the fields highlighted below.
   
   
   You can update:
   
   • @RunDate field with the current date.
   
   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.
   
   
4. Click .
   The results of the query are displayed in the Results tab.
5. Copy the data to the AEDC template.
6. 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.