• HOME
• ABOUT US
  • Name Address
  • General Description
  • Governance
  • Academic Calendar
  • Degree Programmes
  • List of Programmes in English
  • General Admission and Registration Procedures
  • Credit Mobility and Recognition of Prior Learning
  • ECTS Credit Allocation
  • Academic Guidance
  • Contacts
• Degree Programmes
  • Third Cycle Programmes (Doctorate Degree)
  • Second Cycle Programmes (Master's Degree)
  • First Cycle Programmes (Bachelor's Degree)
  • Short Cycle Programmes (Associate's Degree)
• GENERAL INFORMATION FOR STUDENTS
  • Cost of Living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Disabled Students
  • Insurance
  • Financial Supports
  • Student Affairs Office
  • Practical Information for International Students
  • Language Courses
  • Work Placement Possibilities
  • Sports, Social and Cultural Facilities
  • Student Associations and Clubs
  • About İzmir - Turkey
• INTERNATIONAL RELATIONS
  • International Relations Office
  • Registration Procedures
  • Agreements
  • Coordinators
  • Documents
  • List of Programmes in English
  • ECTS / DS Labels

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS BLÖ 3014 ADVANCED MS OFFICE APPLICATIONS ELECTIVE 2 2 0 4

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

INSTRUCTOR FERIT SERKAN AKDOĞAN

Offered to

Computer and Instructional Technologies Teacher Education

Course Objective

To be able to create and organize macros in Office software

Learning Outcomes of the Course Unit

1   To define what a macro is 2   To create a macro automatically 3   To write a macro for a certain process 4   To create Windows objects and assign tasks to them 5   To design a form in Office software through the Visual Basic interface 6   Writing programs with Visual Basic interface

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Genaral introduction, what is a macro 2 Function usage in Excel 3 Saving macros in Excel 4 The relative referencing in saving macros 5 Organization of the saved macros 6 Writing macros via Visual basic 7 Conditions, if command, one way if, Dual way if, complex command, nested if 8 Mid-term exam 9 If-else, Question mark operator, Switch 10 Loops, while command, stages of while command, Use of Termination Value, Other operators, Complex Assignment Operators, Increment and Decrement Operators 11 Loops, for command, different usages of for command, do-while command, Nested loops, break ve continue commands, basic errors in loops 12 Functions, function that returns a value, function that not return a value, parameter, multi-parameter functions 13 arrays, assignment, arrays and functions 14 Definition of string, string input processes, string output processes, string functions, character functions, index strings 15 End-of-term exam

Recomended or Required Reading

1. Çağıltay, N. & diğerleri. (2007) C Dersi: Programlamaya Giriş

Planned Learning Activities and Teaching Methods

Discussion, application

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 VZ Arasınav 2 DTK Diğer Etkinlik 3 FN Yarıyılsonu Sınavı 4 BNS BNS VZ * 0.30 + DTK * 0.10 + FN * 0.60 5 BUT Bütünleme Notu 6 BBN Bütünleme Sonu Başarı Notu VZ * 0.30 + DTK * 0.10 + BUT * 0.60

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

serkan.akdogan@deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Theoretical 14 2 28 Application 14 2 28 Assignment Preparation 2 2 4 Project Preparation 8 3 24 Final Preparation 2 2 4 Paper Preparation 2 2 4 Others (Please indicate) 6 1 6 Final Exam 1 2 2 Midterm Exam 1 2 2 TOTAL WORKLOAD (hours) 102

Contribution of Learning Outcomes to Programme Outcomes

PO/LO PO.1 PO.2 PO.3 PO.4 PO.5 PO.6 PO.7 PO.8 PO.9 PO.10 PO.11 PO.12 PO.13 PO.14 PO.15 PO.16 LO.1 5 4 LO.2 5 4 LO.3 5 4 LO.4 5 4 LO.5 5 4 LO.6 5 4 5 5 5 5 5