TÜRKÇE
ENGLISH
Information
| Code | TB524 |
| Name | Data base for Field Crops |
| Term | 2022-2023 Academic Year |
| Term | Spring |
| Duration (T+A) | 3-0 (T-A) (17 Week) |
| ECTS | 6 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | Türkçe |
| Level | Doktora Dersi |
| Type | Normal |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | |
| Course Instructor |
1 |
Course Goal / Objective
learn how to enter, manage, and search through large amounts of data in an database.
Course Content
Introduction to Databases Learn all about an Access database and how it works.
Course Precondition
No-prerequisites
Resources
Adım adım Microsoft Access sürüm 2002 : Microsoft Office XP application 320 s Access Basics: https://edu.gcfglobal.org/en/access/
Notes
Database Management Systems
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | have a broad understanding of database concepts and database management system software |
| LO02 | have a high-level understanding of major DBMS components and their function |
| LO03 | be able to program a data-intensive application using DBMS APIs. |
| LO04 | Overview of Storage and Indexing |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Graduates become a specialist on the field crops area by improving their skills. | 3 |
| PLO02 | Bilgi - Kuramsal, Olgusal | They comprehend interdisciplinary interaction in his specialization area. | 2 |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | They can follow the latest developments in field crops area and get access to the knowledge source, gather this knowledge, reach new knowledge and synthesize by evaluating available studies and follow the innovations in his field. | |
| PLO04 | Beceriler - Bilişsel, Uygulamalı | They can synthesize and interpret interdisciplinary knowledge by using theoretical and practical skills at a specialist level in field crops area. | |
| PLO05 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | They find solutions for problems related to field crops by using research methods and establish cause effect relationships. | |
| PLO06 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | They incorporate their knowledge on his special area by combining their knowledge with those from the other scientific areas and produce new knowledge and also solve the problems by using scientific research methods. | |
| PLO07 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | They determine a problem independently in field crops subject, provide solutions, evaluate the results and implement whenever required. | |
| PLO08 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | They are qualified to solve a problem in their field. | |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | They are equipped with analytical and critical thinking ability to direct their learning and to conduct advanced studies in their fields independently. | |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | They transfer current developments and their own studies in the field crops area systematically to the his working group and to different groups from other study fields orally or visually by supporting them with qualitative and quantitive data. | 5 |
| PLO11 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | They study and improve the social relationships and standards leading these relationship by a critical point of view and take action when needed. | |
| PLO12 | Yetkinlikler - Alana Özgü Yetkinlik | They are able to understand and translate an article written in a foreign language. | |
| PLO13 | Yetkinlikler - Alana Özgü Yetkinlik | They develop policy, strategy and experimental plans related to field crops area and evaluate obtained results within the framework of quality processes. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Objects Learn about each of the four objects in Access to understand how they interact with each other to create a fully functional relational database. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 2 | Getting Started in Access Familiarize yourself with the Access environment, including the Ribbon, Backstage view, Navigation pane, Document Tabs bar, and Record Navigation bar. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 3 | Managing Databases and Objects Learn how to to open and close an Access database, as well as how to open, close, and save objects. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 4 | Working with Tables Learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 5 | Working with Forms Learn how to use forms to enter new records and view and edit existing ones. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 6 | Sorting and Filtering Records Learn how to sort and filter data so you can customize how you organize and view it. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 7 | Designing a Query Learn how to create both a simple one-table query and a slightly more complex multi-table query. | prereading | Öğretim Yöntemleri: Gösteri, Anlatım |
| 8 | Test your knowledge of Access by taking quiz. | Literature search | Ölçme Yöntemleri: Ödev |
| 9 | More Query Design Options Learn how to modify and sort queries, as well as how to use the Totals function to create a query that can perform calculations with your data. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 10 | Creating Reports Learn how to create, modify, and print reports. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 11 | Advanced Report Options Learn how to use the Report Wizard to create complex reports and use Access formatting options to change the look of your report. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 12 | Database Design Tips Modifying Tables Learn how to create and rearrange table fields, as well as set validation rules, character limits, and data types. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 13 | Creating Forms Learn how to create and modify forms using options like design controls and form properties. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 14 | Formatting Forms Learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. | pre reading | Öğretim Yöntemleri: Anlatım, Gösteri |
| 15 | final sınavı Designing Your Own Database Learn how to create a database from an existing template and find resources to learn more about database design. | Literature search | Ölçme Yöntemleri: Proje / Tasarım, Ödev |
| 16 | final exam | Ölçme Yöntemleri: Performans Değerlendirmesi, Sözlü Sınav |
|
| 17 | final exam | Ölçme Yöntemleri: Sözlü Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 5 | 70 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 15 | 15 |
| Final Exam | 1 | 30 | 30 |
| Total Workload (Hour) | 157 | ||
| Total Workload / 25 (h) | 6,28 | ||
| ECTS | 6 ECTS | ||