Knowledge Activity: Query – Local Mortality
Data (Informatics)
Prerequisites
1. It is highly recommended the following activities are completed prior to this activity:
• Query – Basic Orientation (Informatics)
• Query – Advanced Orientation (Informatics)
Student instructions
1. If you have questions about this activity, please contact your instructor for assistance.
2. You will use the EHR Go queries tool to complete this activity. Your instructor has
provided you with a link to the Query – Local Mortality Data (Informatics) activity. Click
on 2: Launch EHR to launch the queries tool and begin this activity.
3. You’ve been granted access to certain data in the EHR to complete this activity. The
approved data has already been linked to the queries tool in the EHR.
4. Document your answers directly on this activity document as you complete the activity.
When you are finished, you will save this activity document to your device and upload
this activity document with your answers to your Learning Management System (LMS).
The activity
A graduate student is completing a public health study assessing the local causes of death and
how they compare to national rates. You’ve been tasked with gathering the data she needs
from the regional healthcare system. In this activity, you’ll be running various queries on the
data to answer questions posed by the student.
Access the EHR queries tool and corresponding dataset under 2: Launch EHR. Click the New
Session button to launch the EHR. Follow the instructions to generate queries to answer the
questions in the next section.
On the Queries tab, select New to initiate a new query.
EHR Go Knowledge Activity: Query – Local Mortality Data (Informatics) IK1041.3 1
Archetype Innovations LLC ©2026
, Name the query ‘Local Mortality Analysis’.
First, you’ll be determining the local rates of death for the top 10 causes: Alzheimer’s disease,
cancer, chronic lower respiratory disease (CLRD), diabetes, diseases of the heart, influenza and
pneumonia, kidney disease, stroke, suicide, and unintentional injuries. There are 21,689 total
local recorded deaths in the database.
Run a query to determine the number of deaths for each cause. The query for Alzheimer’s
disease is shown below. Select Query to generate the total records. Then repeat for the
remaining 9 causes.
Query Rules: ‘Cause of Death’ equal ‘Alzheimer’s disease’
EHR Go Knowledge Activity: Query – Local Mortality Data (Informatics) IK1041.3 2
Archetype Innovations LLC ©202
Data (Informatics)
Prerequisites
1. It is highly recommended the following activities are completed prior to this activity:
• Query – Basic Orientation (Informatics)
• Query – Advanced Orientation (Informatics)
Student instructions
1. If you have questions about this activity, please contact your instructor for assistance.
2. You will use the EHR Go queries tool to complete this activity. Your instructor has
provided you with a link to the Query – Local Mortality Data (Informatics) activity. Click
on 2: Launch EHR to launch the queries tool and begin this activity.
3. You’ve been granted access to certain data in the EHR to complete this activity. The
approved data has already been linked to the queries tool in the EHR.
4. Document your answers directly on this activity document as you complete the activity.
When you are finished, you will save this activity document to your device and upload
this activity document with your answers to your Learning Management System (LMS).
The activity
A graduate student is completing a public health study assessing the local causes of death and
how they compare to national rates. You’ve been tasked with gathering the data she needs
from the regional healthcare system. In this activity, you’ll be running various queries on the
data to answer questions posed by the student.
Access the EHR queries tool and corresponding dataset under 2: Launch EHR. Click the New
Session button to launch the EHR. Follow the instructions to generate queries to answer the
questions in the next section.
On the Queries tab, select New to initiate a new query.
EHR Go Knowledge Activity: Query – Local Mortality Data (Informatics) IK1041.3 1
Archetype Innovations LLC ©2026
, Name the query ‘Local Mortality Analysis’.
First, you’ll be determining the local rates of death for the top 10 causes: Alzheimer’s disease,
cancer, chronic lower respiratory disease (CLRD), diabetes, diseases of the heart, influenza and
pneumonia, kidney disease, stroke, suicide, and unintentional injuries. There are 21,689 total
local recorded deaths in the database.
Run a query to determine the number of deaths for each cause. The query for Alzheimer’s
disease is shown below. Select Query to generate the total records. Then repeat for the
remaining 9 causes.
Query Rules: ‘Cause of Death’ equal ‘Alzheimer’s disease’
EHR Go Knowledge Activity: Query – Local Mortality Data (Informatics) IK1041.3 2
Archetype Innovations LLC ©202
