CCIS1260 Data Analysis I

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.




CCIS1080 - Required. ACCT1125 and MATH2150 - Recommended

Course Requirements and 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.

Learning Outcomes

The following outcomes 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

Text and References

A list of textbooks required for this course is available at the bookstore.

Course Scheduling

The scheduled hours of instruction include sixteen hours for each lecture credit, thirty two hours for each lab credit and forty hours for each credit of supervised occupational experience (SOE). Lecture credit may include formal or impromptu lectures, demonstrations or discussions with the entire class or with small groups or individuals. Refer to the Credit Details section of this course outline for the credit breakdown.

Accommodations Statement

Disability Services assists students with disabilities who need accommodations to access programs, services and college activities.  If this applies to you, please contact the DS Office on your campus to initiate the accommodations process. 
Brooklyn Park Campus - 763-488-2477
Eden Prairie Campus – 952-995-1544


Brooklyn Park Campus Eden Prairie Campus 952-995-1300

Credit Details