City College of San Francisco
Course Outline of Record
Course Status: Active
I. GENERAL DESCRIPTION
A. Approval Date April 2016
B. Effective Semester Spring 2017
C. Department Business
D. Course Number COMP 9904
E. Course Title Microsoft Excel for Business II
F. Course Outline Originator Shuk-Han Lau
G. Department Chairperson Ophelia Clark
H. Dean Wendy Miller
II. COURSE SPECIFICS
A. Hours
45 total
B. Prerequisite None
    Corequisite None
    Pre/Corequisite None
    Advisory ESLN 3600 or placement in ESLN 3700
    Advisory Pre/Corequisite None
C. Course Justification This is a course that emphasizes spreadsheet intermediate techniques using Microsoft Excel. This course is a requirement towards the Computerized Accounting Specialist certificate programs and serves as a foundation course for further study of spreadsheets.
D. Field Trips No
E. Method of Grading Letter or Pass/No Pass or Satisfactory Progress
F. Repeatability As needed
III. CATALOG DESCRIPTION
A comprehensive course providing proficiency in using spreadsheet software to solve business problems. Students learn enhanced worksheet design for business applications, database management techniques, and creating and executing simple and complex macros.
IV. STUDENT LEARNING OUTCOMES
Upon completion of this course, a student will be able to:
  1. Customize SmartArt to convey ideas, processes and data relationships.
  2. Protect workbooks and worksheet contents.
  3. Create formulas that summarize data from multiple worksheets.
  4. Create and format tables from worksheet data.
  5. Record and run macros to automate tasks.
V. CONTENTS
  1. Managing large worksheets
    1. Sorting worksheet data
      1. Headers and footers
      2. Title rows and title columns
    2. Inserting and removing page breaks
      1. Editing page breaks
      2. Moving page breaks
  2. Worksheet graphics
    1. Pictures and ClipArt
      1. Moving images
      2. Scaling and cropping images
    2. Images special effects
      1. Shapes and constrain objects
      2. SmartArt
  3. Adding protection to workbooks
    1. Worksheet elements
      1. Password protection
      1. Protection tab
    2. Workbook elements
      1. Password protection
      2. Protection tab
  4. Multiple-sheet workbooks
    1. Default number of sheets
      1. Linking cells and formulas
      2. Cells from other worksheets
      3. Cells from other workbooks
    2. Copying worksheets
      1. Moving or copying dialog box
      2. Deleting worksheets
      3. Copying formats between worksheets
    3. Naming cells and ranges
      1. Defined names
      2. Naming rules
    4. Modifying and deleting defined names
      1. Hyperlinks
      2. Types of hyperlinks
      3. Hyperlink dialog box
      4. Editing and removing hyperlinks
    5. Printing multiple-sheet workbooks
      1. Page setup options
      2. Entire workbook sheets
      3. Selected workbook sheets
      4. Previewing worksheets
  5. Tables and outlines
    1. Tables
      1. Table rows
      2. Table columns
    2. Creating a table
      1. Converting a range to a table
      2. Renaming a table
      3. Header and total rows
      4. Formatting a table
      5. Adding and deleting rows and columns
    3. Structured references
      1. Formulas with structured references
      2. View structured references
    4. Sorting and filtering
      1. Outline feature
      2. Groups manually
    5. Subtotals
      1. Sorting a list
      2. Subtotal dialog box
      3. Outline bar
  6. Macros
    1. Macro security and security levels
      1. Recording and naming macros
      2. Sorting macros
      3. Current workbook
      4. Personal macro workbook
    2. Running macros
      1. Assigning macros to custom buttons
      2. Assigning macro to shortcut keys
  7. Financial functions, data tables and amortization schedules
    1. Worksheet data
      1. Table titles and column titles
      2. A percent series
      3. Formulas in the data table
      4. Defining and formatting the data table
    2. Creating an amortization schedule
      1. Column widths
      2. A series of integers
      3. Formulas in the amortization schedule
      4. Formatting the amortization schedule
      5. Loan data
VI. INSTRUCTIONAL METHODOLOGY
  1. Assignments
    1. In-class assignment: Participation in instructor-led labs and concept review.
    2. In-class assignment: Participation in instructor-led demonstrations such as adding protection to workbooks, or linking cells from other worksheets.
    3. In-class assignment: Completion of practice exercises and project assignments on topics such as creating spreadsheets with macros, or creating a workbook with multiple worksheets
    4. Out-of-class assignment: Completion of in-class assignments not completed in class such as creating spreadsheets with headers and footers, or creating formulas in the Data Table
    5. Out-of-class assignment: Reading from textbooks and handouts on topics such as using subtotals, or recording and naming macros
  2. Evaluation
    1. Exams/Quizzes/Tests: Tests and quizzes on topics such as creating defined names, or creating hyperlinks
    2. Performance: Successful completion and submission of in-class assignments such as applying password protection, or inserting shapes and constraining objects
    3. Performance: Completion of assigned exercises or projects such as creating the personal macro workbook, or protecting workbook structure and windows
    4. Participation: Participation in class discussion on topics such as inserting page breaks, or creating SmartArt
    5. Final Assessment: Final exam based on chapter problems such as creating an amortization schedule, or using security level to change Macro security and working with security levels.
  3. Representative Textbooks and Other Instructional Materials
    1. Steven M. Freund. Microsoft Office 365 & Excel. Cengage Learning.
    2. Gaskin & Vargas. GO! with Microsoft Excel, Comprehensive. Pearson Higher Education.