BA 169Z Data Analysis Using Microsoft Excel

Covers Microsoft Excel software skills necessary for evidence-based problem-solving, including workbook editing, formula creation, charting, and pivot tables. Emphasizes hands-on learning using Excel functions to perform data analysis to enhance decision-making. Note - computer required; (Chromebooks/tablets will not suffice).

Credits

4

Prerequisite

BA 101Z or BT 120 or any 4+ credit CIS/CS course AND MTH 065 or higher or equivalent via the math placement process

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:

1. Create and manage worksheets using appropriate data formatting

2. Construct formulas with relative, absolute, and mixed cell references

3. Analyze data using logical, lookup, mathematical, statistical, and text functions

4. Manipulate large volumes of data using datasets and tables.

5. Interpret data using data visualization tools, including pivot tables and charts