Computer Literacy Requirements

Introduction

All Carroll students are required to demonstrate computer literacy as a graduation requirement. Students can demonstrate computer literacy by taking a three or four credit course in MIS, CAD, CGR, or CIS. Some students elect to take the Computer Literacy Assessment in lieu of taking one of these classes.

Students may complete the Computer Literacy Assessment process one time. If the student is successful, his/her record will indicate that he/she has successfully completed the assessment. If the student is unsuccessful, the record will reflect that the student has unsuccessfully taken the exam, (In this case, the student will be required to satisfy the requirement by taking one of the course identified above). In order to take the Computer Literacy Assessment, the student should:

  • Contact the Office Technology Lab (410-386-8179) to schedule a time to take the assessment. The Office Technology Lab has both day and evening hours and should be able to accommodate all student scheduling constraints.
  • Prepare for the exam by examining the list of skills and topics to be covered on the following pages and by practicing or studying in order to be prepared to demonstrate knowledge of these skills and concepts.  (For further study, students may purchase a textbook package for the MIS 101-75 (Online) course at the Carroll Community College bookstore. This book package contains a Microsoft Office Professional text as well as a text which covers Computer Concepts and covers all of the skills and topics covered in the exam.)
  • Arrive at the Office Technology Lab (Room A226) at the scheduled time and complete several items:
    • Sign the Computer Literacy Assessment acknowledgement form to indicate that you understand the process and acknowledge the policies set forth.
    • Complete the multi-part computerized assessment that measures both knowledge of overall computer concepts and the use of application software. The assessment will take approximately two hours to complete.

If students have any questions or concerns about the process, they may contact the Office Technology Lab at 410-386-8179. Further questions or concerns may also be directed to Mary Beth Graham at 410-386-8253.

Exam results will be certified by the Office Technology Lab staff and communicated to the Records Office, who will post the results to the student record. There is no charge for taking the Computer Literacy Assessment, but students are allowed to complete the testing process only one time.

Overview of Exam Process:

The Computer Literacy Assessment has five sections:

  • Computer Concepts
  • Windows
  • Word Processing (Word)
  • Spreadsheets (Excel)
  • Presentation Management (PowerPoint)

In order to satisfy Carroll Community College's computer literacy requirement, students must score at least an 80% in each of the five sections. If a student fails to score 80% in all five (5) sections, they will not satisfy Carroll Community College's computer literacy requirement.

However, if a student scores 80% or higher in three (3) sections, AND scores at least 50% in the other two (2) sections, they may complete a tutorial for each of the missed sections and then re-take the assessment for only those sections. If the student subsequently scores at least 80% for these sections, they will have satisfied Carroll Community College's computer literacy requirement. If the student does not successfully score 80% or higher on the missed sections during this one retake, they will not have satisfied Carroll Community College's computer literacy requirement, and will need to take the required courses to satisfy the college's requirements.

The above process may not be repeated by a student; this is a one-time assessment.

Review of Topics Covered:

Windows XP

This section assesses the student's ability to use standard components of the Windows operating system, including:

  • Elements of Windows desktop (icons, shortcuts, Start menu, task bar, Recycle Bin, etc.)
  • Using the mouse
  • Using the Start menu
  • Starting up and shutting down the computer
  • Opening and closing files
  • Creating, naming, renaming, and deleting files and folders
  • Working with windows and changing the size and location of windows
  • Using My Computer

Word Processing (Word)

This section of the exam assesses the student's ability to utilize Microsoft Word to perform word processing functions. Possible skill topics include:

  • Creating and editing documents
    • Enter/edit text
    • Delete text
    • Save and save as 
    • Saving file in .doc and other formats
    • Selecting/highlighting text
    • Using Clipboard
    • Open/close documents
    • Working with folders
    • Printing
  • Formatting characters and paragraphs
    • Font typeface, size, color, and style
    • Format painter
    • Paragraph alignment
    • Tabs
    • Indenting text
    • Line spacing
    • Bullets/numbered lists
  • Formatting and enhancing documents
    • Correcting grammar and spelling errors
    • Document views
    • Cut, copy, and paste
    • Page Setup (margins, orientation, etc.)
    • Find and replace
    • Page numbers
    • Headers and footers
    • Insert and format clip art/graphics from clip gallery or a file
  • Tables and charts
    • Inserting a table
    • Formatting a table

Spreadsheets (Excel)

This section of the exam assesses the student's ability to utilize Microsoft Excel to perform electronic spreadsheet functions. Possible skill topics include:

  • Creating and editing worksheets
    • Enter/edit numbers and text
    • Save and save as 
    • Using Clipboard
    • Open/close documents
    • Working with folders
    • Printing
  • Formatting/ a worksheet
    • Deleting cell data
    • Formatting numbers and text (using both menus and toolbar)
    • Modify column width/row height (using both menus and toolbar)
    • Inserting/deleting rows and columns
    • Page setup (margins, header/footer, page orientation)
  • Inserting formulas in a worksheet
    • Insert and modify formulas, including SUM, AutoSum, AVG and other functions
    • Absolute cell references
  • Creating a chart
    • Create a chart (pie, column, etc.) using chart wizard
    • Modify chart elements (title, labels, etc.)
    • Create chart on a new worksheet
  • Working with multiple worksheets in a workbook
    • Adding a new worksheet
    • Renaming/deleting/copying a worksheet within a workbook

Presentation Management (PowerPoint)

This section of the exam assesses the student's ability to utilize Microsoft PowerPoint to perform presentation management functions. Possible skill topics include:

  • Creating and editing a presentation
    • Creating a new presentation
    • Inserting a new slide
    • Selecting and changing slide layouts
    • Entering/editing text
    • Save and save as 
    • Package for CD
    • Using Clipboard
    • Open/close documents
    • Working with folders
    • Printing and changing printing options (slides, handouts, color, black/white, etc.)
  • Formatting text in a presentation
    • Font typeface, size, color, and style
    • Format painter
    • Text alignment
    • Tabs
    • Line spacing
  • Formatting/enhancing a presentation
    • Headers and footers
    • Adding a design template
    • Modifying a design template
    • Inserting clip art/graphics from clip gallery and from a file
    • Custom animation and animation schemes
    • Slide transitions
    • Inserting objects, such as tables, graphs, etc. into presentation

Computer Concepts

  • General knowledge
    • History of computers
    • Introduction of microcomputers
    • Information Processing Cycle (input, processing, output, storage)
    • Bits, bytes (KB, MB, BG, TB)
  • Input/Output devices
    • Mouse, keyboard, microphone
    • Printers, monitors, speakers
  • Processing hardware (CPU, RAM, data bus, ports, etc.)
  • Storage devices and media
    • Magnetic storage devices and media
    • Optical discs (CD-ROM, CD-RW, DVD-ROM, DVD-RW)
  • Software
    • Application software
    • System software
      • Operating systems
      • Utilities
      • User interfaces (graphics vs. command line)
    • Software piracy/copyright infringement
    • Using Help
  • Internet
    • URL's
    • Search engines
    • Browser software
    • Spam
    • Viruses
    • Chat rooms
    • Internet service providers
    • Connecting to the Internet (dial-up, DSL, cable, satellite)
  • Communications and networking
    • Modems
    • Wireless technology (Bluetooth, hot spots, hardware, etc.)

Bookmark, Share, or Email this page Get Help