Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The master link: https://uwaterloo.ca/registrar-resources/data-and-reports/data-extracts

Following that link you will find PDF’s with screenshots and instructions

Guidelines for creating extracts of student data

...

  • Permission is required to create an extract (typically in the form of a CSV spreadsheet) of student or course data.

  • When creating an extract, include data that is strictly necessary for your purpose and limit the use of the file to the purpose for which it was compiled. Use of a download for any other purpose must be approved by the appropriate authority.

  • You (the person who creates the downloaded extract) are responsible for keeping track and maintaining control of data extracts. There is no mechanism to keep track of downloads once they have left the system.

  • Keep the extract on a university-managed storage system, e.g., a network drive or SharePoint.

  • If you must put the file on a laptop or external disk, the laptop needs to have an encrypted hard drive and the external disk needs encryption. Use a secure password.

  • Don't put an extract on a phone, tablet, or a USB thumb drive. Don't burn it to a CD-ROM.

  • Don't send the extract via email.

  • Periodically review your extract files and delete the unneeded ones. If you keep an extract for more than a year, review the University's policy on records retention.

  • Paper copies of the data must be stored securely and shredded when no longer needed.

  • Harvesting email addresses from the extract for a mass email requires approval as follows:

    • Mass email addressed to undergraduate students within a particular faculty needs approval of the associate dean - undergraduate studies of that faculty.

    • Mass email addressed to graduate students within a particular faculty needs approval of the associate dean - graduate studies of that faculty.

    • Mass email addressed to undergraduate students in multiple faculties needs approval of the Registrar.

    • Mass email addressed to graduate students in multiple faculties needs approval of Graduate Studies and Postdoctoral Affairs.

  • The authority governing the use of student data is Policy 46, and in the case of any conflict between these guidelines and Policy 46, the latter takes precedence. Any questions or comments regarding these guidelines should be directed to the University's privacy officer.

An additional guide with images to running a data extract. I'm using the Course/Class Extract as an example, but they are all pretty similar start up.

Log into Quest.

Under the navigator select the following pathway: “Data Extracts” → “Records” → “Course /Class extract”

...

image-20241025-175626.pngImage Removed

If you already have one usually your own user id is the one to pick.

If none come up then create one by selecting the “Add a New Value”

...

once you have entered in a run control the next page appears:

...

  • .

...

Select Run

...

It will then take you back to the Course/Class Extract page. To view the report and the status of it being created, select the “Process Monitor” link

...

You will see the process that you are running in the list of processes, usually when you first land on this page it will look like this:

...

image-20241025-180459.pngImage Removedimage-20241025-180602.pngImage Removedimage-20241025-180715.pngImage Removed

it will down load and give you all the course time room instructor information (if you’ve selected the Course/Class Extract)

...