Note:  If you took the introduction course, you may simply use the completed documents from the last course, rather than repeating the assignment. 

- Make a scatter-plot of the hourly rate and hours worked.  Format this plot appropriately.

- In cells E17 and E18 use the COUNTIF formula to count the number of employees working overtime, and the number of employees not working overtime.  Display this data with a pie chart and a par graph.  Format these appropriately.

- Display the net pay (with overtime) with a line graph.  Format this graph appropriately. 

- After completion, save the Excel file as YourName Week1a Assignment, and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page. 

- Insert a column after the "Weight Lost in Week 4" column and insert sparklines to display the weight each individual has lost each week - use the bar graph option.

   *If you're working with a version older than Excel 2010 sparklines do not exist, so you must skip this step. 

- Filter the data to display only those individuals who started at least 75 pounds overweight.

- Insert another worksheet.  Name the existing worksheet "Data" and the new one "Summary."

- After completion, save the excel file as YourName Week1b Assignment, and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page.  

Review the homework "solution" tutorial, complete the self evaluation, save the file as YourName Week1b Evaluation and submit via the appropriate dropbox under the 'Coursework' tab located at the left of the course page.

Note: each self evaluation is the same, so if you keep the blank file somewhere accessible, you do not need to download it after every assignment.