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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
CENG 290	SPREADSHEETS AND APPLICATIONS	4 + 0	4th Semester	4

COURSE DESCRIPTION

Course Level	Bachelor's Degree
Course Type	Compulsory
Course Objective	The aim of the course is to make students have the ability of calculation based on functions and macros. At the end of this course, students will be able to identify spreadsheet applications, understand the basic and advanced level functions and code with macros (VBA).
Course Content	Introduction to spreadsheets, Basic level functions, Advanced level functions, Graphics, Pivot tables, Macros, Introduction to VBA programming, Advanced level VBA programming
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

2	Explains daily and industrial usage of functions
1	Explains spreadsheet concepts
3	Helps to generate automatic report tables
4	Explains fast coding in spreadsheets

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	PO 13
LO 001	5	5	5	5	5	5	5	5	5
LO 002	5		5	5	5		5					5	5
LO 003	5	5	5	5	5	5	5					5	5
LO 004	5	5	5	5	5							5	5
Sub Total	20	15	20	20	20	10	15	5	5			15	15
Contribution	5	4	5	5	5	3	4	1	1	0	0	4	4

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	4	56
Assignments	1	12	12
Mid-terms	1	10	10
Final examination	1	10	10
Report / Project	1	16	16
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
CENG 290	SPREADSHEETS AND APPLICATIONS	4 + 0	1	Turkish	2023-2024 Spring

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Prof. Dr. OLCAY POLAT	opolat@pau.edu.tr		MUH B0018-03 ÖİDB BB109	%70

Goals		The aim of the course is to make students have the ability of calculation based on functions and macros. At the end of this course, students will be able to identify spreadsheet applications, understand the basic and advanced level functions and code with macros (VBA).
Content		Introduction to spreadsheets, Basic level functions, Advanced level functions, Graphics, Pivot tables, Macros, Introduction to VBA programming, Advanced level VBA programming

Topics

Weeks	Topics
1	Introduction to Excel 1
2	Introduction to Excel 2
3	Advanced Proporties of Excel 1
4	Advanced Proporties of Excel 2
5	Dashboard Reporting
6	Excel Functions 1
7	Excel Functions 2
8	Midterm
9	Macros
10	Introduction to VBA
11	Variables, Parameters, Loops
12	VBA Coding
13	User Form 1
14	User Form 2

Materials

Materials are not specified.

Resources

Resources	Resources Language
İleri Düzey Excel 2016, Ömer Bağcı Excel ile Programlama 1 VBA, M. Temel Korkmaz	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