Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Lab Manual/CPSC203 Lab Quiz 1 on Spreadsheets

Instructions for Students

 * 1) PREPARATION. Review the previous labs in this module (and the TA examples), it 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 Name 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 Excel and is Open Book. Students may use Excel's Help facility, but not the Internet.
 * 6) SETUP. The TA will dispense a handout to each student. The quiz will also be displayed on a projector.  Carefully read each question.  NOTE: ALL handouts must be collected back at the end of class and have their with their Name and Signature filled in. There is a zero tolerance policy to academic misconduct.
 * 7) Lab Quiz. Students have 50 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 Name 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.
 * 10) 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 Name and Signature fields on the handout.
 * 4) CONTEXT. Explain the quiz quickly (see background information above)
 * 5) FORMAT. The quiz is done in Excel and is Open Book. Students may use Excel’s 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. The quiz will also be displayed on a projector.  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 50 minutes to do the quiz and submit it. At 45 minutes – remind students to submit the exam. At 50 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 Name and Signature filled in.
 * 9) MARKING. Mark only those submitted quizzes that match signed handouts  and whose date-stamp indicates the quiz was completed in class.
 * 10) SPECIAL ARRANGEMENTS/PROBLEMS. See your instructor regarding any students requiring special arrangements, or any problems that occur with respect to conducting the Lab Quiz.

Excel Lab Quiz on Spreadsheets
Excel Lab Quiz are scheduled for the 2nd tutorial the week of MONTH DAY YEAR

Skill List for Excel is:


 * Type in some basic data – used for rest of the quiz


 * Autofill a field(s)


 * Set up appropriate Field formats (Currency, Numbers, Text, etc.)


 * Calculate Basic Statistics (Min, Max, Average, SD, Median)


 * Use Chart Wizard to do a default chart on a data set.


 * Customize a chart according to good chart design principles


 * Do a custom calculation using a formula (possibly in several steps)


 * Use a nested If ... Then statement to define classes.


 * Use a Lookup table to define classes.


 * Use the vlookup function.


 * Summarize data in a Pivot table.


 * Sorting and filtering data.

Marking Sheet
Marking Sheet for Lab Quiz Excel have been emailed to TA's. Please follow the marking guidelines for grading the quiz.