CIS 1173 - Spreadsheets i

Institution:

National Park College

Subject:

Description:

This course is designed to instruct students in the use of spreadsheet software to model, analyze, and support common business decisions. Instruction will include using the software as a decision support tool and as a list management tool. Concepts and features presented include: scenario and regression analysis, data scrubbing, chart building and analysis, Pivot tables and Pivot charts, filtering, troubleshooting formulas, tracing errors, and using advanced functions. An introduction into Visual Basic for Applications (VBA) is included and used in creating custom forms, custom functions, recording and editing macros, using variables and ranges and controlling code execution. Instruction is also given in importing, linking, and using VBA to share spreadsheet data with databases and the Web. Prerequisite: CIS 1013 Information Systems I with a grade of "C" or better; CIS 2013 Information Systems II recommended. Spring. Lab Fee.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.np.edu

Phone Number:

(501) 760-4222

Regional Accreditation:

North Central Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.