SDU Education Information System
   Home   |  Login Türkçe  | English   
 
   
 
 


 
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 :
Number Duration Total  
Course Duration (Excluding Exam Week) :
14 3 42  
Time Of Studying Out Of Class :
14 1 14  
Homeworks :
3 1 3  
Presentation :
1 1 1  
Project :
0 0 0  
Lab Study :
0 0 0  
Field Study :
0 0 0  
Visas :
1 1 1  
Finals :
1 1 1  
Workload Hour (30) :
30  
Total Work Charge / Hour :
0  
Course's ECTS Credit :
0      
Assessment Methods and Criteria
Studies During Halfterm :
Number Co-Effient
Visa :
1 50
Quiz :
0 0
Homework :
1 50
Attendance :
0 0
Application :
0 0
Lab :
0 0
Project :
0 0
Workshop :
0 0
Seminary :
0 0
Field study :
0 0
   
TOTAL :
100
The ratio of the term to success :
40
The ratio of final to success :
60
TOTAL :
100
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