Other Homework Help. CSUN Public and Private Schools in LA County that Reported Immunization Data Exercise
Download the “Test Your Skills” workbook.
- This data is on public and private schools in LA County that reported immunization data in 2015-2016. The data looks specifically at those with personal belief and religious belief exemptions. The original dataset has much more information, but it’s been shortened for this assignment.
- Start with the “Test Your Skills” worksheet
- Add a Fake ID using Auto Fill (column should read from numbers 1 through 3374)
- Fill in the percentage column
- Remember the percentage is the count of students divided by the enrollment
- Be sure to format the cells using the correct format (percentage)
- Format to 2 decimal places
- Filter the “Test Your Skills” worksheet to show public schools with Religious PBEs and 8 students with exemptions — take a screenshot of your worksheet to show me you did this and then clear your filters
- Use conditional formatting to highlight schools with more than 10 students with an exemption (make sure your formatting rule doesn’t apply to other columns (only apply to column E)
- In the “Summary of Test Your Skills” worksheet, fill in the table using formulas and functions that you’ve learned.
- Be sure to use =VLOOKUP() function for Fake ID #17’s Percentage of Exemptions)
- Make the “Summary of Test Your Skills” worksheet look nice with table styles.
- Upload the following:
- Completed Excel Workbook (with all changes above)
- Screenshot of your filtering of the “Test Your Skills” worksheet from step 5
Check your numbers using images attached below.
Grading
- Auto Fill IDs – 3 points
- Percentages Calculated with correct formula for the whole column – 4 points
- Percentages formatted to be a percentage with 2 decimal points for the whole column – 4 points
- Screenshot of filtering for “Test Your Skills” worksheet to show public schools with Religious PBEs and 8 students with exemptions – 5 points
- Conditional formatting on only column E – 5 points
- Average % calculated with correct function (formula in Summary sheet) – 3 points
- Maximum % calculated with correct function (formula in Summary sheet) – 2 points
- Minimum % calculated with correct function (formula in Summary sheet) – 2 points
- Median % calculated with correct function (formula in Summary sheet) – 2 points
- Sum of Count of Students with Exemptions calculated with correct functions (formula in Summary sheet) – 3 points
- Fake ID #17’s Percentage of Exemptions found via correct VLOOKUP function (formula in Summary sheet) – 4 points
- Summary table looks “pretty” – 3 points