ID Search and excel file drop

The ID search brings a specific list of students into your Found Set in TrackEd. If you already have the students you want in a spreadsheet, you can copy their IDs, paste them into TrackEd, and get exactly that group back, ready to profile, datawall, tag, or report on.

It lives in the Find Panel and works two ways: paste a list of IDs, or drop in an Excel file. Both return the same result, a Found Set of just the students on your list.

Common use cases: Case managing a group of students you track in a spreadsheet; bringing a OneSchool export (such as medical students) into TrackEd; recalling a group you exported from TrackEd earlier, as an alternative to tagging; turning a filtered Excel list into a datawall of names and photos.

Quick Start Guide

Important: You need a list of IDs to paste, usually copied from a column in a spreadsheet. Have that ready on your clipboard before you start.

Start on the Home page and open the Find Panel (the purple button).
On the left-hand edge of the Find Panel, choose Pasted ID List.
Choose your ID type: Student ID, LUI, USI, or MIS.
Open your spreadsheet, select the list of IDs, and copy them to your clipboard.
Paste the IDs into the list.
To narrow the group, add any other search criteria at the same time (optional).
Choose Find students.
TrackEd returns those IDs as a list of students in your Found Set.

Tip: Once the group is in your Found Set, you can sort it and build a datawall, save PDFs, or apply a tag, the same as any other search result.

Training Video

0:01 Where to find the ID search: The Find Panel sits at the top and bottom of the Home page and the top of the Profile and List pages, always shown in purple.
0:18 Pasting a list of IDs: Copy IDs from an Excel file, paste them into the Pasted ID List, and choose Find Students to return that group as your Found Set.
0:47 Choosing the ID type: Pick Student ID, LUI, USI, or MIS, the student’s email address, which works with either the first part or the whole address.
1:08 Adding other criteria: Combine the pasted group with another search, such as the red attendance band, to return only a subset.
1:27 An alternative to tagging: Export student data to Excel and run an ID search later to recall a case-managed group without using a tag.
1:55 Excel file drop: Drag a TrackEd-format file (EQID in column A, data from row 2) onto the drop zone to return the group.
2:35 Other use cases: Download a list of students from OneSchool, copy the IDs, and run an ID search.
2:48 From Found Set to datawall: Sort the group and build a datawall of names and photos.

Detailed Guide

Tip: For a visual walkthrough, see the Training Video above.

Pasting a list of IDs
Dropping an Excel file
Narrowing the group with extra criteria
Using ID search instead of tags
Turning a found list into a datawall
Reference
Putting your Found Set to work

Pasting a list of IDs

When you already have a group of students in a spreadsheet, the Pasted ID List brings exactly that group into TrackEd. The IDs can come from anywhere: a column in an Excel file, an export from OneSchool, or a file you exported from TrackEd earlier.

Open the Find Panel (the purple panel at the top or bottom of the Home page, or the top of the Profile and List pages) and choose Pasted ID List on the left-hand edge. Pick the ID type that matches your list, copy the IDs from your spreadsheet to your clipboard, paste them into the list, and choose Find students. TrackEd returns those IDs as a list of students in your Found Set.

For which identifier to choose, see the ID type reference below.

Dropping an Excel file

If your list is already an Excel file in TrackEd’s format, you can skip the copy and paste. The Excel file drop sits just under the Pasted ID List.

Drag the file onto the Excel file drop and TrackEd returns that same group of students into your Found Set.

Important: The Excel file drop reads the EQID from column A and assumes your data starts on row 2 (the header is row 1). Any file exported from TrackEd already matches this layout.

Narrowing the group with extra criteria

Sometimes you want only part of the pasted group, for example the students on your list who are also flagged for attendance. You can add other Find Panel criteria at the same time as the pasted IDs.

TrackEd then finds only the students in your pasted group who also match. For example, paste a group of IDs and choose the red attendance band, and it returns anyone in that red zone from within your pasted group.

Using ID search instead of tags

If you case manage groups of students, the ID search lets you recall a group without creating a tag. Export student data to an Excel file (it saves into your TrackEd_Docs folder), and at any point in the future paste those IDs back in to pull the same group into your Found Set.

This works well alongside tagging rather than replacing it: a tag lives inside TrackEd, while an exported ID list is a spreadsheet you can keep, filter, and re-import whenever you need the group back.

Turning a found list into a datawall

A common reason to gather a group is to produce a quick visual reference. Once the group is in your Found Set, sort it however you want, then build a datawall (for example, 25 per page).

The result is the names and photos of every student on your list, a fast way to turn a spreadsheet into a usable format. See Exploring the datawalls for the layout options.

Reference

ID type reference

The Pasted ID List and Excel file drop can match on four different identifiers. Choose the one your list uses.

ID type	What it is	When to use
Student ID (EQID)	The Education Queensland student ID	The default. Matches the EQID used in TrackEd exports and the Excel file drop.
LUI	The QCAA Learner Unique Identifier	When your list uses LUIs, for example senior schooling data.
USI	The national Unique Student Identifier	When your list uses USIs.
MIS	The student’s email address	When your list has email addresses. The first part or the whole address both work.

Putting your Found Set to work

Once your group is in the Found Set, it drives the rest of TrackEd. Sort it and build a Datawall of names and photos, save the group as PDFs, apply a tag for ongoing case management, or open the profiles to review and edit.

The ID search is the quickest way to get a known list of students from a spreadsheet into any of those workflows. For the full range of searches that build a Found Set, see the Find Panel.

Frequently Asked Questions

Q: Which ID types can I paste?
A: Student ID (EQID), LUI, USI, or the student’s email address (MIS). Choose the type before you paste the list.

Q: Does the email option need the full email address?
A: No. For MIS, the first part of the email address or the whole thing both work, TrackEd handles either case.

Q: What format does the Excel file drop expect?
A: The EQID in column A, with the data starting on row 2. Any file exported from TrackEd is already in this format.

Q: Can I combine an ID search with other search criteria?
A: Yes. Add other Find Panel criteria at the same time and TrackEd returns only the students in your pasted group who also match, for example those in the red attendance band.

Q: Can I use the ID search instead of tagging a group?
A: Yes. Export the group to an Excel file and paste the IDs back in whenever you want to recall it, without creating a tag. It works well alongside tagging.

Q: Where do I get a list of IDs?
A: From any spreadsheet, for example an export from OneSchool or a file you exported from TrackEd. Copy the IDs to your clipboard, then paste them into the Pasted ID List.