Data+Activity+1


 * Activity 1 – Analyzing General Trends in Salaries by Gender

Locate the following data:** Table 3. Median usual weekly earnings of full-time wage and salary workers by occupation and gender, quarterly averages, not seasonally adjusted http://www.bls.gov/webapps/legacy/cpswktab3.htm

Select one of the job categories below. A possible activity is to ask each participant to take one of the areas below, and create a graph that compares the number of men and women who work in each area.


 * Management, professional, and related occupations


 * Management, business, and financial operations occupations


 * Professional and related occupations


 * Service occupations


 * Sales and office occupations


 * Sales and related occupations


 * Office and administrative support occupations


 * Natural resources, construction, and maintenance occupations


 * Farming, fishing, and forestry occupations


 * Construction and extraction occupations


 * Installation, maintenance, and repair occupations


 * Production, transportation, and material moving occupations


 * Production occupations


 * Transportation and material moving occupations

By clicking on “More Formatting Options” you can choose “Annual” Data only, or select one particular year. Note changes over the past 5 years. 1. Record the salary for each job for Men, Women, and Both together. 2. Sort the list from Highest to Lowest Paid. 3. Record the total number of workers in each area. 4. Record the total number of men and women in each area. 5. Manually figure out what percentage of the workers in each category is male or female. 6. Enter a formula that will give you the same result (see question 5) 7. If a job has a higher percentage of women than men, apply Pink shading to the row. If a job has a higher percentage of men, apply a blue shading to the row.