TIR & RA Selection
Our project for student housing was a way for them to replace piles of paper forms, PDFs and Excel spreadsheets with a series of easy web forms, backed by a database, that handled and compiled all the applicants, applications, interviews and screenings for Resident Assistants and Tutors-in-Residence in one place.It starts with adding a list of potential applicants. Names are gathered at informational meetings, and then can be dropped into the form. It accepts either SHU ID numbers, or SHU shortnames, looks up each name in turn from the Active Directory system, and adds it to the database.
Alternatively, you can enter a last name and search for people. Then, just drag and drop from one column to the other and submit.
Once the names are ready, just click the green button.
These name selectors are a standard tool we’ve developed here at TLTC, and can be incorporated into many kinds of projects.
When the names go in, e-mails go out. To each candidate, with a custom link inviting them to log in and fill out their application. In addition to the form fields, they upload a resume file, which is stored for future reference. We’ll look at the application a little further down.
Once names are in place, and applications start to be worked on, there are ways of tracking progress. This screen shows each applicant’s basic information, and tracks
- New or returning applicant
- Whether they want to be an RA or TIR
- Whether they’ve begin the application
- If they’re done, when they finished
- If their essay questions have been scored, what the result is
- The status of the two references they’re required to get
On this screen, as on most of the index screens, the tables are fully sortable. Just click the header row you want to sort on, and click it again to reverse sort. They’re also fully paginated. If you click on one of the “Detail View” links (only available for completed applications) you can view the application as submitted.
The last tab on this screen lets administrators change the role of people in the system. That way, you can set someone to be an administrator or evaluator for a time, then change them back to another role with fewer permissions.
The next stage after the applications are in and the essays are screened is in-person interviews. The interviewers log into the proper screen and begin by selecting the name of the candidate to interview.
And see the detail view for all.
You’ve probably noticed how the score column here, as well as on other screens, is color-coded. In addition to the numeric score received by the candidate, the recommend/recommend with reservations/do not recommend determination is determined by green/orange/red. This screen composites all the new candidates’ interviews and group activity scores into one table, with totals and subtotals that can all be sorted.
Initial reviews are great. It’s saved the department hundreds of man-hours. Plus, the result tables can all be copied-and-pasted directly into the old Excel spreadsheets for even more data manipulation.
Server-side LAMP stack.
Twitter’s Bootstrap framework with responsive add-on
- Data Tables