Course Information
| Course Unit Title |
: |
Spreadsheets Macros |
| Course Unit Code |
: |
01INS6148 |
| Type of Course Unit |
: |
Optional |
|
Level of Course Unit
|
: |
Second Cycle |
| Year of Study
|
: |
Preb |
| Semester
|
: |
255.Semester |
| Number of ECTS Credits Allocated
|
: |
6,00 |
| Name of Lecturer(s) |
: |
---
|
| Course Assistants |
: |
|
| Learning Outcomes of The Course Unit |
: |
More efficient use spreadsheet skills
Visual programming ability
|
| Mode of Delivery |
: |
Face-To-Face
|
| Prerequisities and Co-requisities Courses |
: |
Unavailable
|
| Recommended Optional Programme Components |
: |
Unavailable
|
| 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.
|
|
Languages of Instruction |
: |
Turkish
|
| 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
|
|
Course Aims |
: |
Improving the use of macros in spreadsheet programs
Ability to create user interface for macros
Spreadsheet use via visual programming
|
|
WorkPlacement |
|
|
|
|
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)
|
|
|
ECTS / Table Of Workload (Number of ECTS credits allocated)
|
Student workload surveys utilized to determine ECTS credits.
|
|
Activity
|
:
|
|
|
Course Duration (Excluding Exam Week)
|
:
|
|
|
Time Of Studying Out Of Class
|
:
|
|
|
Homeworks
|
:
|
|
|
Presentation
|
:
|
|
|
Project
|
:
|
|
|
Lab Study
|
:
|
|
|
Field Study
|
:
|
|
|
Visas
|
:
|
|
|
Finals
|
:
|
|
|
Workload Hour (30)
|
:
|
|
|
Total Work Charge / Hour
|
:
|
|
|
Course's ECTS Credit
|
:
|
|
|
Assessment Methods and Criteria
|
Studies During Halfterm
|
: |
|
|
Visa
|
: |
|
|
Quiz
|
: |
|
|
Homework
|
: |
|
|
Attendance
|
: |
|
|
Application
|
: |
|
|
Lab
|
: |
|
|
Project
|
: |
|
|
Workshop
|
: |
|
|
Seminary
|
: |
|
|
Field study
|
: |
|
| |
|
|
|
TOTAL
|
: |
|
|
The ratio of the term to success
|
: |
|
|
The ratio of final to success
|
: |
|
|
TOTAL
|
: |
|
|
|
Weekly Detailed Course Content
|
Week
|
Topics
|
|
1
|
Basic features of spreadsheets
|
|
|
|
|
2
|
Basic features of spreadsheets
|
|
|
|
|
3
|
Working with Macros
|
|
|
|
|
4
|
Working with Macros
|
|
|
|
|
5
|
Visual programming
|
|
|
|
|
6
|
Visual programming
|
|
|
|
|
7
|
Commands of programming
|
|
|
|
|
8
|
Commands of programming
|
|
|
|
|
9
|
Creating spreadsheets with macros use
|
|
|
|
|
10
|
applications
|
|
|
|
|
11
|
applications
|
|
|
|
|
12
|
applications
|
|
|
|
|
13
|
applications
|
|
|
|
|
14
|
Presentations
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|
0
|
|
|
|
|
|