Description:

Upon successful completion of this course, the student should be able to use the beginning features of an operating system and word processing, spreadsheet, database management, presentation graphics, and e-mail programs to prepare and manage documents simulating legal, medical and general business office applications. Proficiency will also be attained in selecting appropriate applications to use and to integrate all of the business computer application programs to complete projects. Document formatting and proofreading will also be introduced. Hands-on, practical projects will be performed to reinforce the concepts taught. 3 hrs. lecture/wk.

Supplies: Refer to the instructor's course syllabus for details about any supplies that may be required.

Textbook(s): For information see - http://bookstore.jccc.net

Course Fees: NONE

Course Objectives:

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

1. Perform basic operating system and file management functions.
2. Create, format, edit, and print business documents using word processing software.
3. Create, format, edit, and print business documents using spreadsheet software.
4. Create, format, edit, and print business documents using database management software.
5. Create, format, edit, and print business presentations using presentation software.
6. Create, format, edit, send, receive, reply to, and print e-mail messages.
7. Use all software programs to complete integrated business projects.

Content Outline & Competencies:

I. Perform Basic Operating System and File Management Functions
   A. Start and shut down Windows
   B. Start and close a program
   C. Move and resize windows
   D. Use menus, keyboard shortcuts, and toolbars
   E. Use Windows Help
   F. Create, save, and view files
   G. Create folders
   H. Copy and move files 
   I. Search, delete, and restore files

II. Create, Format, Edit, and Print Business Documents Using Word
Processing Software
   A. Start and close software program
   B. Insert, select, and delete text
   C. Copy, cut, and paste text
   D. Find and replace text
   E. Check the spelling and grammar
   F. Use the thesaurus
   G. Use wizards and templates
   H. Change font size, style, and effects
   I. Align paragraphs
   J. Select, place, change, and delete tabs
   K. Select, place, change, and delete indents
   L. Add bullets, numbering, borders, and shading
   M. Change margin settings, page layout, and paper size
   N. Insert section breaks and page breaks
   O. Add, edit, and delete headers and footers
   P. Insert and delete page numbers
   Q. Create columns and tables
   R. Change print settings
   S. Create and format documents for use in the legal, medical, and
general business office.

III. Create, Format, Edit, and Print Business Documents Using Spreadsheet
Software
   A. Start and close software program
   B. Create, open, save, and close a workbook
   C. Enter, format, edit, and delete labels and values
   D. Name, rename a worksheet
   E. Copy, move, and delete a worksheet
   F. Preview and print a worksheet and workbook
   G. Enter, create, and copy formulas
   H. Use basic functions
   I. Copy and move cell entries
   J. Distinguish between relative and absolute cell references
   K. Insert columns and rows
   L. Adjust column widths and row heights
   M. Add color, patterns, and borders
   N. Create, edit, format, move, resize, and print a chart
   O. Create and format spreadsheets for use in the legal, medical, and
general business office

IV. Create, Format, Edit, and Print Business Documents Using Database
Management Software
   A. Start and close software program
   B. Create, open, save, and close a database
   C. Create fields
   D. Enter and edit records
   E. Create and modify a table
   F. Sort, filter, and find records
   G. Create and modify a query
   H. Create and modify a form
   I. Insert an image
   J. Create and modify a report
   K. Create databases, tables, forms, and reports for use in the legal,
medical, and general business office.

V. Create, Format, Edit, and Print Business Presentations Using
Presentation Software
   A. Start and close software program
   B. Create, open, save, and close a presentation
   C. Create, format, edit, delete slide text
   D. Add, edit, and delete headers and footers
   E. Use design templates
   F. Draw and modify an object
   G. Import text from other software programs
   H. Customize the color scheme and background 
   I. Insert, crop, scale, and delete an image
   J. Embed and format a chart
   K. Create tables
   L. Set slide show timings and transitions
   M. Set slide animation effects

VI. Create, Format, Edit, Send, Receive, Reply To, and Print E-mail
Messages
   A. Start and close program
   B. Create and send new messages
   C. Reply to and forward messages
   D. Send a message with an attachment
   E. Flag a message
   F. Add and organize contacts
   G. Create a distribution list
   H. Send a message to distribution list
   I. Insert appointments and tasks
 
VII. Use Software Programs to Complete Integrated Business Projects
   A. Copy and paste data
   B. Drag and drop data
   C. Link objects
   D. Embed objects
   E. Edit embedded and linked objects
   F. Create hyperlinks
   G. Merge data

Methods of Evaluation of Competencies:

Evaluation of student mastery of course competencies will be accomplished using the following methods:

Examinations         60% of grade
Projects/Assignments 40% of grade
  Total:            100%

Grade Criteria:
  A = 90 - 100%
  B = 80 -  89%
  C = 70 -  79%
  D = 60 -  69%
  F =  0 -  59%

Caveats:

1. Students are expected to know how to type/keyboard.

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.