Information Package
baskent.edu.tr

Program of Technology and Knowledge Management

TKM111

ADVANCED OFFICE APPLICATIONS AND ANALYSIS

Course Code
TKM111
Semester
First Term (Fall)
Theory+Practice
3 + 0
ECTS
6
Course TypeCompulsory Course
Course LevelBachelor's Degree
Year of Study1
SemesterFirst Term (Fall)
ECTS6
Name of Lecturer(s)
Learning Outcomes

At the end of this course, the students;

  1. Learn to use all the features of word processing software at a high level.
  2. Learn to use all the features of the spreadsheet software at a high level.
  3. Learn to use some statistical applications with spreadsheet software
  4. They learn to use all the features of the Presentation software at a high level.
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme Components
Course DescriptionThe aim of this course is; To provide students with problem solving and analysis skills by understanding the importance of advanced information technologies, to create an infrastructure for their research and learning needs, to develop their learning and application skills by understanding the importance of technology and science in education and professional life.
Course Contents
WEEK TOPICS
1st Week Introduction, Introduction and Installation of Microsoft Office Applications
2nd Week Word Processor - Introduction and basic applications
3rd Week Word Processor - Advanced applications
4th Week Spreadsheet Processing - Basic Applications, Formulas and Functions
5th Week Spreadsheet Processing - Charts and Table Preparation
6th Week Spreadsheet Processing - Advanced Formulas and Functions I
7th Week Spreadsheet Processing - Examples and Applications I
8th Week Midterm
9th Week Spreadsheet Processing - Advanced Formulas and Functions II
10th Week Spreadsheet Processing - Examples and Applications II
11th Week Spreadsheet Processing - Some Statistical Applications
12th Week Spreadsheet Processing - Examples and Applications III
13th Week Presentation Preparation - Introduction and Basic Applications
14th Week Presentation Preparation - Advanced Presentation Applications
Recommended or Required Readingİleri Düzey Excel 2019, Ömer Bağcı, Seçkin Yayıncılık, 9.Baskı, 2020.
Microsoft Excel 2019, Osman Gürkan, Nirvana Yayınları, 2020.
Bilgisayar ve İnternet Kullanımı (Windows 7 Ofice 2010), Dr. Hasan Çebi Bal, Ekin Basım Yayın, 2018.
Planned Learning Activities and Teaching Methods
  • Lecture
  • Practice
Assessment Methods and Criteria
Quantity Percentage (%)
Mid-term 1 30
Quiz 3 10
Total(%) 40
Contribution of In-term Studies to Overall Grade(%) 40
Contribution of Final Examination to Overall Grade(%) 60
Total(%) 100
ECTS Allocated Based on Student Workload
Activities Quantity Duration (Hour) Total Workload (Hour)
Midterm exam 1 2 2
Preparation for Quiz 3 7 21
Individual or group work 14 3 42
Preparation for Final exam 1 30 30
Course hours 14 3 42
Preparation for Midterm exam 1 20 20
Laboratory (including preparation)
Final exam 1 2 2
Homework
Quiz 3 2 6
Total Work Load165
Total Work Load / 30 (h)5.5
ECTS Credit of the Course6
Language of InstructionTurkish
Work Placement(s)No

Programme Qualifications / Learning Outcomes

LO1 LO2 LO3 LO4
K1
K2
K3 X X X X
K4
K5
K6
K7
K8 X X X X
K9
K10
K11 X X
K12
K13
K14 X X X
K15 X X X X