Accounting Information Systems

Instructors: please feel free to test drive this assignment by downloading the exercise materials and then watching the video. You may use any 4 digit number you wish as your spreadsheet ID. Please email your completed work to if you would like us to grade your work and give you feedback. 

The Accounting Information Systems exercise covers about 25% of the material on the Microsoft Office Specialist (MOS-200) certification exam while reinforcing accounting concepts taught in class. Students pay $9.95 for the exercise and are guided through a video with numbered steps.

The students are taught 42 different Excel concepts.
    • Opening XLSX workbook
    • Managing table styles
    • WordArt feature
    • Saving XLSM document format
    • Split Window command
    • Text Box feature
    • Print to PDF
    • Create pivot table
    • Formatting shapes
    • Using Excel templates
    • Sparklines feature
    • Set workbook properties
    • Saving as XLS for backwards compatibility
    • Remove Duplicates command
    • Customize ribbon
    • Import CSV file
    • Quick Analysis feature
    • Customize Quick Access Toolbar
    • Hiding columns
    • Create a chart
    • CONCAT function
    • Table feature
    • Duplicating charts
    • COUNTIF function
    • Adding total row to tables
    • Switch rows/columns in chart
    • IF function
    • Date formats
    • Chart styles and borders
    • IFNA function
    • Filter feature
    • Create organizational chart
    • ISNA function
    • Reapply command
    • Macro Recorder feature
    • MATCH function
    • Inserting worksheets
    • Creating macro shortcuts
    • NOT function
    • Workbook themes
    • Enabling macros/macro security
    • VLOOKUP function
Students enter perform the following tasks on their own:
  • Changing worksheet names
  • Hiding worksheet columns
  • Adding worksheets

Each student is assigned a unique 4-digit number known as their Spreadsheet ID for use during the exercise. This ID number is incorporated into the exercise and helps ensure that each student turns in their own work.

The students submit their work to us and we handle all of the grading. We give you three scores:

  • Completion: This score indicates if the student attempted a given step.
  • Accuracy: This score indicates carried out the step accurately.
  • Combined: The average of the two Completion and Accuracy scores.

Within one week of an assignment’s due date we provide instructors with a spreadsheet showing all student results. Partial credit in our scoring is given if a student at least attempts a step. Instructors determine final credit for each student, and whether late submissions are allowed. Students receive written feedback confirming which steps were completed successfully, as well as providing guidance on steps that they did not attempt or did not complete correctly.

Some instructors give more weight to the Completion score than the Accuracy score, while other instructors use the combined average when determining credit. We’re happy to provide any additional information that can help you as an instructor.

Instructors, please direct any questions to David Ringstrom ( or 404-784-0275. Students, all support is email based by way of