Required Reading This module requires you to use Microsoft Excel
Required Reading This module requires you to use Microsoft Excel. If you are not familiar with this program, there are many ways to get assistance with learning. A link to the Microsoft Excel basic skills page is provided. If you prefer video tutorials, feel free to search YouTube or other appropriate platforms. I encourage you to share links to videos and other resources you find particularly helpful with your classmates. Microsoft Basic Tasks in Excel https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca The required Excel data workbook is available for download in the module folder. Recommended Resources None Module Activities NOTE: Work for all activities should be on the same Excel file. Post your Excel file addressing activities 1-3 to the module discussion board by midnight on Friday. Activity 1: Using the required Excel worksheet, complete the following data cleaning activities. • Remove all non-number characters (including spaces) from cells in the following rows: o SBP o RESP o PULSE o GCS o Motor o ISS • Identify how many missing values there are for each variable – give the raw number and % of total • Post links to any Excel tutorial you found helpful for this activity Activity 2: Create a new variable to help identify patients classified as being in hypovolemic shock. • Use the SBP variable values to create the shock variable (create a new column in the existing sheet). • Code SBP < 90 mm Hg as being 0. • Code SBP > 90 mm Hg as being 1. • Identify how many patients were classified as being in shock – raw number and % of total • Post links to any Excel tutorial you found helpful for this activity Activity 3: Recode the mode of transport to be either HEMS or GEMS regardless of transport origin. • Create a new column in the Excel sheet • AS and AT are GEMS transports (ambulance) • HS and HT are HEMS transports (helicopter) • Identify how many patients were HEMS – raw number and % of total • By year, identify how many patients were HEMS – raw number and % per year • Post links to any Excel tutorial you found helpful for this activity Activity 4: Compare your raw numbers and % for activities 1-3 with at least 2 other students. • Do the numbers match? • If not, see if you can identify the reason and help resolve the issue. • Post your responses by midnight on Sunday. Module Grading • Full Credit (10 points): All required postings present. Initial postings completed by midnight on Friday. Response postings completed by midnight on Sunday. • Partial Credit (5 points): Missing required postings or elements.