Senior School data management tools

0 / 0
⌘/

TrackEd includes several tools for manually editing and cross-checking senior schooling data. These complement the QCAA import process by giving you direct control over individual values and a way to review data across the whole cohort.

Note: This video has been flagged for replacement and some details may have changed since it was recorded.
Training video
Video: Senior School data management tools

What you can edit manually

Manual entries cover situations that imports alone don’t handle. You can add points for subjects a student has changed out of, enter S and U unit results directly, type in IA scores for a student who arrives partway through Year 12, and adjust VET completion estimates below the default 100%. If a student has VET duplication, you can record that as a minus value in the other points field.

These edits are made in three locations: the pink edit button on the Profile page, the Subject List Utility report, and the VET Entries report. The pink edit button is for working with one student at a time, while the two reports give you a cohort-wide view.

Profile page: pink edit button

On any Year 12 student’s Profile page, wherever senior schooling results are displayed, you will see a pink edit button. Click it to open an editable view of every subject row TrackEd holds for that student, going back as far as data exists. A scroll bar lets you move through the full history, with Years 10, 11, and 12 shown by default.

From this view you can click and edit OneSchool results, type over S and U values, and manually override points. Any overridden value turns yellow so you can see what has been changed. IA scores can also be typed in directly, and the IA percentages update in real time as you make changes.

Two flag columns appear at the far right of each row. The first is a distance education flag, which you can tick for any subject row. You can also add a new subject row, fill in the details, and flag it as distance ed. The second is a university flag for university-based courses. Flagging subjects in either category lets you run searches and reports later that filter to just your distance ed or university subjects in one place.

Subject List Utility report

The Subject List Utility is found under the Reports menu on the Profile page. It provides a cohort-wide table of every subject row marked Year 11 or Year 12, with columns for OneSchool data, unit results, QCE estimates, IA points, IA percentages, the monitor flag, manual point overrides, distance ed and university flags, and FIA data on the far right.

Before the report loads, filter options let you narrow the view. The most common filter is “senior subjects”, but you can also filter to hidden rows, rows with manual point entries, rows with unit or IA entries, manual IA entries, distance ed subjects, university subjects, or a specific subject name.

Once the report is loaded, you can change the sort order to group students in different ways. The “subject class student” sort is particularly useful: it organises all rows by class grouping, so you can scan top to bottom and see progress across each class quickly. An Export button at the top right sends all visible data to Excel, including LUI and student IDs.

There is also a second, stripped-down view called Senior QCE Monitoring. It shows fewer columns and focuses on the data most relevant to the senior schooling journey. This view is also exportable, with the LUI column on the left edge for easy matching in Excel.

VET Entries report

The VET Entries report, also found under the Reports menu, shows every VET qualification line across the cohort. By default it displays all qualification rows, but a learning name search at the top lets you type a specific qualification name to filter the list (for example, typing “business” to show all Certificate I and Certificate III in Business entries together).

The report includes columns for status, estimated completion, and awarded points. The VET estimate defaults to 100%. If you know a student will not reach full completion, click the percentage and change it. You can also edit the awarded points directly, though this is not recommended if you are running VET imports, as the next import will overwrite any manual changes in this table.

Filter options at the top of the report let you switch between completed, incomplete, no points, and hidden qualification rows.

Where to find these tools

The pink edit button appears directly on the Profile page next to senior schooling results. The Subject List Utility and VET Entries reports are both accessed from the Reports menu on the Profile page. For related reporting and search tools, see Senior School searches and reports. For visual displays of senior data, see Visualising Senior School data.

Updated on March 26, 2026
Was this article helpful?