FCBA

Choosing a Major I Adding A Minor I Professional Sales Program I Proficiency Exam I

Undergraduate Majors

Select a Major Accounting Actuarial Science Economics Entrepreneurship Finance International Business Management Marketing Management Info. Sys.

 

Undergraduate Minors

Select a Minor Business Administration Business Studies Decision Analysis Management Management Info. Sys. Marketing Professional Sales

 

Graduate

Select a Program EMBA MBA MSA
MSQF GCM

 

Business Centers

Select a Center Bus/Economic Research Economic Education Entrepeneurship Executive Development International Trade NAFTA Opportunity Small Business Dev.

 

General Description

Completing the computer proficiency exams or taking the class (BMA172) in the Foster College of Business is required of all incoming freshmen beginning in the Fall, 1996. Successfully completing the proficiency exams or the class satisfies both the Foster College of Business Administration and the University computer usage (CU) requirement.

The proficiency exam consists of two separate tests: Spreadsheet Applications and Microsoft Office Software Integration. The general content of each is described below. The student is expected to be able to work in the Windows XP operating system.

*Engineering students that have completed CON/CE 124 are exempt from this test.

The computer proficiency exam will be offered on Friday, October 30, 2009, at noon in Baker Hall, Room 152. To sign up to take the exam, please contact Pat Koehler at pkoehler@bradley.edu or call 677-2306. You should plan for about 3 hours to complete the exam.

There are two parts to the exam and students should plan to allow 3 hours to complete the entire exam.

A review of the 2 exams follows.

I.  Spreadsheet Application Competency List

·         Create a spreadsheet

·         Use formatting functions

o        Font:  Bold, Italics, Underline

o        Number formats:  Percent, fixed, etc.

o        Conditional

·         Create and use formulas

o        Arithmetic operations

o        Built-in functions:  sum, max, min, average, etc.

o        Absolute and relative addressing

o        Logical and conditional

o        Lookup statements

·         Perform editing functions

o        Copy, Cut, Delete, Paste special

o        Insert, Delete, Hide row/column

·         Lists, Filter and Subtotals

·         Data Validation

o        Worksheet Protection

o        Range Names

o        Locking and unlocking cells

·         Create graphs

·         Create multi-worksheets(pages)

II. Microsoft Office Software Integration

·         Data Validation

o        Excel

o        SPSS

·         Power Point

o        Creating a presentation

o        Editing Masters

o        Applying Transitions

·         Integrating Word, Excel, Power Point files

o        Applying and managing Hyperlinks

 

Bradley University • Foster College of Business
1501 West Bradley Avenue, Peoria, IL 61625
(309) 677-2253• FAX (309) 677-3374