| Anchor | ||||
|---|---|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
This page explains how to use the Application Overview tool, which comprises a weekly-updated visual comparison of Applications, Offers and Acceptances made to the University of York for the current, and previous, cycles. The Application Overview tool forms part of the Application Dashboard suite of Tableau workbooks. Both this workbook - and the underlying data set - have been redeveloped in 2019 for the new cycle (2020/21 entry year). Besides some cosmetic improvements, the workbook has changed little but some underlying data definitions have been adjusted with the result that previously reported figures may now be presented differently - and more accurately. Details of the changes made can be found below. |
| Anchor | ||||
|---|---|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
| Anchor | ||||
|---|---|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
The Application Overview workbook contains data about applications, offers and acceptances for:
The workbook replaces a number of previously published workbooks and spreadsheets:
|
| Anchor | ||||
|---|---|---|---|---|
|
| Panel | ||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||
This workbook has a separate tabs for UG, PGT, PGR and IPC programmes. Each tab works basically the same way, though some filter options may not be available in all tabs (e.g. "Clearing" is not applicable to PGR). Please note that the University of York handles admissions for English language pre sessionals and therefore these figures show on the UG and PG tabs. By default, the workbook shows the most recent application data, as at the current point in the application cycle. For previous cycles, comparable data is shown at the equivalent date. For example, on 8th October 2019, the most recent data for the 2020/21 cycle is the overnight position on 7th October 2019. The equivalent data for the 2019/20 and 2018/19 cycles is, respectively, the 7th October 2018 and 7th October 2017. Using the Date Selection options you can:
How to use the Data Filters and Display Options
Remember to check the text summary of the filters you have selected. |
...
| Panel | ||
|---|---|---|
| ||
1. Removed the “Offers and Responses” option which many people found confusing - instead the offer made and response decision shown is now always the actual offer/response as of the particular date shown. 2. Simplified the “data currency” options, which were confusing and a little clunky. The new version of the workbook:
3. Made some cosmetic enhancements to the user interface, bringing it in line with BIU's latest standards. Apart from the "Offers and Responses" box, the filters and drop-down options remain the same as before, though the position of these has been rearranged into a more logical layout. |
...
Application Data Terms and Definitions
...
| title | Data Terms contained in this Workbook |
|---|
Definitions
The below definitions have been agreed upon with SRA and are used throughout the applications data set. For the purposes of theses definitions a Potential Student is defined as any person who has had a official interaction with the University of York applications and admissions process. From a technical standpoint this is defined as any person who has a record in the CAPS table of the SITS database.
NB see also recent changes to definitions (below)
...
Term
...
Business Definition
...
Technical Definition
...
A recorded instance of a Potential Student applying for a place on a Programme at the University of York (that is not due to a miscoding).
A CAPS record where the Status Code is not like 'Z%'
...
A CAPS record where the Status Code is like 'A%'
...
An Application that has led to a Potential Student being offered a Conditional or Unconditional place at the University of York.
It is worth noting that, though this offer may later be rescinded or turned down these offers will still be included. This field records the fact that the Offer was made, not that the offer is currently live (see Live Offer).
...
An Application that resulted in the Potential Student currently holding a Conditional or Unconditional offer for a Programme at the University of York.
Unlike the above Offer definition this will not include offers that have been subsequently rescinded or turned down. As such offers will be excluded where they have been Declined or Rejected, or the Application has been Withdrawn, or the Potential Student has firmly accepted an Unconditional offer for another programme either at York or another institution.
...
A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is not like '%D', not like '%R%' and (like '%C%' or like '%U%')
...
A Live Application for which the University has neither made a Conditional or Unconditional Offer, nor Rejected the Application.
...
A record where the Status Code is like 'A%' the Decision/Response Code is NULL
...
A Live Offer which the Potential Student has subsequently firmly accepted.
...
Conditional Firm
...
Unconditional Firm
...
An Application that has resulted in the Potential Student being made a Conditional offer for a Programme at the University of York which they have now Declined.
Where Potential Students in receipt of a Conditional offer subsequently firmly accept an Unconditional offer for another Programme, either at York or another institution, this is considered equivalent to a Conditional Decline.
...
An Application that has resulted in the Potential Student being made a Unconditional offer for a Programme at the University of York which they have now Declined.
Where Potential Students in receipt of a Unconditional offer subsequently firmly accept an Unconditional offer for another Programme, either at York or another institution, this is considered equivalent to a Unconditional Decline.
...
A record where the Status Code is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %UD' and additionally as a record where Status Code is not like 'Z%' and like 'UF%' and the Decision/Response Code is like '%UF' or like '%UI' or like '%U'
...
Rejected Without Offer
...
An Application that has not been Withdrawn by the Potential Student, and which the University has rejected after having previously made an offer.
...
A record where the Status Code is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %R%' and like '%C%'
...
Application Data Terms and Definitions
| Panel | ||||
|---|---|---|---|---|
| ||||
Following a review, some marginal changes to the some metric category definitions (e.g. 'Applications', 'Withdrawn') were agreed between SRA and BIU. For the avoidance of doubt, the newly updated data set (and definitions) should always be used in preference to previous extracts. Term Change to the Definition | Applications | Conditional Declines | ||
Unconditional Declines | The definition of unconditional decline has been expanded to include those applicants who had a unconditional decision / response (U, UF orUI) and who had chosen to go to another institution, as well as those with a UD decision/response. In addition the definition of Declined students has been changed such that a student who is both withdrawn and declined only counts as withdrawn (i.e. these are now mutually exclusive and withdrawn take precedence). | The definition of decision pending has been broadened slightly with the only stipulation now being that the applicant must have a status like A and a null IDRC code. |
| Anchor | ||||
|---|---|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
7 Oct 2019 - major version release 2.0 Key changes:
|