AIP203 - Microsoft Office

Prerequisite(s)

KIP103 and LEG303

Topic Outline
EXCEL 
• Complete a basic spreadsheet using the full features of Excels built in shortcuts and productivity functions
• Enhance the spreadsheet using both basic and advanced graphic features
• Work with the basic database features of Excel including sorting and Data Filters.
• Create Single and Multiple Element Functions
• Understand the use of Absolute referencing in Excel Formulas & Functions
• Create Linked worksheets and workbooks that automate the consolidation of data.
• Create Conditional formats
• Work with Excel Pivot Tables
• Create and Edit Excel Charts

POWERPOINT 
• Gain knowledge about graphics in general and how they are incorporated into PowerPoint.
• Plan, Create, and Run a PowerPoint presentation
• Edit slide content and complete a spelling check
• Import graphic objects into your presentations from the Internet and your local file sources
• Add sound and transitions to your presentation
• Learn about key elements of a presentation that can render it ineffective if left unchecked

ACCESS 
• Learn to create and design a basic Access Database
• Work with Tables including features to edit and expand current tables
• Create Select Queries
• Create Access data Forms
• Create Access Reports

Mode of Instruction
During this course student will experience self-directed learning at their own individual pace and contact with the instructor as required. In addition, the opportunity to submit questions and comments both privately and to a public discussion area will be available to everyone. Students will be required to submit assignments and complete a final exam.

Prescribed Texts
All of the course instruction is provided to the students by the instructor through lecture notes for each lesson. No Text book is required.





To find out the cost of books and learning material go here.

Any courses not listed on the bookstore webpage do not require any resources for purchase. All resources will be provided by your instructor.

Reference Material
None

Required Supplies

Student Progression and Promotion Policy

http://www.senecapolytechnic.ca/about/policies/student-progression-and-promotion-policy.html

Grading Policyhttp://www.senecapolytechnic.ca/about/policies/grading-policy.html

A+	90%  to  100%
A	80%  to  89%
B+	75%  to  79%
B	70%  to  74%
C+	65%  to  69%
C	60%  to  64%
D+	55%  to  59%
D	50%  to  54%
F	0%    to  49% (Not a Pass)
OR
EXC	Excellent
SAT	Satisfactory
UNSAT	Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecapolytechnic.ca/about/policies/academics-and-student-services.html) or at Seneca's Registrar's Offices. (https://www.senecapolytechnic.ca/registrar.html).

Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized, correctly formatted and grammatically correct, with proper spelling and punctuation.


Please Note

• Assignments, tests and the final examination are evaluated on subject knowledge as well as correct language usage, organization, and mastery of the subject. 
• In recognition of the significance of proper language skills in the workplace, marks are deducted, in accordance with departmental policy, for language errors on all tests, assignments and exams. (i.e. spelling, grammar, word usage, sentence, and paragraph structure, etc.) 

Assignments

• The student must retain a copy of all assignments.
• If assignments are handed in late without sufficient medical or other reason, which must be documented and approved, two marks per day will be deducted for each day the assignment is late up to a maximum of 10 marks in total. 
• Assignments will not be accepted after the return of graded assignments to the class and/or the provision to the class of the answers to the assignment.
• Written assignments must be word processed. At the professor’s discretion, assignments that are not word processed, may be subject to mark deduction or not accepted. 
• For particulars, please obtain standards, dates, etc. from your instructor.

Evaluation

Based on each student’s demonstrated skill to utilize the required features covered within each of the 10 assignments and the completion of their assignments. Each assignment has two elements:

• Short Answer Questions
• One or more practical exercises to demonstrate the learning for that lesson.

All evaluations are reviewed by the Host College and OntarioLearn. Student feedback via the evaluations provides the foundation for maintaining high standards in all OntarioLearn course.

Absenteeism and Tests

• Students should be aware that absenteeism will impact on their ability to achieve satisfactory grades.
• If you miss a test, you must provide the reason in writing to the instructor within one week. If your reason is accepted, the weighting of that test will be added to that of the final exam.  Otherwise, you will be given a zero for the test. You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence, or other appropriate documentation.
• Progress tests and quizzes may not be announced in advance and details of the assignment requirements may be explained in class.

Final Exam/ Final Assignment

• Students must attain a grade of at least 50% to pass the course.

Academic Honesty

Students at Seneca College are expected to be honest and forthright in their academic endeavours. When students cheat on an examination, steal the words or ideas of another, or falsify their research results, it corrupts the learning process. A Seneca College degree, diploma or certificate signifies to society mastery of a set of defined learning outcomes in a designated field of study. If academic credit is obtained dishonestly, the value of every graduate's diploma in the field of study is diminished, as is the reputation of the college as a whole.

Penalties for Academic Dishonesty

The penalty for a first offence is a grade of '0' on the assignment or examination. The penalty for the second offence is expulsion for a time period determined by the Academic Honesty Committee, normally for a minimum of three semesters. For further information refer to the policies section of the Seneca College student handbook, or to the following website: http://library.senecapolytechnic.ca/Academic_Honesty/

Term Assignments

40% Excel Section

• 5 assignments
• Total assignment marks are factored down to 40% of the Final Grade

15% PowerPoint Section

• 2 assignments
• Total assignment marks are factored down to 15% of the Final Grade

20% Access Section

• 3 assignments
• Total assignment marks are factored down to 20% of the Final Grade

25% Final Exam (Online through the course conference)

• As the exam is designed as an additional learning tool the lecture notes, online help and the software can be used.
• The Exam has 30 short answer questions and requires the completion of an Excel spreadsheet, PowerPoint presentation, and Access Database
• The Exam is timed with a limit of 3 hours and 30 minutes (30 minutes for short answers, and 60 minutes each for the 3 practical exercises.
• If the student submits the Exam after the deadline they will (at the discretion of the instructor) be penalized.
• No proctor required - unless requested specifically by the college.

Assignments found at the end of each lesson are related to the material covered within the lesson allowing each student to demonstrate their individual understanding and skill.

Grading is based on the following marking scheme: 

Excel	40%
PowerPoint	15%
Access	20%
Final Exam	25%

Final Exam Format: Online-no supervision required