Content Outline and Competencies:

I. Microcomputer Concepts  
   A. Identify the hardware components of a microcomputer system
      1. Identify the properties of various microprocessors (CPUs)
      2. Explain the role of random access memory in computer storage and
processing
         a. Identify the most common amounts of RAM in a microcomputer
         b. Explain the types and characteristics of RAM
      3. Identify the types and characteristics of common peripheral
devices in a microcomputer system
         a. Storage devices (Indicate common current storage capacity.)
            1) Hard drive
            2) USB (flash) drive
            3) CD
            4) Network drive
         b. Input devices
            1) Keyboard
            2) Mouse
         c. Output devices
            1) Printer
            2) Monitor
   B. Identify and use common microcomputer software
      1. Name the two broad categories of software
         a. Operating System software
         b. Application software
      2. Define the purpose of operating system software
      3. Use operating system software to perform basic operational tasks
         a. Start the computer and run multiple programs
         b. Manage multiple windows
            1) Move
            2) Resize
            3) Minimize
            4) Maximize
         c. Use menus, toolbars, and panes
         d. Use Windows Help and Support
      4. Define the purpose of application software
      5. Use application software to perform specific tasks
         a. Start an Application Program
         b. Create, Open, Edit, and Save a word processing document
         c. Edit and format text
         d. Create or copy a graphic
         e. Copy data between programs
         f. Print a document
         g. Play a video or sound clip

II. File Management Concepts
   A. Identify and use file management skills to organize files and
folders
      1. Define the purpose of file management
      2. Open and view My Computer and Windows Explorer
         a. View the Folders list
         b. Create and rename files and folders
         c. Copy files and folders
         d. Move files between folders
         e. Delete and restore files and folders
         f. Change folder options
         g. Change file and folder list view
         h. Save files in designated folders
      3. Display disk and folder information
      4. Compress files and folders

III. Internet and E-Mail Concepts
   A. Identify and use the Internet and Web browsers to access
Information
      1. Connect to the Internet
      2. Open a Web page and follow links
      3. Search the Web
      4. Preview and Print a Web page
   B. Use e-mail to send and receive messages with attachments
      1. Compose and send e-mail
      2. Retrieve, read, and respond to e-mail
      3. Attach a file to an e-mail message

Content Outline and Competencies:

I. Macintosh Personal Computer System
   A. Ks, megs, gigs and disks
      1. Define bits, bytes, kilobytes.
      2. Describe floppy disks.
      3. Initialize a new floppy disk.
      4. Lock and unlock a disk.
      5. Define megabytes, gigabytes.
      6. Label disks.
      7. Discuss hardware and software.
   B. Starting up
      1. Turn the Macintosh on.
      2. Define internal and external hard disk.
      3. Discuss other attached devices.
      4. Use the monitor.
      5. Insert a disk into a drive.
      6. Insert a CD into a CD-ROM drive.
   C. The mouse
      1. Use the pointer
      2. Use the mouse.
      3. Move the mouse.
      4. Access and use the mouse control panel.
      5. Connect the mouse.
      6. Clean the mouse.
   D. Desktop and finder
      1. Define the desktop.
      2. Define the finder.
      3. Organize the desktop.
      4. Understand how to hide others.
      5. Clean up the desktop.
      6. Select desktop colors or patterns.
   E. Menus
      1. Choosing a menu command.
      2. Use pop-out, pop-up, and contextual menus.
      3. Understand gray vs. black commands.
      4. Use keyboard shortcuts.
      5. Understand ellipses in the menus.
   F. Important keys
      1. Define modifier keys.
      2. Use command, option (Alt), control keys.
      3. Use spacebar, F keys, arrow keys.
   G. Windows
      1. Identify title bar.
      2. Moving the window.
      3. Identify the active window.
      4. Use size, zoom, collapse and close boxes.
      5. Use scroll bars, arrows, and boxes.
      6. Organize desktop windows.
   H. Folders, icons and files
      1. Create and name a new folder.
      2. Open and put a file into a folder.
      3. Define disk, folder, application and document icons.
      4. Move and rename icons.
      5. Open an application.
      6. Open a document from the desktop.
      7. Discuss rules for naming files.
      8. Copy and select files.
      9. Describe save vs. save as.
      10.   Use the trash can.
      11.   Choose a printer.
      12.   Print a document.
      13.   Print the desktop.
II. Applications  
   A. Word processing concepts
      1. Demonstrate opening a document.
      2. Move the insertion point.
      3. Demonstrate entering text.
      4. Define word wrap.
      5. Define paragraphs (hard carriage returns).
      6. Demonstrate inserting and deleting text.
      7. Define defaults.
      8. Define toggle.
      9. Use application help feature.
     10. Demonstrate assigning attributes, line spacing, and alignments to
text.
     11. Demonstrate inserting graphic image into document.
     12. Describe creating a header.
   B. Spreadsheet concepts
      1. Enter new data into a worksheet.
      2. Insert a new row into a spreadsheet.
      3. Create and edit formulas.
      4. Use built-in functions.
      5. Copy data and formulas into new cells.
      6. Create a chart.
      7. Copy a chart to a document.
   C. Database concepts
      1. Create a database file.
      2. Demonstrate defining fields.
      3. Demonstrate adding new records to the file.
      4. Discuss sorting records.
      5. Create a columnar report layout.
   D. Drawing concepts
      1. Demonstrate selecting tools.
         a.  Describe tools in toolbox.
      2. Discuss how to select colors.
      3. Create and draw image.
      4. Copy image to clipboard.
   E. Clipboard
      1. Describe the clipboard.
      2. Demonstrate the methods of placing items on clipboard.
      3. Demonstrate pasting the contents of the clipboard.
   F. Multitasking
      1. Demonstrate opening multiple documents.
      2. Demonstrate switching between applications.
      3. Describe copying data between applications.
III. Folders and File Management Concepts
   A. Selecting a drive
      1. Select drive on which file is to be saved.
   B. Creating folders
      1. Create a folder in the root directory.
      2. Create a folder within another folder.
      3. Demonstrate opening and closing folders.
   C. Copying files and folders
      1. Copying a file to another drive.
      2. Copying a file to another folder.
   D. Moving files and folders
      1. Moving a file to another drive.
      2. Copying a file to another folder.
   E. Renaming files and folders
      1. Rename a file.
      2. Rename a folder.
   F. Deleting files and folders
      1. Delete a file.
      2. Delete a folder.

Content Outline and Competencies:

I. Word Processing Concepts
   A. Define word processing terms
   B. Discuss features of word processing software
   C. Discuss the importance of creating professional documents

II. Work with Documents
   A. Create, save, and print a document
   B. Correct errors and undo and redo changes
   C. Adjust paragraph and line spacing
   D. Check spelling and grammar
   E. Change margins, alignment, and paragraph indents
   F. Emphasize points with bullets and numbering
   G. Change fonts, font sizes, and font styles
   H. Change the document theme
   I. Proofread the document

III. Multiple-Page Reports
   A. Create a multi-page report divided into sections
   B. Create and edit a table
   C. Sort rows in a table
   D. Modify a table's structure
   E. Create footnotes and endnotes
   F. Set tab stops
   G. Create headers and footers
   H. Insert a cover page

IV. Desktop Publishing and Mail Merge
   A. Identify desktop publishing features
   B. Create columns
   C. Insert and edit graphic images
   D. Wrap text around a graphic
   E. Use symbols and special typographic characters
   F. Add a page border
   G. Perform a mail merge
   H. Create a blog post

Content Outline and Competencies:

I. Cloud Computing and Current Google Services and Applications
   A. Describe cloud computing.
   B. Discuss the advantages and disadvantages of cloud computing.
   C. Discuss current Google services and applications.
   D. Identify Google services and applications that require the establishment of a Google account.
   E. Identify Google services and applications that don’t require a Google account.

II. Google Apps Email
   A. Create a Google email account.
   B. Create, send and view email attachments.
   C. Organize email.
   D. Use chat.
   E. Create, send and view email using mobile devices.

III. Google Calendar
   A. Create and organize a schedule.
   B. Create and share events and meetings.
   C. Organize and search events.
   D. Publish calendars and events.

IV. Google Talk
   A. Identify other users online.
   B. Create and reply to instant messages.
   C. Create voice calls.
   D. Manage contacts.
   E. Manage chats.

V. Google Docs
   A. Create or upload basic documents, spreadsheets and presentations.
   B. Create and share files.
   C. Define and use on-screen chat.
   D. Organize and store files.
   E. Publish work as a Web page.

VI. Google Sites
   A. Create a basic website.
   B. Communicate and collaborate with others.
   C. Discuss and use on-screen chat.
   D. Organize and store files.
   E. Organize an offsite.

VII. Google Start Page
   A. Discuss the purpose of the Start Page.
   B. Identify changes that can be made by the user and the administrator.
   C. Discuss the steps to make changes to the Start Page based on the needs of the user.

Content Outline and Competencies:

I. Introduction to Spreadsheets 
   A. Overview of Spreadsheets
   B. Characteristics of the Specific Spreadsheet Program

II. Work with the Specific Spreadsheet
   A. Load the Program
   B. Move Around the Spreadsheet
   C. Enter Labels, Values and Formulas
   D. Save and Retrieve
   E. Use the Command Menus and Tool Icons
   F. Enter Headers and Footers

III. Utilize Spreadsheet commands
   A. Copy Formulas
   B. Use Predefined Functions
   C. Insert and Delete Rows and Columns
   D. Use Help Features
   E. Perform Range Operations

IV. Employ Charts
   A. Define Manual and Automated Charts
   B. Position in Same Worksheet or Separate Worksheet
   C. Specify Bar, Pie and Line Styles
   D. Enter Titles, Legends, and Data Display

Content Outline and Competencies:

I. Review 
   A. Use command lines
   B. Generate charts
   C. Print Worksheets

II. Prepare and Examine What-If Alternatives
   A. Seek Solutions by Trial and Error Method
   B. Use Software Specific Goal Seeking Features
      1. Solver
      2. Create Versions and Scenarios

III. Create Worksheet Databases
   A. Create Database
   B. Set Up and Make Data Entries
   C. Sort on Single or Multiple Keys
   D. Do Criteria Searches
   E. Use Filters in Searches
   F. Use VLOOKUP

IV. Work with Multiple Worksheets
   A. Organize Worksheets in a Workbook
   B. Name/Rename Worksheets
   C. Insert Worksheets
   D. Delete Worksheets
   E. Move Worksheets
   F. Define and Use Range Names
   G. Create a Consolidation Worksheet
   H. Use Group Edits

V. Use Macros
   A. Record a Macro
   B. Run a Macro
   C. Briefly describe complex macros

Content Outline and Competencies:

I. Database Concepts

A. Explain the purposes for a database.

B. Describe the advantages of a database.

C. Define database terminology.

II. Tables

A. Create and modify table structures.

B. Compare and contrast field types.

C. Modify field properties.

D. Create primary key fields.

III. Relationships

A. Compare, contrast and apply different relationships

1. One-to-One

2. One-to-Many

3. Many-to-Many

B. Describe and apply referential integrity.

IV. Data Entry

A. Modify records in datasheets and forms.

B. Explore records in datasheets and forms.

V. Sort and Filter

A. Order records using one or more sort fields.

B. Select records using textual, numeric and date criteria.

VI. Queries

A. Create select queries.

B. Develop criteria to limit the recordset using logical and mathematical operators.

C. Create calculated fields.

D. Create summary fields using functions such as Sum, Average and Count.

VII. Forms

A. Create forms with a wide variety of controls such as text boxes, labels, command buttons, images and combo boxes.

B. Modify control properties.

VIII. Reports

A. Create reports with text boxes and labels.

B. Modify report sections and controls to modify create reports.

C. Create expressions to create calculations on groups of records.

Content Outline and Competencies:

I. Advanced Queries

A. Build parameter queries.

B. Build crosstab queries.

C. Analyze redundant data.

D. Analyze unrelated records.

E. Create queries to find top values.

F. Create action queries to make tables, append records, delete records and update fields.

G. Join tables within a query.

H. Use basic SQL commands to build a query and retrieve data.

II. Advanced Forms

A. Create forms with subforms.

B. Add tab controls to enhance the design of a form.

C. Create combo boxes to enter data or find data.

D. Add calculations to forms.

III. Advanced Reports

A. Apply multiple sorting and grouping fields.

B. Create calculated controls to subtotal data.

C. Create report totals.

IV. Data Importing and Exporting

A. Import and export data between Access and HTML.

B. Import and export data between Access and spreadsheets.

C. Import and export data between Access and text files.

D. Convert Access data to PDF.

IV. Analyze Relationships

A. Analyze many-to-many relationships.

B. Build one-to-many relationships.

C. Build one-to-one relationships.

D. Describe and apply referential integrity.

V. User Interface Issues

A. Design and develop navigation forms.

B. Create dialog boxes and error message prompts.

C. Create macros to automate common processes.

D. Create command buttons to run macros.

E. Create custom toolbars and menus.

VII. VBA Programming Code

A. Write event procedures to automate common tasks.

B. Create custom functions to calculate values.

C. Test and debug procedures.

Content Outline and Competencies:

I. Database Design Skills

A. Analyze customer data requirements.

B. Design normalized data for a relational database.

II. Documentation

A. Diagram a database schema.

B. Use standard field and object naming conventions.

C. Create metadata for database documentation.

III. Data Conversion

A. Analyze existing data accuracy and consistency.

B. Use action queries to create, update and delete data.

C. Create appropriate lookup tables.

IV. VBA

A. Create event handler procedures to automate forms.

B. Create procedures to trap errors.

Content Outline and Competencies:

I. Overview of E-Mail Applications
   A. Discuss e-mail history and its relationship to the growth of
local area networks and the Internet
   B. Compare today's features of e-mail to early products

II. Software Interface
   A. Use the interface to navigate throughout the features of the
software
   B. Customize the interface to meet the needs of the user


III. Messages
   A. Receive, view, send, forward, print, and delete f messages
   B. Insert e-mail signatures
   C. Organize, sort, and search messages using folders, flags, filters
   D. Create e-mail with file attachments
      1. Receive, view, launch, and save file attachments
      2. Send file attachments
   E. Discuss and use advanced delivery options
   F. Use advanced formatting features such as tables, formatted text,
hot
spots, links, collapsible sections, and HTML e-mail

IV. Address Book and Contacts
   A. Create, edit, and delete contacts
   B. Create, edit, and delete groups
   C. Use personal and global address books
   D. Find, track, and organize contacts

V. Calendars and Scheduling
   A. Create and edit calendar entries such as appointments, events, and
reminders
   B. Use the calendar to schedule group meetings
   C. Create and edit tasks/ to do list

VI. Instant Messaging
   A. Send and receive instant messages

   B. Attach and send files with instant messaging

Content Outline and Competencies:

1. Computer User Support

   1. Discuss historical changes in computer use.

   2. Describe common categories of end users.

   3. Identify resources needed by end users.

   4. Discuss problems end users experience.

   5. Describe how organizations provide a user support function.

   6. Discuss user support services.

2. Careers in Computer User Support

   1. Describe common entry level job titles.

   2.  Describe typical responsibilities.

   3. Describe potential career paths.

3. Customer Service Skills and Verbal Communication Skills

   1. Discuss important verbal communication and customer service skills.

   2. Describe effective verbal communication techniques.

   3. Identify an incident management strategy.

   4. Describe strategies for difficult clients and incidents.

   5. Identify client friendly web sites and Web 2.0.

4. Written Communication Skills

   1. Describe common types of user support documentation.

   2. Discuss how technical writing differs from other writing.

   3. Describe the technical writing process and strategies.

   4. Identify technical writing tools.

5. Problem Solving Strategies and Tools

   1. Discuss the troubleshooting process and common computer problems.

   2. Discuss effective communication skills for troubleshooting.

   3. Identify information resources to help solve computer problems.

   4. Describe diagnostic repair tools used to troubleshoot computer problems.

   5. Role-play scenarios to practice problem-solving tools and skills.

6. Help Desk Operation

   1. Discuss help desk operational procedures.

   2. Describe the multi-level support model.

   3. Discuss the incident management process.

   4. Discuss best practices in help desk operation.

   5. Describe the physical layout of help desk work areas.

   6. Discuss stress associated with help desk work.

   7. Identify hardware and software tools used by support agents, managers and end users.

   8. Discuss help desk industry trends.

7. User Support Management

   1. Describe the purpose and features of a mission statement.

   2. Discuss items in a typical user support budget.

   3. Describe how a help desk is typically staffed.

   4. Describe support staff training programs.

   5. Discuss how support staff performance might be evaluated.

   6. Identify industry certifications for support associations.

   7. Discuss ethical principles that guide the professional behavior of support workers.

8. Product Evaluation Strategies and Support Standards

   1. Describe how product and support standards emerged.

   2. Discuss common tools and methods for evaluating and selecting computer products.

   3. Identify information resources and decision-making tools for evaluating and selecting computer products.

   4. Describe typical product standards.

   5. Describe how organizations develop and implement support standards.

9. End User Needs Assessment Projects

   1. Describe basic strategies for performing end-user needs analysis and assessment.

   2. Discuss the steps analysts use to analyze and assess a user’s needs.

   3. Discuss the common tools that help support specialists conduct a user needs assessment project.

   4. Describe the tasks in managing a user needs assessment project.

   5. Describe project management software tools.

10. End-User Computers

    1. Describe site preparation steps for computer installations.

    2. Identify pre-installation site preparation tasks.

    3. Explain the tools needed to install hardware.

    4. Discuss the steps to install and configure hardware, operating systems, networks and application software.

    5. Describe ongoing site management tasks.

11. Computer User Training

    1. Explain the goals of training activities.

    2. Identify steps in the training process.

    3. Plan and prepare a training session.

12. Utility Software

    1. Describe software utilities and information resources used by support specialists.

    2. Describe categories of common user support utilities.

    3. Identify useful support utilities.

Content Outline and Competencies:

I. Introduction to Project Management
   A. Explain the goals of project management
   B. Write the phases of project management
   C. Apply project management terminology to a real case, including:
      1. Task
      2. Duration
      3. Relationship
      4. Resource
      5. Critical Path
   D. Explain how project management software enhances project management

II. Project Planning 
   A. Set project goals
   B. Analyze a project and break it into tasks, milestones, and phases
   C. Analyze tasks to create task sequencing
   D. Analyze tasks to create appropriate durations 
   E. Analyze tasks to create task relationships, including:
      1. Finish-to-Start
      2. Start-to-Start
      3. Finish-to-Finish
   F. Create project resources

III. Project Creation
   A. Enter and edit tasks, phases, milestones, and durations
   B. Enter and edit task relationships
   C. Assign resources to tasks
   D. Use various charts to view project
      1. Gantt
      2. PERT
   E. Use various techniques to analyze the critical path

IV. Project Communication
   A. Calculate project schedules and costs
   B. Preview and print appropriate charts and reports
   C. Develop a project baseline

V. Track Progress
   A. Enter and update actual vs. scheduled tasks, durations, and resource
allocations
   B. Compare baseline versus actual schedule and cost projections using
various charts and reports
   C. Use various task, duration, constraint, and resource variables to
control projects that are off schedule or over budget

VI. Advanced Project Management
   A. Manage resources across multiple projects
   B. Use advanced project management tools such as resource leveling 
   C. Customize reports
   D. Consolidate multiple projects into one master project

Content Outline and Competencies:

I. Microcomputer Basics
   A. Identify hardware
      1. Define the CPU
      2. Define storage devices
      3. Describe RAM
      4. Describe ROM
   B. Define operating system concepts
      1. Locate Microsoft Windows accessibility options
      2. Identify application programs
      3. Experience using Assistive Technology programs

II. The Keyboard
   A. Manipulate a standard keyboard
   B. Control a modified keyboard
   C. Type using the keypad
   D. Identify numeric keypad
   E. Utilize intermediate keypad
   F. Identify function keypad

III. The Johnson County Community College Computer Systems
   A. Recognize the jccc.net computer network components
   B. Log in to access class schedules
   C. Find Pipeline account
   D. Check grades online
   
IV. Disabilities and Assistive Technologies
   A. Identify disabilities
      1. Blindness
      2. Low vision
      3. Learning disabilities
      4. Orthopedic disabilities
   B. Gain academic independence through the use of Assistive Technology
   C. Demonstrate JAWS screen reading systems
   D. Execute screen magnification systems
   E. Control print access systems
   F. Control reduced motion systems

V. Screen Reading System, Window Bridge
   A. Recognize keyboard layouts
   B. Demonstrate synthesizer control keys
   C. Stop the automated voice controls
   D. Apply, in exercises, the reading commands
   E. Control the pointer with Windows MouseKeys
   F. Interact with the Window Bridge control panel

VI. Screen Magnification System, ZoomText
   A. Load ZoomText
   B. Select ZoomText User Interface
   C. Close ZoomText
   D. Minimize and maximize ZoomText
   E. Enter Zoom modes

VII. Print Access Systems, Kurzweil  3000
   A. Identify key functions of Kurzweil  3000
   B. Access the  Kurzweil  3000 menus
   C. Discuss the "Where Am I" key
   D. Select text and objects
   E. Execute the scan key
   F. Navigate in Kurzweil  3000
   G. Start the speak key
   H. Utilize the Escape key
   I. Identify the main menu
   J. Use Windows High Contrast for reading documents
   K. Create a document
   L. Scan a document

VIII. Using the Johnson County Community College Library resources
   A. Tour of Assistive Technology in the campus Library 
   B. Describe Adaptive Technology available in the library

Content Outline and Competencies:

I. Introduction To Presentation Graphics
   A. Describe basic computer hardware
   B. Describe the operating system attributes

II. Use Presentation Graphics Software
   A. Create and save a presentation file
   B. Set automatic outlining attributes for slides
   C. List basic tools
   D. Create text formatting
   E. Use template files
   F. Create master pages
   G. Create drawn images
   H. Integrate animation dissolve sequences
   I. Create color schemes
   J. Copy, cut, delete and paste items
   K. Print a presentation
   L. Save and close a presentation

III. Create Hands-on Project, including:
   A. Create a one minute on-computer presentation
   B. Create, import and align graphic images
   C. Use special effects for slide transitions
   D. Incorporate text specifications for style, size, weight and
justification
   E. Print speaker notes and handouts for the visual presentation
   F. Print presentation images

Content Outline and Competencies:

I. Templates and Outlines
   A. Create a new document from an installed template
   B. Save, open, and delete a new template
   C. Understand themes, styles, and style sets
   D. Customize the document theme
   E. Create and modify a style
   F. Use outline view
   G. Create a table of contents
   H. Use the Research task pane

II. Mail Merge
   A. Describe the mail merge process
   B. Select or create a main document
   C. Select or create a data source
   D. Edit the main document
   E. Edit an existing data source
   F. Merge the main document and data source
   G. Sort records
   H. Create mailing labels
   I. Convert tables to text

III. Advanced Formatting Techniques
   A. Track changes in a document
   B. Insert and delete comments
   C. Accept and reject changes
   D. Compare and combine documents
   E. Embed and modify a worksheet
   F. Modify and update a linked chart

IV. Web Pages
   A. Create and format a Web page
   B. Insert and edit hyperlinks
   C. Save a Word document as a Web page
   D. View a Web document in a Web browser

V. Customize and Automate Word
   A. Create and modify styles within a document template
   B. Use smart tags
   C. Create a watermark
   D. Create and insert Quick Parts
   E. Customize AutoCorrect
   F. Work with Columns and different widths
   G. Manage document properties
   H. Automate parts of a document using fields

VI. Macros
   A. Record and run macros
   B. Edit macros using Visual Basic
   C. Import and run Visual Basic macros
   D. Record an AutoMacro

Content Outline and Competencies:

I.Components of a Computer System

A. Identify key components and functionality of hardware.

1. CPU

2. Memory

3. Hard drive

B. Define the purpose of common software programs.

1. Operating system

2. Application programs

C. Identify and use current peripheral devices.

1. Input devices

2. Output devices

3. Storage devices

II. Operating System

A. Copy, move, rename and delete files and folders.

B. Minimize, maximize, restore and resize windows.

C. Launch applications, access help and search for files.

D. Customize the operating system environment.

III. Word Processing

A. Create, edit, save and print documents.

B. Correct spelling and grammar errors.

C. Use the help system.

D. Format text with font and character formatting.

E. Create bulleted and numbered lists.

F. Apply paragraph formatting.

G. Insert and manipulate graphics.

H. Create a multipage report divided into sections.

I. Apply page layout features including headers, footers and margins.

J. Format text with styles.

K. Create, format and edit a table.

L. Create citations and bibliographies.

M. Identify document properties and secure documents.

IV. Spreadsheet

A. Create, edit, save and print workbooks.

B. Enter labels, values and formulas.

C. Use the help system.

D. Apply absolute, mixed and relative cell references in formulas.

E. Create formulas with functions.

F. Insert and delete rows and columns.

G. Move and copy a range of cells.

H. Perform what-if analysis.

I. Format and align labels and values.

J. Apply page layout features including headers, footers and print settings.

K. Use spell check on worksheets.

L. Add comments and graphics to worksheets.

M. Protect cell formulas and secure worksheets and workbooks.

N. Print formulas.

O. Create and modify charts.

V. Presentation

A. Create, edit, save and print presentations.

B. Add, duplicate, rearrange and delete slides.

C. Use the help system.

D. Create handouts and speaker notes.

E. Preview, print and save presentations.

F. Change existing slide layouts.

G. Insert pictures and clip art.

H. Apply presentation themes.

I. Animate objects and bulleted lists.

J. Embed sound and video in presentations.

VI. Database

A. Build tables by defining fields and setting field properties.

B. Specify primary keys.

C. Use the help system.

D. Link tables with one to many relationships.

E. Enter and edit records.

F. Create and run queries to sort and select data.

G. Create and format forms.

H. Create and format reports.

I. Create interfaces to protect and secure data.

VII. Integration

A. Embed charts into documents.

B. Link worksheets to documents.

C. Secure data and files using links and passwords.

D. Create presentations from document outlines.

VIII. Internet Research

A. Develop search techniques for locating information on the Web.

B. Use search engines to conduct searches.

C. Find and evaluate information on the Web.

D. Identify and document Web resources.

E. Discuss and apply copyright laws and principles.

F. Document Web resources according to academic research standards.

Content Outline and Competencies:

I. Install and maintain system components
   A. Decompress a system file
   B. Select an external hard drive for startup
   C. Mount a disk image
   D. Run Disk First Aid
   E. Find items with Apple's Sherlock application
   F. Install a control panel
   G. Install a desk accessory
   H. Install a font
   I.  Create a screen capture
   J. Rebuild the desktop file
   K. Customize an icon's color with the Color Picker

II. Use Apple and third party utility applications
   A. Print a HyperCard stack
   B. Create an Apple Script to shut down a Mac
   C. Repair and optimize a volume(disk or hard drive)
   D. Increase processing memory for applications
   E. Install a task bar using the application GoMac

III. Manage fonts
   A. Plan font organization
   B. Rename a font suitcase
   C. Install fonts outside the System Folder
   D. Decompress font resources
   E. Turn on fonts with Adobe Type Manager Deluxe

IV. Creating backups
   A. Reduce the size of files and folders with compression software
   B. Create self-extracting archives
   C. Calculate file size and compression percentages

Content Outline and Competencies:

I. Exploring the Basics
   A. Execute startup and shutdown of Windows
   B. Discuss the objects of the Windows desktop
   C. Use the mouse to point to objects
   D. Run software applications and switch between them
   E. Use the controls in a window
   F. Use the Windows Help system

II. Working with Files
   A. Use the format utility to initialize a disk
   B. Create, print and save a file
   C. Open and edit a file
   D. Discuss the rules for naming files
   E. Switch to the web style interface
   F. View files and change view options
   G. Perform file management operations such as move, copy, delete and
rename a file
   H. Navigate the Explorer window

III. Organizing Files with Windows Explorer
   A. Use Windows Explorer to view the structure of folders and files
   B. Use Windows Explorer to select, create and rename folders
   C. Use Windows Explorer to perform file management operations such as
moving, copying and deleting files and folders
   D. Create a printout showing the structure of files and folders
   E. Use the MS DOS mode to create directories, change directories,
manage files and launch applications

IV. Customizing the Desktop for Increased Productivity
   A. Position a document icon on the desktop
   B. Create and delete shortcuts
   C. Change the desktop appearance
   D. Use the Control Panel to access system settings
   E. Use power management features
   F. Customize the mouse
   G. Customize accessibility settings

V. Bringing the World Wide Web to the desktop
   A. Discuss the structure of the Internet and the World Wide Web
   B. Use the Exploring window to view, open, navigate and print web
pages
   C. Download a file
   D. Enable Active Desktop to add, move, resize, close and remove Active
Desktop items
   E. Subscribe to and unsubscribe to a channel
   F. Customize folders with Web content using Web view
   G. Modify taskbar toolbars

VI. Finding Files and Data
   A. Use the Windows Find utility
   B. Use Quickview to view files
   C. Search for objects on the Internet using query and subject searches
   D. Search with the Search Explorer bar

VII. Working with Graphics
   A. Use the Paint accessory program to open, edit and save a graphic
image file
   B. Use the various drawing tools in the Paint program
   C. Add color, format text and flip and stretch a graphic
   D. Copy and paste portions of a graphic

VIII. Object Linking and Embedding
   A. Insert data from other documents into the WordPad accessory program
   B. Use copy, cut and paste to transfer data from one document to
another
   C. Use the Calculator accessory
   D. Use the Clipboard viewer to view the contents of the clipboard
   E. Use Object Linking and Embedding to insert a graphic and a video
clip in a document
   F. Discuss and use Windows multimedia accessories

IX. Hardware, Printers and Fonts
   A. Print a document to the active printer and to a different printer
   B. Use the print queue to pause, remove and reorder print jobs
   C. Discuss serial, parallel and USB ports for connecting printers to a
computer
   D. Use the Add Printer Wizard
   E. Use the Print Troubleshooter
   F. Discuss Plug and Play
   G. Open the fonts window to examine fonts installed on a computer
   H. Use the System Information Utility to get system information

X. Disk Maintenance
   A. Use the Disk Cleanup accessory to remove unwanted files
   B. Restore deleted files from the recycle bin
   C. Use Scandisk to check for disk errors
   D. Use the disk Defragmenter to defragment a disk
   E. Use the task Scheduler to schedule disk maintenance tasks
   F. Use the Backup and Restore utilities
   G. Create a Startup disk

Content Outline and Competencies:

I. Describe UNIX software components and features, including:
   A. Multi-tasking
   B. Multi-user
   C. Shells and shell programming
   D. Security

II. Access the UNIX System
   A. Login/Logout
   B. Change Password

III. Manage UNIX directories, files and processes, including:
   A. Create, change, list and remove directories
   B. Copy, move, display, create and change permission on files
   C. Originate, kill and check the status of processes
   D. Manipulate foreground and background processes

IV. Create and Edit Initialization files, including:
   A. .profile
   B. .kshrc

V. Perform tasks using UNIX utilities, including:
   A. e-mail
   B. vi editor
   C. telnet
   D. ftp

Content Outline and Competencies:

I. Introduction To Internet
   A. Describe the history of Internet
   B. List Hardware components of Internet

II. Internet Applications
   A. Explore the World Wide Web using a Web Browser
   B. Identify hypertext links and URL addresses
   C. Manage multiple tabs in a web browser
   D. Explain the use of the History command
   E. Identify security issues 

III. Favorites
   A. Add a favorite
   B. Modify favorites
   C. Organize favorites

IV. Search Engines
   A. Use multiple search engines to search the Internet
   B. Apply Boolean Operators to search expression
   C. Save retrieved information

V. Electronic Mail 
   A. Set up an e-mail account
   B. Add contacts to an address book
   C. Send e-mail messages
   D. Send e-mail messages with attachments
   E. Read and reply to e-mail messages

Content Outline and Competencies:

I. Use Electronic Mail To Subscribe and Send Messages
   A. Use a windows and non-windows application to send and receive
electronic mail
   B. Create address book and distribution lists

II. Connect To a UNIX System
   A. Login/Logout
   B. List contents of directories
   C. Create directories
   D. Change directories
   E. Remove files and directories
   F. Change permission on flies

III. Locating And Retrieving Information
   A. Locate FTP resources.
   B. Upload and download files with a Windows-based FTP client
application.
   C. Use a window's program to compress and decompress downloaded files.

IV. Creating a Web Page
   A. Design a Web Page
   B. Use Notepad to create a Web Page
      1. Insert headings and text
      2. Create hyperlinks to connect to other Web resources
   C. View and copy HTML source code
   D. Place Web page on provider's server

Content Outline and Competencies:

I. Overview of HTML
   A. List the advantages of HTML
   B. Explain the limitations of HTML
   C. Describe the use of angle brackets
   D. Explain case-sensitivity 

II. Create Simple HTML Document
   A. Identify required applications
   B. Format text, including:
      1. Font style
      2. Size, justification, blinking
   C. Apply required HTML tags in a document, including:
      1. Title tags
      2. Head tags
      3. Body tags
   D. Provide for text, link, and background color
   E. Display and preview an HTML document

III. Using Headlines and Paragraph Tags
   A. Create Headlines
   B. Format Paragraphs

IV. Creating a Document with URLs
   A. Create a http URL
   B. Create a ftp URL
   C. Create a Gopher URL
   D. Create a mailto URL

V. Lists
   A. Create bullet lists
   B. Create numbered list
   C. Compose and construct menu list
   D. Nest lists

VI. Create Tables
   A. Use preformatted text
   B. Create heading, row, and data tags
   C. Provide for cell alignment
   D. Create a Boxed Table

VII. Images
   A. Format an Inline Image
   B. Define and use helper applications
   C. Use inline image as a hyperlink

VIII. Special Features
   A. Place Ruler Lines
   B. Use Special Characters

Content Outline and Competencies:

Content Outline and Competencies:

Varies