Excel for Business
Overview
Note: Students who have received credit for CSIS 1110 or CSIS 1140 cannot receive additional credit for CSIS 1190.
- Operating system concepts – finding files and organizing folders, using utilities such as backup and firewall
- Browser and search-engine concepts – efficient and advanced searching techniques
- Word processing and Presentation software concepts – basic features and functions to produce quality business reports, memos and presentations
- Excel concepts
- basic: worksheet environment, navigation, formatting, entering data/formulas, editing
- intermediate: cell references, recalculating formulas, designing templates, "what if" analysis, charts and graphs
- advanced: financial functions, specialized functions, table lookup, pivot tables and pivot charts, multisheet workbooks, importing from other sources, data forms, dashboards and templates, macros
- application: creating a complete, working project that could be deployed and implemented in a business environment
Lecture, seminar, demonstration, and hands-on exercises.
Evaluation will be carried out in accordance with the Douglas College Evaluation Policy.
Assignments/Labs (min 3) | 10-30% |
Term Tests (min 3) | 30-45% |
Final Examination* | 30-40% |
Total | 100% |
* Practical hands-on computer exam
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).
At the end of this course, the successful student will be able to:
- Use operating system software to manage files/folders, perform computer backups and ensure the computer environment is secure;
- Use client browser software and search engines to efficiently search for resources on the Internet;
- Use Word Processing software to produce business standard reports that include a Title Page, Table of Content, various body options and Work Citations;
- Use Presentation software to produce business standard presentations;
- Describe the main features and functions of Excel;
- Use computers as a tool to solve Excel business problems, i.e. analyze a problem, develop the appropriate Excel application, and test the Excel solution;
- Use built-in functions in Excel;
- Produce charts and graphs in Excel;
- Demonstrate the correct usage of forecasting and what-if analysis in Excel;
- Use advanced Excel features such as Pivot tables and charts; multiple spreadsheet development and macros.
Poatsy, Mulbery, Davidson & Grauer, Exploring Microsoft Excel 2016 Comprehensive, latest edition, Pearson Educational
or other textbooks as approved by the department
Requisites
Prerequisites
Pre-Calculus 11 (C or better) or Foundations of Math 11 (C or better) or MATU 0410 (C or better) or FINC 1231 (C or better) or approved substitute OR currently active in one of the following:
PBD Advanced Human Resource Management
PBD Finance
PBD International Supply Chain Management
PDD Financial Planning
PDD International Business Management
Corequisites
No corequisite courses.
Equivalencies
Course 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 Transfers
These are for current course guidelines only. For a full list of archived courses please see https://www.bctransferguide.ca
Institution | Transfer Details for CSIS 1190 |
---|---|
Athabasca University (AU) | AU CMIS 2XX (3) |
Camosun College (CAMO) | CAMO BUS 140 (3) |
Capilano University (CAPU) | CAPU BCPT 123 (3) or CAPU TOUR 149 (3) |
College of New Caledonia (CNC) | No credit |
College of the Rockies (COTR) | COTR OFAD 181 (1.5) |
Kwantlen Polytechnic University (KPU) | No credit |
Nicola Valley Institute of Technology (NVIT) | NVIT BUSM 1XX (3) |
North Island College (NIC) | NIC BUS 170 (3) |
Okanagan College (OC) | No credit |
Simon Fraser University (SFU) | No credit |
Thompson Rivers University (TRU) | No credit |
University Canada West (UCW) | UCW CPSC 1XX (3) |
University of British Columbia - Okanagan (UBCO) | No credit |
University of British Columbia - Vancouver (UBCV) | No credit |
University of Northern BC (UNBC) | No credit |
University of the Fraser Valley (UFV) | UFV CIS 1XX (3) |
University of Victoria (UVIC) | UVIC CSC 1XX (1.5) |
Vancouver Island University (VIU) | VIU QUME 185 (3) |
Course Offerings
Winter 2025
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14610
|
Tue | Instructor Last Name
Tan
Instructor First Name
William
|
Course Status
Open
|
CSIS 1190 002 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110. Students will NOT receive credit for both CSIS 1110 and CSIS 1190.
Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14611
|
Tue | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 003 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110. Students will NOT receive credit for both CSIS 1110 and CSIS 1190.
Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14612
|
Wed | Instructor Last Name
Choong
Instructor First Name
Victor
|
Course Status
Open
|
CSIS 1190 004 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14613
|
Thu | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 005 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14615
|
Thu | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 006 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14616
|
Fri | Instructor Last Name
Manabala
Instructor First Name
Rupa
|
Course Status
Open
|
CSIS 1190 007 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14617
|
Thu | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 008 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
14619
|
Mon | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 009 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
15424
|
Sat | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 070 - This section is on Saturdays.
Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.
CRN | Days | Instructor | Status | More details |
---|---|---|---|---|
CRN
15533
|
Tue | Instructor Last Name
TBA
Instructor First Name
(Faculty)
|
Course Status
Open
|
CSIS 1190 010 - Students in ACCT, BUSN, FINC, MARK and HOSP programs please note: As of September 2014, CSIS 1190 is now the requirement for your program replacing CSIS 1110.
Students will NOT receive credit for both CSIS 1110 and CSIS 1190. Registering in both CSIS 1110 and CSIS 1190, either concurrently or sequentially, will affect student loan status. If you have any questions please contact Stephen Chiong at: chiongs@douglascollege.ca
CSIS 1190 is now a program requirement for ACCT, BUSN, FINC, MARK and HOSP credentials.