files attached

1 answer below »
files attached


Microsoft Word - 2022_Assignment 2_Detailed Instructions.docx Health & Society (HLTH 1025) SP2 2022 Assessment #2 - (30%) 1 Health and Society vs. The Nation This second assignment provides an opportunity for you to demonstrate the skills you have developed through this course in accessing, managing, and interpreting data. It will also provide an opportunity to discuss in depth how the determinants of health can lead to differences in health behaviours across population groups. Each student needs to complete this assignment independently (i.e. as an individual). The topic for this assignment is the prevalence of smoking. This assignment is comprised of five (5) tasks. Exercise 1: Compile data sets This exercise requires you compile data sets from each of the following sources: 1. 2019 Health and Society Student Health Survey dataset 2. 2011-18 Australian National Health Survey (Australian Bureau of Statistics (ABS) data) smoking dataset 3. 2018-19 Aboriginal and Torres Strait Islander Health Survey (ABS data) smoking dataset For this exercise, you will need to download three data sets, available under the “Resources” section of the learnonline course site. You are also required to appropriately reference the data sources used. Exercise 2: Create a summary table for your data For this exercise, you will need to create a table in Microsoft Word to present summary statistics according to age groups for each of the three population groups: 1. 2019 Health and Society student cohort; 2. 2017-18 Australian National Health Survey sample; and 3. 2018-19 Aboriginal and Torres Strait Islander Health Survey sample. The age groups by which you should present your data include: 1) 18-24 years; 2) 25-34 years; 3) 35- 44 years; 4) 45 years and over; 5) Total (i.e. 18 years and over). Note: you may need to combine data for the age group 45 years and over. Health & Society (HLTH 1025) SP2 2022 Assessment #2 - (30%) 2 For this table, you will need to report for each population group by each age group the number and proportion of those who are smokers. For the 2019 Health and Society student cohort, please do the calculations as taught in the previous weeks by using the COUNTIF and COUNTIFS formulas as appropriate. For the 2017-18 Australian National Health Survey dataset, no calculation is required, you have to identify the correct data in the dataset and copy them in your spreadsheet. For the 2018-19 Aboriginal and Torres Strait Islander Health Survey dataset, it is the same process, identify and copy the correct data. For the age group 45 years and over, you need to combine data: add the numbers (estimates) for the group 45-54 years and the group 55 years and over. To calculate the proportion, please divide this sum by the sum of the persons in each of the two age groups (last row in the sheet ‘Total persons’) and multiply by 100 to get the %. For the % Total (≥18 years), use the non-age-standardized figure. Harmonize the number of decimals shown for the % (1 decimal best). The table below is an example of the kind of table you could create and format to present your data: Table 1. Summary of smoking prevalence according to age groups for three Australian population groups Age group Number (%) 2019 Health and Society student cohort 18-24 years 25-34 years 35-44 years 45 years and over Total (≥18 years) 2017-18 Australian Health Survey 18-24 years 25-34 years 35-44 years 45 years and over Total (≥18 years) 2018-19 Australian Aboriginal and Torres Strait Islander Health Survey 18-24 years 25-34 years 35-44 years 45 years and over Total (≥18 years) Health & Society (HLTH 1025) SP2 2022 Assessment #2 - (30%) 3 Exercise 3: Present your summary data in a graph Create a graph (bar or column chart) in Excel to present the data summarised in the table in Exercise 2 for the prevalence of smoking. For this exercise, you should present the percentages (%) by age group (not the n’s) in your graph. Note: To create your graph from the data presented in Exercise 2, you will need to format your data in Excel differently to that presented in your table for Exercise 2 to allow you to create an appropriate graph. Note: You need to create your graph in Excel, but you must present it within the main body of your assignment in Microsoft Word. Exercise 4: Compare health status across the three population groups In 270-330 words, describe the data presented in Exercises 2 and 3 (the table and graph), and compare the three population groups. This exercise should include a description of any similarities and/or differences in the prevalence of smoking between your student cohort (2018 Health and Society student cohort), Indigenous Australians and the total Australian population. Note: The word count is a maximum (i.e., you will be penalised for any text over the stated word limit). Exercise 5: Discuss the role of determinants of health and health literacy In 630-770 words, discuss the social, cultural and environmental determinants which potentially contribute to differences in the prevalence of smoking between your student cohort (2018 Health and Society student cohort), the Indigenous Australian population, and the total Australian population. For your discussion, you may find it helpful to focus on one determinant for each ‘category’ (e.g., income (social determinant), discrimination (cultural determinant), and remoteness (environmental determinant)). As part of your discussion, also address the relevance of health literacy to differences across the three population groups. Your discussion should be informed by at least two appropriate peer reviewed references. Note: The word count is a maximum (i.e., you will be penalised for any text over the stated word limit). The word count includes the in-text references but not the reference list. Health & Society (HLTH 1025) SP2 2022 Assessment #2 - (30%) 4 Format requirements This assignment should not exceed 6 pages (2 cm margins) with text formatted with 1.5 line spacing and a minimum of 11 point font. For tables you may use single (1.0) spacing and 10 point font (but no smaller than this). A maximum of one decimal should be used and consistent for all data presented. Ensure there are titles for the table and the figure. The titles should be comprehensive and concise (no sentence). The assignment should be presented in four sections: Section 1: You should have an assignment title, your name and student ID number. Formatted table with original data and graph (Exercises 2 & 3) in Section 1. Section 2: A maximum of 330 words responding to Exercise 4. Section 3: A maximum of 770 words responding to Exercise 5. Section 4: A reference list formatted according to the UniSA-Harvard (author-date) referencing style. You may choose to include more than 2 peer-reviewed references but at least 2 references for Exercise 5 must be peer reviewed. Note: You should have at least 5 references in your reference list (3 data set references PLUS at least 2 peer-reviewed journal articles. Please ensure there is a title for all graphs and tables, and that figures and tables are referred to in the associated text. Note: You are encouraged to use the UniSA Roadmap to Referencing resource (http://roadmap.unisa.edu.au) to assist you with correct in-text referencing and reference list formatting. Submission All assignments will be automatically assessed by Turnitin. Assignments demonstrating similarity will be reviewed for academic misconduct, so it is very important that you read your Turnitin reports and make any necessary changes. Turnitin compares your assignment against all assignments in the Turnitin databases AND all electronic resources such as the web or library databases and provides a similarity report. The report highlights text, images or tables which is similar to another source and calculates a percentage. The percentage on its own means very little, because if you have referenced sources, then these references should be identified by Turnitin as being similar to library databases or the original source. For any assignment where you are required Health & Society (HLTH 1025) SP2 2022 Assessment #2 - (30%) 5 to use references, the similarity report percentage will never be zero (0%). Use of quotes is not allowed in this assignment. Please look at the resources on adequate paraphrasing on the course website (Foundation week). There are also useful resources for writing assignments https://lo.unisa.edu.au/mod/book/view.php?id=1144638, in particular for students who have difficulties with English. When using Turnitin, you MUST OPEN and READ the Turnitin report, not just look at the similarity percentage. Your Turnitin report should ALWAYS show your references/reference list as being similar or the same as another source. BUT unless you have directly quoted (and correctly referenced text as a direct quote), there should no other text identified as similar to another source. If Turnitin has highlighted areas of text within your assignment that is not a direct quote and referenced as such, this is likely to be word for word copying from a source or paraphrasing of the source; and this is plagiarism. It is always worth reading your Turnitin report and if needed, amend your assignment BEFORE you submit the final version. Please note that it can take over 24 hours to generate a Turnitin report or longer in peak periods. Please also note that suspected plagiarism cases will be referred to an Academic Integrity Officer. For further information please access the following resource: https://lo.unisa.edu.au/mod/book/view.php?id=252146 Grading Criteria Assignment 2 (30%) Student name_____________________________ Marker _____________________________ 6 Criteria Outstanding performance Exceeds core requirements Meets core requirements Does not meet requirements Not attempted Data compilation & table (Tasks 1 & 2) (30%) • Data summarised
Answered 2 days AfterMay 24, 2022

Answer To: files attached

Mohd answered on May 26 2022
76 Votes
Summary of smoking prevalence according to age groups for three Australian population groups
     
    
    
     
     
     
     
     
     
    Age Group
    Number
    %
    2019 Health and Society student cohort
    18-24 years
    160
    86.5%
     
    25-34 years
    
19
    10.3%
     
    35-44 years
    4
    2.2%
     
    45 years and over
    2
    1.1%
     
    Total (≥18 years)
    185
    100.0%
    2017-18 Australian Health Survey
    18-24 years
    317
    12.4%
     
    25-34 years
    527
    20.6%
     
    35-44 years
    511
    20.0%
     
    45 years and over
    1206
    47.1%
     
    Total (≥18 years)
    2560
    100.0%
    2018-19 Australian Aboriginal and Torres Strait Islander Health Survey
    18-24 years
    106
    21.7%
     
    25-34 years
    118
    24.2%
     
    35-44 years
    84
    17.2%
     
    45 years and over
    179
    36.9%
     
    Total (≥18 years)
    487
    100.0%
     
     
     
     
We have taken three population groups; in first group we have 2019 student health and society cohort data counts with respect to each age group category. Of the total data counts, 185 people were having age greater than 18. In which approximately 86 percent people are from 18-24 age group and 10.3 percent people from 24-35 age group. 35-44 age group and 45 years and overs have 2.2 percent and 1.1 percent respectively. As we can see from summary statistics as we increase age the counts of age group categories decreasing significantly.
In second group we have 2017 Australian health survey data counts with respect to each age group category. Of the total data counts estimate, 2560 people were having age greater than 18. In which approximately 12.4 percent people are from 18-24 age group and 20.6 percent people from 24-35 age group. 35-44 age group and 45 years and overs have 20 percent and 47.1 percent respectively. As we can see from summary statistics as we increase age the counts of age group categories increasing significantly.
In third group we have 2018-19 Australian Aboriginal and Torres Strait Islander Health Survey data counts with respect to each age group category. Of the total data counts estimate, 487 people were having age greater than 18. In which approximately 21.7 percent people are from 18-24 age group and 24.2 percent people from 24-35 age group. 35-44 age group and 45 years and overs have 17.2 percent and 36.9 percent respectively. As we can see from summary statistics as we increase age the counts of age group categories decreasing first than increasing...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here