MCW144 - Excel Level III

Outline info
Semester
School
Last revision date 2017-10-30 12:46:05.109
Last review date 2017-10-30 12:46:05.111


Subject Title
Excel Level III

Subject Description
This advanced subject introduces topics to increase productivity. Participants collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

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. Increase productivity and improve efficiency by streamlining your workflow.
2. Collaborate with others using workbooks.
3. Audit worksheets.
4. Analyze data.
5. Work with multiple workbooks.
6. Import and export data.
7. Use Excel with the web.
8. Structure workbooks with XML.

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 and MCT142 or MCW142 or equivalent experience. 

Topic Outline

Lesson 1: Streamlining Workflow

  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbook's Properties
  • Modify Excel's Default Settings

Lesson 2: Collaborating with Others
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Lesson 3: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Lesson 4: Analyzing Data
  • Create a Trendline
  • Create Scenarios
  • Perform What-If Analysis
  • Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 6: Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File

Lesson 7: Using Excel with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

Lesson 8: Structuring Workbooks with XML
  • Develop XML Maps
  • Import and Export XML Data

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 III + 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