• 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 EMT 2012 ADVANCED EXCEL PROGRAMMING ELECTIVE 3 0 0 5

Offered By

Econometrics

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSISTANT PROFESSOR SERKAN ARAS

Offered to

Econometrics Econometrics

Course Objective

The main objective of the course is to help you learn Visual Basic for Applications (VBA) programming with Excel. This includes a basic understanding of ranges and cell references, formulas, built-in functions, charts, and writing macros. More specifically, it will show you how to write programs that automate various tasks in Excel.

Learning Outcomes of the Course Unit

1   To be able to comprehend components of Excel. 2   To be able to be familiar with cell references, formulas, and built in functions. 3   To be able to take advantage of the Excel object model. 4   To be able to use application programming interface (API) calls. 5   To be able to write programs that automate various tasks in Excel.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description 1 Variables, Arrays, Constants, and Data Types. 2 Programming Basics: Decisions and Looping. 3 Strings, Functions, Message Boxes, and Operators 4 Debugging, Errors and the Error Function 5 Dialogs, Common Dialog Control, Command Bars and Buttons 6 The Excel Object Model, Using Excel to Interact with Other Office Programs 7 Working with Databases, API Calls, Class Modules, and Animation 8 MIDTERM 9 MIDTERM 10 Converting Labels to Numbers and Numbers to Labels, Adding Formula Details into Comments, 11 Summing Cells by Reference to a Master Cell, Coloring Alternate Rows and Columns of the Spreadsheet 12 An Alternative to Message Boxes 13 Globally Changing a Range of Values, Searching Multiple Sheets and Workbooks 14 Turning Your VBA Code into an Add-In

Recomended or Required Reading

1. Shepherd, R. (2004). Excel VBA Macro Programming. McGraw-Hill/Osborne. 2. Walkenbach, J. (2010). Excel Power Programming with VBA. Wiley Publishing. 3. Birnbaum, D. (2005). Microsoft Excel VB Programming for the Absolute Beginner. Thomson Course Technology PTR.

Planned Learning Activities and Teaching Methods

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA 1 MTE MIDTERM EXAM 2 MTEG MIDTERM GRADE MTEG * 1 3 FIN FINAL EXAM 4 FCGR FINAL COURSE GRADE MTEG * 0.40 + FIN * 0.60 5 RST RESIT 6 FCGR FINAL COURSE GRADE (RESIT) MTEG * 0.40 + RST * 0.60 *** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

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)

To be announced.

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours) Lectures 12 3 36 Preparations before/after weekly lectures 12 2 24 Preparation for midterm exam 1 30 30 Preparation for final exam 1 30 30 Midterm 1 1 1 Final 1 1 1 TOTAL WORKLOAD (hours) 122

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 LO.1 5 LO.2 5 LO.3 5 LO.4 5 LO.5 5