Introduction to Business Data Analysis

Undergraduate

This course focuses on giving students the knowledge and skills to be used in a world in which spreadsheets are an integral part and which requires graduating business students to be proficient in its use. It also provides students with the knowledge and skills to be used in other courses in which spreadsheets’ powers can play an important role in analyzing data and presenting information in a professional manner. This knowledge and skills include: effectively entering data on spreadsheets so that they can be efficiently manipulated and converted into relevant information, both numerical and graphical; and, creating and interpreting this relevant information in a professional manner. To accomplish this, students will learn how to create professional looking graphs and charts and how to use and apply various Excel functions and capabilities including pivot tables, filtering, sorting, merging, lookup formulas, conditional formulas, relative and absolute formulas, range labelling, descriptive statistics functions, probability functions and financial functions. (Prerequisite: Semester 2 standing or above.) (Corequisites: MATH-1980/ /MATH-1250/ MATH-1720/ MATH-1760 (or equivalent)