1 \u00a9 HealthCareCAN All rights reserved
\nHealth Information Management
\n304 Introduction to Data Analysis
\nAssignment #2
\nTotal: 63 Marks
\nValue: 15%
\nPurpose: The purpose of this assignment is to assess your understanding and ability to apply
\nwhat you learned about using available coded data, how the data can be presented and used to
\nsupport decision-making.
\nRequest: Senior management at your hospital has received funding from the ministry or
\ndepartment of health to develop a new gynecology program to provide this service in your
\ngeographic area.
\nYou have been asked to provide the senior management team with data that will help them
\ndecide how to allocate these new funds.
\nSince your hospital has never had a gynecology program prior to receiving this funding, you will
\nuse your \u201cNeighbouring Facility\u2019s\u201d data to help better understand and to project ( help with nursing paper writing from experts with MSN & DNP degrees) anticipated
\nneeds of this service population. Since your \u201cNeighbouring Facility\u201d has had a gynecology
\nprogram for many years, their data will help you estimate volumes of diagnoses and
\ninterventions that your facility should expect to serve once the new gynecology program is up and
\nrunning.
\nYou will create a slide deck with speaker\u2019s notes to present this data and your analysis to the
\nsenior management team.
\nInstructions:
\n1. You will use the Excel spreadsheet titled \u201cNeighbouring Facility,\u201d saved on Brightspace in the
\nassignment area. Download the file and save a copy to your computer.
\n2. You will create a new Excel spreadsheet. You will use this new Excel spreadsheet to create
\nthe tables and graphs, using the data you retrieve from the \u201cNeighbouring Facility\u201d Excel
\nspreadsheet.
\n3. You will filter or create a pivot table to identify the top 5 diagnoses (ICD-10-CA codes and
\ncode titles) and the top 5 interventions (CCI codes and code titles) for your \u201cNeighbouring
\nFacility\u2019s\u201d gynecology program, by fiscal year and by institution type (day surgery and acute
\ncare inpatient).
\n” rearning ” a division of ……. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE
\n2 \u00a9 HealthCareCAN All rights reserved
\n4. You will identify how you isolated the data you needed to conduct this analysis \u2013 such as, the
\ndata element(s) you used to compile the data.
\n5. Summarize and compare the data using tables and graphs to help you analyze and report the
\ndata.
\n6. Create a succinct and concise PowerPoint presentation for the senior management team
\nwhich you will present to them.
\n\u2022 Ensure the slides are presented professionally and concisely. Each text slide should have
\nno more than 5 bullets with no more than 6 words per bullet.
\n\u2022 You must include completely and accurately labelled tables and graphs to illustrate the
\ndata you have compiled and analyzed.
\n\u2022 Explain how this data will help with planning by identifying what staffing, equipment,
\nmaterials, and other resources will be required to meet the needs of the anticipated
\nservice population (based on your \u201cNeighbouring Facility\u2019s\u201d top 5 diagnoses and top 5
\ninterventions).
\n\u2022 Identify and define at least 5 other data elements on which you will report once the
\ngynecology program is up and running at your facility and explain how this data will help
\nsenior management with planning for this service on a go forward basis.
\n7. Include detailed speaker\u2019s notes in the PowerPoint file or as a separate Word document for
\neach slide – explaining the information on each slide of your presentation. You will explain
\nwhat is represented on each slide, the data, the analysis and how the data and other
\ninformation will help inform their decisions about allocation of resources for this new
\nprogram. Include conclusions and recommendations based on the data.
\nContact the instructor if you have any questions or if you require further clarification when
\ncompleting this assignment.<\/p>\n
” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE
\n3 \u00a9 HealthCareCAN All rights reserved
\nGrading Rubric (information to include in presentation \u2013 slide deck with speaker\u2019s notes)
\nNote: Part marks may be given
\nCriteria Fully Meets
\nExpectations (6)
\nMeets Most
\nExpectations (4)
\nDoes Not Meet
\nExpectations (2)
\nNo Evidence
\n(0)
\nClear and
\naccurate
\nsummary of
\ngynecological
\ndata in Excel
\nformat using
\nboth tables and
\ngraphs
\n(x 2 = 12 marks)
\nStudent has provided an
\nexcellent, clear summary
\nof the gynecological data to
\nsupport decision-making.
\nStudent has provided mostly
\nclear and complete
\nsummary of the
\ngynecological data. Some
\nminor details or
\ncomponents of the data are
\nmissing or incorrect.
\nUnclear or inaccurate
\nsummary of data. Both
\ntables and graphs not
\nprovided.
\nNo summary of
\nthe data provided.
\nCorrect selection
\nof data for
\ngynecology
\npatients
\nStudent has identified the
\ncorrect data element to
\nidentify the patient
\npopulation and has
\nretrieved the appropriate
\ndata.
\nStudent has identified the
\ncorrect data element to
\nidentify the patient
\npopulation or has retrieved
\nthe appropriate data.
\nStudent has retrieved
\nsome data but did not
\nuse the correct data
\nelement to identify the
\npatient population.
\nStudent does not
\nunderstand how
\nto retrieve and
\ncompile program
\ndata.
\nPowerPoint
\npresentation \u2013
\nclear and
\nprofessional
\nThe presentation is
\nexcellent and reflects a
\nvery professional format, is
\nvery clear and concise.
\nThe presentation is good
\nand reflects a professional
\nformat. Is clear and concise.
\nCould benefit from minor
\nimprovements.
\nThe presentation
\nrequires improvements
\nto align with
\nprofessional
\nexpectations. Does not
\nmeet required level of
\nclarity and\/or too
\ncluttered with too many
\nwords on slides.
\nPresentation is
\nunprofessional or
\ndemonstrates
\nvery little effort.
\nPowerPoint
\npresentation \u2013
\ntechnical notes
\n(x2 = 12 marks)
\nThe technical notes
\nconcisely and accurately
\nexplain, in a manner
\nappropriate for the
\naudience, that types of
\ncases are included in the
\ndata and why. Includes the
\n5 data elements, definitions
\nand explains how data can
\nbe used to inform decision\u0002making.
\nThe technical notes explain
\nwith adequate accuracy, the
\ntypes of cases included and
\nwhy. May need to be more
\nconcise or written at a level
\nappropriate for the
\naudience. Includes data
\nelements and definitions but
\ndoes not explain how data
\ncan be used to inform
\ndecision-making.
\nThe technical notes are
\nunclear, inaccurate
\nand\/or not
\nunderstandable to the
\naudience. Does not
\nreflect a clear
\nunderstanding by the
\nstudent. Includes data
\nelements but does not
\ninclude definitions or
\nexplain how data can be
\nused to inform decision\u0002making.
\nNo technical
\nnotes included.
\nNo data elements
\nincluded.
\nPowerPoint
\nPresentation \u2013
\ntables and
\ngraphs
\n(x 2 = 12 marks)
\nTables and graphs included
\nare perfectly clear,
\npresented and labelled for
\nthe audience, promoting
\nunderstanding of the data
\nanalysis.
\nTables and graphs included
\nare clearly presented and
\nmostly labelled. They are
\nadequate for the audience
\nbut may require further
\nrefinement.
\nTables and graphs lack
\nclarity, labelling and
\neffective presentation.
\nNo tables or
\ngraphs included
\nor very poorly
\ndone.
\n” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE
\n4 \u00a9 HealthCareCAN All rights reserved
\nCriteria Fully Meets
\nExpectations (6)
\nMeets Most
\nExpectations (4)
\nDoes Not Meet
\nExpectations (2)
\nNo Evidence
\n(0)
\nPowerPoint
\nPresentation \u2013
\nSpeaker\u2019s notes
\n(x 2 = 12 marks)
\nSpeaker\u2019s notes are
\ncomprehensive and reflect
\na solid understanding of
\nthe assignment objectives,
\nthe data that has been
\nanalyzed and has drawn
\nlogical and helpful
\nconclusions about the
\ndata\u2019s impact on decisions.
\nSpeaker\u2019s notes are good.
\nThey reflect a good
\nunderstanding of the
\nassignment objectives, the
\ndata that has been analyzed
\nand has drawn some
\nconclusions about the data
\nthat could be helpful.
\nSpeaker\u2019s notes lack
\ndetail and show little
\nunderstanding of the
\ndata and what
\ninformation is required
\nby decision-makers.
\nNo speaker\u2019s
\nnotes included.
\nSpelling,
\nGrammar and
\nReferencing (3)
\nThe writing is free of errors
\nand proper APA format is
\nused for referencing.
\nThere are occasional errors,
\nbut they do not represent a
\nmajor distraction or obscure
\nmeaning. APA referencing
\nis used.
\nThe writing has many
\nerrors that distract the
\nreader. APA referencing
\nis used incorrectly.
\nThere are so
\nmany errors that
\nmeaning is
\nobscured. The
\nreader is
\nconfused and
\nstops reading.
\nAPA referencing
\nis not used.<\/p>\n
Key Resources:
\n1. Use the information in the Learning Guide to help you.
\n2. Use the \u201cNeighbouring Facility\u201d Excel spreadsheet available on Brightspace to identify volumes
\nto project ( help with nursing paper writing from experts with MSN & DNP degrees) resource use and anticipated needs of the service population.
\n3. Review the Discharge Abstract Database (DAD) Abstracting Manual and the National
\nAmbulatory Care Reporting System (NACRS) Abstracting Manual to identify at least 5 data
\nelements (other than diagnoses and interventions) that will be used in your analysis (specify
\nthe data element, define the data element, and explain how the data element will help senior
\nmanagement with decision-making).
\nNote: Grammar, spelling and sentence structure and citation of resources using the American
\nPsychological Association (APA) format, is important. (3 marks)
\nUpload completed and clearly labelled (i.e., with your name and student number) assignment
\n(i.e., the PowerPoint presentation \u2013 maximum 25 slides, complete with speaker\u2019s notes) to
\nBrightspace.
\nNote: The speaker\u2019s notes can be a separate Word document or can be included in the \u201cnotes\u201d
\nwindow of the slide.
\n” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE<\/p>\n","protected":false},"excerpt":{"rendered":"
1 \u00a9 HealthCareCAN All rights reserved Health Information Management 304 Introduction to Data Analysis Assignment #2 Total: 63 Marks Value: 15% Purpose: The purpose of\u2026<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8816],"tags":[],"class_list":["post-115285","post","type-post","status-publish","format-standard","hentry","category-thesis-writing-help-online"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/115285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=115285"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/115285\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=115285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=115285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=115285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}