Minimum Computer Literacy Graduation Requirements

For Transferring, ROP or ISP Students

Categories: Touch Keyboarding, File Management, Word Processing, Spreadsheets and Information Transmission, Storage, Retrieval & Online Research

Curriculum: “Learning MS Office”, “Recipes For Computing Success”, Mavis Beacon Teaches Typing

Testing Requirements: Pass 5 Competency Tests (for each of the 5 categories below).

Credit allowed for similar Competencies passed at other high schools.

Touch Keyboarding

- Test #1: Timed Writing with minimum 28 adjusted words per minute (net).

File Management – Windows Explorer

- terminology, menu commands, file creation, filename changing, folder creation, storing files in folders and folders in folders, moving and copying files and folders, searching files/folders by file size, date, file type, filename, etc.

- Test #2: covering material found in “Learning MS Office 2003”, Basics (on CD) Lessons 1-4 and Champion Recipes #2-10

Word Processing – MS Word

- Formatting & Editing: terminology, menu commands, margins, page orientation, tabs, headers/footers, copy/paste, fonts, justification, bullets, borders, graphics, tables, spell check, pagination, graphic insertion, text wrap, printing

- Test #3: covering material found in “Learning MS Office 2003”, MS Word Lessons 1-3 & 5

Spreadsheets – Excel

- terminology, menu commands, workbook/worksheet creation, chart creation, cell navigation, cell formatting/width/borders/backgrounds/alignment, cell formulas, series, number formats, functions, math operations

- Test #4: covering material found in “Learning MS Office 2003”, Excel Lessons 1-3

Information Transmission, Storage, Retrieval & Online Research

- Internet browser use to search and utilize information by using appropriate operators and searching techniques

- access electronic encyclopedias, dictionaries, thesauri, maps, atlases, museums, libraries, research centers and other educational/information repositories

- capture and save data, information, objects in the correct formats

- store and send documents via modern devices (WAN, LAN, CD, DVD, Flash drives, email, FTP, etc.) and techniques (file compression, encryption).

- Test #5: covering exercises found in “Recipes for Computing Success”, Recipes #50-54