Pamukkale University
University is the guide to life
Welcome to PAU;
Prospective Student
Our Students
Our Staff
TR
Information Package & Course Catalogue
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes
FIRST CYCLE - BACHELOR'S DEGREE
FACULTY OF ENGINEERING
INDUSTRIAL ENGINEERING DEPARTMENT
255 Industrial Engineering
Course Information
Course Learning Outcomes
Course's Contribution To Program
ECTS Workload
Course Details
Print
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
All Years
2023-2024 Spring
2022-2023 Spring
2021-2022 Spring
2020-2021 Fall
2019-2020 Summer
2019-2020 Fall
Course Term
No
Instructors
Details
2023-2024 Spring
1
OLCAY POLAT
Details
2022-2023 Spring
1
OLCAY POLAT
Details
2021-2022 Spring
1
OLCAY POLAT
Details
2020-2021 Fall
1
OLCAY POLAT
Details
2019-2020 Summer
1
OLCAY POLAT
Details
2019-2020 Fall
1
OLCAY POLAT
Details
2019-2020 Fall
2
OLCAY POLAT
Print
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
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes