Computer & Information Technology 10600 Waiver Exam

Test out of CIT 10600

Students who feel competent in word processing, spreadsheet, and presentation software, as well as basic computer concepts, Windows operating systems, and the Internet, may choose to take the waiver exam for the course CIT 10600, Using a Personal Computer.

To earn credit, you must earn no lower than a 75% on the test overall. You must also earn a 75% for each section. You will receive an "S" as the grade on your transcript for CIT 10600, a 3 credit hour course. A traditional letter grade is not available.

Topics on this exam

The waiver exam consists of hands-on exercises using Microsoft Windows, Word, Access, PowerPoint, and Excel. You will have four hours to complete the exam without resources such as books, notes, or the Internet.

You must earn no lower than a 75% on the test overall, and a minimum of 75% for each section:

  • Identify Word window elements
  • Format using the Fluent User interface
  • Set document properties
  • Use spell check, grammar check, and thesaurus
  • Create a bibliography
  • Publish as PDF
  • Create a blog
  • Create and edit Word Art
  • Use Word Options on the Office Button menu
  • Use word wrap
  • Use insert and overtype mode
  • Create and edit documents
  • Use file commands
  • Navigate through a document using keyboard and mouse
  • Use undo, redo
  • Change fonts and font sizes
  • Use document themes
  • Use print commands and print preview
  • Change page setup
  • Select text and objects
  • Find and replace text
  • Change paragraph formats, including line spacing
  • Use left, hanging, and right indents
  • Create headers and footers and use auto codes
  • Use the Format Painter
  • Create columns
  • Use cut and paste to move text or objects
  • Use copy and paste to move text or objects
  • Use page breaks, section breaks, and column breaks
  • Create footnotes and endnotes
  • Insert symbols
  • Wrap text around objects
  • Create and edit tables
  • Use Autocorrect
  • Create a working hyperlink
  • Insert page number
  • Identify Access window elements
  • Identify field, record, table, relational database, flat database, primary key, foreign key, data redundancy, referential integrity
  • Follow guidelines for designing databases
  • Create and use table, query, form, and report objects in design view, layout view, and with wizards
  • Print database objects
  • Use headers and footers in objects
  • Create a flat database
  • Define relationships between two tables in a database
  • Create and edit fields including field names and properties
  • Name tables, queries, forms, and reports
  • Sort data
  • Copy and paste records from one database to another
  • Compact, backup, and restore a database
  • Create and edit queries: use exact match, comparison operator, wild cards; create and format a calculated field; use aggregate functions
  • Create multi-table queries
  • Create forms and subforms
  • Add pictures to forms and reports
  • Move, size, and add controls to forms and reports
  • Find data using a form
  • Use a form to add records to a database
  • Identify PowerPoint window elements
  • Use good design principles, including effective text and animation in presentations
  • Move, copy, and delete slides
  • Use File commands
  • Promote and demote text
  • Create and edit slides
  • Choose slide layouts
  • Use templates, themes, and layouts,
  • Change templates, themes, and layouts
  • Use multiple themes in one presentation
  • Create speaker notes
  • Print black and white slides, handouts, speaker notes, and outlines
  • Insert headers and footers in slides and handouts
  • Use the slide master
  • Insert, create, edit, format, move, delete, and size objects
  • Insert, size, move, delete, and crop pictures and clipart
  • Align objects
  • Apply animation to text and objects
  • Apply transitions
  • Create and edit a PowerPoint table
  • Create and manipulate a shape
  • Navigate a slideshow
  • Import a Word outline
  • Add a sound file
  • Create a diagram using Smart Art
  • Insert and rotate text boxes
  • Use spell check
  • Identify Excel window elements
  • Identify columns, rows, cells, ranges, and tables
  • Create documentation for a worksheet
  • Navigate through a worksheet using keyboard and mouse
  • Distinguish between workbooks and worksheets
  • Create and edit labels and values
  • Create arithmetic expressions (formulas)
  • Use the math order of operations in formulas
  • Use functions: sum, average, max, min, today, IF
  • Create an assumptions area for raw numbers, if necessary
  • Use cell references in formulas and not raw numbers
  • Use relative versus absolute cell references
  • Clear cell content and formats
  • Use print commands and print preview
  • Change page setup
  • Use headers and footers with auto codes
  • Copy and move cell contents
  • Use fill handle and auto fill
  • Name a worksheet
  • Use spell check
  • Resize, move, delete, and insert columns and rows
  • Insert comments
  • Display worksheet formulas
  • Format text, numbers, cells, ranges, and tables
  • Align text in cells, including wrapping text
  • Merge and center cells
  • Split merged cells
  • Freeze panes
  • Sort data
  • Switch worksheet views
  • Use My Computer or Windows Explorer to manage files
  • Explain root directories
  • Identify drive letters for various storage devices
  • Create folders and subfolders
  • Move, copy, delete, and rename files and folders
  • Display file extensions
  • Search for a file
  • Use the Recycle Bin
  • Use shortcut menus
  • Create zipped folders
  • Identify file size
  • Identify free and used space on storage devices

Step 1: Schedule your waiver exam

You must request approval to take the CIT 10600 waiver exam by sending an email from your official IUPUI email address to nanevans@iupui.edu. Please include your student ID in the body of the email.

Once you are approved, the CIT 10600 course coordinator will notify you and the IUPUI Testing Center of your authorization to take the waiver exam. You may then schedule your exam through the Testing Center during any of these days and times:

  • Monday 8:30 a.m. to 4:30 p.m.
  • Tuesday 8:30 a.m. to 4:30 p.m.
  • Wednesday 8:30 a.m. to 4:30 p.m.
  • Thursday 8:30 a.m. to 4:30 p.m.
  • Friday 8:30 a.m. to 4:30 p.m.

The exam will last approximately four hours.

Waiver exams are offered in the Business Building (BS3000).

Schedule your exam