Calculating Student Recidivism in Excel


I’ll share what I think are helpful tips for housing professionals using systems (Advocate by Symplicity) and software (Microsoft Office) that are common tools in higher education. Today’s focus will be on using pivot tables to get descriptive statistics on your student conduct. Specifically, we’ll use the reporting tool to create a spreadsheet of data from cases marked “Closed Responsible” and the students involved in those cases. Our residential conduct procedures process each parent case into individual child cases, giving a 1:1 ratio of student to case, which is an important caveat to the process described below.

Getting the Data

First, I use the reporting tool in Symplicity to extract the data I need about student conduct. This is done using the “Reporting” tool. Choose “Add New Report”. Select the following fields: Continue reading