Türkçe | English
FACULTY of ENGINEERING / DEPARTMENT of MINING ENGINEERING

Course Catalog
http://www.muhfak.ktu.edu.tr/maden/index.htm
Phone: +90 0462 3257406 , 3773153
MF
FACULTY of ENGINEERING / DEPARTMENT of MINING ENGINEERING /
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

VMAL1004Computer Programmes in Office1+1+0ECTS:4
Year / SemesterSpring Semester
Level of CourseShort Cycle
Status Compulsory
Department
Prerequisites and co-requisitesNone
Mode of DeliveryFace to face, Group study, Lab work
Contact Hours14 weeks - 1 hour of lectures and 1 hour of practicals per week
Lecturer--
Co-LecturerLECTURER Davut HÜRFİKİR,
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
Teaching how the role of computer in business life can be increased.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : create and manage complex elecronic tables.
LO - 2 : use advanced document features of Word in documents.
LO - 3 : know effective presentation techniques and prepare impressive presentations.
LO - 4 : do researches by using the Web site.
LO - 5 : manage e-mail accounts and Web 2.0 tools.
LO - 6 : produce statistical conclusions and comments via data in electronic media
CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome

 
Contents of the Course
Advanced Excel: The reports of table and graphs, formulas and graphs. Advanced Word: Documentation. Advanced PowerPoint: Preparing presentation and design of slide. Access: Data processing. Outlook: Receiving and sending mail. Occupational package programs: SPSS, Statview, Statistica. Applications on Internet.
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1Functions in electronics tables
 Week 2Financial process in electronic tables
 Week 3Producing graphics in electronic tables
 Week 4Excel Macros
 Week 5Creating and editing business and analysis forms, case studies
 Week 6Formatting techniques
 Week 7Working with non-text items
 Week 8Creating address and letter
 Week 9Mid-term exam
 Week 10Table of Contents
 Week 11Preparing extensive documents
 Week 12Preparing Presentation
 Week 13Presentation editor
 Week 14Presentation techniques
 Week 15Basic internet skills
 Week 16End-of-term exam
 
Textbook / Material
 
Recommended Reading
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 18/11/2016 1 50
End-of-term exam 16 13/01/2017 1 50
 
Student Work Load and its Distribution
Type of workDuration (hours pw)

No of weeks / Number of activity

Hours in total per term
Yüz yüze eğitim 2 14 28
Sınıf dışı çalışma 2 4 8
Laboratuar çalışması 2 13 26
Arasınav için hazırlık 7 1 7
Arasınav 1 1 1
Uygulama 2 12 24
Klinik Uygulama 0 0 0
Ödev 0 0 0
Proje 0 0 0
Kısa sınav 0 0 0
Dönem sonu sınavı için hazırlık 12 2 24
Dönem sonu sınavı 1 1 1
Diğer 1 0 0 0
Diğer 2 0 0 0
Total work load119