Step 1: Ensure the user only enters a Canadian phone number that is exactly 10 digits long. Only the digits can be entered (no other characters such as spaces or dashes are allowed).

Step 1A: click on Cell A2 to ensure it's the currently active cell. For Steps 1  3 make sure this cell is the one selected.

Step 1B: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation.

Step 1C: Under the 'Settings' tab change the following:

Step 1Ci: Under 'Allow' select 'Whole number'

(Unless the option under the 'Data' label has an option selected other than 'between' specified you don't have to change it. The 'Ignore blank' option should be unchecked.)

Step 1Cii: Under 'Minimum' type in '1111111111' (10 ones)

Step 1Ciii: Under 'Maximum' type in '9999999999' (10 nines)

Step 1Civ: Click 'OK'

Step 2A: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation

Step 2B: Select the "Input Message" tab.

(Unless the checkbox for "Show input message when cell is selected" is not checked you don't have to change this control).

Step 2Bi: Under 'Title' type in "Phone number: input cue"

Step 2Bii: Under "Input Message" type in "Enter exactly 10 digits for the phone with no extra spaces, dashes or other separators."

Step 2Biii: Click 'OK'

Step 3: Create a message that describes the error that will occur after the user has entered an erroneous value.

Step 3A: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation

Step 3B: Select the "Error Alert" tab.

These controls don't have to be changed unless they are set to states that are different from the following:

• Show Error alert after invalid data is entered: Checkbox should be 'checked'

• Style: Only change it if an option other than 'Stop' has been selected.

Step 3Bi: Under 'Title' type in "Phone number: error message"

Step 3Bii: Under "Error Message" type in "Reminder: Type in exactly 10 digits for the phone number with no separators such as spaces or dashes."

Step 3Biii: Click 'OK'

Step 4: Ensure the user only selects or types in a faculty from the following list: arts, business, engineering, science, social science.

Step 4A: click on Cell B2 make it the currently active cell. For Steps 4 - 6 make sure this cell is the one that has been selected.

Step 4B: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation

Step 4C: Under the 'Settings' tab change the following:

These controls don't have to be changed unless they are states different from the following:

• Ignore blank: Checkbox should be 'checked'

• In-cell dropdown: Checkbox should be 'checked'

Step 4Ci: Under 'Allow' select 'List'

Step 4Cii: Under 'Source' type in "arts, business, engineering, science, social science" Include the commas and the spaces.

Step 4Ciii: Click 'OK'

Step 5: Create a message that will provide input clues for the faculty before the user enters a value.

Step 5A: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation

Step 5B: Select the "Input Message" tab.

(Unless the checkbox for "Show input message when cell is selected" in not checked you don't have to change this control).

Step 5Bi: Under 'Title' type in "Faculty: input cue"

Step 5Bii: Under "Input Message" type in "Select a faculty from the pull down list using the triangular shaped control (right of Cell B2)."

Step 5Biii: Click 'OK'

Step 6: Create a message that describes the error that occurred after the user has entered an erroneous value.

Step 6A: Select the Data Validation feature: Data -> Data Tools: Data Validation -> Data Validation

Step 6B: Select the "Error Alert" tab.

This control doesn't have to be changed unless it's set to a state that is different from the following:

• Show Error alert after invalid data is entered: Checkbox should be 'checked'

Step 6Bi Change the Style to: 'Warning'.

Step 6Bii: Under 'Title' type in "Faculty: error message"

Step 6Biii: Under "Error Message" type in "Select the following from the pull down list: arts, business, engineering, science, social science."

Step 6Biv: Click 'OK'

Step 7: Test the Data Validation rule for the telephone number.

Step 7A: Click in Cell A2 to make it active.

Step 7B: Check how invalid input is handled.

Step 7Bi: Type in 2109455 and press enter.

Step 7Bii: The error message that you previously created should appear. Select 'Cancel'.

Step 7Biii: Type in abc123 and press enter.

Step 7Biv: The error message that you created in a previous step should appear. Select 'Cancel'.

Step 7Bv: Mouse-over cell A2 and the "Input cues" that you created previously should appear in a yellow popup.

Step 7C: Check how valid input is handled.

Step 7Ai: Type in 4032109455 and press enter. This value should be accepted.

Step 8A: Click in Cell B2 to make it active.

Step 8B: Check how invalid input is handled.

Step 8Ai: Type in 'Humanities' and press enter.

Step 8Aii: When the popup appears select 'Yes'.

Step 8Aiii: Type in 'Kinesiology' and press enter.

Step 8Aiv: When the popup appears select 'Cancel'.

Step 8C: Check how valid input is handled.

Step 8Ci: Type in 'Arts' and press enter.

Step 8Cii: Select one of the faculties from the list such as science.

Marking and grading

• Operating system specific issues: submissions must work on the machines a Windows computers. (For the remote learning semester since access to the lab computers is more challenging: the requirement is that your document works on any Windows computer). It's up to you to test and check this is the case. Non-functional submissions will receive only partial credit (if any at all). Although operating system issues are rare (non-existent?) if you implement your solution on another operating system it's a good idea to check your submission on a Windows computer. (See the administrative video lecture loaded into D2L for the week of Jan. 9 - 15 for suggestions as to how you can do this). Caution for Windows users: take care that you don't accidentally submit a shortcut to a file instead of the actual file. (Check the file name and compare the file size to your original file. Simply downloading the shortcut file as a test won't work because that shortcut will work on your computer but not on anyone else's machine).
• Late assignments or components of assignments: Extensions may be granted for reasonable cases by the course instructor with the receipt of the appropriate documentation (e.g., a statutory declaration with a commissioner of oaths). Location of the online form: [PDF file]. Alternate submission mechanisms (non exhaustive list of examples: email, uploads to cloud-based systems such as Google drive, time-stamps, TA memories) cannot be used as alternatives if you have forgotten to submit work or otherwise have not properly submitted into D2L. Only files submitted into D2L by the due date is what will be marked, everything else will be awarded no credit. The final cut off date after which full assignments will not be accepted is after the maximum progressive penalty (listed below) can be applied.
• Assignment extensions (must be requested before the assignment is due): may be granted for reasonable cases by the course instructor with the receipt of the appropriate documentation (e.g., a sworn declaration signed by a commissioner of oaths). Typical examples of reasonable cases for an extension include: illness or a death in the family. Example cases where extensions will not be granted include situations that are typical of student life: having multiple due dates, work commitments, forgetting or mixing up due date etc. Tutorial instructors (TAs) will not be able to provide extension on their own and must receive permission from the course instructor first. If you request an extension from me let me know the name of your tutorial instructor and the tutorial number [link to : tutorial and TA information) because the markers won't accept late submissions without directly getting an email from me and I need to know who to contact. Also extensions need to be requested before the due date and not afterward.
• How you will be graded for assignments. Because most exercises are fairly simple a marking spreadsheet isn't required. Instead you can find your grade point in the D2L Dropbox and read any comments that the Teaching assistant may have entered.
• Questions or concerns about grades have been released: Assignments will be marked by your tutorial instructor (the "Teaching Assistant" or "TA") for your tutorial section (instructor information listed here as well). When you have questions about marking this is the first person that you should be directing your questions towards. If you still have question after you have talked to your TA, then you can talk to your course (lecture) instructor but please indicate in your email that you first contacted your TA before going into your concerns.

Collaboration:

Assignments must reflect individual work; group work is not allowed in this class nor can you copy the work of others. Some "do nots" for your solution: don't publically post it, don't email it out, don't show it to other students, don't get help with your assignment from a tutor (if you have hired one).  For more detailed information as to what constitutes academic misconduct (i.e., cheating) for this course please read the following [link].

Submitting your work:

D2L configuration for this course

• Do not use compression utilities (such as zip) or archiving utilities (such as tar) otherwise your submission may not be marked. The space savings in D2L is not worth the extra time required by the marker to process each submission.
• How often can you submit: Multiple submissions are allowed for this assignment: You can (and really should) submit work as many times as you wish before the due date. Due dates are strict, only what is in D2L by the deadline is what will be marked. Other methods of verifying that your work was completed on time (e.g. checking timestamps, emailed files etc.) will NOT be accepted. However only the latest versions of each individual document are the ones that will be marked, everything else will be ignored (because it is not fair to your marker to sort through multiple versions of your files). In the case of A1 the marker will just look at the latest version of: Calgary and the merged letter that the marker can 'click through'.

Late submissions for assignments  when there is no extension granted: Make sure you give yourself enough time to complete the submission process so you don't get cut off by D2L's deadline (or your submission will be automatically flagged as late by D2L and it will be graded appropriately)..