This page explains how to use the Application Summary tool, which contains daily updated data about Applications made to the University of York since 2011/12.Anchor top top
The Application Summary tool forms part of the Application Dashboard {insert link} 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 here {insert link}
Contents:
- Overview
- Data Terms contained in this Workbook
- Using this workbook
- Changes to the Tableau workbook
- Changes to the underlying data set
- Change Log
Anchor overview overview
Overview
| overview | |
| overview |
The Application Tracking workbook contains data about applications, offers and acceptances for:
- the current application cycle (data is refreshed daily overnight to show the close of business position for the previous day)
- completed application cycles (when compared with the current cycle, data for the equivalent date is shown; otherwise the end of cycle position is shown)
The workbook replaces a number of previously published workbooks and spreadsheets:
- Application Analysis (workbook showing Applications - current season)
- UG applications and offers by programme, current season (weekly updated spreadsheet showing UG Applications)
- PG applications by programme, current season (weekly updated spreadsheet showing PGT/PGR Applications)
- Application Overview (workbook showing Applications - complete seasons)
- UG applications by programme, end of season (spreadsheet showing final UG Applications position)
- PG applications by programme, end of season (spreadsheet showing final PGT/PGR Applications position)
Changes to the Tableau workbook
...
Term | Business Definition | Technical Definition |
|---|---|---|
| Application | 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%' |
| Withdrawal | An Application that has been withdrawn by the Potential Student. | A record where the Status Code is not like 'Z%' and like 'W%' |
| Live Application | An Application which is not a Withdrawal; not invalidated due to the Potential Student firmly accepting an Unconditional offer for another Programme either at York or another institution; and not superseded by a replacement/adjusted application record. | A CAPS record where the Status Code is like 'A%' |
| Offer | 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). | A record where the Status Code is not like 'Z%' and the Decision/Response Code is like '%C%' or like '%U%' |
| 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%') |
| Pending Offer Decision | 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 |
| Offer Decision Made | An Application for which the University has either made a Conditional or Unconditional Offer, or Rejected the Application. | A record where the Status Code is not like 'Z%' and the Decision/Response Code is like '%C%' or like '%U%' or like '%R%' |
| Firm Acceptance | A Live Offer which the Potential Student has subsequently firmly accepted. | A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %F' |
Conditional Firm | A Live Offer that is Conditional to which the Potential Student has responded with a Firm Acceptance. | A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %CF' |
Unconditional Firm | A Live Offer that is Unconditional to which the Potential Student has responded with a Firm Acceptance. | A record where the Status Code is not like 'Z%' not like 'W%' and not like 'UF%' and the Decision/Response Code is like %UF' |
| Conditional Decline | 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. | A record where the Status Code is not like 'Z%' and not like 'W%' and the Decision/Response Code is like %CD' and additionally as a record where Status Code is not like 'Z%' and like 'UF%' and the Decision/Response Code is like '%CF' or like '%CI' or like '%C' |
| Unconditional 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 without making 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 not like '%C%' |
| Rejected After 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%' |
| Anchor | ||||
|---|---|---|---|---|
|
Anchor 8 8
Change Log:
| 8 | |
| 8 |
7 Oct 2019 - major version release 2.0
Key changes:
- Improvement to underlying data set
- Minor aesthetic improvements to conform to BIU design standards
- Removal of "original/current" option
- Refactoring of date selector.