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 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.
Expert Solution Preview
Introduction:
The module requires the use of Microsoft Excel for data cleaning and analysis. As a medical professor, it is important to have proficiency in Excel to effectively evaluate student performance and conduct research. In this module, we will be completing data cleaning tasks, creating new variables, and identifying key patterns in patient data.
Answer:
The activity requires students to use Microsoft Excel to complete data cleaning tasks. It is important for students to familiarize themselves with the program to effectively complete the assignment. Resources such as the Microsoft Excel basic skills page and video tutorials on YouTube can be utilized. It is also recommended for students to share helpful resources with their classmates. The activity involves removing non-number characters from specific rows, identifying missing values, and posting links to helpful Excel tutorials. The completed Excel file addressing activities 1-3 should be posted to the module discussion board by the given deadline.
