Tips & Insights provides advice on and examples of technology used to simplify and streamline IR activities, as well as real world examples of visual displays of data (e.g., charts, graphs, maps, tables, pictures). These eAIR features are developed by members.
-
Long-term Enrollment Trends
Humboldt State University is one of 23 campuses in the nation’s largest four-year university system, the California State University system. While a formal office of Institutional Research was only founded in 2009,...Read Moreabout: Long-term Enrollment Trends -
Side-by-Side Comparison Charts
Figure 1. Ethnicity Table The columns I used for the chart were Ethnicity, Georgia Percentage Positive, Georgia Percentage, and College Percentage (Figure 2). Excel 2016 is the software used to construct the chart. The ...Read Moreabout: Side-by-Side Comparison Charts -
Using the INSERT Command in SPSS Syntax
There are usually some of the same variables (gender, birthdate, etc.) included in multiple data files that your office collects or maintains. Instead of duplicating the syntax in the syntax file for each data file, a sm...Read Moreabout: Using the INSERT Command in SPSS Syntax -
Qlik Sense: Visualizing Future Enrollment/Tuition Revenue
This visual display focuses on predicting enrollment of admitted applicants depending on the amount of a scholarship offer. Predictions are visualized using the dashboard with a possibility to explore "what if" scenarios...Read Moreabout: Qlik Sense: Visualizing Future Enrollment/Tuition Revenue -
Using the Listagg Function in SQL
Our institutional research analysts frequently extract data and modify the structure of data using SQL to suit the needs of data consumers or to ease analysis. Often, we need to aggregate tables containing multiple rows ...Read Moreabout: Using the Listagg Function in SQL