TB524 Data base for Field Crops

6 ECTS - 3-0 Duration (T+A)- . Semester- 3 National Credit

Information

Code TB524
Name Data base for Field Crops
Term 2023-2024 Academic Year
Semester . Semester
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 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

Update Time: 10.05.2023 09:51