sean-m-cusick / wap_shs_app Goto Github PK

to complete the user interface for shiny app.

To complete the server.r file

• 
* A&E attendances and performance data

• * 
Quarterly Hospital Beds Information -

• * Datasets - Scottish Health and Social Care Open Data - nhs.scot

• * 
Delayed discharge data

• 
Hospital Activity and Patient Demographics
• 
Hospital Activity and Deprivation

KANG

• 
Hospitalisations due to Covid 19

ABOUBAKAR

* A&E attendances and performance data

• 
Quarterly Hospital Beds Information -
• Datasets - Scottish Health and Social Care Open Data - nhs.scot
• 
Delayed discharge data

• * 
Hospitalisations due to Covid 19

• * 
Hospital Activity and Patient Demographics

• * 
Hospital Activity and Deprivation

• Define roles
• Choose what questions to answer
• Design shiny app layout
• Choose datasets
• Set up Gantt
• Create WBS
• Set up Kanban board

MVP
Three questions:

How does winter affect hospital activity?
A&E/Department activity/ by time

How does deprivation affect hospital activity?
A&E/ Department activity by SIMD

How does Covid affect hospital activity?
Was there a change post Q1 2020?

Data needed:
Counts grouped by time, geography

Shiny App:
Tabs: Maps, Time Series, Proportional Graphs, Tables?

Maps:
Regional level
Health board level
Hospital level
Variables: covid infections by population
: covid infections by SIMD
: use a slider to show changes of time

Time Series:
Daily
Weekly
Monthly
Quarterly
Annually

Graphs:
Demographics
SIMD (Deprivation)

Nice to add on:
Bed capacity/A&E specialism
Projections

Define the objective for our MVP

• 12. What has been happening from 2020 onwards in the acute hospital sector?
• 13. Three questions: 1. How does winter affect hospital activity? 2. How does deprivation affect hospital activity? 3. How does Covid affect hospital activity?

MVP
Three questions:

1. How does winter affect hospital activity?
   A&E/Department activity/ by time

i). How does Covid affect hospital activity?
Was there a change post Q1 2020?

2. How does deprivation affect hospital activity?
   A&E/ Department activity by SIMD

Data needed:
Counts grouped by time, geography

Shiny App:
Tabs: Maps, Time Series, Proportional Graphs, Tables?

Maps:
Regional level
Health board level
Hospital level
Variables: covid infections by population
: covid infections by SIMD
: use a slider to show changes of time

Time Series:
Daily
Weekly
Monthly
Quarterly
Annually

Graphs:
Demographics
SIMD (Deprivation)

Nice to add on:
Bed capacity/A&E specialism
Projections

Other Questions:
[ ] 1. The whole system: from what’s coming through the front door in A&E and then how it filters through; how many emergency admissions are there, how many electives, how does this impact the lengths of stay people have in hospital?

• 2. What does this mean for the number of people in intensive care and the number of beds?
• 3. Do people have longer lengths of stay from elective or emergency admissions?
• 4. Capacity – what is happening to the number of beds over the period? Perhaps think about the specialties these are if there have been specific variations?
• 5. Are there any demographic groups that are driving the activity?
• 6. Are there key cohorts of patients (based on their demographics) that drive the overall hospital activity?
• 7. How significant is deprivation as a driver of hospital activity?
• 8. Are there specialties that have more stable activity patterns over time and how much of an impact is stability on overall activity?
• 9. How significant are the differences in hospital activity across the country? Does urban/rural have an impact or is it related to the size and capacity of the health board?
• 10. Has Covid had a noticeable affect on beds? (or other variables)
• 11. Do deprived areas have different Covid rates than non-deprived areas?

SEAN

• * Hospital Activity page

• * Hospital Activity by Speciality

Hospital Location

• [ ]

Deprivation

• [ ]

Accident & Emergency

• [ ]

COVID-19

• [ ]

mid-project design Review to establish that project is on path.

To complete the global.r file

to aggregate all functions used by the app in a separate .r file, in a separate folder.

• Team learning goals - AH
• Team learning goals - KL

• Roles & responsibilities - AH
• Roles & responsibilities - KL
• Roles & responsibilities - LB
• Roles & responsibilities - SMC _______
• Update Wireframes

• MVP details - Landing page
• MVP details - Page 1
• MVP details - page 2
• MVP details - page 3

• Update network graph - version control

• Data set details - synthesises
• Data set details - motivations

• Quality
• biases -

• data cleaning
• data wrangling

• storage - hierarchy
• data wrangling

• glossary - acronyms
• data wrangling

• Map
• Time series
• Demographics

• Data
• Cleaning
• Wrangling
• Visualisation
• Application
• Report
• Presentation
• README

• Temporal
• Spatial
• Demographics