Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Business Support Systems with Excel

Course Code: CSIS 3190
Faculty: Commerce & Business Administration
Credits: 3.0
Semester: 15 week
Learning Format: Lecture, Lab
Typically Offered: TBD. Contact Department Chair for more info.
course overview

In this course, students will build on their knowledge to apply advanced Excel features, to create unique business support systems (BSS). Topics included: Advanced Functions (Business, Statistics, Logical), Macro’s, Power Pivot Tables, User Defined Functions (UDF), Visual Basic Application (VBA) coding, What-If Analysis tools and Custom System User Interface (UI) Dashboards. This is a case-based course where students will be presented with real world capstone business problems and create multifaceted business systems using Excel and the agile system development methodology.

Course Content

During our work together in this course, students will:

  1. Review the fundamental terms, concepts and theories associated with BSS, computerized decision aids, expert systems, group support systems and executive information systems.
  2. Examine business cases that support business decisions, and various planning, analysis and control tasks.
  3. Develop the systems using agile planning, analysis, design and implementation of a computerized BSS.
  4. Design user interfaces (UI) and create custom dashboards.
  5. Connect live XML web databases for dynamic analysis.
  6. Build state-of-the-art BSS using advanced macro and Visual Basic Application (VBA).
  7. Recognize that most business support systems are designed to support rather than replace decision makers.
  8. Create documenting and training material to support a customized BSS.

Methods of Instruction

Lecture and Lab

Means of Assessment

Business Case Assignments     10%-20%  
quizzes  10%-30%  
Midterm 20%-40%  
Final Exam  25%-40%  

**In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).

Learning Outcomes

At the end of the course, the successful student should be able to:

  1. Evaluate the differences between a variety of business support systems.
  2. Analyze a business problem and create a business support system using Excel.
  3. Apply Visual Basic Application (VBA) coding to create a business support system.
  4. Utilize power pivot tables to rapidly analyze large data sets.
  5. Resolve a redundant business procedure using macros.
  6. Create dynamic connections, implement and update online XML data.
  7. Design a custom user interface (UI) to simplify rapid input analysis.
  8. Create a custom user defined function (UDF) to automate an iterative procedure.
  9. Present a custom designed business support system (BSS) to management.
  10. Demonstrate the knowledge necessary to write the industry standard MOS Excel certification exam.

course prerequisites

CSIS 1190 OR currently active in the 

PDD Data Analytics

PBD Computer Information System Data Analytics

Corequisites

None

Equivalencies

None

curriculum guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester/year of the course, consider the previous version as the applicable version.

course schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.

noticecurriculum notice

There is an upcoming curriculum change scheduled for .
View upcoming changes