Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | EM406.1B | Macro Programming | Elective | 4 | 8 | 5 |
|
Level of Course Unit |
First Cycle |
Objectives of the Course |
In today's business environment even more professional of engineers programs they use at the beginning of the Excel spreadsheet programs on the main features of the teferruata with the ability to Excel and to introduce programming to stroke can be defined as a Macro with Excel Macro Programming "to teach, even momentarily, to make sample applications with Macro Programming. |
Name of Lecturer(s) |
Dr. Öğr. Üyesi Latif AKÇAY |
Learning Outcomes |
1 | The main features of the spreadsheet Applications | 2 | Benefits of programming with spreadsheet programs and what we can do | 3 | Graphical illustrations with Microsoft Excell | 4 | Developing visual basic applications with Microsoft Excell |
|
Mode of Delivery |
Normal Education |
Prerequisites and co-requisities |
None |
Recommended Optional Programme Components |
None |
Course Contents |
Spreadsheet application introducing Microsoft Excel Package Program and be enrolled in such program Macro Programming realization phases. |
Weekly Detailed Course Contents |
|
1 | Excel basic definitions, the concept of the cell, copy-and-Paste-Paste Special | | | 2 | The concept of absolute and relative references, area | | | 3 | In general the concept of functions, excel functions | | | 4 | Conditional formatting | | | 5 | Data Validation | | | 6 | Excel-Visual Basic relationship | | | 7 | Overview of the Visual Basic programming language, basic functions | | | 8 | Midterm Exam | | | 9 | User-Defined Functions | | | 10 | User-defined Functions Area concept | | | 11 | Excel Visual Basic Editor's basic operations | | | 12 | Work with macro recorder | | | 13 | Macro programming function processes, graphic works | | | 14 | Example Applications | | | 15 | Macro Programming Industrial Applications | | |
|
Recommended or Required Reading |
VBA Macros, M. Kemal Korkmaz,
Step by step Microsoft Excel XP 2002, Curtis Frye, friend Publications |
Planned Learning Activities and Teaching Methods |
|
Assessment Methods and Criteria | |
Midterm Examination | 1 | 100 | SUM | 100 | |
Final Examination | 1 | 100 | SUM | 100 | Term (or Year) Learning Activities | 40 | End Of Term (or Year) Learning Activities | 60 | SUM | 100 |
| Language of Instruction | Turkish | Work Placement(s) | None |
|
Workload Calculation |
|
Midterm Examination | 1 | 1 | 1 |
Final Examination | 1 | 2 | 2 |
Attending Lectures | 14 | 3 | 42 |
Self Study | 14 | 3 | 42 |
Individual Study for Mid term Examination | 1 | 14 | 14 |
Individual Study for Final Examination | 1 | 18 | 18 |
Report | 1 | 10 | 10 |
Homework | 1 | 10 | 10 |
|
Contribution of Learning Outcomes to Programme Outcomes |
LO1 | 3 | 2 | 2 | 2 | 3 | 3 | 2 | 1 | LO2 | 3 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | LO3 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | LO4 | 3 | 1 | 2 | 1 | 1 | 1 | 3 | 1 |
|
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|