Nevşehir Hacı Bektaş Veli University Course Catalogue

Information Of Programmes

GULSEHIR VOCATIONAL SCHOOL OF SOCIAL SCIENCES / ENF 102 - LOCAL GOVERNMENT

Code: ENF 102 Course Title: USAGE OF BASIC ?NFORMATION TECHNOLOGIES II Theoretical+Practice: 2+0 ECTS: 3
Year/Semester of Study 1 / Spring Semester
Level of Course Short Cycle Degree Programme
Type of Course Optional
Department LOCAL GOVERNMENT
Pre-requisities and Co-requisites None
Mode of Delivery Face to Face
Teaching Period 14 Weeks
Name of Lecturer SIDDIK ÜNAL (sunal@nevsehir.edu.tr)
Name of Lecturer(s) SIDDIK ÜNAL,
Language of Instruction Turkish
Work Placement(s) None
Objectives of the Course
To introduce the innovations that Office 2007 has brought along and to maintain the efficient use of Microsoft Word, Excel and Powerpoint programmes which are in Office 2007 package as well as to introduce Mozilla Thunderbird which is one of the e-mail management programmes.

Learning Outcomes PO MME
The students who succeeded in this course:
LO-1 They can create document by using MS Word application programme, make formulation, create table, and set properties of programme and documents. PO-9 9- Use basic information technologies.
Examination
LO-2 They can create work book by utilizing MS Excel application programme, make cell formulation, add formula, and set property of programme and work books. PO-9 9- Use basic information technologies.
Examination
LO-3 They can create presentation slide by using MS Powerpoint programme, set property of formalization like slide order, design and animation, and set property of programme and presentation PO-9 9- Use basic information technologies.
Examination
LO-4 MS Word, Excel and Powerpoint programs knows to use daily lesson plans PO-9 9- Use basic information technologies.
Examination
PO: Programme Outcomes
MME:Method of measurement & Evaluation

Course Contents
MS Word, MS Excel, MS Powerpoint
Weekly Course Content
Week Subject Learning Activities and Teaching Methods
1 The concepts of Office programmes, Versions of Office, System requirements for Office 2007, Installing Office 2007, What is new in Office 2007 and a general overview of Office 2007 programs. to show and do, practical work, question and answer
2 Display elements of Word 2007, tabs, page setup and file operations, text operations, tables. to show and do, practical work, question and answer
3 Working with pictures, thumbnails, shapes, word art, smart art and graphics in Word 2007 to show and do, practical work, question and answer
4 Equations and Symbols in Word 2007, Calculation in Tables. to show and do, practical work, question and answer
5 Getting to know Excel 2007, display elements, tabs, page setup and file operations. to show and do, practical work, question and answer
6 Workbook Operations in Excel 2007, Working with Data and Data Tables. to show and do, practical work, question and answer
7 Working with formulas in Excel 2007. to show and do, practical work, question and answer
8 mid-term exam
9 Focusing on certain data using filters in Excel 2007, creating graphics. to show and do, practical work, question and answer
10 Data Verification, Excel 2007’de Veri Doğrulama, Automating recurring tasks with macros, Creating dynamic lists with spreadsheets. to show and do, practical work, question and answer
11 Introduction to PowerPoint 2007, how to start the program, display elements, tabs, page setup and file operations. to show and do, practical work, question and answer
12 Do’s and Dont's while preparing presentations in PowerPoint 2007, how to prepare a presentation. to show and do, practical work, question and answer
13 Creating tables, photo albums, shapes, smart art graphics in PowerPoint 2007 and adding footers, headers, date, slide numbers, symbols, objects, video and sounds to pages. to show and do, practical work, question and answer
14 Animation tabs, slideshow tabs in Power Point 2007 to show and do, practical work, question and answer
15 How to use Mozilla Thunderbird, one of the e-mail management programs to show and do, practical work, question and answer
16 final exam
Recommend Course Book / Supplementary Book/Reading
1 Adım Adım Microsoft Office Word 2007,Arkadaş Yayınevi.
Required Course instruments and materials

Assessment Methods
Type of Assessment Week Hours Weight(%)
mid-term exam 8 1 40
Other assessment methods
1.Oral Examination
2.Quiz
3.Laboratory exam
4.Presentation
5.Report
6.Workshop
7.Performance Project
8.Term Paper
9.Project
final exam 16 1 60

Student Work Load
Type of Work Weekly Hours Number of Weeks Work Load
Weekly Course Hours (Theoretical+Practice) 2 14 28
Outside Class
       a) Reading 0
       b) Search in internet/Library 0
       c) Performance Project 5 8 40
       d) Prepare a workshop/Presentation/Report 0
       e) Term paper/Project 0
Oral Examination 0
Quiz 0
Laboratory exam 0
Own study for mid-term exam 4 2 8
mid-term exam 1 1 1
Own study for final exam 6 2 12
final exam 1 1 1
0
0
Total work load; 90