Syllabus

Schedule

Course Schedule at a glance

Course Schedule at a Glance

Learning Modules	Topics	Assignments and Due Dates
Week 1 1/8-1/15	Health Informatics – An Introduction to Relational Databases	Hands-on Database Assignments – Wednesday
Week 2 1/15-1/22	Using Queries to Extract Data and Database Creation	Discussion – Initial post by Sunday, responses by Wednesday Hands-on Database Assignments – Wednesday
Week 3 1/22-1/29	Database Development and Presentation	Discussion – Initial post by Sunday, responses by Wednesday Diabetes Project Part 1 – Wednesday
Week 4 1/29-2/5	More SQL Skills	Discussion – Initial post by Sunday, responses by Wednesday Hands-on Database Assignments – Wednesday
Week 5 2/5-2/12	Creating Views	Discussion – Initial post by Sunday, responses by Wednesday Hands-on Database Assignments – Wednesday  Diabetes Project Part 2 – Wednesday
Week 6 2/12-2/19	An introduction to database administration activities	Discussion – Initial post by Sunday, responses by Wednesday Hands-on Database Assignments – Wednesday
Week 7 2/19-2/26	Finishing touches and final database presentation	Diabetes Project Part 3 – Wednesday
Week 8 2/26-3/1	Final Reflection	Assignment, Week 8 – Sunday

Detailed Course Schedule

Week 1: Health Informatics — An Introduction to Relational Databases

Overview:

During this week, we will install MySQL, MySQL Workbench, and the necessary files (SQL Scripts) to complete this course.  In addition to installing the necessary applications and files, we will learn concepts and terms related to SQL and relational databases. We will also learn how to design a database by following the six basic steps of designing a data structure.

Reading:

• Murach, J. (2015). Murach’s MySQL Training and Reference (2nd ed.). Fresno, CA: Mike Murach & Associates, Inc.
  • Chapter 1 – An introduction to Relational Databases and SQL p.4-16, 22-32
  • Chapter 2 – How to use MySQL Workbench and other development tools
  • Chapter 3 – How to retrieve data from a single table
  • Chapter 10 – How to design a database

Video:

• Relational Database Concepts
  • Transcript for Relational Database Concepts

Learning Outcomes:

• Describe the way a relational database is organized
• Start and stop the database
• Use MySQL Workbench to enter simple SQL commands
• Use MySQL Workbench to create an EER model for a database

MySQL Installation Assignment: 

Follow the instructions in the MySQL Installation Guide to install MySQL (database server) and MySQL Workbench (MySQL Graphical Interface).  Once the MySQL and MySQL Workbench installation is complete, open MySQL Workbench to install the necessary database files needed for this course.

Installing database files:

Download the student files

Once the file has been downloaded, navigate to page 563, step 4, and follow the remaining steps in this section to complete the installation of the database files.

If Mac OS is being used for this course, navigate to page 573, step 4, and follow the remaining steps in this section to complete the installation.

MySQL Password Reset on a Mac instructions

Submit screenshots of MySQL Workbench to BlackBoard to show the installation has been completed (A list of databases that have been installed will show up in the bottom left-hand corner of the ‘Management’ pane in MySQL Workbench).

Hands-on Database Assignments

Complete the exercises below, following the instructions in the textbook. Be sure to save each SQL script by using the ‘Save Script As’ menu option:

• • Chapter 1 exercises
  • Chapter 2 exercises
  • Chapter 3 exercises
  • Chapter 10 exercises

Once the exercises are completed, upload the saved SQL scripts to Blackboard. Refer to Weekly Hands-on Database Assignment Rubric for submission standards.

Week 2: Using Queries to Extract Data and Database Creation

Overview:

During this week, we will learn how to use the SELECT statement to retrieve data, learn how to use the INSERT, UPDATE, and DELETE statements to add, update, and delete rows from a database. We will also learn how to create databases, tables and indexes within the database.

Reading:

• Murach, J. (2015). Murach’s MySQL Training and Reference (2nd ed.). Fresno, CA: Mike Murach & Associates, Inc.
  • Chapter 4 – How to retrieve data from 2 or more tables
  • Chapter 5 – How to insert, update and delete data
  • Chapter 11 – How to create databases, tables and indexes

Learning Outcomes:

• Select data from more than one table
• Use the Select, Insert, Update, Delete commands
• Create databases, tables and indexes

Week 2 Discussion: 

Now that you’ve learned how to create databases and tables, and learned how to select and manipulate data, you can think about describing your life in the form of SQL statements.  Using proper SQL format, write a SQL statement to describe an accomplishment, a feeling, or an event that you do not mind sharing with your peers.

Hands-on Database Assignments:

Follow the instructions (Be sure to save each SQL script by using the ‘Save Script As’ menu option):

• • Chapter 4 exercises
  • Chapter 5 exercises
  • Chapter 11 exercises

Once the exercises are completed, upload the saved SQL scripts to Blackboard. Refer to Weekly Hands-on Database Assignment Rubric for submission standards.

Week 3: Database Development and Presentation

Overview:

This week you will start your final project for this class, building a diabetes registry. You will have to review materials from the previous weeks, as well as do some investigation on your own.

Reading:

• Review materials from previous weeks and use the MySQL Reference Manual to assist with completing your assignments.

Learning Outcomes:

• Design and develop a database with a minimum of three tables that are connected through a unique identifier

Week 3 Discussion:

• This week you will begin creating a database that you will add to in weeks 5 and 7. As you work through creating your database this week, use this space to seek advice from classmates or to offer help to others. By mid-week please post a short statement about how it is going for you. Are you encountering any problems? If so, what are they or what were they (if you have solved them)? If you aren’t encountering problems, what advice can you offer? Or can you comment on something interesting that you discovered as you worked on your database?

Assignment, Week 3: Diabetes Project Part 1

In the culminating assignment for this course, you will create a database to address an authentic problem in health informatics. This project will be completed in three parts and will enable you to demonstrate your database and structured query language skills.

You have just been promoted to the position of HIT coordinator. In your new role, you have been asked to develop a diabetic registry using a database. The purpose of the diabetic registry is to provide a snapshot of the patients’ progress to providers an easy to read format. It will allow providers to determine if further intervention is needed for their patients. First, research diabetic registries to determine what data to capture and how to effectively monitor diabetic patients. After researching diabetic registries, develop and create a database with a minimum of three tables using a unique identifier as a link. For example, create a table for demographics, a table for glycemic control, a table for coronary risk factors, and a table for microvascular end-organ disease.

Once the database has been created, populate the tables with at least twenty (20) patients using various results for their labs. After data has been entered, use Screencast-O-Matic (or another screencasting tool) to present the database you created. During the presentation, describe how the tables are linked, what type of fields used in each table, e.g., date/time, numeric, text. Upload the screencast to YouTube, and submit the link in BlackBoard.

Week 4: More SQL Skills

Overview:

During this week, we will continue to develop our SQL skills by learning how to summarize data contained in a database.  We will learn how to use summary queries, learn how to code subqueries, learn how to work with data types, and how to use functions to extract data to use for decision making.

Reading:

• Murach, J. (2015). Murach’s MySQL Training and Reference (2nd ed.). Fresno, CA: Mike Murach & Associates, Inc.
  • Chapter 6 – How to code summary data
  • Chapter 7 – How to code subqueries
  • Chapter 8 – How to work with datatypes
  • Chapter 9 – How to use functions

Learning Outcomes:

• Code summary queries that use aggregate functions, including queries that use the WITH ROLLUP operator
• Code SELECT statements that require subqueries
• Code queries that convert data from one data type to another
• Code queries that format numeric or date/time data

Week 4 Discussion:

You have learned what relational databases are, and looked at how these databases can be used to collect and organize data in a central location through multiple tables and unique IDs. Now think about an instance when you wished you had all the information needed to complete a project in one location. Describe how you could organize this database. How many tables would it take to organize the information, and why? Would queries be used? If so, how and why?

Hands-on Database Assignments:

Follow the instructions (Be sure to save each SQL script by using the ‘Save Script As’ menu option):

• • Chapter 6 exercises
  • Chapter 7 exercises
  • Chapter 8 exercises
  • Chapter 9 exercises

Once the exercises are completed, upload the saved SQL scripts to Blackboard.

Week 5: Creating Views

Overview:

A view is a subset of the data constructed from a query. The view can be a read-only view such as the list of patients for operating room A, or the data can be updated, think of your online shopping cart.

Reading:

• Murach, J. (2015). Murach’s MySQL Training and Reference (2nd ed.). Fresno, CA: Mike Murach & Associates, Inc.
  • Chapter 12 – How to create views

Learning Outcomes:

• Create one or more views

Hands-on Database Assignments

Be sure to save each SQL script by using the ‘Save Script As’ menu option:

• • Chapter 12 exercises

Once the exercises are completed, upload the saved SQL scripts to Blackboard.

Week 5 Discussion:

EHR data can be used to construct bills, track disease progression, measure provider performance, among a host of other activities.   Data for these activities are accessed through a view. For the substantive post, please provide an example of your own, list the variables required to create the view required of the activity, who has access to the data, and whether the data should be read-only or whether it can be updated.

In the discussion response, provide a constructive critique. Include comments regarding whether all the variables been identified? Which variables are missing? Which variables are superfluous? What role (provider, nurse, financial, quality) would use the view and is the data normally associated with that role?

Assignment: Diabetes Project 2

Using the database you developed in part 1, create a view in your database project to compare A1Cs between male and female patients. Next, create another view to display patients with an A1C of 6.5 or higher.

Use Screencast-O-Matic (or another screencasting tool) to demonstrate the views that were created. Upload the screencast to YouTube and submit the link to the screencast along with the saved SQL statements used to create the views.

Week 6: An introduction to database administration activities

Overview:

This week we will learn about the “care and feeding” of a database. You will learn about adding users, permissions, and how to backup and restore a database

Reading:

• Murach, J. (2015). Murach’s MySQL Training and Reference (2nd ed.). Fresno, CA: Mike Murach & Associates, Inc.
  • Chapter 17 – Intro to Database Administration (DBA)
  • Chapter 18 – Secure Database Administration (DBA)
  • Chapter 19 – Back/Restore Database
• Security Guidelines
• Backup and Recovery Strategy

Learning Outcomes:

• Use MySQL Workbench to kill processes and view status variables and system variables
• View and manage log files
• Create both admin and end users, and grant privileges to a user
• Backup a database so that it can be restored to any point in time
• Restore a database to any point in time

Week 6 Discussion:

User management is a requirement to ensure appropriate access is given to any system by managing what end users are able to access and modify. Without thinking about user management for an electronic system such as a database application, think about how users were managed before the use of electronic systems. How did your place of employment (or a place you are familiar with) ensure information was accessible only by authorized personnel? If your place of employment is not currently using an electronic storage system, how are records stored, and how is access controlled?

Hands-on Database Assignments:

Be sure to save each SQL script by using the ‘Save Script As’ menu option:

• • Chapter 17 exercises
  • Chapter 18 exercises
  • Chapter 19 exercises

Once the exercises are completed, upload the saved SQL scripts to Blackboard.

Week 7: Finishing touches and final database presentation

Overview:

This week you will secure your database by adding users, and creating a backup of your project.

Reading:

Review materials from previous weeks and refer to the MySQL Reference Manual to assist with completing your assignments.

Learning Outcomes:

• Modify database to add different types of users

Assignment: Diabetes Project Part 3

For the final part of your Diabetes Project, you will modify your database to add different types of users and create a screencast to present your diabetic registry database to a Health Board. Use the database you developed and create at least four (4) users with different access levels to the database. Of course, one of the users will be the root, or administrator, then create a user that can perform database backups, a user who can enter and modify data (but not delete data), and a user who can only access the views that were created last week.

Once the finishing touches have been completed, use Screencast-O-Matic (or another screencasting tool) to create a presentation to propose your database to a health board. Upload the presentation to YouTube and submit the link to the presentation along with a copy of the database backup.

Week 8: Final Reflection

Overview:

This is the last week of class, and it is a short week, ending on Sunday.

Week 8 Discussion:

Consider your challenges and victories in this term. If you struggled with a concept, please describe your experience and how you were able to move forward.

Which concepts did you find most interesting? How can you see applying what you’ve learned in this course to your professional life?

Peer response is not necessary this week.

Assignment:

Using the knowledge and skills you have obtained throughout this course, write a 3-5 page APA formatted paper discussing the importance of databases in healthcare, the importance of entering quality data, and the importance of assigning appropriate privileges in databases and the applications used to access databases.

Student Resources

Online Student Support

Your Student Support Specialist is a resource for you. Please don't hesitate to contact them for assistance, including, but not limited to course planning, current problems or issues in a course, technology concerns, or personal emergencies.

Questions? Visit the Student Support Health Informatics page

APA Style Guide

• https://www.apastyle.org

UNE Libraries:

• Library Access for all students: Your library login ID and password are the same as the ones you use to log into Blackboard/Brightspace.
• MSIN Databases: https://library.une.edu/library-materials/find/research-by-subject/health-informatics/
• Library Tutorial: Find an article
• Library Questions: Ask a librarian or phone library staff at (207) 602-2361 or (207) 221-4330.

UNE Student Academic Success Center

The Student Academic Success Center (SASC) offers a range of services to support your academic achievement, including tutoring, writing support, test prep and studying strategies, learning style consultations, and many online resources. To make an appointment for tutoring, writing support, or a learning specialist consultation, go to une.tutortrac.com. To access our online resources, including links, guides, and video tutorials, please visit:

• UNE Student Academic Success Center

Accommodations

Any student who would like to request, or ask any questions regarding, academic adjustments or accommodations must contact the Student Access Center at (207) 221-4438 or pcstudentaccess@une.edu. Student Access Center staff will evaluate the student's documentation and determine eligibility of accommodation(s) through the Student Access Center registration procedure.

Policies

Technology Requirements

Please review the technical requirements for UNE Online Graduate Programs: Technical Requirements

Turnitin Originality Check and Plagiarism Detection Tool

The College of Professional Studies uses Turnitin to help deter plagiarism and to foster the proper attribution of sources. Turnitin provides comparative reports for submitted assignments that reflect similarities in other written works. This can include, but is not limited to, previously submitted assignments, internet articles, research journals, and academic databases.

Make sure to cite your sources appropriately as well as use your own words in synthesizing information from published literature. Webinars and workshops, included early in your coursework, will help guide best practices in APA citation and academic writing.

You can learn more about Turnitin in the Turnitin Student quick start guide.

Information Technology Services (ITS)

ITS Contact: Toll Free Help Desk 24 hours/7 days per week at 1-877-518-4673

Course Evaluation Policy

Course surveys are one of the most important tools that University of New England uses for evaluating the quality of your education, and for providing meaningful feedback to instructors on their teaching. In order to assure that the feedback is both comprehensive and precise, we need to receive it from each student for each course. Evaluation access is distributed via UNE email at the beginning of the last week of the course.

Attendance Policy

Online students are required to submit a graded assignment/discussion prior to Sunday evening at 11:59 pm ET of the first week of the term. If a student does not submit a posting to the graded assignment/discussion prior to Sunday evening at 11:59 pm ET, the student will be automatically dropped from the course for non-participation. Review the full attendance policy.

Late Policy

Assignments: Late assignments will be accepted up to 3 days late; however, there is a 10% grade reduction (from the total points) for the late submission. After three days the assignment will not be accepted.

Discussion posts: If the initial post is submitted late, but still within the discussion board week, there will be a 10% grade reduction from the total discussion grade (e.g., a 3 point discussion will be reduced by 0.3 points). Any posts submitted after the end of the Discussion Board week will not be graded.

Please make every effort ahead of time to contact your instructor and your student support specialist if you are not able to meet an assignment deadline. Arrangements for extenuating circumstances may be considered by faculty.

Student Handbook Online - Policies and Procedures

The policies contained within this document apply to all students in the College of Graduate and Professional Studies. It is each student's responsibility to know the contents of this handbook.

UNE Online Student Handbook

UNE Course Withdrawal

Please contact your student support specialist if you are considering dropping or withdrawing from a course. The last day to drop for 100% tuition refund is the 2nd day of the course. Financial Aid charges may still apply. Students using Financial Aid should contact the Financial Aid Office prior to withdrawing from a course.

Academic Integrity

The University of New England values academic integrity in all aspects of the educational experience. Academic dishonesty in any form undermines this standard and devalues the original contributions of others. It is the responsibility of all members of the University community to actively uphold the integrity of the academy; failure to act, for any reason, is not acceptable. For information about plagiarism and academic misconduct, please visit UNE Plagiarism Policies.

Academic dishonesty includes, but is not limited to the following:

1. Cheating, copying, or the offering or receiving of unauthorized assistance or information.
2. Fabrication or falsification of data, results, or sources for papers or reports.
3. Action which destroys or alters the work of another student.
4. Multiple submissions of the same paper or report for assignments in more than one course without permission of each instructor.
5. Plagiarism, the appropriation of records, research, materials, ideas, or the language of other persons or writers and the submission of them as one's own.

Charges of academic dishonesty will be reviewed by the Program Director. Penalties for students found responsible for violations may depend upon the seriousness and circumstances of the violation, the degree of premeditation involved, and/or the student’s previous record of violations.  Appeal of a decision may be made to the Dean whose decision will be final.  Student appeals will take place through the grievance process outlined in the student handbook.