Course

Excel for Business

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course Code
CSIS 1190
Credits
3.00
Semester Length
15 Weeks
Max Class Size
35
Method(s) Of Instruction
Lecture
Seminar
Course Designation
None
Industry Designation
None
Typically Offered
To be determined

Overview

Course Description
This course gives students a brief introduction to information technology concepts before concentrating on essential Excel topics used in the business world. Information technology concepts covered include searching the Internet efficiently, managing files/folders, and computer security and backup. Excel topics include the basic fundamentals to advanced functionality, such as what-if analysis and macros. Word processing, database, and presentation software will be used as tools for presenting finished projects and assignments.
Note: Students who have received credit for CSIS 1110 or CSIS 1140 cannot receive additional credit for CSIS 1190.
Course Content
  1. Operating system concepts – finding files and organizing folders, using utilities such as backup and firewall
  2. Browser and search-engine concepts – efficient and advanced searching techniques
  3. Word processing and Presentation software concepts – basic features and functions to produce quality business reports, memos and presentations
  4. 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
Learning Activities

Lecture, seminar, demonstration, and hands-on exercises.

Means of Assessment

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).

Learning Outcomes

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

  1. Use operating system software to manage files/folders, perform computer backups and ensure the computer environment is secure;
  2. Use client browser software and search engines to efficiently search for resources on the Internet;
  3. Use Word Processing software to produce business standard reports that include a Title Page, Table of Content, various body options and Work Citations;
  4. Use Presentation software to produce business standard presentations;
  5. Describe the main features and functions of Excel;
  6. 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;
  7. Use built-in functions in Excel;
  8. Produce charts and graphs in Excel;
  9. Demonstrate the correct usage of forecasting and what-if analysis in Excel;
  10. Use advanced Excel features such as Pivot tables and charts; multiple spreadsheet development and macros.
Textbook Materials

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 (minimum of C) or Foundations of Math 11 (minimum of C) or MATU 0410 (minium of C) or FINC 1231 (minimum of C) or approved substitute OR currently active in one of the following:

PBD Advanced Human Resource Management
PBD Finance
PDD Financial Planning
PDD International Business Management
PDD Project 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 2024

CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14607
Thu
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Ma
Instructor First Name
Hao
Course Status
Waitlist
Section Notes

CSIS 1190 050 - 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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
35
0
Actual Wait Count
2
Days
Building
Room
Time
Thu
Building
New Westminster - North Bldg.
Room
N6109
Start Time
18:30
-
End Time
21:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14609
Wed
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Choong
Instructor First Name
Victor
Course Status
Waitlist
Section Notes

CSIS 1190 001 - 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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
31
4
Actual Wait Count
2
Days
Building
Room
Time
Wed
Building
Coquitlam - Bldg. A
Room
A2130
Start Time
9:30
-
End Time
12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14610
Wed
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Ahmadi Abkenari
Instructor First Name
Parissa
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
36
-1
Actual Wait Count
5
Days
Building
Room
Time
Wed
Building
New Westminster - North Bldg.
Room
N5107
Start Time
8:30
-
End Time
11:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14611
Thu
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Choong
Instructor First Name
Victor
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
34
1
Actual Wait Count
3
Days
Building
Room
Time
Thu
Building
Coquitlam - Bldg. A
Room
A2110
Start Time
9:30
-
End Time
12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14612
Tue
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Tan
Instructor First Name
William
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
36
-1
Actual Wait Count
3
Days
Building
Room
Time
Tue
Building
New Westminster - North Bldg.
Room
N5111
Start Time
12:30
-
End Time
15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14613
Fri
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Tan
Instructor First Name
William
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
35
0
Actual Wait Count
3
Days
Building
Room
Time
Fri
Building
New Westminster - North Bldg.
Room
N5111
Start Time
12:30
-
End Time
15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14615
Wed
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Gupta
Instructor First Name
Anu
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
35
0
Actual Wait Count
9
Days
Building
Room
Time
Wed
Building
New Westminster - North Bldg.
Room
N6107
Start Time
12:30
-
End Time
15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14616
Fri
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Manabala
Instructor First Name
Rupa
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
35
0
Actual Wait Count
6
Days
Building
Room
Time
Fri
Building
New Westminster - North Bldg.
Room
N6107
Start Time
9:30
-
End Time
12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14617
Tue
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Ma
Instructor First Name
Hao
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
32
3
Actual Wait Count
3
Days
Building
Room
Time
Tue
Building
New Westminster - North Bldg.
Room
N6107
Start Time
15:30
-
End Time
18:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
14619
Thu
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Ali
Instructor First Name
Liaqat
Course Status
Open
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
33
2
Actual Wait Count
0
Days
Building
Room
Time
Thu
Building
New Westminster - North Bldg.
Room
N5109
Start Time
12:30
-
End Time
15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
15424
Sat
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Manabala
Instructor First Name
Rupa
Course Status
Waitlist
Section Notes

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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
33
2
Actual Wait Count
1
Days
Building
Room
Time
Sat
Building
New Westminster - North Bldg.
Room
N6107
Start Time
9:00
-
End Time
11:50
CRN
Days
Dates
Start Date
End Date
Instructor
Status
CRN
16131
Sat
Start Date
-
End Date
Start Date
End Date
Instructor Last Name
Sahiwal
Instructor First Name
Jaspreet
Course Status
Open
Section Notes

CSIS 1190 071 - 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.

Max
Enrolled
Remaining
Waitlist
Max Seats Count
35
Actual Seats Count
13
22
Actual Wait Count
0
Days
Building
Room
Time
Sat
Building
New Westminster - North Bldg.
Room
N5111
Start Time
13:00
-
End Time
15:50