Courses/Computer Science/CPSC 203/CPSC 203 Template/Labs Template/Lab Quiz on Databases

Instructions for Students

 * 1) PREPARATION. Review the previous labs in this module. This will prepare you for the Lab Quiz.
 * 2) ARRIVAL. Arrive early for your Tutorial, so you will have the full tutorial to do the Lab Quiz.
 * 3) ATTENDANCE. Using FOIP guidelines (if you are unsure – ask your instructor) attendance will be taken. In this case – students must fill in their FirstName, LastName, Student# and Signature fields on the handout. Please ensure you also have your Student ID card with you.
 * 4) CONTEXT. The TA should explain to you quickly what the Lab Quiz will entail, listen carefully.
 * 5) FORMAT. The Lab Quiz is done in Access and is Open Book. Students may use Access' Help facility, but not the Internet.
 * 6) SETUP. The TA will dispense a handout to each student. Carefully read each question.  NOTE: ALL handouts must be collected back at the end of class and have their FirstName, LastName, Student#, and Signature fields filled in.  There is a zero tolerance policy to academic misconduct.
 * 7) Lab Quiz. Students have 45 minutes to do the Lab Quiz and submit it using Blackboard. At 45 minutes – submit the exam. At 50 minutes – the Lab Quiz will be finished. Late submissions will not be accepted.
 * 8) SUBMISSION. At the end of submission: All computers should be shut down, and no student is allowed to leave the class unless they have handed back their signed handout directly to the TA. ALL handouts must be collected back at the end of class and have their FirstName, LastName, Student#, and Signature fields filled in.
 * 9) MARKING. Marking will only be performed on those submitted quizzes that match signed handouts  and whose date-stamp indicates the Lab Quiz was completed in class.


 * 1) SPECIAL ARRANGEMENTS/PROBLEMS. See your TA and Instructor if you require special arrangements, or any problems that occur with respect to conducting the Lab Quiz

Instructions for TAs

 * 1) Do the quiz yourself, so you can experience what the students will go through.
 * 2) ARRIVAL. Arrive early for your Tutorial, so students have the full tutorial to do the Lab Quiz.
 * 3) ATTENDANCE. Take attendance using FOIP guidelines (if you are unsure – ask your instructor). In this case – students must fill in their FirstName, LastName, Student# and Signature fields on the handout.
 * 4) CONTEXT. Explain the quiz quickly (see background information above)
 * 5) FORMAT. The quiz is done in Access and is Open Book. Students may use Access’ Help facility, but not the Internet.
 * 6) SETUP. Hand a copy of the handout to each student. Do not simply place the handouts in a pile, as students may attempt to obtain an extra copy. Ask students to carefully read each question. Explain to students that: ALL handouts must be collected back at the end of class and have their FirstName, LastName, Student#, and Signature fields filled in.  Let  students know  that there is a zero tolerance policy to academic misconduct.
 * 7) QUIZ. Students have 45 minutes to do the quiz and submit it. At 40 minutes – remind students to submit the exam. At 45 minutes – enforce the quiz submission.
 * 8) SUBMISSION. Submission procedures will vary depending on instructor. Check with your instructor how they wish this quiz to be submitted. Common methods would be for instructors to set up an quiz link in Black Board (or equivalent course ware) or have students submit directly to their TAs. During submission, walk behind rows to ensure no students are attempting to email their solutions to others. At the end of submission: All computers should be shut down, and no student is allowed to leave the class unless they have handed back their signed handout directly to the TA. ALL handouts must be collected back at the end of class and have their FirstName, LastName, Student#, and Signature fields filled in.
 * 9) MARKING. Mark only those submitted quizzes that match signed handouts  and whose date-stamp indicates the quiz was completed in class.


 * 1) SPECIAL ARRANGEMENTS/PROBLEMS. See your instructor regarding any students requiring special arrangements, or any problems that occur with respect to conducting the Lab Quiz.

Lab Quiz on Databases
Skill List for Access is:

1.Type in some basic data into several tables

2.Set table field types and default values

3.Define Primary and Foreign keys for each table

4.Do a query selecting fields across tables (setting Join conditions)

5.Do a query with multiple constraints (Where clause)

6.Do an aggregate query including basic statistics (Group By clause)

7.Do an aggregate query with multiple constraints (Having clause)

8.Summarize data via a Crosstab query

9.Do a custom calculation within a query

10.Do an IF ... Then statement within a query.