IT 481H

Trends in Computer Information Technology Honors

This course is about mastering tools to create charts and graphs in the service of business decision making. Many business decisions are based upon supporting data and their analyses. The presentation of data in support of decisions is as important as understanding what the data analyses tells us. Businesses need employees who are able to communicate powerfully in order to reveal trends and explain underlying data. Students learn how to customize Excel charts that show trends, differences, and relationships. They learn how to effectively create stock analysis charts, pivot tables, and pivot charts to analyze large data sets. In addition to learning advanced charting features such as mixing two chart types into a single chart and creating dynamic charts, students learn how to use Excel Sparklines and data visualization techniques associated with conditional formatting in worksheet cells. Students learn how to plot data geographically on maps and know when someone is trying to deceive with charts. Case studies are utilized in the course.

Units: 3.0-6.0(3.0)