HIM650 Health Care Data Management
Week 1 Discussion
DQ1 Explain the differences between data, information, and a database. Describe the purpose of a database in health care and provide an example of one utilized locally, statewide, and nationally.
DQ2 The CMS Quality Measures Inventory is a compilation of measures used by CMS in various quality, reporting, and payment programs. The measures are evidence-based criteria that indicate timeliness and effectiveness of care for specific conditions. Consider the CMS core measures and the data used to support their 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 2 Discussion
DQ1 Who would be the ideal candidate(s) from whom to elicit information during the requirements gathering and analysis phase of the database project? Explain why.
DQ2 Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication.
Identify different entities from this scenario.
Create an entity-relationship diagram illustrating 1:1 and 1:many relationships.
Compare your ERD with another classmate's and discuss the differences each of you had.
HIM650 Health Care Data Management
Week 3 Discussion
DQ1 Utilize Figure 4.3, Figure 4.4, and Table 4.3, located in the textbook, for assistance in completing this discussion question.
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 Programming language (such as JAVA, C, Python, and SQL) is commonly used in electronic health records and databases. Relational databases use structured query language (SQL) programming. SQL statements can be divided into two categories: data manipulation language (DML) and data definition language (DDL). Compare and contrast data manipulation and definition language and provide an example and statement from each category.
HIM650 Health Care Data Management
Week 4 Discussion
DQ1 Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA's managerial role of enforcing these functions? Using SQL statements, provide some examples of how you would use the data dictionary to monitor the security of the database.
DQ2 Find two examples of data/security breaches that resulted in theft/loss/exposure of confidential data, preferably data related to health care. Describe the incidents and explain what could have been done to prevent or mitigate them.
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 Data analytics is applied to discover trends and patterns in health care data and predict future events based on the discoveries. Compare and contrast data analytics, specifically the use of explanatory or predictive analysis, that you might employ for analyzing health data.
HIM650 Health Care Data Management
Week 6 Discussion
DQ1 Using the topic Resources, answer the question: "What is R?" Discuss the role of R on software and the health care industry. What are the benefits and challenges of R as compared to other programming languages used in the health care industry?
DQ2 Using the topic Resources, consider R language definitions. Define the term data structures or objects in R and discuss several examples (e.g., vectors, lists, language objects, symbol objects, expression objects, function objects, NULL). All R objects have attributes. What is the purpose of attributes?
HIM650 Health Care Data Management
Week 7 Discussion
DQ1 Describe one or two differences between single vendor solutions and multiple vendor integrated solutions. What is the role and importance of multiplatform integration in health care IT systems? Describe how multiple integrated solutions evolve in a large health care organization and the challenges incurred for both the clinical and technical staff. When a new system or application is considered for implementation, what are some vital factors that must be considered within the framework of the existing architecture?
DQ2 Discuss challenges associated with maintaining multiple interfaces between health care systems and how the 21st Century Cures Act will affect data exchange. What are some examples of timing and data integrity challenges you may have experienced in your own career or you feel may be encountered when an organization operates multiple systems on different platforms?
HIM650 Health Care Data Management
Week 8 Discussion
DQ1 Discuss the difference between supervised and unsupervised machine learning. Provide examples of how machine learning is used in health care.
DQ2 Discuss the analytic techniques used to analyze supervised and unsupervised learning. Provide an example.
HIM650 Health Care Data Management
Week 1 Assignment
File Structures
Complete the "File Structures" assignment in MindTap for Database Systems: Design, Implementation, and Management. Examine the provided file structures and answer the associated problem questions.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master's degree level:
F2: Information Science and Technology: Shows How
F4: Health Information Science and Technology: Shows How
HIM650 Health Care Data Management
Week 2 Assignment
Database Project Proposal - Part 1
Assessment Description
The purpose of this assignment is to provide learners a basic understanding for identifying a database project proposal for collecting data and for designing and developing a small database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products and utilization.
There are three parts to the database project proposal. The initial step involves identifying an idea for a database and describing its purpose. The second part allows you to design the database components. The third part requires you to present the database proposal to stakeholders. Feedback from the instructor at every stage will help you make improvements in the database project.
To complete Part 1 of the Database Project Proposal assignment, create a 500-750-word proposal outlining the following elements:
State the project problem and definition of terms.
Identify database users (personnel/credentials): Who are they? What are their competencies and background?
Discuss the types of data that users will collect for the proposed database and describe at least three reports that will be generated for analysis. Explain their use and who will use the reports?
Describe the project goals and clear measurable objectives for the database. Identify the steps you will take to meet the goals and objectives.
Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made?
Discuss data communications protocols that could be used in your database project. Refer to the "Blockchain Personal Health Records: Systematic Review" article, provided in the topic Resources.
Conclude with the value of the project with emphasis on feasibility and the benefit of the expected results.
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. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master's degree level:
F1: Health: Shows How
F2: Information Science and Technology: Shows How
F4: Health Information Science and Technology: Shows How
HIM650 Health Care Data Management
Week 3 Assignment
Database Project Proposal - Part 2
Assessment Traits
Requires Lopeswrite
Assessment Description
The purpose of this assignment is to build upon your database project proposal by creating the database schema components. A schema is a logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other.
To complete Part 2 of the Database Project Proposal assignment, write a 750-1,000-word essay that contains the following information:
Restate your database project; describe its goal and objectives.
Describe the purpose of the database schema for your project.
Write out the process associated with your business rules relating to your database.
Create a data dictionary that contains no less than five entities. Select and design an entity-relationship diagram (Crow, Chen, UML); Note: There are a variety of ER modeling software programs on the market. Microsoft Visio, OmniGraffle, LucidChart, and MySQL are few of these programs that provide free trials to create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word, PowerPoint Shapes, or SmartArt.
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.
Discuss the project's limitations and possible extensions.
This is an ongoing project and feedback from the instructor at every stage will help you to improve your final project.
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. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level:
F1: Health: Does
F2: Information Science and Technology: Does
F4: Health Information Science and Technology: Does
HIM650 Health Care Data Management
Week 4 Assignment
Data Manipulation and Querying With SQL
Assessment Description
The purpose of this assignment is to give learners an opportunity to write and execute MySQL commands utilizing SQL Fiddle. SQL Fiddle is a cloud-based application that allows database designers to write syntax and share data with other professionals.
For this assignment, begin by reviewing the attached document, "Data Manipulation and Querying With SQL Resource," for assistance in completing this assignment.
Part 1
Log onto SQL Fiddle and execute the SQL commands listed, in the order provided, in the attached document, "Data Manipulation and Querying With SQL Assignment Instructions." Use the information found in the "Provider Table" that is located within the instructions document to build the database.
Part 2
Write a 500-750-word essay that includes the following:
The history of SQL language.
The purpose of SQL language.
A statement and screenshot of each executed command.
Discussion of deletion and marker columns (50-75 words).
General Requirements
The bulk of the essay should focus on the history and purpose of SQL language.
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. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level:
F2: Information Science and Technology: Does
HIM650 Health Care Data Management
Week 5 Assignment
Database Project Proposal - Part 3
Assessment Description
The purpose of this assignment is to provide learners a basic understanding for identifying a proposal for collecting data, designing and developing a small database, and presenting the proposal to stakeholders.
To complete Part 3 of the Database Project Proposal assignment, create a PowerPoint (10-15 slides) presentation video discussing your database proposal. Using Loom, record your presentation and submit the unrestricted Loom link on the first page of your PowerPoint presentation to the instructor.
Refer to the topic Resources for additional guidance on recording your presentation with Loom.
Part 1
Apply principles of the systems development life cycle (SDLC) in your proposal by including the SDLC phases listed below into your presentation. You may copy and paste elements from past assignments that apply to the SDLC.
Planning
Analysis (What are the requirements of the current system’s end user?)
Detailed Systems Design (Completes the design of the system’s processes, technical specifications, data dictionary, ERD diagram, training principles, and methodologies.)
Implementation (Database is actually created and is customized by the creation of tables and views, user authorizations, etc. During this implementation phase, the database enters into a cycle of coding, testing, and debugging until it is ready.)
Maintenance (During this phase, end users can begin to request change in it.)
Part 2
The presentation must also include the following elements of the proposal:
State the project problem and explain the role of the database in the organization.
Identify database users (personnel/credentials): Who are they? What are their competencies and background? What training might the database end users need to utilize the database?
Discuss the types of data that users will collect for the proposed database and the types of reports that will be generated for analysis, including an explanation of their use as well as an explanation of who will use the reports.
Describe the project goals and clear measurable objectives for the database.
Provide examples of database schema components: database dictionary and ERD diagram.
Demonstrate database functions by providing a screenshot of basic MySQL statements and their outcomes for at least four rows: Statements include: CREATE TABLE, ALTER TABLE, QUERY TABLE, ADD A NEW COLUMN, QUERY - COLUMN FUNCTIONS, ADD A NEW ROW, QUERY - AGGREGATION, MULTI-TABLE-QUERIES - JOINING, and QUERY - MULTI-TABLE.
Explain policies, procedures, and regulations (HIPAA) to assure security, privacy, and integrity of the database proposal.
Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made?
Conclude with the value of the project, emphasizing feasibility, cost (including future costs, security costs, and hosting costs), necessity, usefulness, and the benefit of the expected results. Make sure to include an explanation on how this database will save the organization time and money and improve patient care/treatment with the data it will store and query both now and in the future.
General Requirements
Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be 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.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level:
F2: Information Science and Technology: Does
F4: Health Information Science and Technology: Does
HIM650 Health Care Data Management
Week 6 Assignment
Introduction to R
Review the "Introduction to R Programming With DataCamp," video and the other topic Resources. Answer the following R programming questions related to the video and topic Resources (750 words minimum):
Discuss the advantages and disadvantages of R programming language in the health care industry.
Discuss applications of R for data analysis and visualization.
Discuss three R statements used for decision making. Include three corresponding example statements.
Describe two data visualization options in R programming language. Provide an example of a health care data application for each of the visualization options selected (e.g., histogram). Make sure to provide both the example and graph for each of your selected visualization examples.
What is the purpose of the Microsoft Visual Studio? List the commands used to create a new R project in Visual Studio. What is your impression of the ease of use for this tool?
Learners may gain additional practice in R by viewing the Microsoft Visual Studio website. There you will be able to practice using the Microsoft Visual Studio by using the interactive tool that allows you to create a new R project.
APA style is not required, but solid academic writing is expected.
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.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level:
F2: Information Science and Technology: Shows How
HIM650 Health Care Data Management
Week 8 Assignment
Machine Learning
Requires Lopeswrite
Assessment Description
The purpose of this assignment is to describe and evaluate machine learning processes and techniques used in health care. In a 750-1,000-word essay, address the following:
Describe the difference between labeled data sets and unlabeled data sets.
Describe the difference between supervised and unsupervised machine learning.
Select either supervised or unsupervised machine learning and discuss the types of analytic tools that are used to analyze data sets.
Discuss the types of analytic tools that are used to analyze data sets.
Discuss the rationale for selecting the analytic tool that was selected to analyze supervised vs. unsupervised machine learning.
Discuss the machine learning process?
Provide examples of the uses of machine learning in health care.
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. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level:
F2: Information Science and Technology: Shows How
F4: Health Information Science and Technology: Shows How
