USA: +1(669)289-8683 
Sign in
check attached file
Identify a specific health or health care delivery information management issue, other than patient electronic health record. This databse should be summarized in a few sentences.
Name: __________________________
CLP 6527
Week 06 Homework
Distributed: 10/11/2022 Due back in Canvas at 11:59 am ET 10/17/2022
Rubric posted at the end of this document
St. Charles, Ventnor and Reading (2022) examined 267 adults who responded -yes- to a survey item that indicated that they had difficulty swallowing. After a detailed workup, some were classified as being in a -Dysphagia- group, and the remainder were classified as being in a -NoDysphagia- group. All participants were asked about how much social The remaining patients were classified as having -NoDysphagia-. All participants were asked how much social interaction they had. support they experienced surrounding meals and eating. Thus, the two variables in Class06_homework_2022.csv are
(1) Dysphagia Group (Varname = DysphGroup, value -Dysphagia- = yes; value -NoDysphagia- = no
(2) Social support (higher scores indicate more social support)
1. The first question deals with the proportion of true dysphagia adults in the sample.
a. Obtain the frequency count for those who were classified as dysphagic and those who were not.
b. In this population, we would expect 5% of adults to meet sufficient criteria to be dysphagic (.05 is your null hypothesis value). Evaluate the 95% confidence interval of the proportion of dysphagics in your sample, using this null hypothesis value. Summarize what this means, in words. We would expect 5% of adults in this population to meet the criteria for dysphagia (.05 is your null hypothesis value). Using this null hypothesis value, calculate the 95% confidence interval for the proportion of dysphagics in your sample. Explain in words what this means.
2. The second question deals with the distribution of the social support variable.
a. Compute the 95% confidence interval of the mean of social support, based on our sample. Again, summarize what this means.
b. Plot a one-group jittered dot plot for social support, showing the distribution of social support. On this graph, superimpose mean social support and the 95% confidence interval of social support (as an error bar).
- United Nations Children’s Fund (UNICEF). Centers for Disease Control and Prevention (CDC). Assessment Brief Assignment Help National Center for Transgender Equality.
- Advocacy & Services for LGBT Elders. Equal Justice Initiative. Urban Triage.
- World Health Organization. Alliance for Retired Americans.
3. The third question plots and compares social support separately for the two dysphagia groups
a. Plot a two-group jittered dot plot for social support, comparing the distribution of social support in dysphagic and non-dysphagic adults. Again, superimpose the 95% confidence interval of social support in each group as an error bar.
b. Based on your inspection of the means and confidence intervals in each group, what conclusions might you draw as to a test of the null hypothesis that -dysphagic and non dysphagic adults do not differ in social support surrounding meal and eating Adults who are dysphagic and those who are not are not different in terms of social support for meals and eating. -? Protip: If you want to see the means/etc. separately for each group, you can use the describeBy function from the psych package
30-536
Healthcare Informatics
Week 3 Online Assignment
Create a Database Assignment
Each group will work together to:
Identify a specific health or health care delivery information management issue, other than patient electronic health record. This should be summarized in a few sentences.
A database is defined as a “file structure that supports the storage of data in an organized fashion and allows data retrieval as meaningful information “
Review database design at these URLs:
http://geekgirls.com/2011/09/databases-from-scratch-i-introduction/
http://geekgirls.com/2011/09/databases-from-scratch-ii-simple-database-design/
Identify the following elements that are needed to create a database to address this information management issue.
Field Name
: Components needed to address the information management issue; must be unique identifiers
Source of Data
: May be previously entered into another system (name the system) or may need to be entered here for the first time (new entry)
Complete the table below. You will need to add additional rows. See the example in the attached file.
Field Name
Source of Data
30-536 Healthcare Informatics
Week 3 Online Assignment
One group member posts the group’s final work to the class discussion board, Databases..
30-536 Healthcare Informatics
Week 3 Online Assignment
Create a Database Assignment
Each group will work together to:
Identify a specific health or health care delivery information management issue, other than patient electronic health record. This should be summarized in a few sentences.
A database is defined as a “file structure that supports the storage of data in an organized fashion and allows data retrieval as meaningful information “
Review database design at these URLs:
http://geekgirls.com/2011/09/databases-from-scratch-i-introduction/
http://geekgirls.com/2011/09/databases-from-scratch-ii-simple-database-design/
Identify the following elements that are needed to create a database to address this information management issue.
Field Name
: Components needed to address the information management issue; must be unique identifiers
Source of Data
: May be previously entered into another system (name the system) or may need to be entered here for the first time (new entry)
Complete the table below. You will need to add additional rows. See the example in the attached file.
| Field Name | Source of Data |
|
|
One group member posts the group’s final work to the class discussion board, Databases..
30-536 Healthcare Informatics
Week 3 Create a Database Assignment
Sample: Create a Database Assignment
Illinois has just passed a mandatory continuing education requirement for registered nurses. As the head of the nursing education department, I am interested in establishing a database for nurses employed at our institution related to their participation in continuing education.
We offer numerous programs in the traditional classroom mode at the University. We also have recently started to offer courses via our University Intranet. Nurses also take courses outside the University.
|
Field Name |
Source of Data |
||||
|
Employee ID |
Human Resources |
||||
|
First Name |
|||||
|
Middle Initial |
|||||
|
Last Name |
|||||
|
Date of Hire |
|||||
|
Nursing License Number |
Nursing Office |
||||
|
Department (s) Employed |
|||||
|
Certification Number University Classroom |
Nursing Education |
||||
|
Certification Date University Classroom |
|||||
|
CEU’s University Classroom |
|||||
|
Certification Number
University Intranet |
Automatic from Intranet |
||||
|
Certification Date
University Intranet |
|||||
|
CEU’s University Intranet |
|||||
|
Certification Source Other |
New entry |
||||
|
Certification Number Other |
New entry |
||||
|
Certification Date
Other |
|||||
|
CEU’s
Other |
Note: In the future, it might be possible to merge the University Classroom, University Intranet, and Other into one field each for the field names of certification numbers, dates, and CEU’s .
For classroom sessions, nurses would register on-line and receive their certificates on-line. This data would automatically be entered into the data base. Then the nursing education department would only have to manually enter the outside programs. If this was the case, and the department was interested in whether or not the program was classroom, Intranet, or other, a new field could be created.
30-536 Healthcare Informatics
Week 3 Create a Database Assignment
Sample: Create a Database Assignment
Illinois has just passed a mandatory continuing education requirement for registered nurses. As the head of the nursing education department, I am interested in establishing a database for nurses employed at our institution related to their participation in continuing education.
We offer numerous programs in the traditional classroom mode at the University. We also have recently started to offer courses via our University Intranet. Nurses also take courses outside the University.
|
Field Name |
Source of Data |
||||
|
Employee ID |
Human Resources |
||||
|
First Name |
|||||
|
Middle Initial |
|||||
|
Last Name |
|||||
|
Date of Hire |
|||||
|
Nursing License Number |
Nursing Office |
||||
|
Department (s) Employed |
|||||
|
Certification Number University Classroom |
Nursing Education |
||||
|
Certification Date University Classroom |
|||||
|
CEU’s University Classroom |
|||||
|
Certification Number
University Intranet |
Automatic from Intranet |
||||
|
Certification Date
University Intranet |
|||||
|
CEU’s University Intranet |
|||||
|
Certification Source Other |
New entry |
||||
|
Certification Number Other |
New entry |
||||
|
Certification Date
Other |
|||||
|
CEU’s
Other |
Note: In the future, it might be possible to merge the University Classroom, University Intranet, and Other into one field each for the field names of certification numbers, dates, and CEU’s .
For classroom sessions, nurses would register on-line and receive their certificates on-line. This data would automatically be entered into the data base. Then the nursing education department would only have to manually enter the outside programs. If this was the case, and the department was interested in whether or not the program was classroom, Intranet, or other, a new field could be created.
30-536 Healthcare Informatics
Week 3 Create a Database Assignment
Sample: Create a Database Assignment
Illinois has just passed a mandatory continuing education requirement for registered nurses. As the head of the nursing education department, I am interested in establishing a database for nurses employed at our institution related to their participation in continuing education.
We offer numerous programs in the traditional classroom mode at the University. We also have recently started to offer courses via our University Intranet. Nurses also take courses outside the University.
|
Field Name |
Source of Data |
||||
|
Employee ID |
Human Resources |
||||
|
First Name |
|||||
|
Middle Initial |
|||||
|
Last Name |
|||||
|
Date of Hire |
|||||
|
Nursing License Number |
Nursing Office |
||||
|
Department (s) Employed |
|||||
|
Certification Number University Classroom |
Nursing Education |
||||
|
Certification Date University Classroom |
|||||
|
CEU’s University Classroom |
|||||
|
Certification Number
University Intranet |
Automatic from Intranet |
||||
|
Certification Date
University Intranet |
|||||
|
CEU’s University Intranet |
|||||
|
Certification Source Other |
New entry |
||||
|
Certification Number Other |
New entry |
||||
|
Certification Date
Other |
|||||
|
CEU’s
Other |
Note: In the future, it might be possible to merge the University Classroom, University Intranet, and Other into one field each for the field names of certification numbers, dates, and CEU’s .
For classroom sessions, nurses would register on-line and receive their certificates on-line. This data would automatically be entered into the data base. Then the nursing education department would only have to manually enter the outside programs. If this was the case, and the department was interested in whether or not the program was classroom, Intranet, or other, a new field could be created.
