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:
1. You should be able to use a word processor.
- Explain what a word processor is and when you would use one.
- Open and save document from/to the hard drive, file server and flash drives
- Save documents in a variety of formats such as (.txt, .rtf, .pdf, and .html) and understand when you would use each.
- 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.
- Cut, copy, paste, undo and redo via keyboard shortcuts.
- Find and replace specific text.
- 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.
- Change the format of a page’s margins, orientation, line spacing
- Change the format of paragraph line spacing, spacing and borders
- Change the font, font size, font weight, font color, alignment and indentation both for selected text and via styles.
- 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.
- Understand and use the MLA documentation style to insert and edit citations and their sources
- Create a biographical list of sources
- Insert/remove manual page breaks.
- 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.
- Insert symbols
- Remove formatting from inserted text.
- Understand the types of tab stops and be able to use them; create hanging indents.
- Insert, format and edit a table and the individual rows, columns and cells in a table.
- Insert and format columns of text.
- Create a graph in a spreadsheet and use it in a word processing document.
1. You should be able to use a spreadsheet
- Explain what a spreadsheet is and when you would use one
- Input text, dates, and numbers
- Find and correct errors, check spelling
- Format the worksheet and individual cells in a variety of ways using styles, themes, and conditional formatting.
- Choose the correct way to display cells that hold percentages, dates, currency and numbers.
- Adjust column widths, row heights, cell alignments and cell wrappings
- When printing, be able to set margins, orientation, headers & footers, grid lines and print range
- Rename, color, move, insert & delete worksheet tabs
- Sort data in ascending and descending alphabetical and numerical order
2. You should be able to create and format a chart
- Select data and chart type
- Embed and move charts between worksheets other programs
- Insert and format chart titles, labels, and axis
3. You should be able to enter formulas and functions to solve problems
- Enter and verify formulas using the keyboard/point mode
- Understand and use absolute and relative cell references
- Use the sum, average, maximum, minimum and count functions
- Create formulas that add, subtract, multiply and divide
- Use the IF function to evaluate between 2 choices
- Copy formulas and functions using the fill handle
1. You should be able to use presentation software
- Create a new presentation and select/change/modify a theme
- Understand how and when to add a variety slides including title, title with content, comparison and bulleted lists to a presentation.
- Duplicate and change the order of slides
- Copy slide elements between slides
- Add presenter notes to the presentation
- Print a presentation with and without notes and change the number of slides that will be printed per page
- 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
- Understand when to use bulleted lists and when not to
- Insert, delete and move placeholder slide elements
- Understand how and when to apply transitions, animations and sound
- Insert, move, arrange and resize images including images that act as the background for a slide.
- Change the font, font size, font weight, font effects, alignment and font color so that it will be visible to a large audience.
- Insert, size and add text and effects to a shape
3. You should understand how to use a master slide
- Insert or delete an image, text or other media into a master slide
- Change the background of a presentation using the slide master
- Apply slide dating and/or numbering to all slides
4. You should be able to use the following advanced presentation options.
- Use format painter to copy format to other slide elements
- Format and add effects to images
- Ungroup, edit, and regroup slide elements
- Change the style of bulleted lists to better fit your presentation
- Insert, edit and control video and audio clips
- Create a graph in a spreadsheet and use it in a presentation.