CIS-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 Microsoft Office application suite (MS Word, MS Excel, MS Powerpoint and MS Access).. To test your current applications skill level and to determine if CIS-115 is an appropriate course for you, take this survey and answer Yes or No to the following statements.

# Statement Yes No
Microsoft Word
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, Quick Access toolbar, shortcut menus, and Quick Access Toolbar.

8. I can insert a hyperlink and convert to regular text.

9. I can insert, format, reposition, change layout options 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
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 Auto Calculate 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
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
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.