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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
LOJ 111	INTRODUCTION TO SPREADSHEETS	3 + 0	1st Semester	5

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	The aim of this lesson is to enable students to have the ability to use functions and design electronic spreadsheets based on various conditions. By the end of this course, students are expected to be able to design functions and create conditional spreadsheets.
Course Content	Introduction to Spreadsheets and Basic Concepts, Basic Operations and Formulas, Tables and Data Organization, Charts and Visualization Fundamentals, Basic Functions, Conditional Statements and Functions, Data Validation and Error Handling, Basic Data Analysis Tools, Data Organization Techniques, Internal and External Data Connections, Dashboards and Reporting, User Interface and Customization, Applied Project Work
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.

COURSE LEARNING OUTCOMES

1	Effectively utilizing the basic functions and interface of spreadsheets.
2	Processing data using simple formulas and functions.
3	Sorting, filtering, and performing data analysis.
4	Creating basic charts and applying visualization techniques.
5	Utilizing basic data validation and error handling techniques.
6	Preparing simple reports and dashboards using spreadsheets.
7	Effectively using spreadsheets in both professional and academic settings.

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
Hours for off-the-classroom study (Pre-study, practice)	14	4	56
Mid-terms	1	13	13
Final examination	1	19	19
Total Work Load ECTS Credit of the Course			130 5

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2025-2026 Fall	3	MURAT TOKBAŞ

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester	Mode of Delivery
LOJ 111	INTRODUCTION TO SPREADSHEETS	3 + 0	3	Turkish	2025-2026 Fall	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 enable students to have the ability to use functions and design electronic spreadsheets based on various conditions. By the end of this course, students are expected to be able to design functions and create conditional spreadsheets.
Content		Introduction to Spreadsheets and Basic Concepts, Basic Operations and Formulas, Tables and Data Organization, Charts and Visualization Fundamentals, Basic Functions, Conditional Statements and Functions, Data Validation and Error Handling, Basic Data Analysis Tools, Data Organization Techniques, Internal and External Data Connections, Dashboards and Reporting, User Interface and Customization, Applied Project Work

Topics

Weeks	Topics
1	Introduction to computers (Hardware)
2	Software
3	Using Keyboard and shortcuts
4	Windows operating system
5	Windows operating system
6	Windows operating system
7	Exam
8	Microsoft Word
9	Microsoft Word
10	Microsoft Word
11	Microsoft Excel
12	Microsoft Excel
13	Microsoft Powerpoint
14	Microsoft Powerpoint

Materials

Materials are not specified.

Resources

Resources	Resources Language
Temel Bilgi Teknolojisi Kullanımı,Seçkin Yayıncılık	Türkçe
Bilgisayar Öğreniyorum,KodLab	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