• Program: Information Technology/Computer Careers
  • Course: Data Analysis II
  • Course #: CCIS2460
  • Total Credits: 3

Course Description

Continuation of Data Analysis I with more advanced treatment of data reporting, interpretation, and presentation. Advanced Excel formulas, functions and macros will be created to perform advanced data interpretations. Explore the need and use of data within a variety of industries, such as healthcare and banking. Students should have advanced Excel spreadsheet knowledge.

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:
Identify data trends and effectively report their impact
Utilize advanced Excel and Access techniques for data reporting
Define concepts of descriptive summary measures
Solve complex data analysis cases using data analysis tools
Create charts for data interpretation
Create and edit macros
Demonstrate knowledge of relational data
Develop an application based upon business needs determined
Design effective presentations using data gathered for reporting
Develop logical data models

Credit Details
  • Lecture: 3
  • MnTC Goal: 0
Course Details
  • Prerequisites:  MATH2150 - Required. CCIS1260 - Recommended
  • Campus: Brooklyn Park/Eden Prairie

Apply Now Search Awards Search Courses