Assignment #13

  (30 points)

  1. Watch the video Creating HTML Pages (MS Excel)   (CC).

  2. Complete either Option A or Option B below.

    Option A:
    Create a MS Excel application using Visual Basic for Applications (VBA) that creates web pages similar to the one developed in the video and shown in the images below (Assignment 13 - students). When the "Create HTML Pages" command button is pressed your code should create the following 3 HTML pages ("all-companies.html", "retail-companies.html", and "service-companies.html"). Insert your name somewhere in the document. Rename this sheet "Assignment13A". (VBA code.) (Maximum score possible: 15 points.)

    Option B:
    Create a MS Excel application using Visual Basic for Applications (VBA) that creates web pages similar to the one developed in the video and shown in the images below (Assignment 13 - students). When the "Create HTML Pages" command button is pressed your code should create the following 4 HTML pages ("all-companies.html", "retail-companies.html", "service-companies.html", and "grocery-companies.html"). Insert your name somewhere in the document. Rename this sheet "Assignment13A". (VBA code.) (Maximum score possible: 20 points.) (Extra data for Grocery Stores).



    Complete either Step #3 or Step #4 below.

  3. Create a new tab in the Microsoft Excel document created in the previous step. Rename this sheet "Assignment13B". Enter the data as shown in the image below. Add a command button labeled "Create Pie Chart" and another labeled "Create Line Chart." Pressing these buttons should generate a pie chart and a line chart, respectively.



  4. Explore the tutorial Hyperlinks in Excel (A Complete Guide + Examples). 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.

  5. Save your work as "assignment13.xlsm" when you are finished. The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)".

  6. Upload this file to 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. Option A: Created an application (Assignment 13A) using Visual Basic for Applications (VBA) similar to the one developed in the video and shown above. When the "Create HTML Pages" command button is pressed your code creates the following 3 HTML pages ("all-companies.html", "retail-companies.html", and "service-companies.html"). Spreadsheet contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. 15 0 8 15 __/20
1. Option B: Created an application (Assignment 13A) using Visual Basic for Applications (VBA) similar to the one developed in the video and shown above. When the "Create HTML Pages" command button is pressed your code creates the following 4 HTML pages ("all-companies.html", "retail-companies.html", "service-companies.html", and "grocery-companies.html"). Spreadsheet contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. 20 0 10 20 __/20
2. Spreadsheet (Assignment 13B) includes a command button labeled "Create Pie Chart" and another labeled "Create Line Chart." Pressing these buttons should generate a pie chart and a line chart, respectively.

OR

Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4. 		10 0 5 10 __/10
Total points __/30