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 (BUS 195) if you already have a mastery of spreadsheets.
The exam is given in Microsoft Office (Excel) 2016. 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):
You must possess basic charting skills. The chart you create must have all the key elements.
You must know the basic set of functions and how to use them, including: SUM, AVERAGE, MIN, MAX, COUNT and IF
You must not use numbers in your formulas. Rather, in your formulas you must reference the cells which contain the necessary values.
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.)
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.
(Fill in and print out. Submit with payment for exam.)
Upcoming Exam Dates:
Friday, November 3, 2017 5-7 PM Room 202 Luther Bonney Hall, Portland Campus
Friday, November 17, 2017 5-7 PM Room 202 Luther Bonney Hall, Portland Campus
Wednesday, January 17, 2018 4:30-6:30 PM Room 202 Luther Bonney Hall, Portland Campus
If you are a USM student, you can also find the information about the practice exam on Blackboard following these instructions:
- Login to Blackboard
- Click on the Community tab
- Enter SB Central in the search box
- Hover on the ORG_P_SB announcements result from the search
- Click the dropdown arrow and click on Enroll
- Click the Submit button
- Click the OK button
- You now have access to SB Central
- Click on the Info for Students button on the left
- The first notice is about the practice exam