COURSE UNIT TITLE

: ADVANCED EXCEL APPLICATIONS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
MBD 5060 ADVANCED EXCEL APPLICATIONS ELECTIVE 2 0 0 4

Offered By

Buca Faculty Of Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

FERIT SERKAN AKDOĞAN

Offered to

Music Teacher Education
Turkish Language Teacher Education
Computer and Instructional Technologies Teacher Education
Chemistry Teacher Education
Biology Teacher Education
Turkish Language and Literature Teacher Education
Geography Teacher Education
Physics Teacher Education
Special Teacher Education
ELEMENTARY MATHEMATICS TEACHER EDUCATION
PRE - SCHOOL TEACHER EDUCATION
Mathematics Teacher Education
Elementary Teacher Education
FINE ARTS TEACHER EDUCATION
Guidance and Psychological Counseling
Social Studies Teacher Education
History Teacher Education
Science 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 VBA interface
6   Writing programs with VBA 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

Excel'de Makrolar: VBA, Cenk Iltir

Planned Learning Activities and Teaching Methods

Discussion, application

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 VZ Midterm
2 FN Semester final exam
3 BNS BNS Student examVZ * 0.40 + Student examFN * 0.60
4 BUT Make-up note
5 BBN End of make-up grade Student examVZ * 0.40 + Student examBUT * 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)

Lect. Ferit Serkan Akdoğan
ferit.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/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14
LO.14
LO.24
LO.34
LO.44
LO.54
LO.64

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS