Due dates for all assignments can be found on the [main grid] of the course webpage.

Note: The computer lab for CPSC 203 is located in MS 119 (the "Computer Science computer lab"). If you find that your particular version of Word (e.g. Office 365, older versions of Office, MAC users) does not include everything needed for a feature then you should to complete that feature in MS119. You can enter the lab 24/7 but card access is required. However one of the security doors (entrance closer to the Earth Sciences building rather than Science Theaters) should allow public access on weekdays roughly during normal business hours. And to login to the computers in the lab you need to [set up your CPSC login credentials]. [Image of the doors that don't require card access during business hours]

Alternatively login to a lab computer from your own. [Information link created by UC-IT with modifications by James Tam, for questions: www.ucalgary.ca/it]. Keep in mind that the remote login method to a Windows computer works (I've tested it), it is convenient (you don't have to be on campus), the process is a bit of learning curve and sometimes operations are slow.

Introduction and tip for programming

This assignment will be more challenging than the other workbook exercise. Partly it's because the first exercise was simply to show you exactly what you need to do create and run a working VBA program, partly because this exercise is give you some actual practice writing a program that requires more than just following a bunch of steps or looking up the answer in the notes. In that way it's similar to the full assignment coming up you must think through your solution, albeit the solution for this exercise is far less complex, but it will help you prepare for writing the larger and more complex program needed for the next assignment. And it will provide you with a more realistic idea of what programming is like than the first exercise. Actual programmers don't just follow a sequence of prescribed steps or "look up an answer somewhere" when creating a computer program. Instead it requires that they understand basic programming concepts (e.g. getting user input, displaying output, using variables, branching etc.) and figuring out how to apply those concepts with the program that they must create. In a way it's analogous to creative writing. You first learn the grammar of the language. Next you study the elements associated with good writing style. Then you must determine how to apply what you have learned in order to tell a good story well - there isn't an exact sequence of steps you can apply for every situation nor can you simply lookup parts of your story someplace. Also, similar to creative writing, one gets better by 'doing'.

In the case of programming the doing means writing programs (from scratch) on your own. Examples of practice problems include: the ones listed in the course workbook, example problems covered in tutorial and lecture, suggested problems that may be described in lecture. If you have time then you can even try writing the example problems from lecture and tutorial on your own. Don't just look at the final solution! You will get more out of this process if you write a program from scratch. That program should implements the same features as the example we covered. You should do this without looking at the solution because that's just copying an answer. However you can look at the course notes and other examples to remind you of how things work in VBA.

Description

Here is a [e] to ensure that you at least start with the type of Word document that can contain a macro. (It doesn't contain any VBA instructions). The document is provided so you start with a Word document that can contain a macro (docm), whether or not you use it is entirely up to you. If you are unsure of what is required in the creation of a VBA program then you should refer the extra notes that you should have been taking while I covered the material to [the first set of VBA lecture notes].

Below is one important reminder image of how you should save your macros (in this case the name of the Word document to contain the VBA macro is called "starting document" but your program (and the Word document that contains it) must be called "exercise4VBA").

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 your VBA macro really is in the Word document that you upload! It is up to you to do the check, don'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 paste your VBA program into a regular Word document and submit that extra Word document as well the macro-enabled document. Alternatively you can just copy-paste your VBA program from the Visual Basic editor into the exercise4VBA Word document.

It  would be a good idea to check your submission by downloading what you uploaded into D2L and actually open that document, ideally on a different computer that the one you used to write your VBA program (to help ensure that you aren't looking at a local file on the first computer which you used to write the program). As was the case with the assignments do not use other compression utilities (such as zip), otherwise your submission may not be marked.

Requirements for this exercise

Similar to the assignment everyone starts out with a grade point of zero for this exercise. As you implement the features listed below your grade will increase.

Write a VBA program called "exercise4VBA". Again: that should also be the name of your Word document as well.

To help you test your program there are 4 Word documents. Download these to folder that contains the VBA program that you are creating for this exercise. In addition to testing your program with these documents you should test your solution with test cases in other Word documents that you have made yourself to check any other cases that you might think are relevant.

• 'case1A_has_typo_zero_shapes' (at least one spelling mistake and no inline shapes)
•  'case1B_has_typo_3_shapes' (at least one spelling mistake and multiple inline shapes)
• 'case2_no_typos_1_shape' (no spelling mistakes and a single inline shape)
•  'case3_no_typos_3_shapes' (no spelling mistakes and multiple inline shapes)

You don't need to submit these 4 Word documents. The marker will have access to these documents to test your submission and may perform additional tests with other documents. But you should test your program on your own with these files because the program you need to submit will have to handle the required cases properly.

Program features and grading.

• The following two popup messages will always appear: This is regardless of the number of typographical mistakes and inline shapes that reside in the document. The  counts will carried out via the 'ActiveDocument' object.
  • The program will count and display using a MsgBox (0.5 GPA) the number of typo graphical errors. The message must take the form <"Num typos: "> <Actual # typographical mistakes>.
  • 
  • Count and display using a MsgBox the number of 'InlineShapes' which is (0.5 GPA) in the document. The message must take the form <"Num inline shapes: "> <# of inline shapes>.
  • 
• To make an open Word document active you can click on it.
  • For instance, in order to test your program with the document for Case 1A you would open the document 'case1A_has_typo_zero_shapes' (or click on the window containing document if it is already open). Then without clicking on any other Word documents (not even the one containing your VBA program) you would go into the VB editor and run your program. Because the last Word document that you clicked on was case1A_has_typo_zero_shapes then that is the Word document where the count of spelling mistakes and number of inline images would be performed. [Video showing how to make the Case 1A document the active one] Notice in the video how I don't run the program by clicking on the Word document containing the VBA program but instead I click on the play icon in the Visual basic editor. If I ran the program by clicking on the VBA macro enabled document then the macro enabled document would be the active one and not the desired file 'case1A_has_typo_zero_shapes'.
• Required cases: The content of the popups will vary depending upon the number of typographical mistakes and the inline shapes in the test document.
  • After getting the counts the program will display one of 3 MsgBox popups depending upon the following conditions. You need to use IF structures in order to ensure that the correct message appears under the correct condition.
    • Condition 1 (1.0 GPA): The currently active Word document has one or more spelling mistakes (as counted by your VBA program) the popup message will take the form <"Num typos: "> <Actual # typographical mistakes> <", Num inline shapes: not counted">. As you can see the number of inline shapes will have no bearing on whether or not this popup appear i.e. the number of inline shapes is irrelevant if there any typographical errors in the document.
    • 
    • Condition 2 (1.0 GPA): The currently active Word document has no spelling mistakes (as counted by your VBA program) and there are less than 3 inline shapes the popup message will take the form <"Num typos: "> <Actual # typographical mistakes> <", Num inline shapes: too low">. 
    • 
    • Condition 3 (1.0 GPA): The currently active Word document has no spelling mistakes (as counted by your VBA program) and there are at least 3 inline shapes the popup message will take the form <"Num typos: "> <# typographical mistakes> <", Num inline shapes: "> <# of inline shapes>. 
    • 

  • In terms of the output of the message box for the 3 conditions: the part between the quotes is what literally appears in the popup, the part that is italicized and not quoted will be a number that varies depending upon the number of spelling mistakes or the number of inline shapes in the document. You will only get credit for the above 3 popups if the messages appear under the correct conditions (described under each of the 3 conditions).

Documentation requirements

Although you won't be graded on documentation for exercises it still would be a good idea to include it so you don't miss it in the assignment. What's needed for assignments include: your full name as provided to the university (make sure it matches, don't include 'nicknames'), student identification number, tutorial number. Also you should clearly specify what features of the assignment that you completed or didn't complete. In order to get credit the documentation has to be clear and complete

Style requirements

Similar to documentation requirements you aren't graded for style for workbook exercises but it would be a good idea to still follow those requirements so you get in the habit of doing this.

1. Each level of code indenting is consistently 1 tab. Instructions in the sub-routine (between the 'sub' and 'end-sub' is 1 level:

   sub exercise4VBA

       'Instructions indented one level (one tab)

   end sub

   The body of IF or WHILE structures counts as another level of indenting. An IF within an IF or WHILE within a WHILE (or even  an IF within a WHILE or a WHILE within an IF) each count as another level.

   sub exercise4VBA

    

       while()     'Instructions indented one level (one tab)

           if()     'Nested body indented two levels (two tabs)

               if()     'Another level of nesting: indented three levels (three tabs)

   end sub

    

2. Good naming conventions (e.g. variables, sub-routines, the name of Word document containing the VBA program and constants if applicable) are followed. Some examples of naming conventions are provided in [the VBA Part I notes].

• The document must be electronically submitted using D2L.
• You need to submit the Word document that contains the macro (a macro-enabled Word document .docm). Do not mistakenly submit the starting document that was opened by your VBA program because it won't contain your program and your marker won't be able to assign you credit.
• Make sure that you [check the contents of your submitted files] (e.g., is the file okay or was it corrupted, is it the correct version etc.). It's your responsibility to do this! (Make sure that you submit your assignment with enough time before it comes due for you to do a check). If don't check and there were problems with the submission then you should not expect that you can "learn your lesson" and simply resubmit.