Due Tuesday December 8 at 4 PM

Programming MS-Word using VBA (Visual Basic for Applications):

For this assignment you are to write VBA macros that will be included in a Word macro-enabled document (ends in the suffix ".docm") document. In order to get credit for the assignment you must write VBA macro code and you will get no credit, for instance, you just take an existing Word document and manually make the changes using Word instead of writing a program. There are a number of sample documents that the TA's may use when marking your work. None of those documents will include things beyond the requirements of the features listed below, they will just evaluate how well you implemented your program. To get you started here is an [example document]. Use this document as a starting point and embed your VBA instructions here (make sure you don't save the VBA macros in "all word documents" but in the sample document. If you are unsure of what this entails then you should refer to your in class lecture notes (the first set of VBA lecture notes) but here is a reminder image of how you should save your macros:

Because your macros will be included in the document, when it comes time to submit your work you can just upload the macro-enabled document. Double check that there really are macros in the Word document that you upload! It is up to you to do the check, you shouldn't rely on us to do it for you.  If you want to be extra safe (and I highly recommend that you do this) you can copy and paste your VBA program into a regular Word document and submit that extra Word document as well the macro-enabled document.

Similar to the previous assignment everyone starts out with a grade point of zero for this assignment. As you implement the features or documentation requirements listed below your grade will increase. Violating style requirements will result in a decreased assignment grade.

Features that your VBA macros should include:

Documentation requirements (see Part I of the VBA notes for a detailed explanation for #1 & 2 summary is provided below): documentation marks may be awarded independently of program functionality

1. Contact information: Name, student ID and tutorial section (+0.1 GPA for including all pieces of information, no credit for partial information)
2. A list of features (#1 - 9 above) as well as a clear indication if the feature was or was not fully completed and (if applicable) which version of the feature that was completed (0.1 grade point for every three features listed x 9 features = 0.3 GPA max). You only get documentation marks for each grouping of three features e.g., listing 0 - 2 features provides no documentation marks, listing 3 - 5 features yield 0.1 documentation marks etc. so be sure to document every feature if you don't complete them all.
3. Use of a versioning system that ties into a list of features completed e.g., "Version (Nov 12) has Feature 8 completed", "Version (Nov 13) Has Features 1, 2, 8 completed" (+0.1 GPA)

Style requirements (see Part I of the VBA notes for a detailed explanation):

Good naming conventions: all program identifiers (variables, named constants, macro and file names must exhibit properties good naming conventions). A penalty of -0.1 GPA will applied for the first instance of a poor naming convention, -0.2 GPA for the second instance down to a maximum penalty of -0.3 GPA for naming conventions.

Appropriate use of named constants. If there is one or two instances where named constants could have been employed but you didn't define them then no penalty is applied. If there were three or more instances where named constants could have been employed then a maximum penalty of -0.1 GPA will be applied. (To get you started the cut-off used to determine if the number of spelling mistakes is unacceptable is a prime candidate for a named constant e.g. "Const SPELLING_CUTOFF = 0").

Submitting your work: