OCA303 - Office IV: Excel

Outline info
Last revision date 2018-07-20 13:49:34.232
Last review date 2018-07-20 13:49:43.762

Subject Title
Office IV: Excel

Subject Description
Students continue to improve upon their ability to manipulate software within the Windows environment as they learn the features of Excel 2013. Students learn how to enter, organize, manipulate, calculate, and graph data, and how to format the data to produce attractive presentations. Students enter formulas, including the IF formula, use a variety of Functions, explore What-If analysis, and make web queries. Students create static and dynamic web pages using Excel. In the second half of the subject, students learn how to enhance a worksheet and chart and how to work with multiple worksheets in a workbook. Students study financial functions including data tables, amortization schedules, and hyperlinks. Students create, sort, and query a worksheet database. Students create templates and work with multiple worksheets and workbooks.

Credit Status
This is a credit subject towards certificates in the Office Administration credit programs offered through the Faculty of Continuing Education and Training.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Create a worksheet and embedded chart.

2. Enter formulas, apply functions, apply formatting, and use web queries.

3. Explore What-If analysis, charting, and working with large worksheets.

4. Create static and dynamic web pages using Excel (Web Feature).

5. Use financial functions, create data tables, create an amortization schedule, and add hyperlinks.

6. Create, sort, and query a worksheet database.

7. Create templates and work with multiple worksheets and workbooks.

8. Link an Excel worksheet to a Word document (Integration Feature).

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

For General, Executive and Medical Office Administration Certificates: Office Computer Applications: OCA103
For Administrative Assistant Certificate: Prior Experience with Microsoft Office Programs

It is your responsibility to ensure that program requirements and subject prerequisites as outlined are met. Prerequisites are included for your academic protection. Subject content and your professor's teaching assumes that students are academically prepared and instruction will proceed accordingly. Students lacking prerequisites not only jeopardize their own ability to succeed but present unnecessary interruption. If you lack appropriate prerequisites (or advance standing for the prerequisite subject) you may be asked to withdraw or transfer to a more appropriate subject with the risk of academic/financial penalty.  It is your responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the student's class. 

Topic Outline
The order of the topics is at the discretion of the professor.  The content of one module does not have to be completed before another module is started, nor do the modules have to be taught in the order listed.  Rather by the end of the subject all the topics will have been covered.

Create a worksheet and embedded chart 

  • Start Excel 2013 and describe the Excel worksheet
  • Select a cell or range of cells
  • Enter text and numbers
  • Use the AutoSum button to sum a range of cells
  • Copy a cell to a range of cells using the fill handle
  • Change the size of the font and bold cell entries
  • Apply AutoFormat command to format a range
  • Centre cell contents across a series of columns
  • Use the Name box to select a cell
  • Create a Column chart using the Chart Wizard
  • Save and open a workbook
  • Use the AutoCalculate area to determine totals
  • Correct errors on a worksheet
  • Print a worksheet
  • Use the Office Assistant and other online Help tools to answer questions
Enter formulas, apply functions, apply formatting, and use web queries
  • Enter multiple lines of text in the same cell
  • Enter a formula using the keyboard and using Point mode
  • Identify the arithmetic operators
  • Apply the AVERAGE, MAX, and MIN functions
  • Determine a percentage
  • Verify a formula
  • Change the font, colour the characters, and colour the background of a cell
  • Add borders to a range
  • Format numbers using the Format Cells dialogue box
  • Add conditional formatting to a range of cells
  • Align text in cells
  • Change the width of a column and the height of a row
  • Check the spelling of a worksheet
  • Preview how a printed copy of the worksheet will look
  • Distinguish between portrait and landscape orientation
  • Print a partial or complete worksheet
  • Display and print the formulas version of a worksheet
  • Print to fit
  • Use a Web query to get real-time data from a Web site
  • Rename sheets
  • E-mail the active workbook from within Excel
Explore What-If analysis, charting, and working with large worksheets
  • Rotate text in a cell 
  • Use the fill handle to create a series of month names
  • Copy a cell’s format to another cell using the Format Painter
  • Copy a range of cells to a non adjacent paste area
  • Freeze column and row titles
  • Insert and delete cells
  • Format numbers using format symbols
  • Use the NOW function to display the system date
  • Format the system date
  • Use absolute cell references in a formula
  • Use the IF function to enter one value or another in a cell on the basis of a logical test
  • Copy absolute cell references
  • Display and dock toolbars
  • Add a drop shadow to a range of cells
  • Create and format a 3-D Pie chart on a separate chart sheet
  • Rearrange sheets in a workbook
  • Preview and print multiple sheets
  • Use the Zoom box to change appearance of a worksheet
  • View different parts of the worksheet through window panes
  • Use Excel to answer what-if questions
  • Use the Goal Seek command to analyse worksheet data
Create static and dynamic web pages using Excel  (Web Feature)

Use financial functions, create data tables, create an amortization schedule, and add hyperlinks 

  • Control the colours and thickness of outlines and borders
  • Assign a name to a cell and refer to the cell in a formula by using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Enter a series of percents using the fill handle
  • Create a data table to analyse data in a worksheet
  • Add a pointer to a data table using conditional formatting
  • Determine a present value of a loan using the PV function
  • Create an amortization schedule
  • Analyse worksheet data by changing values
  • Add a hyperlink to a workbook
  • Protect and unprotect cells
  • Analyse worksheet data by goal seeking
Create, sort, and query a worksheet database 
  • Create a worksheet database
  • Add computational fields to a database
  • Use the VLOOKUP function to look up a value in a table
  • Change the range of a name
  • Use a data form to display records, add records, delete records, and change field values in a worksheet database
  • Sort a worksheet database on one field or multiple fields
  • Display automatic subtotals
  • Use a data form to find records that meet comparison criteria
  • Filter data to display records that meet comparison criteria
  • Use the advanced filtering features to display records that meet comparison criteria
  • Apply database functions to generate information about a worksheet database
Create templates and work with multiple worksheets and workbooks 
  • Create and use a template
  • Use the ROUND function
  • Utilize custom format codes
  • Define, apply, and remove a style
  • Copy data among worksheets in a workbook
  • Drill an entry through worksheets
  • Add a worksheet to a workbook
  • Create formulas that use 3-D references to cells in different sheets in a workbook
  • Summarize data using consolidation
  • Draw a 3-D Cone chart
  • Use WordArt to create a title
  • Create and modify lines and objects
  • Add comments to cells
  • Add a header or footer to a workbook
  • Change the page margins
  • Set print titles and options
  • Insert a page break
  • Use the Find and Replace commands
  • Consolidate data by linking workbooks
Link an Excel worksheet to a Word document   (Integration Feature)

Mode of Instruction
Students learn through classroom lectures, hands-on assignments during classroom hours, as well as homework assignments. Students are required to complete assignments and practise the skills they have learned in the lab.

Blended models of delivery may also be available.

Prescribed Texts
Benchmark Series: Microsoft Excel 2013 Level 1 & 2. Latest Edition. EMC Paradigm Publishing. 

Reference Material

Required Supplies

Promotion Policy

Grading Policy
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)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.

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

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.
  • For further information on evaluation and academic standing, see a copy if the Academic Policy available at Seneca Registration offices.
Field Placement Requirements

Students who do not successfully complete all professional subjects may not be eligible for placement. 

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.senecacollege.ca/Academic_Honesty/.

Grading is based on the following marking scheme: 

Lab Assignments 10%
Term Tests (2 @ 30% each) 60%
Final Exam 30%

Materials permitted into tests and exams are at the discretion of the instructor.

Approved by: Sandra Noble