MCW142 - Microsoft Excel Level II Workshop

Outline info
Semester
School
Last revision date 2017-10-30 12:45:22.858
Last review date 2017-10-30 12:45:22.859


Subject Title
Microsoft Excel Level II Workshop

Subject Description
Participants review basic Excel concepts and build on further enhancing workbooks. The use of advanced functions, inserting and formatting charts and organizing information with Excel Tables will be explored. Other topics include using Pivot Tables and Pivot Charts, inserting graphic objects and customizing workbooks.

Credit Status
Participating students who attend at least 70% of the scheduled class(es) receive a document confirming he/she attended this workshop.

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

1. Calculate with advanced formulas.
2. Organize worksheet and table data using various techniques.
3. Create and modify charts.
4. Analyze data using Pivot Tables and Pivot Charts.
5. Insert graphic objects.
6. Customize and enhance workbooks and the Microsoft Office Excel environment.

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.

Discrimination/Harassment
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.

Prerequisite(s)
MCT140 or MCW140 or equivalent experience. 

Topic Outline

Lesson 1: Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions


Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet
  •  

Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts


Lesson 4: Analyzing Data Using Pivot Tables and Pivot Charts
  • Create Pivot Table Reports
  • Analyze Data Using Pivot Charts


Lesson 5: Inserting Graphic Objects
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects


Lesson 6: Customizing and Enhancing Workbooks and Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

Mode of Instruction
Classroom instruction and extensive hands-on experience will be provided with each participant having exclusive use of a computer.
Additional modes of instruction will include class discussion and question and answer period. 

Prescribed Texts
The following course materials will be provided:
Excel 2016 - Level II + Data CD

Required Supplies
USB Flash Drive 

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)
OR
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
There is no formal testing or process to evaluate the students understanding. It is up to the student to evaluate his/her own progress. Students must attend 70% of the class(es) to receive a document confirming he/she attended this workshop.

Approved by: Denis Gravelle