Excel for Business

Curriculum guideline

Effective Date:
Return to Course
Print Guideline
Course
CSIS 1190
Discontinued
No
Course code
CSIS 1190
Descriptive
Excel for Business
Department
Computing Studies & Information Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201730
PLAR
Yes
Semester length
15
Max class size
35
Contact hours
Lecture: 2 hrs/week Seminar/Lab: 2 hrs/week
Method(s) of instruction
Lecture
Seminar
Learning activities

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

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 and presentation software will be used as tools for presenting finished projects and assignments.
Note: Students who have received credit for CSIS1110 or CSIS1140 cannot receive additional credit for CSIS1190.
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 outcomes
  1. Use operating system software to managing 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.
Means of assessment
Assignments/Labs (min 3)  25-35%
Term Tests (min 3) 30-45%
Final Examination 20-30%
Total 100%
Textbook materials

Poatsy, Mulbery, Davidson & Grauer, Exploring Microsoft Excel 2010 Comprehensive, latest edition, Pearson Educational

or other textbooks as approved by the department

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

Which prerequisite

ACCT 1220 and ACCT 1222 and BUSN 2275 and BUSN 3380 and MARK 3441 and MARK 4440