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 2010: MS Word, MS Excel, MS Powerpoint and MS Access) 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

Microsoft Word 2010
1. Using Microsoft Word I can perform the following basic operations to create Word documents: start/quit, open/close, display formatting marks, edit/select/move text, undo/redo, print preview/print, and save documents.    
2. I can create a document and format/modify text with the following: font type, font size, bold, italics, underline, superscript, and subscript.    
3. I can use the following Word features: spelling and grammar check, help, thesaurus, AutoCorrect, Office Clipboard, find/replace , word count, AutoText    
4. I can insert and format the following: headers/footers, page numbers, manual page breaks, indented paragraphs (first-line and hanging indents), hyperlinks, and tab stops.    
5. I can create, edit, and format a table.    
6. I understand the default line spacing in Word 2010 and can modify the line spacing before and after paragraphs.    
7. I can identify and utilize the various components of the Word window: Ribbon, Mini toolbar, shortcut menus, and Quick Access Toolbar.    
8. I can insert a hyperlink and convert to regular text.    
9.  I can insert, format, reposition, and resize pictures, clip art, and symbols.    
10. I can prepare a research paper and follow proper guidelines using the Modern Language Association of America (MLA) documentation style.    
11. I can create a business letter with a letterhead.    
12. I can apply predefined styles that appear in the Styles gallery on the Ribbon.    
13. I can customize and reset Word options and change document properties.    

Microsoft Excel 2010
14. Using Microsoft Excel I can perform the following basic operations: enter, edit, and format text and numbers by changing the font type, font size, font color, fill color, and use the format painter to copy formatting from one location to another.    
15. I can enhance the visual display of a worksheet by adding styles, themes, borders, rotate text, center cell entries across columns by merging cells, and add conditional formatting to a range of cells.    
16. I can create and enter formulas using the keyboard and point mode, use AutoSum, use the range finder to verify a formula, and display the formulas version of the worksheet.    
17. I can use built-in functions to perform common calculations on data and use the AutoCalculate area to display statistics.    
18. I understand the difference between absolute and relative cell references.    
19. I can use What-If Analysis and Goal Seek to analyze worksheet data.    
20. I can use the fill handle to create a series, and copy a formula to adjacent cells.    
21. I can insert and format charts such as pie/column/Sparkline charts.    
22. I can adjust row heights and column widths, insert and delete rows and columns, and freeze column and row titles.    
23. I can change a worksheet name and add color to the worksheet tab.    
24. I can set margins, add headers and footers, change the worksheet orientation, save a workbook, print preview a worksheet, print a worksheet or a section of a worksheet, and change document properties.    

Microsoft Access 2010
25. Using Microsoft Access I can design and create a new database.    
26. I can create a table in datasheet or design view, identify the primary key, define the fields in a table, add/delete records, import records to a table, save, print preview, and print the contents of a table.    
27. I can create a query using the simple query wizard or create a query in design view and add criteria to a query including text data, numbers, comparison operators, a wild card, and compound criteria to search for information in a database.    
28. I can sort data in a query, join tables, use calculated fields, and print query results.    
29. I can create and save a form, enter records using the form, and print the form.    
30. I can create custom reports, modify column headings, resize columns in print layout view, add totals to a report, and print the report.    
31. I can customize the navigation pane, change database properties, and compact and repair a database.    
32. I can maintain a database by adding, changing, deleting, and filtering records.    
33. I can change the structure of a database by adding a new field, deleting a field, resizing columns, and changing field size.    
34. I can create validation rules such as specifying a required field, specifying a range, specifying a default value, and specifying a collection of legal values.    
35. I can use single-valued and multivalued lookup fields.    
36. I can update forms and reports to reflect changes to the table structure.    

Microsoft PowerPoint 2010
37. Using Microsoft PowerPoint I can create a new slide show presentation.    
38. I can choose a document theme to provide consistency in design and color throughout the presentation by setting the color scheme, font set, and layout of a presentation.    
39. I can create slides, including a title slide and a text slide with a multi-level bulleted list, add new slides, and change slide layouts.    
40. I can insert Clip Art and photographs into slides.    
41. I can add a picture style, add a border, add and resize shapes, apply a shape style, and use WordArt.    
42. I can format a slide background, using a solid color, gradient color, or a picture or texture.    
43. I can add a shadow to text to help letters display prominently.    
44. I can add animation effects, special visual and sound effects, and apply to text or content.    
45. I can add a slide transition, a special animation effect, used to progress from one slide to the next.    
46. I can format pictures by recoloring and adding artistic effects.    
47. I can change from normal view to slide sorter view to check slides for balance and consistency.    
48. I can add media to slides by inserting a video file and an audio file, and run a slide show with media.    
49. I can change document properties.    
50. I can add notes to a slide in the notes pane, preview and print a handout, save, and close the presentation.    

If you answered Yes with confidence to 40 or more of the statements above, you may contact Jane Corradetti at (708)974-5463 or Carol Boyle at (708) 974-5444 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.