Reference no: EM131040157
Information Systems Course Project-
You will be provided with simulated data from a hospital. The primary data set will include ER wait times, and supporting tables ranging from ER Staffing schedules to bed turnaround time. You will use this data to conduct an analysis into potential factors impacting ER wait times and recommend possible process improvements based on the dataand any additional research you have conducted. If you use external data resources make sure they are credible and properly cited in your presentation.
Your project must include the following components:
1. Import and Structure Data
a. Use the provided data sets to import tables into a blank access database
b. Use database normalization techniques to split the flat file databases into a relational database.
c. Make sure to utilize primary and foreign keys so the data can be queried effectively.
2. Exploratory Data Analysis & Reporting
a. Review the provided data sets to explore ER wait times, summarize the data and correlate it to the provided data sets. I.e. are wait times lower when more staff is assigned? Hint: do not stop there.
b. Your exploratory analysis must use one query that aggregates and at least one chart.
c. Use the queries from your exploratory analysis to create Access Report objects summarizing what you have discovered.
3. Interactivity
a. Create an Access Form that has an interactive component (drop down box, radio button, etc.)
b. When interacted with your form should requery and display the requested information, taking into account the users direct input?
4. Presentation
a. Create a PowerPoint presentation, it should include data from the reports you created as well as recommendations for how best to address the length of wait times in the ER.
b. Recommendations will be evaluated based on how feasible they are. You must consider patient safety, quality of care, cost of implementation and other limitations. No solution is perfect or free, but your recommendations should reflect consideration of these factors.
c. You should have more than one recommendation, but be sure to support your recommendations with data and detail. A single sentence is not a recommendation.
Data link- https://www.dropbox.com/s/1apq8g2nmlhldba/Project%20Data.xlsx?dl=0
|
Statutorily protected employee organizations under the act
: What are statutorily protected employee organizations under the Act? What standards does the NLRB apply to determine weather a group is an employee organizations for purposes of the act?
|
|
What is the marginal tax rate
: What is the marginal tax rate for 2014 for $65,000 of taxable income for a single person?
|
|
How should the terminal value or going concern be estimated
: What is the total value of AirThread before considering any synergies? What is the value of AirThread, assuming Ms. Zhang's estimates for synergies are accurate?
|
|
Cyber warfare gains in sophistication
: Stuxnet and more recent types of malicious software, or malware- particularly Duqu, Flame, and Gauss-herald a frightening new era in cyberwarfare. China, Russia, the United States, and other nations have been engaging in cyberw arfare for several ..
|
|
Use database normalization techniques to split the flat file
: Import and Structure Data - Use the provided data sets to import tables into a blank access database and Use database normalization techniques to split the flat file databases into a relational database
|
|
Who is harmed by the library project
: Who is harmed by the Library Project? Make a list of harmed groups, and for each group, try to devise a solution that would eliminate or lessen the harm. Why is Google pursuing the Library Project? What is in it for Google? Make a list of benefits to..
|
|
Question regarding the marketing operations
: How are the four major functions of management (planning,organising, leading and controlling) are related to the marketing operations, finance and human resource management departments?
|
|
Cases in collective bargaining and industrial relations
: What are statutorily protected employee organizations under the Act? what standards does the NLRB apply to detemine weather a group is an employee organizations for purposes of the act? What are the standards of the NLRB apploes to determine if emplo..
|
|
Change without altering that persons values
: Are accurate perceptions always necessary to develop sound decisions? Is it appropriate to change the emotions of people in the organization? If so, what situations will be appropriate? And how can a person’s emotions be change without altering that ..
|