Assignment #17

  (10 points)

  1. Watch one of the videos below:

  2. Create either a Google Sheet or a Microsoft Excel document similar to the document developed in the video and shown below. Formulas must be created for Age, AARP Eligible, Age of average employee, Age of youngest employee, Age of oldest employee, Number of employees less than 40, Number of employees AARP eligible. (Data)



  3. Insert your name somewhere in the document.

  4. Save your work as "assignment17". If using Google Sheets, share this document with your instructor: rosener@nsuok.edu.

  5. If using MS Excel upload this file to YOUR-CLASS-WEBSITE. If using Google Sheets create a link to this document on YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Document contains row headers, column headers, and data. Document uses borders and possibly shading to enhance the visual impact. 3 0 2 3 __/3
2. Document uses formulas to compute: Age, AARP Eligible, Age of average employee, Age of youngest employee, Age of oldest employee, Number of employees less than 40, Number of employees AARP eligible. 7 0 4 7 __/7
Total points __/10