IMS--IMS-115 Skills Survey

Information Management Systems

Welcome

Announcements

Course Surveys

Degrees & Certificates

Courses Offered

Special Topics Courses

Tutor Schedule

Certification Testing

Management Information Systems

Office Systems and Applications

Faculty

Support Services

MSDNAA/ELMS

Moraine Valley Robotics Club

Do you have an IMS card for a FREE SONG DOWNLOAD?

Ask your IMS Instructor how to earn one.
CLICK HERE!

IMS-115 Skills Survey

This course is designed to develop integrated PC application skills required for the completion of personal and business projects. The creation and modification of text using a popular office application suite (Microsoft Office 2003) are emphasized. To test your current applications skill level and to determine if IMS-115 is an appropriate course for you, print this survey and answer Yes or No to the following statements.

	Statement	Yes	No
*Word Processing*
1.	I can use Microsoft Word to create, edit, print, and save a document.
2.	When utilizing Word, I can display formatting marks, check spelling automatically, select text, and format text (bold, italics, underline, small caps, superscripts, subscripts.)
3.	When utilizing Word, I can format paragraphs, undo and redo commands, insert clip art, resize and reposition clip art, and correct errors.
4.	I can use the help system efficiently.
5.	I can use Word to create a research paper in MLA style.
6.	I can create headers and footers, insert page numbers, and automatically indent paragraphs.
7.	I can use Word's AutoCorrect feature, modify styles, insert automatic page breaks, and insert symbols.
8.	I can insert manual page breaks, create a hanging indent, create a hyperlink, and sort paragraphs.
9.	I can use find and replace, move text, use the thesaurus, use word count, and reset menus and toolbars.
10.	I can use Word's Resume Wizard to create a resume.
11.	I can create and edit a table, set tab stops, use the Office clipboard to collect multiple items and paste them in new locations, and create an AutoText entry.
12.	I can use Word's Web Page Wizard to create and modify a Web page.
Spreadsheets
13.	I can use Microsoft Excel to create a worksheet and embedded chart.
14.	I can select a cell or range of cells, use AutoSum, copy using the fill handle, apply the AutoFormat command to format a range, and center cell contents across columns.
15.	I can use the Name box to select a cell, create and format a column chart and a 3-D pie chart, use AutoCalculate, save, and print a partial or complete worksheet.
16.	I can create formulas and utilize built-in functions, verify a formula, color the characters and background of a cell, add borders to a range, add conditional formatting to a range of cells, and adjust column width and row height.
17.	I can use a Web query to get real-time data from a Web site, rename and rearrange sheets, and display and print the formulas version of a worksheet.
18.	I can rotate text in a cell, use the fill handle to create a series, use the format painter button to copy a cell's format to another cell, freeze column and row titles, and insert and delete cells.
19.	I can use absolute references in a formula, use the IF function, display and dock toolbars, and use the Goal Seek command to analyze worksheet data.
20.	I can save an Excel workbook as a static Web page, save a workbook as a dynamic Web page, and modify the worksheet on a dynamic Web page.
Database Management
21.	Using Microsoft Access, I can create a new database.
22.	I can create a table, add records to a table, correct errors in data, and print the table.
23.	I can create and save a form, enter records using the form, and switch between form and datasheet view.
24.	I can create and print a report.
25.	I can create a query using the select query window, run and save the query, and print the query results.
26.	I can use text data, wildcards, numeric data, and comparison operators in query criteria.
27.	I can use compound criteria, sort data in a query, join tables, use calculated fields, and use criteria and grouping in calculating statistics.
28.	I can add, modify, filter, and delete records in a table.
29.	I can change the structure of a database by changing field size, adding a new field, deleting a field, resizing columns, using an update query and a delete query.
30.	I can create validation rules such as specifying a required field, specifying a range, specifying a default value, specifying a collection of legal values, and using a format.
31.	I can specify referential integrity, use subdatasheets, order records, create and use indexes, and publish to the Internet using data access pages.
Presentation Graphics
32.	I can use Microsoft PowerPoint to create a new presentation, choose a design template, create a title slide, create a bulleted list slide, and add new slides with the same autolayout.
33.	I can end a slide show with a black slide, check a presentation for consistency and spelling, display and modify the slide master and the title master, display a presentation in black and white, and print a presentation.
34.	I can create a presentation in outline view, rearrange slides in slide sorter view, change slide layout, insert clip art on a slide, move and modify clip art, and create a hyperlink.
35.	I can add headers and footers to slides and handouts, animate clip art, run a slide show, and print an outline.
36.	I can save and view a PowerPoint presentation as a Web page, and I can edit a Web page through a browser.

If you answered Yes with confidence to 29 or more of the statements above, you may contact Jane Corradetti at (708)974-5463 to discuss taking an Assessment of Prior Learning test to earn credit for IMS-115 or to request a Waiver of Prerequisite for IMS-115 in order to take advanced courses. Otherwise, it is recommended that you enroll in IMS-115, Introduction to PC Applications.