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

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
BYS 144	OFFICE SOFTWARES-II	1 + 2	2nd Semester	3,5

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Elective
Course Objective	Safely on the computer performing data entry transactions, provide the ability to make professional presentations in business
Course Content	Spreadsheets, presentation softwares, Web Operations
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Know and apply the methods of data entry using spreadsheets
2	Gains the ability to learn the techniques of effective presentation and presentation
3	Ensure data security and data protection methods, gain ability to learn
4	Learn techniques for transferring data over the Internet and web page management skills wins
5	Ability to win and prepare effective charts in spreadsheets calculation
6	Gains the ability to learn the techniques of report preparation and electronic media
7	Learns and applies the methods of preparing the electronic printing data prepared by
8	Learns the techniques of electronic data filing gains the ability to create and archive

COURSE'S CONTRIBUTION TO PROGRAM

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	3	3
Assignments	1	10	10
Mid-terms	1	5	5
Laboratory	2	9	18
Final examination	1	8	8
Presentation / Seminar Preparation	1	5	5
Total Work Load ECTS Credit of the Course			91 3,5

COURSE DETAILS

Select Year

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
BYS 144	OFFICE SOFTWARES-II	1 + 2	1	Turkish	2021-2022 Spring

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer MUSTAFA SAVAŞ	msavas@pau.edu.tr		Course location is not specified.	%60

Goals		Safely on the computer performing data entry transactions, provide the ability to make professional presentations in business
Content		Spreadsheets, presentation softwares, Web Operations

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