Home > Syllabus > Print

 Site Map

Syllabus

• You MUST login to your course by the end of first week of classes or you may be withdrawn.

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.

1. Microsoft Office 2003: Introductory Concepts and Techniques by Shelly, Cashman, & Vermaat, Course Technology, 2003. (ISBN: 0-619-25477-7)

1. Two 3.5" high-density diskettes to be used for student data files.
2. SAM CD

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.

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.

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 2003; 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.

Last Updated: 06/22/06