Business Department
Classes:
Office Applications Specialist 1 Outline

Week 1

  • INTRODUCTION/CLASSROOM PROCEDURES
  • ELECTRONIC MAIL
  • OVERVIEW OF COURSE SOFTWARE
  • Windows 95, 98, NT Workstation
  • Word
  • Excel
  • PowerPoint
  • Access
  • Publisher
  • INTERNET BROWSERS-NETSCAPE/EXPLORE
  • Evaluating World Wide Web Information
  • TWA flight 800
  • ETHICS IN TECHNOLOGY

Week 2

  • NT WORKSTATION/ 2000

Weeks 3 & 4

  • INTRODUCTION TO WORD PROCESSING BASICS--WORD 2000
  • BASIC EDITTING
  • BASIC FORMATTING
  • Letters
  • Reports
  • Memos
  • Title page
  • INTERMEDIATE FORMATTING
  • Paragraph Indents and Margins
  • Special paragraph Settings
  • Columns, Tables, Watermarks
  • ADVANCED EDITTING
  • Reformatting Margins and Indents
  • Adding Graphics and Charts
  • Headers and Footers
  • Hyperlinks and Bookmarks
  • Footnotes, Bibliography

Weeks 5, 6, & 7

  • INTRODUCTION TO SPREADSHEET BASICS--EXCEL 2000
  • Values, Labels, Cells, Formulas, Functions, etc.
  • CREATING BASIC SPREADSHEETS
  • ENTERING FORMULAS
  • ADVANCED FUNCTIONS
  • IF Functions
  • LOOKUP Tables
  • FV, PMT
  • CREATING CHARTS
  • PROJECTS

Weeks 8, 9, & 10

  • INTRODUCTION TO POWERPOINT
  • Editing, Formatting, Printing, Objects, WordArt, Clip Art and Slide Shows
  • Slide Outlines, Charts and Tables, Organizational Charts, Multimedia Elements, Color Schemes and Templates, Animation, and Linking
  • PRESENTATIONS/ BASIC GUIDELINES/ XAP SHOT/ SCANNER/ VIDEO CAPTURE
  • PRESENTATION OF MATERIAL FROM AN ACADEMIC CURRICULUM AREA
  • USING PERPHERIALS-XAP SHOT CAMERA, SOUND, SCANNER, VIDEO CAMERA

Weeks 11, 12, & 13

  • INTRODUCTION TO ACCESS 2000
  • DATABASE TERMINOLOGY
  • Tables, Records, Fields, Query, Reports, Macros
  • CREATING A TABLE
  • ENTERING DATA
  • SORTING DATA
  • SELECTING DATA
  • Creating Forms
  • Creating Database Reports
  • MACRO GAME/ PRESENTATION

Weeks 14 & 15

  • INTEGRATION OF APPLICATIONS
  • WORD PROCESSING AND DATABASE FORM LETTERS
  • WORD PROCESSING AND SPREADSHEETS, CHARTS, AND DATABASE
  • WORD PROCESSING AND INTERNET DATA AND GRAPHICS

Week 16

  • INTRODUCTION TO MICROSOFT PUBLISHER
  • DESKTOP PUBLISHING TERMINOLOGY
  • WORKING WITH OBJECTS
  • LAYERING
  • PAGE LAYOUT
  • NEWSLETTER PROJECT

Week 17

  • INTERNET TERMINOLGOY
  • SEARCH ENGINES/ PROS & CONS
  • DATA SEARCHES ON THE INTERNET (Authenticity) SHORTCUTS
  • PRIMARY RESOURCES vs. SECONDARY RESOURCES
  • INTERNET PROJECT

Week 18

  • TESTING AND FINAL EXHIBITIONS

Webmaster: Bruce Case | Last Updated: 6/23/06 | Site designed by Todd W. Mar '04; Updated by Tim B Jun '06