GCU HIM650 Full Course Latest 2020 May

HIM650 Health Care Data Management

Week 1 Discussion

DQ1 Consider the following scenario: You are in a hospital setting that uses an enterprise EHR system with multiple interfaces to other health information platforms. What types of data would be kept in each system and what steps would be needed to allow for analytics to be performed across multiple disparate platforms?

DQ2 Compare traditional paper health records to electronic records. What can one do that the other cannot? Some of the formats of electronic data include spreadsheets and databases. What are some of the trade-offs between using a spreadsheet versus a database to record, analyze, and retrieve data in a health care setting?

 

HIM650 Health Care Data Management

Week 2 Discussion

DQ1 What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly?

DQ2 How does understanding the logic of a database assist clinical resources? How does being involved with workflow development assist IT resources?

 

HIM650 Health Care Data Management

Week 3 Discussion

DQ1 Who would be the ideal candidate(s) to elicit information from during the requirements gathering and analysis phase? Explain why.

DQ2 Compare bottom-up to top-down modeling. What is the best approach to arrive at an effective data model?

 

HIM650 Health Care Data Management

Week 4 Discussion

DQ1 How important are naming conventions in database modeling? What comes first: the need for a report or the data?

DQ2 Recall the Y2K bug or the quote "640K [of memory] ought to be enough for anybody" misattributed to Bill Gates. What lessons can one learn from these examples when it comes to database creation?

 

 

 

 

HIM650 Health Care Data Management

Week 5 Discussion

DQ1 Can you think of ways to validate the information from SQL queries or reports, to assure a level of accuracy in the results? When, if at all, is it better to extract raw data instead of summary information and what are the best ways to present any retrieved information (e.g., tables, diagrams, narrative)?

DQ2 What is the primary reason and the need to aggregate data in health care? Explain your answer with examples.

 

HIM650 Health Care Data Management

Week 6 Discussion

DQ1 Utilizing the ideas from parts of your proposed Database Design Proposal and other associated assignments, consider the following scenario: An academic researcher wants to conduct a study on the distribution of various medications over the past 10 years.

1) What steps are required before the researcher can obtain any data?

2) What would be the applicable policy and regulations based on the module lecture notes and other knowledge of data security?

3) What will constitute your plan on how to provide the necessary data to the researcher—which pieces of information can and cannot be provided?

4) Explore and weigh options on providing restricted access to the database directly to the researcher (specify the necessary SQL statements to establish database accounts, configure privileges, and create restricted views of the data) versus exporting the required data.

Summarize your answers to these questions and post it into the Discussion Forum. Compare your ideas with those of your colleagues.

DQ2 Find two examples of data/security breaches that resulted in theft/loss/exposure of confidential data, preferably health care related data. Describe the incidents and explain what could have been done to prevent or mitigate them.

 

HIM650 Health Care Data Management

Week 7 Discussion

DQ1 What are the benefits and challenges associated with accessing health data through forms and reports?

DQ2 Consider the CMS core measures and the data used to support the reporting. Which do you believe are the easiest to collect and which do you think are the most difficult to collect?

 

 

HIM650 Health Care Data Management

Week 8 Discussion

DQ1 Consider the idealized cycle of health information in evidence-based medicine where database systems offer information sharing service for doctors, medical researchers, medical institutions, and patients. In this scenario, doctors and researchers can easily query and analyze medical information with much greater speed, security, and ease. What would facilitate achieving this ideal, and assess the benefits and challenges of these achievements. How soon do you realistically expect to see these to be implemented on a large scale?

DQ2 What is the greatest challenge with reports produced for health care providers, managers, directors, and executives?

 

HIM650 Health Care Data Management

Week 1 Assignment

Database Design Project: Proposal          

The Database Design Project consists of several assignments that are due in various topics throughout the course. For this project, students will design and develop a database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products and utilization. The proposal is the initial step of this assignment.

Create a 500-750-word proposal outlining the following:

1.            Statement of the project problem and definition of terms.

2.            Identify your users (personnel/credentials): Who are they? What are their competencies?

3.            Discuss the information data users need to compile for the proposed system and the types of reports the proposed system should be able to generate and why.

4.            Based on your response to #3, articulate the project goals and objectives for the database design and how they affect the data model.

5.            Identify the steps you will take to meet the goals and objectives.

6.            Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made?

7.            Conclude with the value of the project with emphasis on feasibility, necessity, usefulness, and the benefit of the expected results.

This is an ongoing project and the feedback from the instructor at every stage will help you in improving your final project. Be sure to consult with your instructor throughout the course and incorporate suggestions and recommendations in your project.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.

 

HIM650 Health Care Data Management

Week 2 Assignment

Database Schema           

Design a database schema for the proposed Database Design Proposal in Module 1.

Identify and list all relevant entities and their relationships:

1) Select no less than five entities.

2) Provide a diagram.

3) Map this to a database schema.

4) Provide a data dictionary for all entity attributes.

Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.

Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

This assignment will be utilized again in Topic 4 and 5. Prior to Topic 4, review any feedback provided to you by the instructor.

You are not required to submit this assignment to LopesWrite.

 

 

 

 

 

HIM650 Health Care Data Management

Week 3 Assignment

Risk Incidence Occurrence Solution        

 In reference to your Database Design Proposal from topic 1, consider a situation where you want to track, and ultimately identify performance variances (quality measures) or the occurrence of at-risk incidents (pharmaceutical) within the environment you selected.

Write a 500-750 word proposal for an incident solution from the perspective of the Health Information Manager. Include the following criteria in your proposal:

 Identify and select an incident in which you are interested.

1.            For your risk incidence solution, discuss the proposed solution and specification of the requirements.

2.            Describe the database design and/or modifications to existing databases

3.            Describe the required resources to develop data model, including hosting considerations.

4.            Explain the breakdown of responsibilities among staff to collect, analyze, and disseminate the information.

 Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.

 This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.

 

HIM650 Health Care Data Management

Week 4 Assignment

SQL Queries      

For this assignment you will create SQL queries use the following database schema:

1.            Patient—PatientID, Name, DOB

2.            Doctor—DoctorID, Name, MedLicenseNumber, Phone

3.            Medication—MedicationID, BrandName, GenericName

4.            Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationID

Specify the SQL queries to retrieve:

1.            A list of all doctors.

2.            The number of patients who were born before 01/01/1994.

3.            The patient information along with the ID of any prescribing doctor for each patient.

4.            The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.

5.            The most prescribed generic medication name.

APA style is not required, but solid academic writing is expected.

You are not required to submit this assignment to LopesWrite.

 

HIM650 Health Care Data Management

Week 4 Assignment

Database Schema-SQL Statements         

1) Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).

2) Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?

APA format is not required, but solid academic writing is expected.

This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

You are not required to submit this assignment to LopesWrite.

 

HIM650 Health Care Data Management

Week 6 Assignment

Health Data Reporting  

For this assignment, you will write 500-700-word paper discussing the legal duty to report health data to a state or federal public health agency. Choose two examples where a legal duty exists to report health data to a state or federal public health agency. These examples can be items recently reported in the news.

Include the following items in your paper:

1.            Summarize the examples you've chosen. Describe why these examples require mandatory reporting.

2.            Discuss how the information is gathered and submitted to the authorities.

3.            Propose ways of improving the status quo and provide reasons why this has not yet been accomplished.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.

 

HIM650 Health Care Data Management

Week 7 Assignment

Database Design Proposal: Product        

In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database.

The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.

The working prototype should include the following:

1.            Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design and how it would be used to support data warehousing, reporting and mining

2.            Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.