Pageof 5ZOOMNGR 7827 Module 12: Using Excel for Data Management and Analysis 1 Bottom Line: By the end of this module, each student will have completed an Excel data worksheet for data collection

Pageof 5ZOOMNGR 7827?odule 12: Using Excel for Data Management and Analysis 1?ottom Line: By the end of this module, each student will have completed an Excel data?orksheet for data collection and management, entered sample data consistent with their?roposed DNP project, and complete a data analysis plan to answer the research question(s).?equired Reading?ylvia & Terhaar Chapters 6-9, 12 (required for prior modules). Chapters 6-8 will assist with?dentifying variables and data sources. Chapter 9 will assist with developing an analysis plan,?ut it will certainly not cover every possible analysis. Do the best you can right now. Eventually,?ou will need to meet with a data analysist or statistician to develop a formal analysis plan.?his module requires you to use Microsoft Excel. If you are not familiar with this program, there?re many ways to get assistance with learning. A link to the Microsoft Excel basic skills page is?rovided. If you prefer video tutorials, feel free to search YouTube or other appropriate?latforms. I encourage you to share links to videos and other resources you find particularly?elpful with your classmates.?icrosoft Basic Tasks in Excel?ttps://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca?ecommended Resources?one?odule Activities?OTE: Work for all activities should be on the same Excel file. Post your Excel file addressing?ctivities 1-3 to the module discussion board by midnight on Friday.?ctivity 1: Develop an Excel worksheet for data collection and management for your DNP?roject.? Clearly state your research question(s) at the top of the worksheet.? For each research question, clearly identify the variables needed to answer the?uestion. If there is are Independent and Dependent variables, clearly indicate this next?o the variable.? Clearly identify the source for your variables.?he nature of the example project requires 2 different working data sets. Data set 1 records?EMS (helicopter EMS units) count by year. Data set 2 records patient level data. In order to?eep everything in one place, 3 worksheets are created ? Plan, HEMS Count, and Patient Data.? Create the necessary worksheets for your DNP project. You will at least need a sheet for?our Plan and another for your DNP Data. If other worksheets are needed, create them?n your Excel file.? Your project may not require multiple data sets. If one data set will work, stick with one.?ctivity 2: Fabricate appropriate data to mimic what you expect things to look like for your DNP?roject.? Use the sheets in the Excel file to fabricate data that approximates what you anticipate?sing for your project.? Create enough entries to complete your analysis.? If you are using longitudinal data (e.g., weeks, months, or quarters), create at?east 12 entries.? If you are using individual patient data, create at least 25 cases.? You can be creative but make the data realistic.?ata Set 1 Headings?ata Set 2 Headings?ere are what the HEMS example data look like:?ctivity 3: Determine your analysis plan to answer your research question.? What data cleaning or recoding need to be completed?? What calculations need to be completed?? What comparisons need to be completed?? How will you display your data??OTE: The purpose of Activity 3 is to get you thinking about the analysis plan. Articulate what?ou want the data to tell you even if you don?t know the specific statistical test. During the?lanning phase of your DNP project, you will meet with a data analysist or statistician to?etermine a detailed data plan (including the analysis).?ere is the HEMS example analysis plan:?ctivity 4: Review the research question(s) and variables identified by at least 1 other student.? Do the identified variables match the question?? Does the data source seem reasonable for obtaining the data?? What other variables would you suggest to help answer the question?? Post your responses by midnight on Sunday.?ctivity 5: Review the analysis plan provided by at least 1 other student.? Do the recoding and cleaning activities match the question?? Do the calculations seem reasonable and appropriate given the question and data?? Do the comparisons seem reasonable and appropriate given the question and data?? What suggestions do you have for improving the analysis plan?? Post your responses by midnight on Sunday.?odule Grading? Full Credit (10 points): All required postings present. Initial postings completed by?idnight on Friday.