Excel for Business
Curriculum guideline
Lecture: 2 hrs/week
Lab: 2 hrs/week
Lecture, seminar, demonstration, and hands-on exercises.
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
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.
| 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).
Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.
Poatsy, Mulbery, Davidson & Grauer, Exploring Microsoft Excel 2016 Comprehensive, latest edition, Pearson Educational
or other textbooks as approved by the department
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
Courses listed here must be completed either prior to or simultaneously with this course:
- No corequisite courses