14 February 2013

Hints & Help: ACE Data Return – Question 7

This series of Hints & Help blogs is all about questions 3 to 7 of the ACE Data Return and how you can use Ensemble to produce the relevant information. This guide is working on the assumption that all of the relevant information is contained within Ensemble.
Also for those who do not yet have them, here are the links to the ACE Data Return Template and Guidance Notes. You can use these as a reference for the guidance below.

Question 7

Question 7 is asking for the number of Pupil on each of the Assessment levels that are currently receiving tuition. This information is simple to get from Ensemble provided you have the pupils in lessons and log their assessments in the system
  1. Extract Pupils – Make sure you select the following options on the Pupil extract.
    1. (Pupil Tab) One Record Pupil Activity
      1. School And Centre Tuition
      2. Autumn Term 2012
This will give you the details of all Pupils in School and Centre tuition. From here you will now be able to group this information by assessment level. To do this go through the following steps:
  1. Group the data by the ‘NQEQUIV’ columnimage
  2. Create Summary Dataset
This will give you the aggregated statistics of Pupil numbers by National Equivalent, rather than by your own assessment levels.

No comments:

Post a Comment