|
CMIS 108 proficiency exam
The CMIS 108 Proficiency Exam is considered
an Out Of Class Proficiency, which means that the student may not
be concurrently enrolled in a CMIS 108 course and register to take
the CMIS 108 Proficiency Exam. Any student currently enrolled in
a CMIS 108 course must withdraw from the course by Friday of the
first week in order to be eligible to register for the CMIS 108
Proficiency Exam. Currently the Proficiency Exam is offered on the
Friday afternoon of Week 3 from 12:00 pm – 4:00 pm. Students
must register to take the CMIS 108 Proficiency at Instructional
Services and obtain a form that will be used by the exam administrator
to submit the grade earned. Instructional Services is located in
Peck Hall, Room 1404, and the phone number is 650.2295. After obtaining
the Registration Form from Instructional Services, students must
also obtain a seat for the exam by submitting the completed form
to the CMIS Department located in Founders Hall, Room 2310. Students
must register for and obtain a seat for the exam by Friday of Week
2 of the Fall or Spring semesters. The CMIS 108 Proficiency Exam
is not offered during the summer session. Visit the CMIS Department
website for more information regarding the CMIS 108 Proficiency.
The CMIS 108 Proficiency Exam is designed to
assess proficiency in basic computer terminology and skills. The
exam consists of two parts that are administered during a four hour
exam period. The theories portion of the exam has approximately
130 questions covering all materials contained in the two CMIS 108
books. The skills portion of the exam consists of three tests covering
Word, Excel and PowerPoint materials. Students must successfully
complete the theories portion of the exam with 70% before being
allowed to proceed to the skills portion of the exam. Fall Semester
2005, 2% of the CMIS 108 Proficiency registrants successfully completed
the theories portion of the exam. Students will be allowed to use
the Microsoft Office textbook as a reference on the skills portion
of the CMIS 108 Proficiency Exam only. Students will be expected
to be proficient in the following skills areas:
Word Skills
Launch Microsoft Word
Create a simple document and save it to a folder on removable
media.
Open an existing document and apply the following text editing:
o Boldface
o Italics
o Underlining
o Left/center/right/full justification
o Various vertical alignments
o Change text font and size
o Adjust margins and or tables
o Bulleted or numbered lists
o Use borders and shading on pages and objects
Vary line spacing for a document, section or paragraph
Insert page/section/column breaks
Create multiple columns in the document
Use headers/footers/footnotes and Autotext
Insert and manipulate a picture into the document
Cut/copy/paste text from one document to another document
Insert clipart images inline and other layouts into text
Insert and format WordArt
Use styles from the Style box
Create Title pages.
Manipulate header printing
Manipulate the Print menu
Excel Skills
Launch (start up) and exit Microsoft Excel
Design, create and save a simple spreadsheet to disk drive an
external device
Import data files into a worksheet
Enter text, values, formulas, and functions in cells
Convert an algebraic expression to a spreadsheet formula, including
the use of the +, -, *, and / mathematical operators.
Enter formulas in cells using both absolute and relative addressing
Copy and cut and then paste cell contents to other cells and to
other sheets of a workbook
Copy and cut and past cell formulas to other cells and sheets
Move the contents of a range of cells
Delete and clear cell contents
Use Excel Functions such as AVERAGE, SUM, MAX, MIN, IF and others
Perform What-If Analysis by changing variable data values
Use the Autosum feature to sum a set of vertical or horizontal
cells
Sort data by columns and or rows
Create range names
Format text including bold face, italics, underlining, left/center/right
justification
Format cells for different types of numeric display, such as number,
currency, and percentage
Center a spreadsheet vertically and horizontally
Add and remove gridlines from the screen display and printouts
Spell check a worksheet
Changing text style and size
Center text across columns
Change column size
Use AutoFormat
Add borders to cells
Insert a page header/footer and page number and date
Change margins
Print a spreadsheet or a portion of a spreadsheet
Lock row and column headings to print on multi-page printouts
Print spreadsheet formulas
Print a large spreadsheet to a single, 8½ x 11 inch page
Insert new rows and columns
Delete rows and columns
Freeze rows and columns
Insert comments, callouts and text boxes
Insert or create graphics, including banners and arrows, using
the Drawing toolbar
Print in landscape and portrait mode
Add shadowing, color, and shading to cells, text boxes, images,
and other objects
Create different types of charts including pie charts, bar graphs,
and column charts
Create 2D and 3D charts
Specify detailed characteristics of a graph including the chart
title, axis labels, and data labels
Select row versus column display of data
Create an embedded chart
Create a chart in another sheet of a workbook
Move and resize a chart
Add patterns to column chart data markers
Add a picture to a chart
Rearrange the order of worksheets in a workbook
PowerPoint Skills
Launch PowerPoint
Create a new presentation with multiple slide layouts, including:
Bullet slides
Title slides
Text & clipart slides
Blank slides
Importing slides into an existing presentation using either cut/copy/paste
or Slide Finder
Changing slide order in both outline mode and slide sorter mode
Adding bullet items and/or changing the level (promote/demote)
of items on a bullet slide
Adding and deleting slides in an existing presentation
Adding, editing (using Picture Toolbar), moving and resizing objects
such as clipart, Internet images/pictures (including motion images)
, autoshapes (including callouts), text boxes, etc.
Modifying clipart with Group/Ungroup
Adding or changing backgrounds and/or design templates in a presentation
Creating and printing speaker notes and handouts
Creating a slide show with transitions, custom animations, sound
effects, and action buttons.
|
