Red Raider Research Registry

Tutorial analyzing data over a period of time

In this example, we are looking at course data for the last ten (10) years. This tutorial will show you how to do the following:
- Idenify duplicate data (i.e. students that retook a course).
- Make a dataset that only shows unique values for analysis.
- Create pivot tables and charts to review and analyze data.
Instructions
Combining multiple columns into a single column

This example shows how to merge the multiple race columns into one race column for all the unique id’s that are found in a Demographics export
Instructions
Creating Pivot Charts and Pivot Tables

Pivot tables and pivot charts are an excellent way to analyze large, complex datasets. In this example, we will make both a pivot table and pivot chart to analyze the data of students who repeated a class
Instructions
Removing Duplicate Values in Excel

Student data downloaded from Red Raider Registry can contain duplicate values. These duplicate Unique Identifiers can result from searching courses over time or result from multiple course attempts by a student. This tutorial will provide steps on how to identify if the data set contains duplicate values and how to remove those duplicate values from the data set.
Instructions