ChabotCollege

Course Outline for Computer Application Systems 54A, Page 2

Fall 2010

ChabotCollege Fall 2010

Course Outline for Computer Application Systems 54A

MICROSOFT EXCEL I

Catalog Description:

54A – Microsoft Excel I3 units

Introduction to spreadsheet techniques using Microsoft Excel to create a variety of spreadsheets with emphasis on business application programs. Calculate data using functions and formulas. Create charts, link and consolidate worksheets. This course prepares students to take the Microsoft Office Specialists (MOS) core level certification. Strongly recommended: Computer Application Systems 50, Computer Application Systems 72E, or Computer Science 8. 2 hours lecture, 2 hours laboratory.

[Typical contact hours: lecture 35, laboratory 35]

Prerequisite Skills:

None

Expected Outcomes for Students:

Upon completion of the course the student should be able to:

  1. identify parts of a worksheet, using menus, ribbon tabs, office button;
  2. create workbooks, and multiple worksheets;
  3. format worksheets with themes, fonts styles, text color, patterns;
  4. enter data, construct IF functions, financial functions, and format numbers for accounting;
  5. adjust column widths, apply conditional formatting, insert footers;
  6. copy, paste, move cell contents, use absolute cell references;
  7. name ranges, sort and filter data, convert text into columns;
  8. check for spelling errors, use accuracy tools;
  9. find, replace,and merge data;
  10. create save, manage files and folders;
  11. use dates, times, and financial functions;
  12. create and print various types of excel charts;
  13. save worksheets in delimited format, link data;
  14. control print options, print formulas, preview and modify page breaks.
  1. Course Content (Lecture):
  1. Worksheets, workbooks
  2. Formulas, functions
  3. Range names, sorting
  4. Advanced formulas and functions
  5. Charts and maps
  6. Multiple worksheets
  7. Linked and consolidated Worksheets
  8. Printing
  1. Course Content (Laboratory):
  1. Concepts based assessments
  2. Hands-on tutorials
  3. Hands-on laboratoryexercises
  4. Projects

Methods of Presentation:

  1. Lecture
  2. Classroom discussions
  3. Computer demonstrationsoverhead projector
  4. PowerPoint slides presentations
  5. Visual aids - overlays

Assignments and Methods of Evaluating Student Progress:

  1. Typical Assignments
  2. Work through end-of-chapter outcomes-based assessments
  3. Learn to add custom buttons using the Quick Access Toolbar
  4. Create multiple worksheets, workbooks
  5. Enhance worksheets
  6. Construct a file management system to save Excel files and folders
  1. Methods of Evaluating Student Progress
  2. Laboratory assignments
  3. Projects
  4. Outcome based assessments
  5. Participation
  6. Quizzes
  7. Final examination

Textbook(s) (Typical):

Go with Excel 2007 Comprehensive, Gaskin, Jolly, Prentice Hall, 2007

Special Student Materials:

Portable storage device

JOT

CAS 54A course outline

Revised: Oct2004, Nov2004, Jul2009