Information Package / Course Catalogue
Data Analysis With Excel
Course Code: EK254
Course Type: Non Departmental Elective
Couse Group: First Cycle (Bachelor's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 0
Credit: 3
Lab: 0
ECTS: 5
Objectives of the Course

To be able to easily analyze data from different data sources using many functional functions of Microsoft Excel program

Course Content

Microsoft Excel topics, Microsoft Excel applications, Data Analysis

Name of Lecturer(s)
Learning Outcomes
1.To be able to create documents, prepare visual and graphical presentations, and analyse data
2.To be able to make further analysis with Excel
3.Having knowledge in data science
4.To be able to express the data obtained as a result of experiments and observations in computer environment in a statistical manner.
5.To reveal the relationships between variables.
Recommended or Required Reading
Weekly Detailed Course Contents
Week 1 - Practice
Understanding the Statistical Abilities of Excel
Week 2 - Practice
Using Excel as a Data Analysis Tool
Week 3 - Practice
Excel Charts and Tables
Week 4 - Practice
Working with Data
Week 5 - Practice
PivotTable and PivotChart
Week 6 - Practice
Creating a PivotTable
Week 7 - Practice
Determination of Correlation Coefficient
Week 8 - Theoretical
Determination of Correlation Coefficient
Week 9 - Practice
Estimating Demand Curve and Moving Average
Week 10 - Practice
Single Sample and Two Sample Hypothesis Tests
Week 11 - Practice
Data Analysis
Week 12 - Practice
Data analysis
Week 13 - Practice
Determination of Central Tendency and Variability Measures
Week 14 - Practice
Normal Distribution and Confidence Interval Estimation
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%70
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Practice142370
Individual Work72228
Midterm Examination110111
Final Examination115116
TOTAL WORKLOAD (hours)125
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
OÇ-1
3
5
3
3
3
5
3
3
2
OÇ-2
3
2
2
2
2
5
2
5
3
OÇ-3
3
2
3
2
3
2
3
3
3
OÇ-4
OÇ-5
Adnan Menderes University - Information Package / Course Catalogue
2026