Assignment Prompt & Instructions
INFO ATTACHED
– ## hit2100pass.docx
– ## HIT2100MOD1ASSNINFO2025.docx
– ## HIT2100MOD1Query-BasicOrientationINFO2025.docx
– HIT2100MOD1Query-AdvancedOrientationINFO2025.docx
**## hit2100pass.docx**
Has your last name changed or have you mispelled your name? Click
[here](https://web21.ehrgo.com/help/form) to request an update to the name on your account.
| | |
| — | — |
| **Email:** | KHemphill01@indianatech.net |
| **Username:** | KHemphill01 |
Password- 1$Torm87
**## HIT2100MOD1ASSNINFO2025.docx**
· HIT 2100 EOL 21
For this assignment, you will complete two activities in EHR Go. Specifically, this week's assignment will include:
· Query – Basic Orientation
· Query – Advanced Orientation
Please follow the instructions below, and reach out to your professor if you have any questions.
1. Click on the
[Query – Basic Orientation Links to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23488) and enter your EHR Go credentials to begin.
1.
_If you have not yet set up your EHR Go account, you will need to do so before you can begin. Please follow the instructions below._
2. Download the Query – Basic Orientation activity from the "Overview & Resources" tab of the assignment link.
3. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
4. Use the activity sheet to work through the assignment and formulate your answers
5. Submit your Progress report as an attachment to this assignment link
2. Click on the
[Query – Advanced OrientationLinks to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23482) and enter your EHR Go credentials to begin.
1. Download the Query – Advanced Orientation activity from the "Overview & Resources" tab of the assignment link.
2. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
3. Use the activity sheet to work through the assignment and formulate your answers
4. Submit your Progress report as an attachment to this assignment link
**## HIT2100MOD1Query-BasicOrientationINFO2025.docx**
## Skills Activity: Query – Basic Orientation (Associate)
### Prerequisites
It is highly recommended this activity be completed prior to any additional query activities.
### 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 – Basic Orientation (AS)** 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. You will generate queries in EHR Go as instructed below. When you complete this activity, you will download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS).
### Introduction
Electronic heath records (EHRs) are generating enormous amounts of healthcare data. Analyzing and bringing meaning to this data is a rapidly growing aspect of the Big Data field. Big Data aims to find patterns and trends, draw conclusions, and even predict outcomes from the aggregated data that’s obtained from the individual patient records. Every aspect of healthcare is impacted by Big Data – from facilities, financials, operations, treatment, education, populations, performance, quality, efficiency, and more – with the goal to improve patient care and to save lives.
One way to analyze the data is to use queries. Queries filter the data based on rules and logic in order to answer questions. An example of a question that could be answered through a query is, “how many Cesarean births happened in the current year at the Shoreline Clinic?”
In EHR Go, the querying tool enables sample data sets from the EHR to be analyzed similarly to what is done in a hospital, clinic, or healthcare system. It is based on Structured Query Language (SQL) to create the queries. This activity introduces you to the query tool and the concepts needed to answer questions around a birth outcome dataset. The following terms will be used throughout this activity and the additional EHR Go query activities.
**Query:** A combination of one of more rules used to filter a database, often in order to answer a question.
**Field:** A single unit of data that has been stored. It can be used as part of the filter criteria when developing a query as well as in determining how the data is displayed. For example, Date of Birth (DOB) is a commonly stored field associated with health records.
**Record:** A single entry in a database consisting of populated fields, similar to a single row in a spreadsheet. An electronic health record contains a compilation of fields for a patient.
**Rule:** Also known as a condition. A string consisting of a field, operator, and matching value. For example, “type of birth equals Cesarean”. Type of birth = field; operator = ‘equal’; and matching value = Cesarean.
**Logical operator:** AND or OR function used to join two or more rules. For example, “type of birth equals Cesarean AND birth year equals current year.” AND is the logical operator used to combine the two rules meaning both rules must be true for a record to be included in the results. The logical operator OR is used when only one of the rules needs to be true.
Note:
_Groups_ will be explored in the next activity,
_Query – Advanced Orientation_.
### The activity
Recently, the Shoreline Birth Center was called out in the local paper as having a high rate of Cesarean births. The report seems unfair to Shoreline’s management team, as they have been trying to decrease their Cesarean rates for the past five years. They would like to know, 1) if their efforts have helped, and 2) if their current rates Cesarean births are lower than the national average of 32.1%. You’ve been tasked with running queries to gather the data needed.
Access the EHR queries tool and corresponding dataset under
**2: Launch EHR.** Click the
**New Session** button to launch the EHR.
On the Queries tab, select
**New** to initiate a new query.
1. Name the query ‘
2. Then enter the following query rule:
3. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
4. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view. (Note the Total Record(s) amount has been removed from the image below.)
5. Select
**New** to begin another query.
6. Name the query ‘
7. Then enter the following query rule:
8. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
9. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
10. Select
**Query** then
**Close** to return to the summary view. Both queries should now be listed.
Next, you will generate the same queries for the current year to determine the current rate of Cesarean births.
12. Name the query ‘
**Total Births – Current year**’.
13. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
14. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
15. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view.
16. Select
**New** to begin another query.
17. Name the query ‘
**Cesarean births – Current year’**
18. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
19. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
20. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
21. Select
**Query** then
**Close** to return to the summary view. All 4 queries should now be listed.
22. The rate of Cesarean births from the current year could be determined by dividing the number of Cesarean births by the Total births for the current year.
23. Select
**Close Session** and submit your progress report as described in the next section. Note: you do not need to turn in the calculated Cesarean rates, only the progress report.
**Submit your work**
You will complete the query in EHR Go as instructed. Remember to save your work. When finished, click on the
**Close Session** button at the top right of the screen. Download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.
**Learning objectives**
1. Apply health informatics concepts to the management of health information (3)
2. Utilize technologies for health information management (3)
3. Manage data within a database system (5)
EHR Go Skills Activity: Query – Basic Orientation (Associate) HAS1033.2
Archetype Innovations LLC ©2024
2
**image3.png**
**image4.png**
**image5.png**
**image6.png**
**image7.png**
**image8.png**
**image9.png**
**image10.png**
**image11.png**
**image1.png**
**image2.png**
**image12.jpg**
**HIT2100MOD1Query-AdvancedOrientationINFO2025.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/hit2100mod1query-advancedorientationinfo2025-docx)
**HIT2100MOD1Query-AdvancedOrientationINFO2025.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/hit2100mod1query-advancedorientationinfo2025-docx)
**## hit2100pass.docx**
Has your last name changed or have you mispelled your name? Click
[here](https://web21.ehrgo.com/help/form) to request an update to the name on your account.
| | |
| — | — |
| **Email:** | KHemphill01@indianatech.net |
| **Username:** | KHemphill01 |
Password- 1$Torm87
**## HIT2100MOD1ASSNINFO2025.docx**
· HIT 2100 EOL 21
For this assignment, you will complete two activities in EHR Go. Specifically, this week's assignment will include:
· Query – Basic Orientation
· Query – Advanced Orientation
Please follow the instructions below, and reach out to your professor if you have any questions.
1. Click on the
[Query – Basic Orientation Links to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23488) and enter your EHR Go credentials to begin.
1.
_If you have not yet set up your EHR Go account, you will need to do so before you can begin. Please follow the instructions below._
2. Download the Query – Basic Orientation activity from the "Overview & Resources" tab of the assignment link.
3. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
4. Use the activity sheet to work through the assignment and formulate your answers
5. Submit your Progress report as an attachment to this assignment link
2. Click on the
[Query – Advanced OrientationLinks to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23482) and enter your EHR Go credentials to begin.
1. Download the Query – Advanced Orientation activity from the "Overview & Resources" tab of the assignment link.
2. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
3. Use the activity sheet to work through the assignment and formulate your answers
4. Submit your Progress report as an attachment to this assignment link
**## HIT2100MOD1Query-BasicOrientationINFO2025.docx**
## Skills Activity: Query – Basic Orientation (Associate)
### Prerequisites
It is highly recommended this activity be completed prior to any additional query activities.
### 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 – Basic Orientation (AS)** 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. You will generate queries in EHR Go as instructed below. When you complete this activity, you will download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS).
### Introduction
Electronic heath records (EHRs) are generating enormous amounts of healthcare data. Analyzing and bringing meaning to this data is a rapidly growing aspect of the Big Data field. Big Data aims to find patterns and trends, draw conclusions, and even predict outcomes from the aggregated data that’s obtained from the individual patient records. Every aspect of healthcare is impacted by Big Data – from facilities, financials, operations, treatment, education, populations, performance, quality, efficiency, and more – with the goal to improve patient care and to save lives.
One way to analyze the data is to use queries. Queries filter the data based on rules and logic in order to answer questions. An example of a question that could be answered through a query is, “how many Cesarean births happened in the current year at the Shoreline Clinic?”
In EHR Go, the querying tool enables sample data sets from the EHR to be analyzed similarly to what is done in a hospital, clinic, or healthcare system. It is based on Structured Query Language (SQL) to create the queries. This activity introduces you to the query tool and the concepts needed to answer questions around a birth outcome dataset. The following terms will be used throughout this activity and the additional EHR Go query activities.
**Query:** A combination of one of more rules used to filter a database, often in order to answer a question.
**Field:** A single unit of data that has been stored. It can be used as part of the filter criteria when developing a query as well as in determining how the data is displayed. For example, Date of Birth (DOB) is a commonly stored field associated with health records.
**Record:** A single entry in a database consisting of populated fields, similar to a single row in a spreadsheet. An electronic health record contains a compilation of fields for a patient.
**Rule:** Also known as a condition. A string consisting of a field, operator, and matching value. For example, “type of birth equals Cesarean”. Type of birth = field; operator = ‘equal’; and matching value = Cesarean.
**Logical operator:** AND or OR function used to join two or more rules. For example, “type of birth equals Cesarean AND birth year equals current year.” AND is the logical operator used to combine the two rules meaning both rules must be true for a record to be included in the results. The logical operator OR is used when only one of the rules needs to be true.
Note:
_Groups_ will be explored in the next activity,
_Query – Advanced Orientation_.
### The activity
Recently, the Shoreline Birth Center was called out in the local paper as having a high rate of Cesarean births. The report seems unfair to Shoreline’s management team, as they have been trying to decrease their Cesarean rates for the past five years. They would like to know, 1) if their efforts have helped, and 2) if their current rates Cesarean births are lower than the national average of 32.1%. You’ve been tasked with running queries to gather the data needed.
Access the EHR queries tool and corresponding dataset under
**2: Launch EHR.** Click the
**New Session** button to launch the EHR.
On the Queries tab, select
**New** to initiate a new query.
1. Name the query ‘
2. Then enter the following query rule:
3. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
4. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view. (Note the Total Record(s) amount has been removed from the image below.)
5. Select
**New** to begin another query.
6. Name the query ‘
7. Then enter the following query rule:
8. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
9. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
10. Select
**Query** then
**Close** to return to the summary view. Both queries should now be listed.
Next, you will generate the same queries for the current year to determine the current rate of Cesarean births.
12. Name the query ‘
**Total Births – Current year**’.
13. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
14. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
15. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view.
16. Select
**New** to begin another query.
17. Name the query ‘
**Cesarean births – Current year’**
18. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
19. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
20. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
21. Select
**Query** then
**Close** to return to the summary view. All 4 queries should now be listed.
22. The rate of Cesarean births from the current year could be determined by dividing the number of Cesarean births by the Total births for the current year.
23. Select
**Close Session** and submit your progress report as described in the next section. Note: you do not need to turn in the calculated Cesarean rates, only the progress report.
**Submit your work**
You will complete the query in EHR Go as instructed. Remember to save your work. When finished, click on the
**Close Session** button at the top right of the screen. Download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.
**Learning objectives**
1. Apply health informatics concepts to the management of health information (3)
2. Utilize technologies for health information management (3)
3. Manage data within a database system (5)
EHR Go Skills Activity: Query – Basic Orientation (Associate) HAS1033.2
Archetype Innovations LLC ©2024
2
**image3.png**
**image4.png**
**image5.png**
**image6.png**
**image7.png**
**image8.png**
**image9.png**
**image10.png**
**image11.png**
**image1.png**
**image2.png**
**image12.jpg**
**HIT2100MOD1Query-AdvancedOrientationINFO2025.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/hit2100mod1query-advancedorientationinfo2025-docx)
**## hit2100pass.docx**
Has your last name changed or have you mispelled your name? Click
[here](https://web21.ehrgo.com/help/form) to request an update to the name on your account.
| | |
| — | — |
| **Email:** | KHemphill01@indianatech.net |
| **Username:** | KHemphill01 |
Password- 1$Torm87
**## HIT2100MOD1ASSNINFO2025.docx**
· HIT 2100 EOL 21
For this assignment, you will complete two activities in EHR Go. Specifically, this week's assignment will include:
· Query – Basic Orientation
· Query – Advanced Orientation
Please follow the instructions below, and reach out to your professor if you have any questions.
1. Click on the
[Query – Basic Orientation Links to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23488) and enter your EHR Go credentials to begin.
1.
_If you have not yet set up your EHR Go account, you will need to do so before you can begin. Please follow the instructions below._
2. Download the Query – Basic Orientation activity from the "Overview & Resources" tab of the assignment link.
3. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
4. Use the activity sheet to work through the assignment and formulate your answers
5. Submit your Progress report as an attachment to this assignment link
2. Click on the
[Query – Advanced OrientationLinks to an external site.](https://web21.ehrgo.com/rd/?courseActivityId=23482) and enter your EHR Go credentials to begin.
1. Download the Query – Advanced Orientation activity from the "Overview & Resources" tab of the assignment link.
2. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.
3. Use the activity sheet to work through the assignment and formulate your answers
4. Submit your Progress report as an attachment to this assignment link
**## HIT2100MOD1Query-BasicOrientationINFO2025.docx**
## Skills Activity: Query – Basic Orientation (Associate)
### Prerequisites
It is highly recommended this activity be completed prior to any additional query activities.
### 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 – Basic Orientation (AS)** 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. You will generate queries in EHR Go as instructed below. When you complete this activity, you will download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS).
### Introduction
Electronic heath records (EHRs) are generating enormous amounts of healthcare data. Analyzing and bringing meaning to this data is a rapidly growing aspect of the Big Data field. Big Data aims to find patterns and trends, draw conclusions, and even predict outcomes from the aggregated data that’s obtained from the individual patient records. Every aspect of healthcare is impacted by Big Data – from facilities, financials, operations, treatment, education, populations, performance, quality, efficiency, and more – with the goal to improve patient care and to save lives.
One way to analyze the data is to use queries. Queries filter the data based on rules and logic in order to answer questions. An example of a question that could be answered through a query is, “how many Cesarean births happened in the current year at the Shoreline Clinic?”
In EHR Go, the querying tool enables sample data sets from the EHR to be analyzed similarly to what is done in a hospital, clinic, or healthcare system. It is based on Structured Query Language (SQL) to create the queries. This activity introduces you to the query tool and the concepts needed to answer questions around a birth outcome dataset. The following terms will be used throughout this activity and the additional EHR Go query activities.
**Query:** A combination of one of more rules used to filter a database, often in order to answer a question.
**Field:** A single unit of data that has been stored. It can be used as part of the filter criteria when developing a query as well as in determining how the data is displayed. For example, Date of Birth (DOB) is a commonly stored field associated with health records.
**Record:** A single entry in a database consisting of populated fields, similar to a single row in a spreadsheet. An electronic health record contains a compilation of fields for a patient.
**Rule:** Also known as a condition. A string consisting of a field, operator, and matching value. For example, “type of birth equals Cesarean”. Type of birth = field; operator = ‘equal’; and matching value = Cesarean.
**Logical operator:** AND or OR function used to join two or more rules. For example, “type of birth equals Cesarean AND birth year equals current year.” AND is the logical operator used to combine the two rules meaning both rules must be true for a record to be included in the results. The logical operator OR is used when only one of the rules needs to be true.
Note:
_Groups_ will be explored in the next activity,
_Query – Advanced Orientation_.
### The activity
Recently, the Shoreline Birth Center was called out in the local paper as having a high rate of Cesarean births. The report seems unfair to Shoreline’s management team, as they have been trying to decrease their Cesarean rates for the past five years. They would like to know, 1) if their efforts have helped, and 2) if their current rates Cesarean births are lower than the national average of 32.1%. You’ve been tasked with running queries to gather the data needed.
Access the EHR queries tool and corresponding dataset under
**2: Launch EHR.** Click the
**New Session** button to launch the EHR.
On the Queries tab, select
**New** to initiate a new query.
1. Name the query ‘
2. Then enter the following query rule:
3. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
4. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view. (Note the Total Record(s) amount has been removed from the image below.)
5. Select
**New** to begin another query.
6. Name the query ‘
7. Then enter the following query rule:
8. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
9. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
10. Select
**Query** then
**Close** to return to the summary view. Both queries should now be listed.
Next, you will generate the same queries for the current year to determine the current rate of Cesarean births.
12. Name the query ‘
**Total Births – Current year**’.
13. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
14. Select
**Query** to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.
15. Select
**Close** to return to the Queries tab. Your query will be displayed as a row on the summary view.
16. Select
**New** to begin another query.
17. Name the query ‘
**Cesarean births – Current year’**
18. Then enter the following query rule:
**Query rule(s):**‘Birth year’ equal ‘Current year’
19. Select
**Add rule** to add another rule and select
**AND** as the logic (default).
20. Enter the following second rule:
**Query rule(s):**‘Type Of Birth’ equal ‘Cesarean’
21. Select
**Query** then
**Close** to return to the summary view. All 4 queries should now be listed.
22. The rate of Cesarean births from the current year could be determined by dividing the number of Cesarean births by the Total births for the current year.
23. Select
**Close Session** and submit your progress report as described in the next section. Note: you do not need to turn in the calculated Cesarean rates, only the progress report.
**Submit your work**
You will complete the query in EHR Go as instructed. Remember to save your work. When finished, click on the
**Close Session** button at the top right of the screen. Download your Progress Report in EHR Go under
**3: Download Work**, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.
**Learning objectives**
1. Apply health informatics concepts to the management of health information (3)
2. Utilize technologies for health information management (3)
3. Manage data within a database system (5)
EHR Go Skills Activity: Query – Basic Orientation (Associate) HAS1033.2
Archetype Innovations LLC ©2024
2
**image3.png**
**image4.png**
**image5.png**
**image6.png**
**image7.png**
**image8.png**
**image9.png**
**image10.png**
**image11.png**
**image1.png**
**image2.png**
**image12.jpg**
**HIT2100MOD1Query-AdvancedOrientationINFO2025.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/hit2100mod1query-advancedorientationinfo2025-docx)
– 1
– 2
– 3
– 4