Shasta Union High School District

Performance Objectives for Challenge Computer Proficiency Exam

 

Students Must Pass Word Processing and Other Required Components

With 70% Accuracy on Each Component

  

Web Page

Spreadsheet

Desktop Publishing 

Internet

PowerPoint

General Computer Knowledge

E-mail

Database

Click to see an example of a personal business letter

Word processing (Word) performance objectives:

 

Student will demonstrate proficiency by:

                                                                                                                                   

  1. Opening an existing file
  2. Adding a header and footer to document
  3. Demonstrating correct personal business letter style
  4. Operating spelling, grammar and thesaurus feature
  5. Proofreading, check spelling and correcting errors in document
  6. Format:
    1. Double spacing
    2. Triple spacing
    3. Horizontal centering
    4. Right align text
    5. Bold text
    6. Underline text
    7. Changing right and left margins
    8. Initial caps or title case
    9. Deleting tab and enters as directed
  7. Saving file in correct location 
  8. Printing documents

 

 


Spreadsheet (Excel) performance objectives:

Student will demonstrate proficiency by:

 

  1. Opening file from spreadsheet program
  2. Centering title across selection
  3. Centering column headings
  4. Underlining column headings
  5. Entering numbers as labels
  6. Formatting values to two decimal places with comma
  7. Using header function
  8. Entering formulas to add, subtract and multiple values
  9. Formatting to landscape orientation

10.        Centering spreadsheet vertically and horizontally on page

11.        Printing with gridlines

12.        Printing to one page

13.        Printing formulas

14.        Saving file in correct location

 

 

 

 


Database software (Access) performance objectives:

Student will demonstrate proficiency by:

 

  1. Creating, designing, naming database table and query
  2. Entering text and number data types
  3. Editing and correcting errors as needed
  4. Sorting data in descending order
  5. Adjusting column width as necessary
  6. Creating and designing a query in order to answer specified question
  7. Saving database file in correct location 
  8. Printing table and query

 

 

 


Presentation software (PowerPoint) performance objectives:

Student will demonstrate proficiency by:

 

  1. Creating new slide show
  2. Adding template or background to slide show
  3. Preparing slides in sequential and organized manner
  4. Choosing title, outline and clip art and text slide from slide layout
  5. Entering text on slides
  6. Inserting graphics on slides
  7. Adding custom animation at least two slides
  8. Adding transitions to slide show
  9. Adding effects to slide show

10.        Timing slide show

11.        Saving slide show to student folder

12.        Printing slide show in outline view

 

 

 


Web page (FrontPage or Dreamweaver) performance objectives:

Student will demonstrate proficiency by:

 

  1. Opening web pages from browser using URL
  2. Creating new web page using web page software
  3. Creating tables, fill, adjust and modify the table as needed
  4. Importing and place images
  5. Sizing images
  6. Setting hyperlinks to other web pages and verify hyperlinks work
  7. Applying background color or theme
  8. Modifying colors for links and text as instructed
  9. Creating an e-mail link

10.        E-mailing information to web master as directed

11.        Saving web page in appropriate folder

 

 

 


Desktop Publishing (Publisher or Word) performance objectives:

Student will demonstrate proficiency by:

 

  1. Opening an existing file
  2. Adjusting top/bottom/right and left margins
  3. Horizontal lines
  4. Inserting, sizing and placing images in a document
  5. Wrapping text around image
  6. Formatting newsletter to two columns of equal length
  7. Inserting line enders as instructed
  8. Operating spell checker
  9. Proofreading, check spelling and correcting errors in document

10.        Formatting:

a.             Enlarge font point size

b.            Horizontal centering

c.             Bold text

d.            Center text

e.             Insert a drop cap

11.        Saving file in correct location 

12.        Printing documents

 

 

 

 


Internet performance objectives:

Student will demonstrate proficiency by:

 

  1. Launching a web browser
  2. Searching for information on two specific topics
  3. Copying and pasting information from the web page to word processing document
  4. Copying URL and pasting to word processing document
  5. Adding horizontal lines between word processing documents to separate information
  6. Saving a web page
  7. Printing one page of a web page

 


E-mail performance objectives:

Student will demonstrate proficiency by:

 

  1. Launching a web browser
  2. Navigating to the directed URL
  3. Logging in using designated user name and password
  4. Composing short message to be e-mailed to proctor
  5. Attaching word processing document to e-mail
  6. Sending e-mail to test proctor

 

 

 


Study these terms for the general computer information challenge test component. 

 

Bits

Computer ethics

Computer piracy laws

Bytes

Megahertz

ENIAC

Compact disk

Cell

Active cell

Computer copyrights

Public domain

Desktop publishing software uses

Database field names

Uploading

Electronic bulletin boards

Database file

Database—records

Database--sorting

Disk drives

Bill Gates

Steve Jobs

ENIAC

URL

Browser

Hardware

RAM

Input, processing, output, storage

Modem

Internet Service Providers or IS:

Input devices—list most common

On-line database equipment requirements

Grace Hopper

Lady Augusta Ada Byron

Software

Charles Babbage

Central Processing Unit or CPU

Spreadsheet formulas

Average spreadsheet formula and function

Liquid crystal display or LCD

Spreadsheet software uses

Word processing software uses

Database software uses

Thesaurus

Spell checker

Clip art

Word wrap

Copy and cut in word processing

Tabbing in word processing

Window

Internet protocol