Here is a printable version of the course outline.

Instructors

Andria Hunter (weeks 1-8)	andria@utsc.utoronto.ca	Office: H-420	Phone: 416-208-4748
Kersti Wain-Bantin (weeks 9-12)	wainbantin@utsc.utoronto.ca	Office: S-625A	Phone: 416-287-5653

Lectures:

Monday 12-1pm Room H-214

Instructor Office Hours:

Monday 11:00am-12pm (in office)
Monday 1-2pm (in office)
Wednesday 11-1pm (in office)

Tutorials

Please attend the tutorial section in which you are registered.

Section	Day	Time	Teaching Assistant	Lab Room
T0001	Mon	1-3pm	Calvin Wong	B-471
T0007	Wed	9-11am	Calvin Wong	B-471

Tutorial Office Hours:

Thursday 3-4pm in B-482

Course Web Sites

Main:	http://www.utsc.utoronto.ca/~andria/a01f07/	à outline, lecture material and readings, tutorial material, assignment descriptions, quiz information, relevant links
Blackboard:	http://portal.utoronto.ca/	à announcements, submit assignments, online quizzes, online manuals, view marks

Text Books

1. CSCA01 Course Package, Version 1.0, by A. Hunter (available from your instructor for $30)
2. Microsoft Office Online Manuals, Global Knowledge Inc. (available from Blackboard for free)

Weekly reading assignments are on the Lectures web page on the course web site.

Software — major coverage

• Microsoft Word 2003
• Microsoft PowerPoint 2003
• Dreamweaver 8
• Microsoft Excel 2003
• Visual Basic for Applications (VBA) — lecture mainly
• Microsoft Access 2003

Software — minor coverage (lecture only)

• HTML
• FTP
• DOS and UNIX
• desktop publishing: Microsoft Publisher 2003
• graphics: Corel Paint Shop Pro Photo XI
• audio: Windows Media Player
• video: Windows Movie Maker
• PDF creation: Adobe Acrobat 8 Pro
• file compression/extraction
• CD/DVD burning
• Microsoft Office 2007 — brief introduction

Course Objectives

As this is a non-credit course, your mark in the course will not be calculated into your GPA. You will be given either a PASS or a FAIL as your mark in this course. This course will appear on your transcript, but it will not be counted towards your 20 FCEs.

As the title of this course suggests, the focus is on learning computer skills that will help in your co-op work placements and in future jobs that you might have. The empahasis is on hands-on learning, and thus, more of an emphasis is given to learning in a tutorial (computer lab) setting than in a lecture hall.

This course assumes that students have a basic knowledge of using computers. We assume that students have used Microsoft Word, PowerPoint, and Excel. If you have never used these packages, you should consult the online manuals (available from Blackboard) prior to the beginning of these tutorials. The focus will be on learning more advanced Microsoft Word, PowerPoint, and Excel that will take your computer skills to the next level.

We assume no prior knowledge of HTML, Dreamweaver, VBA, and Microsoft Access. We start our coverage of these software packages at an introductory level, and bring you up to an intermediate level. For VBA, we assume that you have not had any prior programming experience.

In addition to learning the software packages listed above to at least a moderate proficiency level, after successful completion of this course you will:

• be more marketable in the workplace
• have improved your skills to think critically and analytically
• be able to appraise components of a job or project, and determine which "information management" application best meets the requirements of that specific project, as well as the needs of the organization
• have a better understanding of manipulating digital images
• be able to integrate the results from different software packages
• be more comfortable using computers and have a better understanding of file and data management

Schedule

Please note that this schedule is subject to change.

Weeks	Date	Lectures	Tutorials	Due (approximately)
1	Sept 10	Introduction	MS Word
2	Sept 17	Desktop Publishing: MS Publisher	MS PowerPoint	Q1: Word
3	Sept 24	HTML	Dreamweaver	Q2: PowerPoint A1: Word/PowerPoint
4	Oct 1	HTML	Dreamweaver	Q3: Publisher
5	Oct 8 *	Graphics: Corel Paint Shop Pro	Dreamweaver	Q4: HTML
6	Oct 15	Graphics: Corel Paint Shop Pro	MS Excel	Q5: Dreamweaver
7	Oct 22	MS VBA	MS Excel	A2: Graphics/HTML/       Dreamweaver
8	Oct 29	MS VBA	MS Excel	Q6: Graphics
9	Nov 5 #	MS VBA (2 lectures)	MS Excel
10	Nov 12	MS Access	MS VBA	Q7: Excel A3: Excel
11	Nov 19	Integration	MS Access	Q8: VBA
12	Nov 26	MS Office 2007	Review MS Access/Integration	Q9: Integration/Office2007
		STUDY BREAK		Q10: Access A4: VBA/Access/Integration

* Lectures, tutorials, and office hours will be cancelled on Mon Oct 8^th for the Thanksgiving holiday. The lecture has been moved to Wed Oct 10^th from 11am-12pm in room H-214. The two tutorial sections will be combined that week, so all students should attend the tutorial on Wed Oct 10^th from 9-11am.

# Although there is generally only 1 hour of lecture per week, a second lecture may be required on Wed. Nov. 7th from 11am-12pm in room H-214 in order to cover all of the VBA lecture material. If this lecture is needed, an announcement will be posted.

Mark Breakdown

This is a non-credit course. Your final mark in the course will be either a pass or a fail.

Item	Weight (%)	Due Date	Topic(s)
Assignment 1	15	Sun Sep 30 at 11:59pm	Word and PowerPoint
Assignment 2	25	Sun Oct 28 at 11:59pm	Graphics, HTML, and Dreamweaver
Assignment 3	25	Sun Nov 18 at 11:59pm	Excel
Assignment 4	25	Mon Dec 3 at 11:59pm	VBA, Access, and Integration
Quiz 1	1	Fri Sep 21 at 11:59pm	MS Word
Quiz 2	1	Fri Sep 28 at 11:59pm	Presentations and MS PowerPoint
Quiz 3	1	Fri Oct 5 at 11:59pm	Desktop Publishing and MS Publisher
Quiz 4	1	Fri Oct 12 at 11:59pm	Web Design and HTML
Quiz 5	1	Fri Oct 19 at 11:59pm	Dreamweaver
Quiz 6	1	Fri Nov 2 at 11:59pm	Graphics and Corel Paint Shop Pro
Quiz 7	1	Fri Nov 16 at 11:59pm	MS Excel
Quiz 8	1	Fri Nov 23 at 11:59pm	MS VBA
Quiz 9	1	Fri Nov 30 at 11:59pm	Integration and MS Office 2007
Quiz 10	1	Mon Dec 3 at 11:59pm	Databases and MS Access

Assignments:

Each assignment will be marked out of 5 marks. You will be given a mark as follows:

0: not submitted or extremely poor
1: poor
2: fair
3: satisfactory
4: very good
5: excellent

You must obtain at least 2 out of 5 on each assignment. This means that if you fail to submit any assignment in this course, you will fail the course -- afterall, prospective employers who know you have passed this course will expect at least a fair proficiency level in the various software packages covered in this course. Your average mark for the four assignments must be at least 2.5 out of 5.

Online Quizzes:

There will be an online quiz for each topic in the course, available from Blackboard. These are open-book quizzes that you can complete on your own time. You must complete these quizzes by yourself. You will be given 1 hour to complete each quiz.

Each quiz will usually have 10 questions and account for 1% of your mark in this course. Your average quiz mark for the 10 quizzes must be at least 5 out of 10.

Assignments

• Start them early. Around the due date, the demand for PCs and printers may exceed the number available at the computer labs; temporary computer system glitches are not a valid excuse for a late assignment.
• All asignments in this course may be completed at home, if you have the appropriate software. Please keep in mind that problems with your PC do not constitute a valid excuse for a late assignment.
• Make frequent backup copies of your assignment, as you are working on it. Always keep a backup copy of the final version of each assignment that you submit. This will allow you to verify your submission in case there are any problems at a later time.

Plagiarism

• Although you may discuss general approaches to assignments with your classmates, the work you submit must be 100% yours. This means that you should not take notes while discussing the assignments with your classmates.
• Be sure to guard your assignment at all times; i.e. pick up your printouts immediately after printing your assignment on a public printer and do not dispose of your rough work on campus.
• Should you have any questions about plagiarism, please read the students' code of conduct in the calendar and/or talk to your instructor.

Late Assignments

• The following late penalty will be applied to each of your assignments: you will lose 0.5 mark (out of 5) per day that the assignment is submitted late. Late submissions are only accepted up until 5 days after the assignment was due.
• If you are unable to submit an assignment on time due to medical reasons, contact your instructor well ahead of the assignment's due date to inform her of your situation. Please submit your assignment as soon as you are able, and upon your return back to school, give a completed UTSC Medical Certificate (completed by your doctor) to your instructor (not to your TA). Be aware that doctors' notes are periodically verified.

Assignment Re-Marks

• If you need to have an assignment re-marked, you MUST fill out an assignment re-mark request form, which you will find on the course web site. If an assignment re-mark form has not been completed, we reserve the right to not re-mark your assignment. Assignment re-mark request forms must be submitted within 2 weeks of the date that the assignment was returned.

AccessAbility Services

• Students with diverse learning styles and needs are welcome in this course. In particular, if you have a disability/health consideration that may require accommodations, please feel free to approach me and/or the AccessAbility Services office (416-287-7560 or ability@utsc.utoronto.ca) as soon as possible.
• The UTSC AccessAbility Services staff are available by appointment to assess specific needs, provide referrals and arrange appropriate accommodations.
• The sooner you let us know your needs, the quicker we can assist you in achieving your learning goals in this course.

Contact Information

• The instructor can be contacted during office hours and by e-mail.
• Given the large number of e-mail messages received on a regular basis, it is imperative that your message be kept short, clear, and concise, with "CSCA01" as part of your subject line. If you have not made an effort to make sure your message is clear, it will not be answered. If you are sending e-mail from an account other than your UTSC e-mail account, you must include your full name (as printed on your student ID card) and student number at the end of your message.
• If the answer to your question has already been discussed in the course, the instructor is not obligated to reply. Therefore, attending both lectures and tutorials is important. Be sure to check the Blackboard web site for announcements frequently.
• The TAs are not responsible for responding to e-mail. They may only be contacted during their tutorials and office hours, unless they give you permission otherwise.
• E-mail is only answered two or three times per week; do not expect an immediate response, especially on the weekends and close to assignment deadlines. We reserve the right to ignore e-mail messages that do not conform to the rules listed above.