City College of San Francisco
Course Outline of Record
Course Status: Active
I. GENERAL DESCRIPTION
A. Approval Date September 2016
B. Effective Semester Spring 2017
C. Department Business
D. Course Number COMP 9909
E. Course Title Microsoft Excel for Business III
F. Course Outline Originator Stephanie Rosenberg
G. Department Chairperson Ophelia Clark
H. Dean Kimberly D. Harvell
II. COURSE SPECIFICS
A. Hours
45 total
B. Prerequisite COMP 9904
    Corequisite None
    Pre/Corequisite None
    Advisory None
    Advisory Pre/Corequisite Completion of or concurrent enrollment in: ESLN 3500
C. Course Justification Topics covered in this course are basic requirements for accounting-related and general office support employment.
D. Field Trips No
E. Method of Grading Letter or Pass/No Pass or Satisfactory Progress
F. Repeatability As needed
III. CATALOG DESCRIPTION
Students learn advanced spreadsheets formulas and formatting techniques and will concentrate on various Excel applications including formula auditing, PivotTables, PivotCharts, and macros.
IV. STUDENT LEARNING OUTCOMES
Upon completion of this course, a student will be able to:
  1. Automate repetitive tasks using the Excel macros options.
  2. Perform advanced formatting and formulas in Excel.
  3. Create PivotTables, PivotCharts and Sparklines in Excel.
  4. Import and export text files using Excel.
  5. Explain Excel functions related to accounting and office support.
V. CONTENTS

  1. Advanced formatting
    1. Numbers and alphanumeric
    2. Fractions
    3. Scientific
    4. Special number
    5. Custom number
  2. Text formatting
    1. PROPER, UPPER and LOWER
    2. SUBSTITUTE and CONCATENATE
    3. RIGHT, LEFT, MID and TRIM
  3. Advanced formulas and functions
    1. Statistical
      1. COUNTA
      2. COUNTIF and COUNTIFS
      3. AVERAGEIF and AVERAGEIFS
    2. Math and Trigonometry
      1. SUMIF and SUMIF
      2. POWER
      3. PI
    3. Financial Functions
      1. PPMT
      2. IPMT
    4. Logical Functions
      1. Nested
      2. AND and OR
  4. Summarize and consolidate data
    1. PivotTables
      1. Slicers
      2. Timelines
      3. Summary Functions
    2. PivotCharts
      1. From PivotTable
      2. From Insert tab
    3. Sparklines
      1. Add
      2. Customize
  5. Formula Auditing
    1. Trace precedents
    2. Trace dependents
    3. Error checking
  6. What-if analysis
    1. Trial and error
    2. Goal seek
    3. Solver
  7. Macros
    1. Assign
    2. Enable/Disable
    3. Record
    4. Run
    5. Manage
  8. Import, export and distribute data
    1. Import
      1. Access
      2. Website
      3. Text File
    2. Export
      1. Access
      2. Word
      3. PowerPoint
      4. Text File
    3. Distribute workbooks
      1. Publish to PDF
      2. Publish to XPS
      3. Publish to Web page
  9. Function Research
    1. Function Library
    2. Microsoft Excel Help

VI. INSTRUCTIONAL METHODOLOGY
  1. Assignments
    1. In-class assignment: Participation in instructor-guided projects practicing Excel skills such as formatting, functions, and PivotTables, including chapter lessons from textbook and/or instructor-generated handouts, and case studies such as creating and printing macros, importing data from Microsoft Access, and summarizing data using 3-D references.
    2. In-class assignment: Research a "Function" not previously covered in class, and deliver a short presentation to the class.
    3. Out-of-class assignment: Completion of any assignments such as assigned reading of text (including concept review) or handouts.
    4. Out-of-class assignment: Completion of projects that were begun in class as specified above.
  2. Evaluation
    1. Exams/Quizzes/Tests: Quizzes/Exams assessing students' knowledge on all content areas.
    2. Performance: Completion of hands-on assignments described above.
    3. Presentation: Assessment of students' ability to explain Excel functions.
  3. Representative Textbooks and Other Instructional Materials
    1. Rutkovsky, Seguin, Davidson, Roggenkamp, Rutkovsky. 2016. Benchmark Series Microsoft Excel Levels 1 & 2. Paradigm Education Solutions.
    2. Freund, Starks, Schmeider. Microsoft Office 365 Excel. Cengage Learning.
    3. Instructor-generated handouts from Excel Help Menu such as "Excel keyboard shortcuts and functions keys."