Managing Schools (i.e. the Organizations dataset)
- Elizabeth Storrs
Why should Admissions Offices spend time curating their Organizations dataset and linking student’s school records?
The cleaner the list of schools on the applicant record, the easier and more accurate reporting on and outreach to feeder schools will be.
“Curating their Organizations dataset” means what, exactly?
(1) Ensuring that the list of schools in Slate has one entry per institution, and
(2) all applicants have their school listings linked back to a record in the organization table.
Each Organization has a unique identifier, or key, which is the code that links it back to the school entry on a student record. For many schools, this is the same as the CEEB code.
What’s an institution?
To a certain extent, schools get to decide, based on what is important to your decision makers. Baseline best practices are as follows:
How to decide which organization record to keep?
o The record with the most applications/ most recent associated with it is highest priority
o All numbers preferred over anything with letters
Schools with multiple entries in the organizations table look like this to the applicants:
And can be easily seen on the
Three common types of issues that regular curation of the Organizations dataset can help address are:
(1) Students with duplicate school rows
Note that is not the same as students who have two degrees from the same school!
How can I see what
SAmple queries that are useful