COURSE UNIT TITLE

: FIELD ELC. 7 (APPROACHES TO TEACHING PROGRAMMING).

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
TEK 4018 FIELD ELC. 7 (APPROACHES TO TEACHING PROGRAMMING). ELECTIVE 2 0 0 4

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

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 (Excel)

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 VBA
7 Mid-term
8 Conditions, if command, one way if, Dual way if, complex command, nested if
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 Final

Recomended or Required Reading

Excel'de Makrolar: VBA, Cenk Iltir

Planned Learning Activities and Teaching Methods

Observation

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)
Lectures 13 2 26
Preparations before/after weekly lectures 13 4 52
Preparation for midterm exam 1 4 4
Preparation for final exam 1 4 4
Midterm 1 2 2
Final 1 2 2
TOTAL WORKLOAD (hours) 90

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.12555454322
LO.23545555322
LO.32555542222
LO.43545454222
LO.52555455222
LO.62222222222