create a Excel spreadsheet and a written report based on information retrieved f

create a Excel spreadsheet and a written report based on information retrieved from an EHR used in ambulatory care for patients with hypertension.
Project 1 – Completed as an Individual (Excel spreadsheets)
Using the files extracted from OpenMRS, the interprofessional team requests the information for patients with hypertension to be entered into an Excel spreadsheet for analysis.
Using an Excel Spreadsheet (Label the Spreadsheet Tab Hypertension)
For each patient and patient visit enter into the Excel spreadsheet for men and women. Create a spreadsheet for men with hypertension, a spreadsheet for women with hypertension, a spreadsheet for all patients with hypertension
Medical Record Number
Patient’s name
Date of Birth
Age (Correct age for the visit)
Gender
Weight
Pulse rate
Blood pressure – Systolic
Blood pressure – Diastolic
Temperature in Celsius
Temperature in Fahrenheit
Number of visits to the clinic
Encounter type
Data Analysis
Use an Excel Spreadsheet (Label the Spreadsheet Tab Hypertension)
How many individuals have hypertension?
How many men have hypertension?
How many boys have hypertension?
How many women have hypertension?
How many girls have hypertension?
For men, calculate the following
Age
Mean Age
Standard Deviation
Minimum
Maximum
Temperature
Mean Temperature in Celsius and Fahrenheit
Standard Deviation for Celsius and Fahrenheit
Minimum for Celsius and Fahrenheit
Maximum for Celsius and Fahrenheit
Systolic BP
Mean
Standard Deviation
Minimum
Maximum
Diastolic BP
Mean
Standard Deviation
Minimum
Maximum
Pulse Rate
Mean
Standard Deviation
Minimum
Maximum
Weight
Mean
Standard Deviation
Minimum
Maximum
Encounter types
Total
Average number of Encounters by Types
For women, calculate the following
Age
Mean Age
Standard Deviation
Minimum
Maximum
Temperature
Mean Temperature for Celsius and Fahrenheit
Standard Deviation for Celsius and Fahrenheit
Minimum for Celsius and Fahrenheit
Maximum for Celsius and Fahrenheit
Systolic BP
Mean
Standard Deviation
Minimum
Maximum
Diastolic BP
Mean
Standard Deviation
Minimum
Maximum
Pulse Rate
Mean
Standard Deviation
Minimum
Maximum
Weight
Mean
Standard Deviation
Minimum
Maximum
Encounter types
Total
Average number of Encounters by Type
Write a report based on the data analysis and results completed in Excel. Use a cover page.The written report should follow APA 7 style. References should follow APA style. Be sure to use headings to organize the content. The Excel spreadsheets should be included in the report. Do not submit them as separate files. Under paragraph, set before and after to 0 to ensure exact double spacing. Correctly label the tables and figures using APA style. The tables and figures should follow APA 7 styles.
Include a rationale/purpose for the project. The purpose statement should be 1-2 sentences long, which is approximately 20-60 words.
Methods (Use a heading for each item listed)
Setting – Ambulatory Care
Interprofessional team
Software – Excel
Electronic Health Record – OpenMRS
Data Analysis (Use a heading for each question listed below. Convert the question to a succinct statement)
How were the data queried from the EHR?
How were the data analyzed (methods)? For example, descriptive or inferential statistical methods.
Data Cleaning (Use a heading for each topic)
What was the process for missing values? (Need to include a reference)
How does Excel manage missing values? (Need to include a reference)
What was the process for values outside the expected range (outliers)? (Need to include a reference)
How was the correct age calculated?
Were any visits re-coded?
Conversion of temperature Celsius (C) to temperature Fahrenheit (F)
Conversion of weight from kilograms (kg) to pounds (lbs)
What is the definition of an adult?
What is the definition of a child?
What is the definition of hypertension for an adult?
What is the definition of hypertension for a child?
What patients met the inclusion criteria?
Were both adults and children included in the analysis?
Were there any exclusions?
Results – will be presented in the Results section of the written report.
Results should briefly (1 paragraph) introduce the reader to the results. The reader should be informed of the text of the tables and figures.
Results should be presented in Tables and Figures following APA 7 style. Results should not be presented as cuts from the Excel spreadsheets. All results are to be presented.
Discussion of Results
What were things you found by observing, reviewing, and checking the Excel spreadsheets (this could include reason to include/reason to exclude, including or excluding children in the analysis, discussing missing/not recorded data, data outside the expected range for an attribute, age of the individuals with a particular diagnosis, conversion of Celsius to Fahrenheit, organization of the spreadsheet columns, and checking for inaccuracy in data entry)
Recommendations
One paragraph recommending a change to the report that had been provided with simulated patient information.
Conclusion
What are the key points the reader should remember about the project? Do not introduce any new content.
References
Use peer-reviewed references
Use a minimum of 5 references peer-reviewed references
Cite generative AI
Submits all Excel Spreadsheets
The spreadsheets must be included within the report. The files can be embedded in the Word document.
Review https://shorturl.at/low08Links to an external site.
Links to an external site.
Follows APA style, uses headings to organize the content, margins set at 1 inch, exact double spacing, correctly labels figures and tables following APA style, spelling, grammar, and punctuation. Exact double spacing is achieved by selecting paragraph from the ribbon in Word and setting before and after to 0. This will ensure exact double spacing.
Students enrolled in this course may use artificial intelligence (AI)/generative AI technology for ideas to complete graded assignments. The course faculty members screen student assignment submissions for AI detection using Turnitin or other plagiarism-detecting software. Points will be deducted for failure to cite generative AI. Credit to generative AI is a component of academic integrity. Refer to APA Style regarding how to cite generative AI