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 Of Instruction
Lecture
Lab
Typically Offered
To be determined
Campus
Online

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
Methods Of Instruction

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

Means of Assessment
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 (C or better) or Foundations of Math 11 (C or better) or MATU 0410 (C or better) or approved substitute OR currently active in: 

PBD Finance

PBD Accounting and Finance

PDD International Business Management

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

Requisite for

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

Institution Transfer Details Effective Dates
Athabasca University (AU) AU CMIS 2XX (3) 2014/01/01 to -
Camosun College (CAMO) CAMO BUS 140 (3) 2016/09/01 to -
Capilano University (CAPU) CAPU BCPT 123 (3) or CAPU TOUR 149 (3) 2008/09/01 to -
College of New Caledonia (CNC) No credit 2014/01/01 to -
College of the Rockies (COTR) COTR OFAD 181 (1.5) 2020/01/01 to -
Kwantlen Polytechnic University (KPU) No credit 2014/01/01 to -
Nicola Valley Institute of Technology (NVIT) NVIT BUSM 1XX (3) 2014/01/01 to -
North Island College (NIC) NIC BUS 170 (3) 2014/01/01 to -
Okanagan College (OC) No credit 2014/01/01 to -
Simon Fraser University (SFU) No credit 2014/01/01 to -
Thompson Rivers University (TRU) DOUG CSIS 1110 (3) & DOUG CSIS 1190 (3) = TRU COMP 1XXX (3) & TRU COMP 1XXX (3) & TRU MIST 2611 (3), OL 2015/09/01 to 2019/04/30
Thompson Rivers University (TRU) DOUG CSIS 1110 (3) & DOUG CSIS 1190 (3) & DOUG CSIS 2200 (3) = TRU MIST 2610 (3) 2014/09/01 to 2014/12/31
Thompson Rivers University (TRU) TRU MIST 1XXX (3); DOUG CSIS 1190 (3) & DOUG CSIS 1110 (3) & DOUG CSIS 2200 (3) = TRU MIST 2610 (3) 2014/09/01 to 2015/12/31
Thompson Rivers University (TRU) No credit 2016/01/01 to -
University Canada West (UCW) UCW COMP 1XX (3) 2014/01/01 to -
University Canada West (UCW) UCW CPSC 1XX (3) 2006/01/01 to 2013/12/31
University of British Columbia - Okanagan (UBCO) No credit 2014/05/01 to -
University of British Columbia - Vancouver (UBCV) No credit 2014/01/01 to -
University of Northern BC (UNBC) No credit 2014/01/01 to -
University of the Fraser Valley (UFV) UFV CIS 1XX (3) 2016/01/01 to -
University of Victoria (UVIC) UVIC CSC 1XX (1.5) 2014/01/01 to -
Vancouver Island University (VIU) VIU QUME 185 (3) 2014/01/01 to -

Course Offerings

Winter 2021

CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14609
Tue
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Yu
Raymond
Full
Online
CSIS 1190 001 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
34
34
0
0
Days
Building
Room
Time
Tue
8:30 - 11:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14610
Wed
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Yu
Raymond
Open
Online
CSIS 1190 002 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
34
32
2
0
Days
Building
Room
Time
Wed
8:30 - 11:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14611
Thu
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Choong
Victor
Full
Online
CSIS 1190 003 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
0
Days
Building
Room
Time
Thu
9:30 - 12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14612
Mon
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Choong
Victor
Waitlist
Online
CSIS 1190 004 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
1
Days
Building
Room
Time
Mon
11:30 - 14:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14613
Wed
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Ng
Jim-Mee
Waitlist
Online
CSIS 1190 005 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
4
Days
Building
Room
Time
Wed
12:30 - 15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14615
Thu
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Tan
William
Waitlist
Online
CSIS 1190 006 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
3
Days
Building
Room
Time
Thu
9:30 - 12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14616
Tue
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Manabala
Simhadri
Waitlist
Online
CSIS 1190 007 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
6
Days
Building
Room
Time
Tue
12:30 - 15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14617
Wed
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Manabala
Simhadri
Waitlist
Online
CSIS 1190 008 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
6
Days
Building
Room
Time
Wed
12:30 - 15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
14619
Thu
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Gupta
Anupama
Open
Online
CSIS 1190 009 - Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
33
2
0
Days
Building
Room
Time
Thu
12:30 - 15:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
15424
Sat
04-Jan-2021
- 12-Apr-2021
04-Jan-2021
12-Apr-2021
Tan
William
Full
Online
CSIS 1190 070 - This section is on Saturdays.

Please note that, as of the Winter 2015 semester, CSIS 1190 is now REQUIRED in all Accounting, Business and Finance programs. CSIS 1110 will not be accepted as a substitute, unless completed by December 2014. 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

This course will include some synchronous on-line activities. Students should plan to be available on-line at scheduled course times. Synchronous on-line activities may include lecture, or they may not. In some courses, synchronous class time may be used instead for active learning components (e.g. discussions, labs).
Max
Enrolled
Remaining
Waitlist
35
35
0
0
Days
Building
Room
Time
Sat
9:00 - 11:50