Course

Credit Type:
Course
ACE ID:
IBM-0022
Version:
2
Organization:
Location:
Online
Length:
16 weeks and 32 hours
Minimum Passing Score:
70
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Excel for Data Analysis
Lower-Division Baccalaureate 3 Data Analytics
Upper-Division Baccalaureate 3 Data Visualization
Description

Objective:

This course is offered through Coursera, which is an ACE Authorized Instructional Platform.

The course objective is to introduce learners to the modern data ecosystem, consisting of databases and other data sources within and outside an organization. Students will learn that creating stunning visualizations is a critical part of communicating data analysis results and by the end of this course, students will be able to describe common dash-boarding tools used by a data analyst, to design and create a dashboard in a cloud platform, and begin to elevate confidence in creating intermediate level data visualizations.

Throughout this course, students encounter numerous hands-on labs and a final project. With each lab, learners gain hands-on experience with creating basic and advanced charts, then continue through the course and begin creating dashboards with spreadsheets and IBM Cognos Analytics. Students' learning experience culminates with the opportunity to create an interactive dashboard that can be shared with peers, professional communities or prospective employers.

This Specialization is designed for learners interested in starting a career in the field of Data or Business Analytics, as well as those in other professions, who need basic data analysis and visualization skills to supplement their primary job tasks.

Learning Outcomes:

  • Describe the data ecosystem, tasks a Data Analyst performs, and skills and tools required for successful data analysis
  • List various types of charts and plots and create them in Excel as well as work with Cognos
  • Explain basic functionality of spreadsheets and utilize Excel to perform a variety of data analysis tasks like data wrangling and data mining
  • Analytics to generate interactive dashboards

General Topics:

  • What is data analytics?
  • The data ecosystem
  • Gathering and wrangling data
  • Mining and visualizing data and communicating results
  • Career opportunities and data analysis in action
  • Introduction to data analysis using spreadsheets
  • Getting started with using Excel spreadsheets
  • Cleaning and wrangling data using spreadsheets
  • Analyzing data using spreadsheets
  • Final project
  • Visualizing data using spreadsheets
  • Creating visualizations and dashboards with spreadsheets
  • Creating visualizations and dashboards with Cognos analytics
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Case Studies
  • Computer Based Training
  • Lectures
  • Practical Exercises

Methods of Assessment:

  • Other
  • Quizzes
  • Peer review graded projects with rubric
Supplemental Materials
Equivalencies