Office of Academic Assessment

Computer Proficiency Exam

Computer Proficiency Exam Registration Information

If you wish to take the exam, you must register (form below) in advance and pay the $15 fee. If you cancel your exam this is a non-refundable fee. Please drop off your registration form in the mailbox outside of Room 240 Luther Bonney Hall.

There is no credit given for this exam; it is simply a way of avoiding taking ABU190, if you already have a mastery of spreadsheets.

The exam is given in Excel 2013. There is a sample exam available from the School of Business.

The exam just covers spreadsheets.

The exam is much like the practice exam, but presents a different problem.

There are a number of make or break issues on this exam (they all must be done correctly to receive a passing grade):

  1. You must possess basic charting skills. The chart you create must have all the key elements.

  2. You must know the basic set of functions and how to use them, including: SUM, AVERAGE, MIN, MAX, COUNT and IF

  3. You must not use numbers in your formulas. Rather, in your formulas you must reference the cells which contain the necessary values.

  4. All formulas must be written so that they can be copied to the other related cells. To do this effectively and consistently, you must understand whether to use absolute or relative addressing. (Absolute addressing uses a $ before the column and/or row in the cell references within the formula.)

  5. Use functions where appropriate.

In general you should also be capable of all basic spreadsheet skills such as formatting. Minor mistakes in areas other than the above first 4 items will not result in a failing grade.

 


Registration Form
(Fill in and print out. Submit with payment for exam.)

 Upcoming Exam Dates:

Friday, Jan 9, 2015    4:30 - 6:30 PM Room 202 Luther Bonney Hall, Portland Campus

April, 2015 date TBA  4:30 - 6:30 PM Location TBA

Friday, Jun 26, 2015  4:30 - 6:30 PM Room 202 Luther Bonney Hall, Portland Campus

Friday, Aug 28, 2015  4:30 - 6:30 PM Room 202 Luther Bonney Hall, Portland Campus


Practice Test:

Directions

Practice Handouts

Spreadsheet

This information and the practice exam can also be found on the
USM School of Business BlackBoard site:

Go to: http://www.courses.maine.edu

  • Click on the Community tab
  • Enter SB Central in the search box
  • Click on the ORG_P_SBannouncements result from the search
  • Click on the Info for Students button on the left
  • The first notice is about the practice exam