Query Library 101 for Advisors. March 13, 2014. Jeffrey E. Shokler, Assistant Director Office of Undergraduate Advising firstname.lastname@example.org 608-262-9548. Time for some quick data collection!. Quick Poll: What’s your level of experience with the Query Library ?
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
March 13, 2014
Jeffrey E. Shokler, Assistant Director
Office of Undergraduate Advising
Quick Poll: What’s your level of experience with the Query Library?
A repository of pre-built queries designed to answer a very wide variety of questions.
A tool used to obtain information (data) from a data source or sources.
Under the hood, queries consist of three components:
Running queries produces a few different kinds of products/output:
Export data sets
Super handy, and
What’s a “data source?”
Think of a data source as a repository, a holding tank, of information (data).
There’s also the “Data Warehouse”
Think of the Data Warehouse as a “meta-data source.” It’s a repository of data collected from other campus data sources that is organized into data tables (“dataviews”).
STDNT Directory Multiterm
STDNT Program Multiterm
STDNT Plan Multiterm
STDNT ID Crosswalk Multiterm
STDNT Group Multiterm
STDNT Academic Group Codes
STDNT Academic Plan Codes
STDNT High School Codes
STDNT Prev Institutions Codes
STDNT Sport Team Codes
STDNT Subject Codes
STDNT Term Codes
Queries can be simple or very complex.
Simple queries answer one or two questions.
Complex queries can answer multiple questions.
Framing a good (answerable) question is 40% of the battle.
Understanding the data is another 40% of the battle (to ensure getting the right data and to be able to interpretthe data you get)
Knowing which query to choose to address your question is the remaining 20%...
*Jeff’s opinion. The Office of Undergraduate
Advising is not responsible for the above statements…
To use the Query Library it’s good to be comfortable with ISIS term codes. Here’s a quick refresher.
I find it easier to read these backwards. 1144 is the
Spring term (4) of the 2013-2014 academic year (14)…
Internet Explorer only!
(by running some queries…)
Nov. advising peak
Spring advising peak
1 2 3 4 5 6