of0
SDÜ Education Information System Course Content
Programme
Graduate School of Natural and Applied Sciences Civil Engineering
Course Information
Course Unit Code
Course Unit Title
Credit Theoretic
Credit Pratic
Credit Lab/A
Credit Total
Credit Ects
Semester
01INS6148
Spreadsheets Macros
3.00
0.00
0.00
3.00
6.00
1
Course Information
Language of Instruction
Turkish
Type of Course Unit
Elective
Course Coordinator
Professor Mesut TIĞDEMİR
Course Instructors
1-Mesut TIĞDEMİR
Course Assistants
 
Course Aims
Improving the use of macros in spreadsheet programs
Ability to create user interface for macros
Spreadsheet use via visual programming
Course Goals
Improving the quality of spreadsheet use
Increasing the efficiency of the use of macros in spreadsheets table
Private-user interface enhancements of the spreadsheet
Learning Outcomes of The Course Unit
More efficient use spreadsheet skills
Visual programming ability
Course Contents
Visual basic programming commands are saved in the program by working with Excel
development is also called macro programming. In this course, the Excel worksheet
understanding of the macro program examining macro recording and codes run-
will be maintained. Designing forms, add components, adding modules, code writing process will be done.
Form element features will be learned.
Prerequisities and Co-requisities Courses
 
Recommended Optional Programme Components
 
Mode Of Delivery
 
Level of Course Unit
 
Assessment Methods and Criteria
ECTS / Table Of Workload (Number of ECTS credits allocated)
Studies During Halfterm
Number
Co-Efficient
Activity
Number
Duration
Total
Visa
1
50
Course Duration (Excluding Exam Week)
14
3
42
Quiz
0
0
Time Of Studying Out Of Class
14
1
14
Homework
1
50
Homeworks
3
1
3
Attendance
0
0
Presentation
1
1
1
Application
0
0
Project
0
0
0
Lab
0
0
Lab Study
0
0
0
Project
0
0
Field Study
0
0
0
Workshop
0
0
Visas
1
1
1
Seminary
0
0
Finals
1
1
1
Field study
0
0
Workload Hour (30)
30
TOTAL
100
Total Work Charge / Hour
 
The ratio of the term to success
40
Course's ECTS Credit
 
The ratio of final to success
60
 
TOTAL
100
 
Recommended or Required Reading
Textbook
All books and Internet resources related to EXCEL
Additional Resources
All books and Internet resources related to EXCEL
Material Sharing
Documents
 
Assignments
 
Exams
 
Additional Material
 
Planned Learning Activities and Teaching Methods
Lectures, Practical Courses, Presentation, Seminar, Project, Laboratory Applications (if necessary)
Work Placements
As with any other educational component, credits for work placements are only awarded when the learning outcomes have been achieved and assessed. If a work placement is part of organised mobility (such as Farabi and Erasmus), the Learning Agreement for the placement should indicate the number of credits to be awarded if the expected learning outcomes are achieved.
Program Learning Outcomes
No
Course's Contribution to Program
Contribution
1
An ability to design, conduct laboratory experiments and analyze and interpret data, in one of the major civil engineering areas
3