Professor's Name:

Course Title and Number:

Catalog Description:

Semester:

Office Location:

Phone Number:

E-mail Address:

Office Hours:

Listed on course website

Online as needed

Required Text and other Materials:

• Textbook (9781423905776): New Perspectives on Microsoft Office 2007, First Course, Windows XP Edition, by Shaffer/Carey/Finnegan/Adamski
  
• Software (9781423997535): SAM 2007 Assessment & Training v3.0 (no charge for Fall 2008)
  

Bundled ISBN # 978-0-324-61432-9

Link to OCC Bookstore: http://bookstore.ocean.edu

Required Hardware:

• Pentium III or higher
• 256MB of RAM
• CD-ROM drive
• Mouse
• 2.5GB minimum available hard drive space
• SVGA graphics (800x600 256 color or higher)
• Sound card and speakers recommended

Required Software:

• Microsoft® Windows 2000  or  XP
• Microsoft® Office 2007 Professional (Word, Excel, Access, PowerPoint).
• Macromedia® FlashÔ Player 7 (free download)
• Internet Exployer 6.0 or higher (can be downloaded)
• Internet access (high speed broadband, T1 or ISDN recommended; 56K minimum connection required). Persistent connection required.
• E-mail account

Course Learning Outcomes/Objectives:

1. Describe and illustrate the hardware and software requirements for Integrated Office Software.
2. Recognize and use various Windows features (menus, title bars, dialog boxes, cascading menus, dragging and dropping, pop-up menus, icons, taskbar and toolbars).
3. Use Windows to save and retrieve files, maintain directories and run Office Software.
4. Describe file management, word processing, spreadsheet and charting concepts.
5. Identify an application using database, graphics, word processing, spreadsheet and presentation software.
6. Create and edit documents.
7. Format documents with appropriate use of fonts and type styles to improve the appearance of a document.
8. Import graphics and use tables in a document.
9. Work with multiple documents transferring data between documents.
10. Automate work by use of macros and templates.
11. Produce a professional looking document project utilizing the word processing techniques presented.
12. Create, edit and format a spreadsheet.
13. Use functions in a spreadsheet.
14. Work with multiple spreadsheets.
15. Use charts and graphs in a spreadsheet.
16. Produce a professional looking spreadsheet project utilizing the spreadsheet techniques presented.
17. Integrate the document and spreadsheet projects.
18. Create, maintain, and query a database management system.
19. Create and use database forms.
20. Create database reports.
21. Produce a database project utilizing the database techniques presented.
22. Create compound documents containing text, graphics, database, and spreadsheet data.
23. Manage shared data among applications.
24. Produce and present a professional slide show, utilizing graphs, clip art, charts and special features.
25. Integrate word processing, spreadsheets and database into a computer generated presentation application.

General Education Goals Addressed in the Course:

Course Standards:

• Assignments submitted after the scheduled deadline will drop a letter grade for lateness.
• Students may resubmit assignments, but not for full credit.
• All chapter assignment drop boxes will be locked after each application test.
• Forums will be locked after the scheduled deadline and can not be made up.
• Tests will be locked after the scheduled deadline and can only be made up based on extenuating circumstances, which will be evaluated on a case by case situation.

Attendance Policy:

Grading Scale:

90

-

100

A

88

-

89

B+

80

-

87

B

78

-

79

C+

70

-

77

C

60

-

69

D

Course Outline:

1. Introduction to Computers
1. Components of a Computer
2. Computer Software
3. Application Software Packages
4. Communications
5. Networks
6. How to Purchase a Computer System
7. Maintenance


2. Introduction to Windows
1. Communication with Windows
2. Using Windows
3. File and Disk Concepts
4. Using Windows Help
5. Using Explorer


3. Introduction to Integrated Office Software
1. Office Family
2. Microsoft Shortcut Bar
3. Task Switching
4. Modifying a Document File
5. Printing


4. Word Processing
1. Creating and Editing a Document
1. Changing Fonts
2. Formatting Document
3. Correcting Errors
2. Formatting Documents
1. Paragraph Formatting
2. Working with multiple open documents
3. Using the Thesaurus
4. Using Spelling and Grammar Checkers
5. Find and Replace
3. Improving Appearance of a Document
1. Adding Tables
2. Adding Clip Art
4. Automating Work
1. Using Mail Merge
2. Using Macros
3. Using Templates
4. Creating a Resume


5. Spreadsheets
1. Creating, Editing and Formatting a Worksheet
1. Autoformat
2. Custom Formats
2. Using Formulas
1. Hierarchy
2. AutoSum
3. Using Functions
1. Statistical
2. Financial
4. Creating Charts and Graphs
1. Types of Charts
2. Modifying Chart
5. Working with Multiple Worksheets


6. Object Linking and Embedding
1. Integrating the Document with the Worksheet


7. Database Processing
1. Creating a Database
1. Fields
2. Keys
3. Wizards
4. Manual
2. Maintaining a Database
1. Changing Views
2. Editing Tables
3. Entering and Editing Data
3. Creating Forms
1. Wizards
2. Viewing Data
3. Editing Data
4. Querying a Database
1. Sorting
2. Selection Criteria
5. Creating Reports
1. Wizards
2. Printing
6. Managing Shared Data among Applications


8. Presentation Graphics
1. Creating a Presentation
1. Creating Title Slide
2. Changing Text Style and Font
3. Creating Remaining Slides
4. Moving between Slides
5. Viewing the Presentation in Slide Sorter View
6. Correcting Errors
7. Using Online Help
2. Enhancing the Presentation
1. Adding Clip Art to a Slide
2. Adding Text to an Object
3. Using Graphs and Tables
4. Adding Special Effects
5. Running an Automatic Slide Show


9. Integrating word processing, spreadsheets, database and presentation packages

Statement of Plagiarism:

Statement about Civility:

Evaluation of Student:

1. Detailed list of assignments listed on the course website.  All assignments must be uploaded to the appropriate Assignment Drop Box on the Course Website to be evaluated.



2. Online tests scheduled on the course website:
• 1 Objective Test on Introductory Chapters
• 1 Objective Test and Skills Assessment Test (SAM) on Word
• 3 Objective or Skills Assessment Tests on Excel, Access, PowerPoint.  Student chooses the test methodology that bests suits their learning style.
• 2 (Word and Excel) Hands-on Application Tests


3. Participation in 3 Discussions (Word, Excel and Access) scheduled on the course website.

Campus resources and services:

Statement of Accommodation: