Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
PZR 148OFFICE SOFTWARES-II1 + 22nd Semester4

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

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12PO 13
LO 001           5 
LO 002 2  1        
LO 003           5 
LO 004           5 
LO 005    4      5 
LO 006           5 
LO 007           5 
LO 008             
Sub Total 2  5      30 
Contribution0000100000040

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14342
Mid-terms11010
Laboratory14228
Final examination11010
Presentation / Seminar Preparation11414
Total Work Load

ECTS Credit of the Course






104

4
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2017-2018 Spring1MUSTAFA SAVAŞ
Details 2016-2017 Spring1MUSTAFA SAVAŞ
Details 2015-2016 Spring1MUSTAFA SAVAŞ
Details 2014-2015 Spring1MUSTAFA SAVAŞ
Details 2013-2014 Spring1MUSTAFA SAVAŞ
Details 2013-2014 Spring1MUSTAFA SAVAŞ
Details 2012-2013 Spring1MUSTAFA SAVAŞ
Details 2011-2012 Spring1MUSTAFA SAVAŞ


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
PZR 148 OFFICE SOFTWARES-II 1 + 2 1 Turkish 2017-2018 Spring
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer MUSTAFA SAVAŞ msavas@pau.edu.tr Course location is not specified. %70
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
WeeksTopics
1 Spreadsheet general features
2 Spreadsheet File Operations
3 Column, Row, Worksheet, Workbook
4 Cell and Cell Formatting and Data Entry Techniques
5 Data Search, Data Sorting, Data Filtration
6 Basic Functions and Calculation
7 Mathematical and Financial Functions
8 Logical Functions
9 Text and Date Functions
10 Data Analysis and Graphics Preparation
11 Summary Tables Creation and Presentation
12 Printing Operations
13 External Data Transfer
14 Data security
Materials
Materials are not specified.
Resources
ResourcesResources Language
İnternet ve İlgili KitaplarTürkçe
Excel, İleri Düzey Excel KitaplarıTürkçe
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam60Final Exam
Midterm Exam40Midterm Exam
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes