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 MIS Insurance

 

Undergraduate Minors

Select a Minor Business Administration Business Studies Decision Analysis Economics Management MIS Marketing Professional Sales

 

Graduate

Select a Program E.M.B.A M.B.A. M.S.A.

 

Business Centers

Select a Center Economic Research Economic Education Executive Development

 

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. Each test has a two hour time limit The general content of each is described below. The student is expected to be able to work in the Windows operating system.

For more information contact Kolja Scepanik at kscepanik@bradley.edu

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

The proficiency exams will be held at the following times:

Several exam times will be offered between May 8th and 14th, contact Kolja at kscepanik@bradley.edu for details/scheduling.

 

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