Home > Syllabus

Site Map

HomeCourse InformationSyllabusCalendarAssignmentsReview NotesWebCTFAQResources



Printer Friendly Version

Credit Hours: 3 c.c.
Contact Hours: Online
Laboratory Fee: YES
Prerequisites: NONE
Corequisites: NONE
Important Note: This course is designed for the self-motivated and disciplined student who requires a substantial degree of scheduling flexibility. Please consider this carefully before enrolling in the course.
Orientation: An orientation session for CGS 1570W is held at the beginning of each term the course is offered. Important aspects of the course will be discussed at the orientation so please try to attend. If you would like to receive this information as soon as you register please email the instructor with your request.
Course Access: Logging into WebCT is YOUR RESPONSIBILITY!
  • You MUST login to your course by the end of first week of classes or you may be withdrawn.
Catalog Description:

This course is intended for a course that includes a brief introduction to Windows XP and Office 2003. No experience with a computer is assumed, and no mathematics beyond the high school freshman level is required. The objectives of this course are: to learn the fundamentals of Windows XP and Office 2003; to acquaint yourself with the proper procedures to create documents, worksheets, and presentations suitable for coursework, professional purposes, and personal use; to discover the underlying functionality of Office 2003 to become more productive; to develop an exercise-oriented approach that allows learning by doing; to encourage independent study and help those who are working alone or in a distance education environment. This course meets A. A. computer competence requirement.

World Wide Web Sites: http://uwf.edu/clemley/cgs1570w/
Required Textbook(s):
  1. Microsoft Office 2003: Introductory Concepts and Techniques by Shelly, Cashman, & Vermaat, Course Technology, 2003. (ISBN: 0-619-25477-7)
Supplemental Materials:
  1. Two 3.5" high-density diskettes to be used for student data files.
  2. SAM CD
Special Requirements: This course requires a multimedia computer (Sound card, CD player and speakers) with Internet access at a minimum of a 56 Kbps modem. The student MUST have access to Windows XP, Office XP2003 Professional, a computer either Netscape Communicator 4.0 or above or Microsoft Internet Explorer 5.0 or above.

Student will need access to Windows XP, Office 2003 Professional and the internet. If the needed software or access is not available on the student's personal/home computer, computers in the PJC academic computing labs located on the Pensacola, Milton and Warrington campuses may be used.

Major Learning Outcomes:

The student will be able to:

  1. Define terms associated with computer use and application.
  2. Use the operating system to perform simple operations on files such as copy, rename, and delete.
  3. Use word processing software to create documents such as letters, memoranda, resumes, and research reports.
  4. Use spreadsheet software to solve problems in areas such as manipulating budgets and financial plans.
  5. Use presentation graphics software to create a presentation or slide show.
  6. Understand computer-based communications including LANs, the Internet, and information services.
  7. Discuss the use of computer in various areas of human endeavor.
Specific Performance Objectives:
  1. Load and exit windows; use mouse and keyboard; identify the components of the windows desktop; organize screen based desktop; switch tasks in a multi-tasking environment.
  2. Start and exit Microsoft Word XP2003; open and close a document; delete and inset text and blank lines; select blocks of text; change justification and line spacing; save and print a document.
  3. Spell-check a document; open and display two documents; cut, copy, and move text; enter date codes; set margins and tabs; bold and italicize text; search and replace text.
  4. Start and exit Microsoft Excel 2003; design a worksheet; enter labels and values; edit worksheet entries; open and close files; copy data, enter formulas, and align entries; save and print a worksheet.
  5. Copy formulas, enter @functions, and clear cell contents; format values and use absolute references; change column widths, insert and delete rows and columns; move entries, change fonts and attributes; insert and use multiple worksheets.
  6. Create bar, line, mixed, and pie charts; enter chart titles and axis titles; add tick marks, grid lines, and patterns; add test blocks and arrows; add legends and data labels; save and print a worksheet with charts.
  7. Start and exit Microsoft PowerPoint 2003; create a multi-level bulleted list presentation; select a design template; change font style; decrease font size; save a presentation; display slides in an electronic slide show; print copies of the slides to make overhead transparencies.
  8. Use outline view and clip art to create an electronic slide show; change slide layouts; insert clip art; add slide transition effects; add text animation effects; animate clip art; run an animated slide show; and print audience handouts from an outline.
  9. Start and exit Microsoft Access 2003; create a database using design and datasheet views; create, save and close a table; add records to a table; preview and print the content of a table; use a form to view data; create a report; query a database using the select query window; create a new query; enter criteria; use compound criteria; sort data in a query; join tables; use calculated fields in a query.
  10. Maintain a database using the design and update features of Access; add, change, and delete records; search for a record; filter records. change the structure; use a update query; use a delete query; create validation rules; specify referential integrity; order records on multiple fields; create and use indexes.
  11. Define terms and concepts related to the Internet.
  12. Use the Netscape browser to access Web pages. Use search engines to locate information.
  13. Set up an e-mail account. Send and receive e-mail.
Methods of Evaluation and Grade Computation: Final evaluation of a student's performance in the course will be based on the average of five skill-based tests and a series of assignments. The assignments will be associated with Chapter materials and will be e-mailed to the instructor. The assignments will total a maximum 100 points.
Grading Scale:
(No rounding)
A    90 - 100
B+ 85 -   89.99 80 - 84.99
C+ 75 -   79.99 C 70 - 74.99
D+ 65 -   69.99 D 60 - 64.99
F   0 -   59.99
Final Note: The key to your success largely depends on the effort you put into the course. If you follow the instructor's guidelines and use the resources provided, you can successfully complete the course and earn 3.0 college credits. If you have questions at any time, please contact your instructor for assistance.


| Home | Course Information |  Syllabus | Calendar | Assignments | Resources | Review | WebCT | FAQ | Site Map |


EMAIL.GIF (20906 bytes)

For more information, please contact Ms. Linda Lemley by phone or email.

Last updated: 06/22/06