Moraine Valley Community College || Information Management Systems

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 2013: 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, take this survey and answer Yes or No to the following statements.

  Statement Yes No
Microsoft Word 2013
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 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 2013
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 2013
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 multi-valued lookup fields.

36. I can update forms and reports to reflect changes to the table structure.

Microsoft PowerPoint 2013
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 re-coloring 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.

Take a Campus Tour
View the Campus Camera
Veterans Student Information
Moraine Valley Facebook Account
Moraine Valley Twitter Account
Moraine Valley Flickr Account
Moraine Valley Youtube Account