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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
EKNM 111	PRACTICING BASIC INFORMATION TECHNOLOGY	1 + 2	2nd Semester	4

COURSE DESCRIPTION

Course Level	Bachelor's Degree
Course Type	Compulsory
Course Objective	To be able to use computer in basic level (computer recognition, preparing documents, preparing table, preparing presentation, internet usage).
Course Content	Basic computer information, Windows XP, Microsoft Word, Microsoft Excel, Microsoft Powerpoint, İnternet usage.
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	To recognize and use computer in general
2	To recognize and use Windows XP operating systems in general
3	To recognize and use Office programs in general
4	To be able to reach information and communicate in internet environment

COURSE'S CONTRIBUTION TO PROGRAM

	PO 01	PO 02	PO 03	PO 04	PO 05	PO 06	PO 07	PO 08	PO 09	PO 10	PO 11	PO 12
LO 001			4	3	4	5				3	3
LO 002			4	3	4	5				3	3
LO 003			5	4	5	5				3	3
LO 004	4									4	4
Sub Total	4		13	10	13	15				13	13
Contribution	1	0	3	3	3	4	0	0	0	3	3	0

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
Assignments	2	3	6
Total Work Load ECTS Credit of the Course			104 4

COURSE DETAILS

Select Year

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
EKNM 111	PRACTICING BASIC INFORMATION TECHNOLOGY	1 + 2	1	Turkish	2023-2024 Spring

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Asts. Prof. Dr. EREN ERGEN	eergen@pau.edu.tr		İİBF C0012	%70

Goals		To be able to use computer in basic level (computer recognition, preparing documents, preparing table, preparing presentation, internet usage).
Content		Basic computer information, Windows XP, Microsoft Word, Microsoft Excel, Microsoft Powerpoint, İnternet usage.

Topics

Weeks	Topics
1	Introdunction to Excel
2	Data Selection Methods in Excell
3	Introdunction to Excel Functions
4	Working with Excell Sheets
5	Working with Excell Cells
6	Formating in Excel
7	Figures in Exxel
8	Midterm Examination
9	Using Excel Functions
10	Macros in Excel
11	Visual Basic in Excel
12	Form Controls in Excel
13	Importimg External Data
14	Working with Data

Materials

Materials are not specified.

Resources

Resources	Resources Language
Pala, Z. "Microsoft Office Excel-2007", Türkmen Kitabevi, 1. Baskı, 2008.	Türkçe

Course Assessment

Assesment Methods	Percentage (%)	Assesment Methods Title
Final Exam	60	Final Exam
Midterm Exam	40	Midterm Exam

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

Prospective Student