MASTER SYLLABUS
Course title and number: BUS 321 Business Spreadsheets
Department: Accounting/MIS
Credit hours: 3
Prerequisites: BUS 221 (within the last four years) and BUS 108
Fees and charges: None
Effective catalog date for this master syllabus: 2006-2007
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
1.
Catalog description:
An advanced study of the development and implementation of spreadsheets as
applied to business applications, including worksheet design, problem
organization and results presentation.
2. Course content:
a. File management techniques
b. Review of spreadsheet basics
c. Web interaction
d. Advanced formula functions
e. Graphics
f. Three-dimensional workbooks
g. Forecasting and auditing spreadsheets
h. Data management
i. Macros
3. Student learning objectives:
a. Development of spreadsheets, templates, and macros
b. Advanced spreadsheet techniques which illustrate the full power of spreadsheets
c. Building and working with spreadsheet models for business problems
4. Student assessment criteria:
a. Homework assignments are reviewed for improvement in the course competency areas.
b. Exams are administered to determine a student’s proficiency with spreadsheet techniques.