Computer Concepts/IMS-115 Skills Survey Johnson

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 2016) are emphasized. Computer Concepts is a Dual Credit (Early College) course with an agreement with Community School District 218 and Moraine Valley Community College. To test your current applications skill level and to determine what skills you need to know, complete the survey below.
View results without submitting

Name: 


A red asterisk (*) indicates required questions.

  1. Microsoft Word:I can use Microsoft Word to create, edit, print, and save a document.*
    Yes
    No


  1. Microsoft Word:When utilizing Word, I can display formatting marks, check spelling automatically, select text, and format text (bold, itlaics, underline, small caps, superscripts, subscripts).*
    Yes
    No


  1. Microsoft Word:When utilizing Word, I can format paragraphs, undo and redo commands, insert clip art, resize and reposition clip art, and correct errors.*
    Yes
    No


  1. Microsoft Word:I can use the help system efficiently.*
    Yes
    No


  1. Microsoft Word:I can use Word to create a research paper in MLA style.*
    Yes
    No


  1. Microsoft Word:I can create headers and footers, insert page numbers, and automatically indent paragraphs.*
    Yes
    No


  1. Microsoft Word:I can use Word's AutoCorrect feature, modify styles, insert automatic page breaks, and insert symbols.*
    Yes
    No


  1. Microsoft Word:I can insert manual page breaks, create a hanging indent, create a hyperlink, and sort paragraphs.*
    Yes
    No


  1. Microsoft Word:I can use find and replace, move text, use the thesaurus, use word count, and reset menus and toolbars.*
    Yes
    No


  1. Microsoft Word:I can use Word's Resume Wizard to create a resume.*
    Yes
    No


  1. Microsoft Word: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.*
    Yes
    No


  1. Microsoft Word:I can use Word's Web Page Wizard to create and modify a Web page.*
    Yes
    No


  1. Microsoft Excel: I can use Microsoft Excel to create a worksheet and embedded chart.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Excel: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.*
    Yes
    No


  1. Microsoft Access: Using Microsoft Access, I can create a new database.*
    Yes
    No


  1. Microsoft Access:I can create a table, add records to a table, correct errors in data, and print the table.*
    Yes
    No


  1. Microsoft Access:I can create and save a form, enter records using the form, and switch between form and datasheet view. *
    Yes
    No


  1. Microsoft Access: I can create and print a report.
    Yes
    No


  1. Microsoft Access:I can create a query using the select query window, run and save the query, and print the query results.*
    Yes
    No


  1. Microsoft Access:I can use text data, wildcards, numeric data, and comparison operators in query criteria.*
    Yes
    No


  1. Microsoft Access:I can use compound criteria, sort data in a query, join tables, use calculated fields, and use criteria and grouping in calculating statistics.*
    Yes
    No


  1. Microsoft Access:I can add, modify, filter, and delete records in a table.*
    Yes
    No


  1. Microsoft Access: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.*
    Yes
    No


  1. Microsoft Access: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.*
    Yes
    No


  1. Microsoft Access:I can specify referential integrity, use subdatasheets, order records, create and use indexes, and publish to the Internet using data access pages.*
    Yes
    No


  1. Microsoft PowerPoint: 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.*
    Yes
    No


  1. Microsoft PowerPoint: 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.*
    Yes
    No


  1. Microsoft PowerPoint: 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.*
    Yes
    No


  1. Microsoft PowerPoint: I can add headers and footers to slides and handouts, animate clip art, run a slide show, and print an outline.*
    Yes
    No


  1. Microsoft PowerPoint: I can save and view a PowerPoint presentation as a Web page, and I can edit a Web page through a browser.*
    Yes
    No


  1. Looking below, select the rating that you consider your computer knowledge to be.
      1 2 3 4 5  
    Excellent   Poor





Mr. Holben
Education Town, IL