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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
DTC 217	OFFICE PROGRAMS- II	2 + 1	3rd Semester

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Elective
Course Objective	Advanced effective and efficient use of spreadsheet programs is aimed.
Course Content	To be able to create and edit spreadsheets, to calculate and analyze on these tables, to use graphics effectively as a presentation tool and to manage data.
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Creating and editing spreadsheets.
2	To be able to calculate and analyze on spreadsheets.
3	To be able to use graphics effectively and manage data as a presentation tool.

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)	1	6	6
Assignments	1	4	4
Mid-terms	1	8	8
Final examination	1	18	18
Total Work Load ECTS Credit of the Course			78

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2022-2023 Fall	1	MUSTAFA SAVAŞ

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
DTC 217	OFFICE PROGRAMS- II	2 + 1	1	Turkish	2022-2023 Fall

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer MUSTAFA SAVAŞ	msavas@pau.edu.tr		BEMYO E0203	%60

Goals		Advanced effective and efficient use of spreadsheet programs is aimed.
Content		To be able to create and edit spreadsheets, to calculate and analyze on these tables, to use graphics effectively as a presentation tool and to manage data.

Topics

Weeks	Topics
1	Spreadsheet general features
2	Spreadsheet File Operations
3	Column, Row, Worksheet, Workbook
4	Data Entry Techniques and Add Column, Add Row
5	Cell and Cell Formatting
6	Page Loyout and Printing, Data Filling
7	Basic Functions and Basic Functions
8	Calculation Introduction
9	Mathematical and Financial Functions
10	Logical Functions,
11	Text and Date Functions,
12	Search and Reference Functions and Search Data Functions
13	Data Sorting, Data Filtration and Data Analitics
14	Data Analysis and Graphics Preparation Summary Tables Creation and Presentation

Materials

Materials are not specified.

Resources

Resources	Resources Language
İnternet ve İlgili Kitaplar	Türkçe

Course Assessment

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

Prospective Student