• Program: Information Technology/Computer Careers
  • Course: Data Analysis I
  • Course #: CCIS1260
  • Total Credits: 3

Course Description

Introductory data analyst course using Excel, Access and PowerPoint. Extensive use of Excel spreadsheets including formulas, graphs and pivot tables. Create basic Access queries to gather data. Course covers concepts such as percentages, trends and basic statistical concepts.

Course Evaluation

Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.

Disability Services

Hennepin Technical College offers reasonable accommodations to qualified students with disabilities. If you have a documented disability that may require accommodations, contact the college’s Disability Services Director: Sara Laviolette at Brooklyn Park (763-488-2477) or Jean Kreutter at Eden Prairie (952-995-1544).

Course Goals

The following goals will be addressed in the course:
Interpret trend and statistical concepts of data analysis
Discuss the role, methods, and processes for extracting data from complex sources
Solve basic data analysis cases using common data analysis tools
Present data sets using Excel, Access and Word
Explore Excel and Access programming syntax
Manipulate Excel formulas to aid data analysis
Create and troubleshoot formulas and functions for data extraction
Perform what-if analysis
Discuss probability and inference statistics
Define data analysis within the work environment

Credit Details
  • Lecture: 3
  • Lab: 0
  • MnTC Goal: 0
Course Details

Apply Now Search Awards Search Courses