Success Essays logo
  • Our services
    • Personal Statement Writing
    • Book Review Writing
    • Case Study Writing
    • Coursework Writing
    • Custom Essays
    • English 102 Essays
    • Dissertation Writing
    • Thesis Writing Service
    • Writing a Perfect Essay Outline
    • Quality Essays
    • MLA Formatted Papers
    • Frequently Asked Questions
    • Nutrition Essay Sample
    • History Essays and Dissertation
    • Write your Nursing paper like a pro
    • Term Paper Writing
  • Pricing
  • Our Guarantees
  • Why Us?
  • +1(405) 367-3611
  • Reviews ⭐⭐⭐⭐⭐
  • My account
  • Order now
Order Now
Uncategorized

Using Excel for Data Management and Analysis 1 Bottom Line

4 min read
Posted on 
December 10th, 2021
Home Uncategorized Using Excel for Data Management and Analysis 1 Bottom Line

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 and management, entered sample data consistent with their proposed DNP project, and complete a data analysis plan to answer the research question(s). Required Reading Sylvia & Terhaar Chapters 6-9, 12 (required for prior modules). Chapters 6-8 will assist with identifying variables and data sources. Chapter 9 will assist with developing an analysis plan, but it will certainly not cover every possible analysis. Do the best you can right now. Eventually, you will need to meet with a data analysist or statistician to develop a formal analysis plan. 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 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: Develop an Excel worksheet for data collection and management for your DNP project. • Clearly state your research question(s) at the top of the worksheet. • For each research question, clearly identify the variables needed to answer the question. If there is are Independent and Dependent variables, clearly indicate this next to the variable. • Clearly identify the source for your variables. The nature of the example project requires 2 different working data sets. Data set 1 records HEMS (helicopter EMS units) count by year. Data set 2 records patient level data. In order to keep 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 your Plan and another for your DNP Data. If other worksheets are needed, create them in your Excel file. • Your project may not require multiple data sets. If one data set will work, stick with one. Activity 2: Fabricate appropriate data to mimic what you expect things to look like for your DNP project. • Use the sheets in the Excel file to fabricate data that approximates what you anticipate using for your project. • Create enough entries to complete your analysis. o If you are using longitudinal data (e.g., weeks, months, or quarters), create at least 12 entries. o If you are using individual patient data, create at least 25 cases. o You can be creative but make the data realistic. Data Set 1 Headings Data Set 2 Headings Here are what the HEMS example data look like: Activity 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? NOTE: The purpose of Activity 3 is to get you thinking about the analysis plan. Articulate what you want the data to tell you even if you don’t know the specific statistical test. During the planning phase of your DNP project, you will meet with a data analysist or statistician to determine a detailed data plan (including the analysis). Here is the HEMS example analysis plan: Activity 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. Activity 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. Module Grading • Full Credit (10 points): All required postings present. Initial postings completed by midnight on Friday.

Don't use plagiarized sources. Get Your Custom Essay on
Using Excel for Data Management and Analysis 1 Bottom Line
Just from $10/Page
Order Essay

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Share
Tweet
Share
Tweet
Calculate the price
Pages (275 words)
$0.00
Success Essays
Company
  • Home
  • Pricing
  • Why Us?
  • About Us
  • Contact Us
Legal
  • Our Guarantees
  • Money Back Guarantee
  • Revision Policy
  • Refund Policy
  • Privacy Policy
  • Terms and Conditions
How Our Service is Used:
Success Essays essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Success Essays does not endorse or condone any type of plagiarism.
Subscribe
No Spam
  • Personal Statement Writing
  • Book Review Writing
  • Case Study Writing
  • Coursework Writing
  • Custom Essays
  • English 102 Essays
  • Dissertation Writing
  • Thesis Writing Service
  • Writing a Perfect Essay Outline
  • Quality Essays
  • MLA Formatted Papers
  • Frequently Asked Questions
  • Nutrition Essay Sample
  • History Essays and Dissertation
  • Write your Nursing paper like a pro
  • Term Paper Writing
© 2022 Success Essays. All rights reserved.
Success Essays will be listed as ‘Success Essays’ on your bank statement.