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 9900
E. Course Title Microsoft Excel for Business I
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 an introductory course that emphasizes spreadsheet basics using Microsoft Excel. This course is a requirement towards the Computerized Accounting Specialist certificate program 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 introduction to using spreadsheet software to solve business problems. Students learn to set up, format, save, and print spreadsheets. Additional topics include using logical and mathematical functions and creating graphs from spreadsheet data.
IV. STUDENT LEARNING OUTCOMES
Upon completion of this course, a student will be able to:
  1. Create formulas to calculate values, using the proper syntax and order of operations.
  2. Use relative and absolute cell references in formulas.
  3. Use a variety of methods to format a worksheet.
  4. Enter, format, and manipulate date and time data using appropriate formats and functions.
  5. Create, modify, format, and style a variety of charts.
V. CONTENTS
  1. Excel basics
    1. Starting Excel
      1. The Excel program window
      2. Navigation in a worksheet
      3. Mouse and keyboard
      4. The Go To command
    2. Tabs and ribbons
      1. Office button
      2. Quick access toolbar
    3. Displaying tabs and working with ribbons
      1. Dialog box launchers
      2. Hiding the ribbon
    4. Entering data in Excel
      1. Data types
      2. Completing cell entries
      3. Using the enter and cancel buttons
    5. Working with numbers
      1. Formatting numbers
      2. Decimals and negative numbers
    6. Saving concepts
      1. The save and save as command
      2. Locating saved workbooks
    7. Closing workbooks
      1. Closing worksheets
      2. Exiting Excel
  2. Editing and printing worksheets
    1. Editing entries
      1. Replacing entries
      2. Deleting characters
      3. The formula bar
      4. In-cell editing
    2. Selecting cells and ranges
      1. Click and drag selections
      2. Multiple ranges
    3. Moving and copying cells
      1. Drag and drop
      2. Right dragging
      3. Using copy, cut and paste
      4. Undo and redo
      5. Clearing a cells contents and formats
    4. Auto features
      1. AutoFill
      2. AutoComplete vs. AutoFill
    5. Excel views
      1. Page layout view
      2. Normal view
      3. Zoom control
    6. Printing worksheets
      1. Print preview
      2. Printing selections
      3. Printing options
  3. Formulas and functions
    1. AutoSum
      1. Status bar functions
      2. Customization
    2. Creating formulas
      1. Formula syntax
      2. Cell and range references
      3. Formula algebraic hierarchy
    3. Cell references
      1. Relative cell references
      2. Absolute cell references
      3. Mixed references
  4. Formatting the contents of cells
    1. Formatting entries with the ribbon
      1. Mini toolbar
      2. Live preview
    2. Alignment and indent features
      1. Aligning entries
      2. Indenting cell entries
    3. Text control options
      1. Merging and splitting cells
      2. Merge and center command
      3. Wrapping text
      4. Shrinking text to fit within a cell
    4. Formatting numbers
      1. Number command group
      2. Accounting vs. currency styles
      3. Displaying negative numbers
    5. Format cells dialog box
      1. Format painter tool
      2. Formatting with themes
    6. Date functions
      1. Serial numbers
      2. Entering dates
  5. Worksheet appearance
    1. Modifying columns and rows
      1. Setting standard column widths and standard row heights
      2. AutoFit
      3. Inserting and deleting columns, rows, and cells
      4. Hiding columns and rows
    2. Vertical alignment
      1. Setting vertical alignment
      2. Rotating text
    3. AutoCorrect
      1. Creating AutoCorrect entries
      2. Editing AutoCorrect entries
    4. Excel help feature
      1. The help box
      2. The help window toolbar
    5. Using proofing tools
      1. Spell checking
      2. Thesaurus
      3. Translation
  6. Excel charts
    1. Managing worksheets
      1. Inserting and deleting worksheets
      2. Rearranging worksheets
      3. Renaming worksheets
      4. Modifying worksheet tabs
    2. Creating charts
      1. Chart engine
      2. Chart types
      3. Chart tools
      4. Moving, sizing, and deleting embedded charts
    3. Modifying existing charts
      1. Changing chart types
      2. Modifying chart elements
      3. Formatting charts
      4. Applying styles to charts
      5. Printing charts
VI. INSTRUCTIONAL METHODOLOGY
  1. Assignments
    1. In-class assignment: Participation in instructor-led demonstrations and discussions
    2. In-class assignment: Participation in instructor-led exercises such as using AutoComplete and AutoFill, or using relative, absolute, and mixed cell references.
    3. In-class assignment: Completion of practice exercises and project assignments on topics such as creating a spreadsheet with formulas and functions, or creating a spreadsheet with an embedded chart.
    4. Out-of-class assignment: Completion of assignments begun in class such as modifying chart elements, or creating a spreadsheet with date functions.
    5. Out-of-class assignment: Reading from textbooks and handouts on topics such as using AutoComplete feature, or creating a spreadsheet with standard column widths and standard row heights.
  2. Evaluation
    1. Exams/Quizzes/Tests: Tests and quizzes on topics such as using undo and redo, and using AutoSum function
    2. Performance: Successful completion and submission of in-class assignments such as creating a spreadsheet with AutoCorrect entries, or creating a spreadsheet with standard column widths and standard row heights
    3. Performance: Completion of assigned exercises or projects such creating spreadsheets with merge and center command, or shrinking text to fit within a cell
    4. Participation: Participation in class discussion
    5. Final Assessment: Final exam based on chapter problems such as using spell checking and research references, or thesaurus and translation.
  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.