Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
HLT 132OFFICE PROGRAMS-22 + 12nd Semester3

COURSE DESCRIPTION
Course Level Associate's Degree
Course Type Elective
Course Objective To gain the ability to make professional presentations in business life by performing data entry operations securely on the computer.
Course Content Creating and editing spreadsheets, calculating and analyzing on these tables, using graphics effectively as a presentation tool and managing data
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1Knows and applies data entry methods using spreadsheets.
2Learns effective presentation techniques and gains presentation skills.
3Learns the methods of securing data and gains the ability to protect data.
4Gains the ability to calculate in spreadsheets and prepares effective graphics.
5Learns report preparation techniques and gains ability to transfer to electronic media.
6Learns and applies the methods of preparing data in electronic environment for printing.
7Learns data filing techniques in electronic environment and gains the ability to create archives.

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08
LO 001        
LO 002        
LO 003        
LO 004        
LO 005        
LO 006        
LO 007        
Sub Total        
Contribution00000000

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14342
Hours for off-the-classroom study (Pre-study, practice)14114
Assignments11010
Mid-terms155
Final examination177
Total Work Load

ECTS Credit of the Course






78

3
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Spring1MUSTAFA SAVAŞ
Details 2022-2023 Spring1MUSTAFA SAVAŞ


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
HLT 132 OFFICE PROGRAMS-2 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 the ability to make professional presentations in business life by performing data entry operations securely on the computer.
Content Creating and editing spreadsheets, calculating and analyzing on these tables, using graphics effectively as a presentation tool and managing data
Topics
WeeksTopics
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
ResourcesResources Language
İnternet ve İlgili KitaplarTürkçe
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam50Final Exam
Midterm Exam25Midterm Exam
Term Learning Activity25Term Learning Activity
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes