Assignment #9

  (30 points)

  1. Watch the video Data Validation (Google Sheets)   (CC).

  2. Create a Google Sheets spreadsheet similar to the document developed in the video and shown below. (Data). Apply data validation to the "Subscription Type", "Country", and "URL". Insert your name somewhere in the document. Note: In the video, I mention you can select an entire column if you hold the [Ctrl] and [Shift] key down, and then press one time. Clarification: "press one time" should say press one time on the [Down Arrow].

  3. Explore the tutorial An Introduction to Data Validation in Excel. Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.

  4. Save your work as "assignment9". Share this document with your instructor:

  5. 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. Spreadsheet contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Data validation is used on the "Subscription Type", "Country", and "URL". 20 0 10 20 __/20
2. Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #3. 10 0 5 10 __/10
Total points __/30