Computer Applications: Summer Test-Out Option

 

Test-Out Option Information - 2017:

The Computer Applications test-out option is scheduled for Tuesday, May 23, from 8:00-12:00. The test is in three parts: Word Processing, Spreadsheets and Presentation Software. Students must receive at least a B (80%) on all three parts to pass. Each test will consist of a group of documents that students will have to produce or revise as accurately as possible. The cost for the test-out option is $25.  Students can be registered for the test-out option by clicking on the link here.

Summer Class Information - 2017:

The Computer Applications Summer Class is scheduled  May 30-June 2 (Tuesday-Friday) and June 5-9 (Monday-Friday) from 9:00 to 1:00 each day.  Students must attend class every day for the entire time period.  The cost for the Computer Applications Summer Class is $225.  Students can be registered for the Computer Applications Summer Class by clicking on the link here.

 

Objectives that should be met in order to pass the Test Out Option:

 

Word Processing:

1. You should be able to use a word processor.

  1. Explain what a word processor is and when you would use one.
  2. Open and save document from/to the hard drive, file server and flash drives
  3. Save documents in a variety of formats such as (.txt, .rtf, .pdf, and .html) and understand when you would use each.
  4. Print a document including such options as printing a range of pages, changing the paper size and printing on both sides of a piece of paper.
  5. Cut, copy, paste, undo and redo via keyboard shortcuts.
  6. Find and replace specific text.
  7. Proofread a document for spelling, grammar and punctuation errors.

2. You should be able to create, format and edit a word processing document with and without images.

  1. Change the format of a page’s margins, orientation, line spacing  
  2. Change the format of paragraph line spacing, spacing and borders
  3. Change the font, font size, font weight, font color, alignment and indentation both for selected text and via styles.
  4. Insert, move, align, and resize images; format images and change the way text wraps around the image.

3. You should be able to use a word processor to create a research paper with citations and references.

  1. Understand and use the MLA documentation style to insert and edit citations and their sources
  2. Create a biographical list of sources
  3. Insert/remove manual page breaks.
  4. Use a header/footer to number and date pages.

4. You should be able to create a business letter with a letterhead and charts/tables.

  1. Insert symbols
  2. Remove formatting from inserted text.
  3. Understand the types of tab stops and be able to use them; create hanging indents.
  4. Insert, format and edit a table and the individual rows, columns and cells in a table.
  5. Insert and format columns of text.
  6. Create a graph in a spreadsheet and use it in a word processing document.

Spreadsheets:

1. You should be able to use a spreadsheet

  1. Explain what a spreadsheet is and when you would use one
  2. Input text, dates, and numbers
  3. Find and correct errors, check spelling
  4. Format the worksheet and individual cells in a variety of ways using styles, themes, and conditional formatting.
  5. Choose the correct way to display cells that hold percentages, dates, currency and numbers.
  6. Adjust column widths, row heights, cell alignments and cell wrappings
  7. When printing, be able to set margins, orientation, headers & footers, grid lines and print range
  8. Rename, color, move, insert & delete worksheet tabs
  9. Sort data in ascending and descending alphabetical and numerical order

2. You should be able to create and format a chart

  1. Select data and chart type
  2. Embed and move charts between worksheets other programs
  3. Insert and format chart titles, labels, and axis

3. You should be able to enter formulas and functions to solve problems

  1. Enter and verify formulas using the keyboard/point mode
  2. Understand and use absolute and relative cell references
  3. Use the sum, average, maximum, minimum and count functions
  4. Create formulas that add, subtract, multiply and divide
  5. Use the IF function to evaluate between 2 choices
  6. Copy formulas and functions using the fill handle

Presentation Software:

1. You should be able to use presentation software

  1. Create a new presentation and select/change/modify a theme
  2. Understand how and when to add a variety slides including title, title with content, comparison and bulleted lists to a presentation.
  3. Duplicate and change the order of slides
  4. Copy slide elements between slides
  5. Add presenter notes to the presentation
  6. Print a presentation with and without notes and change the number of slides that will be printed per page
  7. Save a presentation in a variety of formats and understand when you would use each.

2.  You should be able to edit the content of a presentation

  1. Understand when to use bulleted lists and when not to
  2. Insert, delete and move placeholder slide elements
  3. Understand how and when to apply transitions, animations and sound
  4. Insert, move, arrange and resize images including images that act as the background for a slide.
  5. Change the font, font size, font weight, font effects, alignment and font color so that it will be visible to a large audience.  
  6. Insert, size and add text and effects to a shape

3. You should understand how to use a master slide

  1. Insert or delete an image, text or other media into a master slide
  2. Change the background of a presentation using the slide master
  3. Apply slide dating and/or numbering to all slides

4. You should be able to use the following advanced presentation options.

  1. Use format painter to copy format to other slide elements
  2. Format and add effects to images
  3. Ungroup, edit, and regroup slide elements
  4. Change the style of bulleted lists to better fit your presentation
  5. Insert, edit and control video and audio clips
  6. Create a graph in a spreadsheet and use it in a presentation.