Assignment #4   (20 points)

  1. Watch the video Ticket Sales Calculator (CC).

  2. Create a "Ticket Sales Calculator" using Microsoft Excel and Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. Save your work as "assignment4A.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.

  3. Watch the video Order Form (Skates) (CC)

  4. Create an "Order Form for Skates" using Microsoft Excel and Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. The interface can be downloaded from the Assignment #4 folder. Save your work as "assignment4B.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
Effectively created a "Ticket Sales Calculator" using VBA (Visual Basic for Applications) similar to the one developed in the video and shown in the image above. 10 0 5 10 __/10
Effectively created a "Order Form for Selling Skates" using VBA (Visual Basic for Applications) similar to the one developed in the video and shown in the image above. 10 0 5 10 __/10
Total points __/20