Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
İST314PROGRAMMING WITH DATA BASEElective364
Level of Course Unit
First Cycle
Objectives of the Course
The aim of the course is to make students create a database with using Microsoft Office components, obtain statistical results from the database by using their programming knowledge
Name of Lecturer(s)
Öğr.Gör.Dr.Emine ÇETİNGÖZ
Learning Outcomes
1List all components of a database
2Define all variables that is required for creating a database
3Design all relations in a database correctly
4Create a database properly in the computer environment
5Query required information from a database
Mode of Delivery
Face to Face
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
Fundamentals of database. Different creating database approaches. Type of variables employed in modeling a database. General information about Microsoft Office components. Fundamentals of Microsoft Excel. Connections between Visual Basic and Microsoft Excel.
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Microsoft Office and its components. Introduction to Microsoft Office Excel.Problem solving with guidance
2Create a Macros in Excel VBA and the Visual Basic EditorProblem solving with guidance
3Type of variables employed in modeling a database and their features. Problem solving with guidance
4Operators in Microsoft Office ExcelProblem solving with guidance
5A Loop in Excel VBA and If Then StatementProblem solving with guidance
6Creating macros in Microsoft Office Excel.Problem solving with guidance
7VBA Code for the Workbooks and WorksheetsProblem solving with guidance
8MidtermProblem solving with guidance
9The usage of the functions in Microsoft Office Excel.Problem solving with guidance
10Using Visual Basic components and coding in Microsoft Office Excel.Problem solving with guidance
11User Forms, “Command Button” control and “Check Box” control in Microsoft Office Excel.Problem solving with guidance
12 “Option Button” control, “Combo Box” control, “List Box” control and “RefEdit” control in Microsoft Office Excel.Problem solving with guidance
13Triggers, “Input Box” and “Msg Box” controls in Microsoft Office Excel.Presentations of semester projects
14Calling Microsoft Office Excel functions by Visual Basic codes. Presentations of semester projects
15Presentations of semester projectsPresentations of semester projects
16Final Exam
Recommended or Required Reading
REQUIRED READING: 1.Excel ile Programlama – 1, M. Temel Korkmaz, 2009. 2.Excel'de Makrolar:VBA, Cenk İltir, Pusula, 2011 3.Excel XP Makro Ötesi, Nihat Demirli ve Yüksel İnan, Palme Yayıncılık (5.Baskı), 2006. RECOMMENDED READINGS: 4.VBA and Macros for Microsoft Excel, Bill Jelen and Tracy Syrstad, Sams Publishing 2004. 5.Mastering Excel 2003 Programming with VBA, Steven M. Hansen, SYBEX Inc., 2004.
Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
SUM0
End Of Term (or Year) Learning ActivitiesQuantityWeight
SUM0
SUM0
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination4520
Problem Solving11222
Project Preparation5630
Project Presentation4520
Performance14228
TOTAL WORKLOAD (hours)120
Contribution of Learning Outcomes to Programme Outcomes
PO
1
PO
2
PO
3
PO
4
PO
5
PO
6
PO
7
PO
8
PO
9
PO
10
PO
11
PO
12
PO
13
PO
14
PO
15
PO
16
PO
17
PO
18
PO
19
PO
20
PO
21
PO
22
PO
23
PO
24
LO1                        
LO2                        
LO3                        
LO4                        
LO5                        
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High
 
Ege University, Bornova - İzmir / TURKEY • Phone: +90 232 311 10 10 • e-mail: intrec@mail.ege.edu.tr