Active Outline

General Information

Course ID (CB01A and CB01B)
CIS D099.
Course Title (CB02)
Office Software Applications
Course Credit Status
Credit - Degree Applicable
Effective Term
Fall 2023
Course Description
Introduces concepts and hands-on projects using four common office productivity software programs including word processing, spreadsheet, database and presentation software.
Faculty Requirements
Course Family
Not Applicable

Course Justification

This course is a major preparation requirement in the discipline of Information Technology for at least one CSU. This course belongs on a number of Health Technologies certificates such as Medical Records Clerk Certificate of Achievement. Extensive skill and knowledge of the computer applications are required for many professions. There are no other courses currently offered addressing this need.

Foothill Equivalency

Does the course have a Foothill equivalent?
No
Foothill Course ID

Course Philosophy

Formerly Statement

Course Development Options

Basic Skill Status (CB08)
Course is not a basic skills course.
Grade Options
  • Letter Grade
  • Pass/No Pass
Repeat Limit
0

Transferability & Gen. Ed. Options

Transferability
Transferable to CSU only

Units and Hours

Summary

Minimum Credit Units
4.5
Maximum Credit Units
4.5

Weekly Student Hours

TypeIn ClassOut of Class
Lecture Hours4.08.0
Laboratory Hours1.50.0

Course Student Hours

Course Duration (Weeks)
12.0
Hours per unit divisor
36.0
Course In-Class (Contact) Hours
Lecture
48.0
Laboratory
18.0
Total
66.0
Course Out-of-Class Hours
Lecture
96.0
Laboratory
0.0
NA
0.0
Total
96.0

Prerequisite(s)

Corequisite(s)

Advisory(ies)

EWRT D001A or EWRT D01AH or ESL D005.

Limitation(s) on Enrollment

Entrance Skill(s)

General Course Statement(s)

Methods of Instruction

Lecture and visual aids

Quiz and examination review

Laboratory experience which involve students in problem solving

Hands-on lab assignments

Discussion of assigned reading

Homework and extended projects

Assignments

  1. Reading from texts and handouts
  2. Written homework questions from assigned readings
  3. Problem-solving documents and project activities using word processing, spreadsheet, database and presentation software

Methods of Evaluation

  1. Midterm and final exams or quizzes to evaluate comprehension and mastery of key terms and concepts as well as application skills related to analysis and synthesis of computer application concepts.
  2. Writing project(s) to evaluate ability to analyze critically and synthesize course materials related to appropriate computer usage of computer office applications.
  3. Participation in lab skills exercises that demonstrate ability to critically evaluate the proper use of computer applications and computer concepts to complete a given set of software application tasks.

Essential Student Materials/Essential College Facilities

Essential Student Materials: 
  • None.
Essential College Facilities:
  • Computers with appropriate software applications installed, printer

Examples of Primary Texts and References

AuthorTitlePublisherDate/EditionISBN
Shelley Gaskin, Alicia Vargas, Debra Geoghan, Nancy Graviett. "Go with Microsoft Office 2016", Volume 1, Pearson Education, Inc. 2016.
Manning, Cheri, "Microsoft Office 2016: A Skills Approach", McGraw Hill, 2017.
Carol Cram, "Microsoft Office 2016 -Projects Course Technology", 1st Edition, Cengage, 2017.

Examples of Supporting Texts and References

AuthorTitlePublisher
Free tutorial - http://office.microsoft.com/en-us/training/default.aspx

Learning Outcomes and Objectives

Course Objectives

  • Use graphics and lists
  • Create tables and letters
  • Format research papers and newsletters
  • Create a spreadsheet and chart data
  • Use functions, create tables, and manage large workbooks
  • Analyze data with pie charts, line charts, and what-if analysis tools
  • Use Financial and lookup functions, define names, validate data and utilize pivot tables
  • Create database with defined tables and fields using queries, forms, reports and templates
  • Sort and query within multiple databases
  • Utilize forms, filters, and reports
  • Create, edit and view presentations using pictures and slide transitions
  • Format electronic presentations
  • Enhance a presentation with animation, tables, charts, digital images and clips.

CSLOs

  • Demonstrate correct format for creating letters using a word processing software.

  • Create spreadsheets to solve business problems.

  • Use of database software to create, search, modify and arrange information.

  • Create a text/graphics presentation using presentation graphics software.

Outline

  1. Use graphics and lists
    1. Create a new document and insert text
    2. Insert and format graphics
    3. Insert and modify text boxes and shapes
    4. Preview and print a document
    5. Change document and paragraph layout
    6. Create and modify lists
    7. Set and modify tab stops
    8. Insert a SmartArt graphic objects
  2. Create tables and letters
    1. Create tables
    2. Add text to tables
    3. Format tables
    4. Create a new document from an existing document
    5. Change and reorganize text
    6. Use the proofing options
    7. Create a document using a pre-designed template
  3. Format research papers and newsletters
    1. Create mailing labels using mail merge
    2. Insert footnotes in research papers
    3. Create citations and a bibliography in research papers
    4. Format multiple-column newsletters
    5. Use special character and paragraph formatting
  4. Create a spreadsheet and chart data
    1. Create, save, and navigate an excel workbook
    2. Enter data in a worksheet
    3. Construct and copy formulas and use the sum function
    4. Format cells with merge & center and cell styles
    5. Chart data in a column chart
    6. Prepare a worksheet for printing
    7. Enter data by range
    8. Construct formulas for mathematical operations
    9. Edit values in a worksheet
  5. Use functions, create tables, and manage large workbooks
    1. Use sum, average, median, min, and max functions
    2. Move data, resolve error messages, and rotate text
    3. Use countif and if functions and apply conditional formatting
    4. Use date & time functions and freeze panes
    5. Create, sort, and filter an excel tables
    6. Format and print a large worksheet
    7. Navigate a workbook and rename worksheets
    8. Enter dates, clear contents, and clear formats
    9. Copy and paste cell contents
    10. Edit and format multiple worksheets at the same time
    11. Create a summary sheet
    12. Format and print multiple worksheets in a workbook
  6. Analyze data with pie charts, line charts, and what-if analysis tools
    1. Chart data with a pie chart
    2. Format a pie chart
    3. Edit a workbook and update a chart
    4. Use goal seek to perform what-if analysis
    5. Design a worksheet for what-if analysis
    6. Answer what-if questions by changing values in a worksheet
    7. Chart data with a line chart
  7. Use Financial and lookup functions, define names, validate data and utilize pivot tables
    1. Use financial functions such as Sum, Count, Average and If.
    2. Use goal seek
    3. Create a data table
    4. Define names
    5. Use defined names in a formula
    6. Use lookup functions
    7. Validate data
    8. Use pivot table to manage data
  8. Create database with defined tables and fields using queries, forms, reports and templates
    1. Identify good database design
    2. Create a table and define fields in a new blank database
    3. Change the structure of tables and add a second table
    4. Create and use a query, form, and report
    5. Save and close a database
    6. Create a database using a template
    7. Organize objects in the navigation pane
    8. Create a new table in a database created with a template
    9. Print a report and a table in a database created with a template
  9. Sort and query within multiple databases
    1. Open existing databases
    2. Create table relationships
    3. Sort records in a table
    4. Create a query in design view
    5. Create a new query from an existing query
    6. Sort query results
    7. Specify criteria in a query
    8. Specify numeric criteria in a query
    9. Use compound criteria
    10. Create a query based on more than one table
    11. Use wildcards in a query
    12. Use calculated fields in a query
    13. Calculate statistics and group data in a query
    14. Create a crosstab query
  10. Utilize forms, filters, and reports
    1. Create and use a form to add and delete records
    2. Create a form by using the form wizard
    3. Modify a form in design view and in layout view
    4. Filter records
    5. Create a report by using the report tool
    6. Create reports by using the blank report tool and the report wizard
    7. Modify the design of a report
    8. Print a report and keep data together
  11. Create, edit and view presentations using pictures and slide transitions
    1. Create a new presentation
    2. Edit presentations in normal view
    3. Add pictures to presentations
    4. Print and view presentations
    5. Edit existing presentations
    6. Format presentations
    7. Use slide sorter view
    8. Apply slide transitions
  12. Format electronic presentations
    1. Format numbered and bulleted lists
    2. Insert clipart
    3. Insert text boxes and shapes
    4. Format objects
    5. Remove picture backgrounds and insert WordArt
    6. Create and format a SmartArt graphic
  13. Enhance a presentation with animation, tables, charts, digital images and clips.
    1. Customize slide backgrounds
    2. Animate a slide show
    3. Insert a video
    4. Create and modify tables
    5. Create and modify charts

Lab Topics

  1. Create a word processing document using graphics and lists
  2. Create a word processing document using tables and letters
  3. Create a spreadsheet and chart data using functions, creating tables, and managing large workbooks
  4. Utilize spreadsheet financial and lookup functions, define names, validate data and utilize pivot tables.
  5. Create a database with defined tables and fields using queries, forms and reports
  6. Sort and query a database and create templates
  7. Create, edit and view a presentation using pictures and slide transitions
  8. Format presentations and utilize animation, tables, and charts
Back to Top