Protect File Assignment

Microsoft Excel
Requirements: To password-protect an Excel spreadsheet


Basic Assignment Option:

Step 1: Idenfity educational data that could be organized in an Excel spreadsheet.
Step 2: Using Excel, create a spreadsheet for the educational data.
Step 3: Create a password for the spreadsheet using Excel's protection options.
Step 4: Name and Save the file.
Step 5: Email the finished product and password to the instructor by the due date.

* Scoring Rubric *

Full Credit
  • Educational data
  • Spreadsheet created
  • Password created
  • Emailed by due date
    		•
    Partial Credit
  • Educational data
  • Spreadsheet created
  • Password created
  • Emailed late
    		•
    No Credit
  • Non-educational data
  • Spreadsheet created
  • Password not created
  • Submitted late
    		•


    Intermediate Assignment Option:

    Step 1: Idenfity educational data that could be organized in an Excel spreadsheet.
    Step 2: Using Excel, create a spreadsheet for the educational data.
    Step 3: Insert a topic-related graphic into the spreadsheet.
    Step 4: Use at least 2 font sizes and font colors in the spreadsheet.
    Step 5: Create a password for the spreadsheet using Excel's protection options.
    Step 6: Name and Save the file.
    Step 7: Email the finished product and password to the instructor by the due date.

    * Scoring Rubric *

    Full Credit
  • Educational data
  • Spreadsheet created
  • Related graphic inserted
  • 2 font sizes used
  • 2 font colors used
  • Password created
  • Emailed by due date
    		•
    Partial Credit
  • Educational data
  • Spreadsheet created
  • Related graphic inserted
  • 1 font size used
  • 1 font color used
  • Password created
  • Emailed late
    		•
    No Credit
  • Non-educational data
  • Spreadsheet created
  • No graphic inserted
  • 1 font size used
  • 1 font color used
  • No password created
  • Emailed late
    		•


    Advanced Assignment Option:

    Step 1: Idenfity educational data that could be organized in an Excel spreadsheet.
    Step 2: Using Excel, create a spreadsheet for the educational data.
    Step 3: Insert a topic-related graphic into the spreadsheet.
    Step 4: Use at least 2 font sizes and font colors in the spreadsheet.
    Step 5: Create a password for the spreadsheet using Excel's protection options.
    Step 6: Name and Save the file.
    Step 7: Link the file on a web page. Upload the webpage and spreadsheet file to a web server.
    Step 8: Email the URL of the web page to the instructor by the due date.

    * Scoring Rubric *

    Full Credit
  • Educational data
  • Spreadsheet created
  • Related graphic inserted
  • 2 font sizes used
  • 2 font colors used
  • Password created
  • Linked to a web page
  • Uploaded to a web server
  • URL emailed by due date
    		•
    Partial Credit
  • Educational data
  • Spreadsheet created
  • No graphic inserted
  • 1 font size used
  • 1 font color used
  • Password created
  • Linked to a web page
  • Uploaded to a web server
  • URL emailed late
    		•
    No Credit
  • Non-educational data
  • Spreadsheet created
  • No graphic inserted
  • 1 font size used
  • 1 font color used
  • Password created
  • No web page link
  • Not uploaded to a server
  • File emailed late
    		•