Create Hyperlink Assignment

Microsoft Excel
Requirements: To Insert a Hyperlink into an Excel Spreadsheet


Basic Assignment Option:

Step 1: Identify educational data that can be organized in an Excel spreadsheet.
Step 2: Using Microsoft Excel, create an Excel spreadsheet for the data.
Step 3: Create/Insert a data-related hyperlink in the spreadsheet.
Step 4: Name and save the document. Test the hyperlink to see if it functions correctly.
Step 5: Submit the "finished product" to the instructor via email attachment by the due date.

* Scoring Rubric *

Full Credit
  • Excel spreadsheet created
  • Hyperlink functioning
  • Emailed by due date
    		•
    Partial Credit
  • Excel spreadsheet created
  • Hyperlink functioning
  • Emailed late
    		•
    No Credit
  • Excel spreadsheet created
  • No hyperlink
  • Emailed late
    		•


    Advanced Assignment Option:

    Step 1: Identify educational data that can be organized and displayed in an Excel spreadsheet.
    Step 2: Using Microsoft Excel, create an Excel spreadsheet for the data.
    Step 3: Create/Insert 2 data-related hyperlinks in the spreadsheet.
    Step 4: Name and save the document. Test the hyperlinks to see if they function correctly.
    Step 5: Use at least 2 font colors in the spreadsheet.
    Step 6: Utilize the "Save As Web Page" option to create a new web page for your original Excel file.
    Step 7: Upload the new Excel web page to a "web space" for display on the internet.
    Step 8: Submit the web address (URL) of the new Excel web page to the instructor via email by the due date.

    * Scoring Rubric *

    Full Credit
  • Excel file created
  • 2 hyperlinks created
  • Excel web page created
  • 2 font colors used
  • Uploaded to web space
  • URL emailed by due date
    		•
    Partial Credit
  • Excel file created
  • 1 hyperlink created
  • Excel web page created
  • 1 font color used
  • Uploaded to web space
  • URL emailed late
    		•
    No Credit
  • Excel file created
  • No hyperlink created
  • No web page created
  • 1 font color used
  • Not uploaded
  • File emailed late
    		•