Issues in Today's Workforce Culture  Based on your reading in chapter 60, why do you think the issues presented in this chapter persist in today’s workforce culture?

COMMUNITY ASSESSMENT WINDSHIELD SURVEY This windshield survey is a tool used by public health nurses to obtain basic knowledge about a given community. This survey can be conducted by traveling by car, walking, or taking public transportation to gather information on the health of a community and the members of that community. When conducting this survey, make sure to include all community participants, schools, police, fire, hospitals, clinics, etc. Also, please make sure to share your completed presentation with an identified entity in the surveyed community who might be interested in your findings. For an example project, watch the Community Assessment Windshield Survey video at this link: https://www.youtube.com/watch?v=TGXMoQjXbUk

CHF StudyThe CHF dataset comes from the MedPAR dataset. MedPAR is a file that is distributed by CMS (the entity that administers the Medicare program). The file contains data for all inpatient Medicare admissions. The documentation for the full file is available here.(Reminder: There are several resources listed in this week’s Required Resources that use the pivot table.) For this assignment, you will use excel to create a data dictionary, combine data records and create tables and charts. Create a Data DictionaryFind definitions for coded variables:AgeGenderAdmission SourceDischarge DestinationReview: VlookupVlookup is a function in Excel that allows the user to combine records from two worksheets.Add a column for gender descriptionPopulate that column using vlookupAdd a column for discharge destination descriptionPopulate that column using vlookupUsing Excel for Charts/TablesCreate a table of gender (with %)Create a two-way table of gender and age groupCreate a pie chart of gender percentages (from #1)Create a grouped bar chart of agegroup grouped by genderUse PivotChart to create a stacked bar of Discharge status by DRGUse PivotChart to create a pie chart of age categoryCreate a scatter plot of LOS by accommodation chargesCreate a charge per diem chartPrepare a one page summary of your findings. Summarize the history and purpose of the MedPAR database.Describe the findings from the two-way table of gender and age groupDescribe the findings from the pie chart of gender percentagesDescribe the findings from the grouped bar chart of agegroup grouped by genderDescribe the findings from the scatter plot of LOS by accommodation chargesDescribe the findings from the charge per diem chartInclude a minimum of two scholarly referencesThe formative paper Must be one to two double-spaced pages in length (excluding title and reference pages), and formatted according to APA style as outlined in the Ashford Writing Center.Must include a title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedMust begin with an introductory paragraph that has a succinct thesis statement.Must use at least two scholarly sources, excluding the textbooks and course articles.Must document all sources in APA style, as outlined in the Ashford Writing Center.Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.