COLL150

Download as PDF

Data Analytics using Excel

Subject Code

COLL

Course Number

150

Department(s)

FFC Requirement(s)

Technology-Intensive

Course Description

In this course, students learn basic and intermediate Microsoft Excel skills to help them analyze data and model outcomes. Students will learn how to perform spreadsheet calculations, create and interpret graphs and charts, execute Excel formulas and functions, manage workbook data, analyze table data, automate worksheet tasks, employ macros and VBA, and conduct "what if" analyses. Students who do not own a Microsoft PC computer will need to use the college computer labs to complete the work in this class. This course is administered entirely through Moodle. The instructor provides recorded lectures and hosts live office hours to provide support for students as needed. Self-guided work is to begin immediately upon the semester beginning. To start the coursework, students go to the Moodle page and read the syllabus to understand the sequencing of the course and to start working on the assignments.