Renewal assessment for Microsoft Certified: Azure Administrator Associate Exam
COMP100 · Other
COMP100 Computer Science — exam and revision material · Other
Updated today
Computer Science exam material, 15 pages. Originally published on StudyMerit.
See the first 3 pages exactly as they appear in the document.
Evidence-Based Healthcare Administration – D547 APN1-TASK 1: DATA ANALYSIS Name ID Date: 02/20/25 A1 (The data I chose to use) Selected Data: 1. Subgroup: Age 2. Primary diagnosis: Symptoms, signs, and abnormal clinical and laboratory findings and Mental, behavior, and neurodevelopmental disorders (but you still have to include the rest of the diagnosis but remember to remove any that are missing data) 3. Most commo reason for visit: Other symptoms/problems related to psychological and mental disorders and Shortness of breath A2 . (Recap of what you will have in your Spreadsheet; these are the 3 notable variables I selected) 545,881,908 more ED visits for primary diagnosis of Symptoms, signs, and abnormal clinical and laboratory finds in age group 18-44 then there were for Mental, behavior, and neurodevelopmental disorders for the same age group 40,413,144 less females are seen for Other symptoms/problems related to psychological and mental disorders then Stomach and abdominal pain, cramps, and spasms 254,903,381 more Females visited the Emergency Dept in general then males A3. See excel spreadsheet Downloaded by Clement Sam (samuelkaruiki40@gmail.com) lOMoARcPSD|6879242
Instructions on what is needed in the spreadsheet and how to create your pivot table and chart – Hope this helps Download the Estimates_of_Emergency_Dept and save it to your laptop/desktop o KeyPoints Leave the main ED estimates as your main tap (reason why I had to resubmit a 2 nd time) Add filters by highlighting your sections (A-L), from the toolbar click “Sort & Filter. This gives you the dropdown options next to each data row For each pivot table I renamed the Measure to either Primary diagnosis or Most common Reason for visit Changed it back once I created the pivot table in a new tab o KeyPoints for Pivot table chart When filtering make sure to have 2016-2021 checked Filter “Measure Type” by primary diagnosis For Measure (or if you changed the name to Primary Diagnosis) select all with the exception of “All Diagnosis” (this is generalized and not needed) Group: filter by either Sex, Age, Race/ethnicity, Region, or type of payment/insurance used (only leave what you need checked) Filter your subgroups (or if you renamed this by whatever you chose to focus on): either by gender, age group, insurance, or region Estimate Type: filter by Visit Count (filter and unselect rate) Estimate: (I changed it to Visit Count) Make sure to unselect any blanks in this column Other three columns are not needed buy you can leave it on the main ED tab o Undo your filters and change names for your next pivot table o Once Pivot tables are complete, I changed the names back on the main Estimates of ED o Pivot time Click on Insert Highlight your columns A-H Downloaded by Clement Sam (samuelkaruiki40@gmail.com) lOMoARcPSD|6879242
Click Pivotchart Select a new tab, but if you want to bring in the filtered data from the main tab [which I did], for that I selected Existing worksheet then clicked the sheet tab and clicked on o From the Pivot chart fields screen If you see any blank rows, you will need to drag that item to the filter section o Filter from your current tab, a row will appear with a dropdown to allow you to filter for any unwanted data o For instance, I unchecked disease of circulatory because it had data missing in the Value count, I also removed any blank data (also, make sure value count is Sum) Once you are done filtering, drag it back to the appropriate section Downloaded by Clement Sam (samuelkaruiki40@gmail.com) lOMoARcPSD|6879242
That’s the free preview
You’ve read 3 of 15 pages. The whole document is yours with a free account, and it stays in your library.
COMP100 · Other
COMP100 · Other
COMP100 · Other
Free
With a free account