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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
BNK 122	OFFICE SOFTWARES - II	2 + 1	2nd Semester	2

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	To gain technical knowledge and skills for advanced use of spreadsheet software, along with conceptual knowledge of spreadsheet software used for decision makers to make effective decisions.
Course Content	General structure of spreadsheet software, spreadsheet techniques and applications, data types and structures, calculations and use of ready-made functions, macros, data analysis techniques, working with graphics, reporting and presentation
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Gain knowledge of spreadsheet software
2	Can design all kinds of tables in electronic environment.
3	Files and prints spreadsheets in desired formats
4	Recognizes data types and gains the ability to operate with data.
5	Gains problem solving skills by using ready-made functions
6	Learns to work with macros. Gains speed and agility in solving problems.
7	Learns to use data analysis techniques and reporting.
8	Learns to use the methods of preparing graphics based on the data and the results obtained in the presentation.

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	5	5		3		4
LO 002				5		2	4
LO 003							2		3			4
LO 004	5	5	5	5	5	5	5
LO 005					4	5	4
LO 006			5	4						4	4
LO 007							5		4	2
LO 008		4			3	4		2
Sub Total	10	14	10	17	12	20	20	2	7	6	4	4
Contribution	1	2	1	2	2	3	3	0	1	1	1	1

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
Mid-terms	1	5	5
Final examination	1	5	5
Total Work Load ECTS Credit of the Course			52 2

COURSE DETAILS

Select Year

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
BNK 122	OFFICE SOFTWARES - II	2 + 1	1	Turkish	2023-2024 Spring

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

Goals		To gain technical knowledge and skills for advanced use of spreadsheet software, along with conceptual knowledge of spreadsheet software used for decision makers to make effective decisions.
Content		General structure of spreadsheet software, spreadsheet techniques and applications, data types and structures, calculations and use of ready-made functions, macros, data analysis techniques, working with graphics, reporting and presentation

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