Assignment #12

  (30 points)

  1. Watch the video Sorting (MS Excel)   (CC).

  2. Create an application using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. (Assignment 12 - students). Your command buttons should sort data by various columns, extract the lowest two sales and highest two sales, Insert your name somewhere in the document. Rename this sheet "Assignment 12A".

    Note: Mac computers only support a restricted version of VBA. If your Mac computer does not allow you to complete this assignment, then complete either option A or B below.
    A. Write out all the code presented in this video and briefly comment what each line does. Save and upload this information to your website.
    B. Complete this assignment using the NSU Virtual Desktop. A link to this service can be found under Obtain access to MS Excel.



    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 "Assignment 12B". Enter the data as shown in the image below. Create a command button "Convert Names to Lower, Upper, & Proper Case" that when pressed takes the information in Column "A" and automatically creates the information in Columns "B", "C", and "D".



  4. Explore the tutorial How to Sort Worksheets in Excel using VBA (alphabetically). 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 "assignment12.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. Created an application (Assignment 12A) using Visual Basic for Applications (VBA) similar to the one developed in the video and shown above. Your command buttons should sort data by the various columns, extract the lowest two sales and highest two sales. 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 12B) contains the required row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. Create a command button "Convert Names to Lower, Upper, & Proper Case" that when pressed takes the information in Column "A" and automatically creates the information in Columns "B", "C", and "D".

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