PAÜ .:. Eğitim Öğretim Bilgi Sistemi

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
LOJ 126	DATA ANALYSIS WITH SPREADSHEETS	3 + 0	2nd Semester	3

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	The aim of this lesson is to teach students the advanced features of spreadsheets in detail while providing them with the necessary skills to solve scenarios based on real-world data. The exercises and mini projects within the scope of the course will encourage students to apply what they have learned. By the end of the course, students are expected to be capable of effectively using spreadsheets in both professional and academic settings and reaching a level of proficiency in data analysis.
Course Content	Formulas and Functions, Advanced Data Processing, Data Lists and Analysis, Charting and Visualization Techniques, Pivot Tables, Data Import and Integration, Data Validation and Error Handling, Conditional Functions, Data Transformation and Cleaning, Dashboard Creation, Data Analysis and Statistics, Scenario-Based Data Analysis.
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.

COURSE LEARNING OUTCOMES

1	Ability to utilize advanced spreadsheet formulas and functions.
2	Analyzing and visualizing complex datasets.
3	Creating effective reports and presentation interfaces.
4	Applying necessary statistical functions for data analysis.
5	Proficiency in solving real-world data problems.

COURSE'S CONTRIBUTION TO PROGRAM

Data not found.

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION

Activities	Quantity	Duration (Hour)	Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)	14	3	42
Mid-terms	1	18	18
Final examination	1	18	18
Total Work Load ECTS Credit of the Course			78 3

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2024-2025 Spring	2	MURAT TOKBAŞ

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester	Mode of Delivery
LOJ 126	DATA ANALYSIS WITH SPREADSHEETS	3 + 0	2	Turkish	2024-2025 Spring	Face to Face

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer MURAT TOKBAŞ	mtokbas@pau.edu.tr		HMYO A0222	%70

Goals		The aim of this lesson is to teach students the advanced features of spreadsheets in detail while providing them with the necessary skills to solve scenarios based on real-world data. The exercises and mini projects within the scope of the course will encourage students to apply what they have learned. By the end of the course, students are expected to be capable of effectively using spreadsheets in both professional and academic settings and reaching a level of proficiency in data analysis.
Content		Formulas and Functions, Advanced Data Processing, Data Lists and Analysis, Charting and Visualization Techniques, Pivot Tables, Data Import and Integration, Data Validation and Error Handling, Conditional Functions, Data Transformation and Cleaning, Dashboard Creation, Data Analysis and Statistics, Scenario-Based Data Analysis.

Topics

Weeks	Topics
1	Understand the Working principles of computer hardware, Understand working principles of applications
2	using the Internet
3	using the Internet
4	Microsoft Excel
5	Microsoft Excel
6	Microsoft Powerpoint
7
8	Microsoft Powerpoint
9	Microsoft Powerpoint
10	What is Database
11	Microsoft Access
12	Microsoft Access
13	cloud technologies
14	Backup

Materials

Materials are not specified.

Resources

Resources	Resources Language
Bilgisayar Öğreniyorum, KodLab Yay	Türkçe
Bilgisayar Öğrenmenin Kısayolu	Türkçe

Course Assessment

Assesment Methods	Percentage (%)	Assesment Methods Title
Final Exam	50	Final Exam
Midterm Exam	50	Midterm Exam

L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes

Prospective Student