Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS Credits
-1BLP219Advanced Office Applications2+2+035

Course Details
Language of Instruction Turkish
Level of Course Unit Associate Degree
Department / Program Computer Programming
Type of Program Formal Education
Type of Course Unit Elective
Course Delivery Method Face To Face
Objectives of the Course The aim of this course is to enable the student to learn the hardware and software parts of the computer and to be able to use MS Office Word and Powerpoint programs, to be able to use Excel at an advanced level, to work with formulas and to use them where necessary, to create tables and graphics.
Course Content Computer hardware, software and operating system, basic concepts related to the internet, information ethics, web-based learning, word processing, presentation preparation, spreadsheet, information and communication technology
improvements.
Course Methods and Techniques
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Instructor Gizem Kahrıman
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources lecture notes
Lecture notes will be given weekly.

Course Category
Education %100

Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Final examination 1 % 60
Total
2
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 2 28
Hours for off-the-c.r.stud 14 2 28
Mid-terms 1 15 15
Final examination 1 30 30
Total Work Load   Number of ECTS Credits 4 101

Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Determining the hardware and software features of information technology tools
2 To communicate on the internet
3 Being able to use MS Word
4 Being able to use MS Powerpoint
5 Be able to use excel


Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Computer Hardware and Software Systems
2 Features of MS Office Applications
3 MS Word: Chart, Header, Footer, Page Number, Adding Reference and Objects, Track Changes, Creating Equations, Adding Controls
4 MS Word: Styles, Table of Contents and Bibliography, Mail Merge
5 MS Powerpoint: Working with Slides, Adding, Editing, Subtracting, Adding Animation to Text
6 To be able to use MS Powerpoint: Presentation
7 To be able to use MS Powerpoint: Presentation
8 Excel Overview and Data Entry
9 Excel: Working on Data
10 Excel: Format Cells
11 Excel: Worksheets
12 Using Excel: Window Operations
13 Excel: Formula Operations on Tables
14 Excel: Canned Functions, Sorting, Filtering Data, Graphs


Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10
All 1 1 3 1 1 5 1 1 5 1
C1 1 1 3 1 1 5 1 1 5 1
C2 1 1 3 1 1 5 1 1 5 1
C3 1 1 3 1 1 5 1 1 5 1
C4 1 1 3 1 1 5 1 1 5 1
C5 1 1 3 1 1 5 1 1 5 1

bbb


https://obs.gedik.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=113570&curProgID=44&lang=en