|
|
| ORM3021 | Informatics in Forestry | 2+0+0 | ECTS:4 | | Year / Semester | Fall Semester | | Level of Course | First Cycle | | Status | Elective | | Department | DEPARTMENT of FOREST ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | | | Contact Hours | 14 weeks - 2 hours of lectures per week | | Lecturer | Doç. Dr. Derya MUMCU KÜÇÜKER | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | The course aims to provide hands-on experiences to the students with the techniques involved in solving forestry problems with microcomputers using word processing (MS word), spreadsheet (MS excel), presentation (Powerpoint), database management tools (Access) and a flavor of geographic information system (Arc/İnfo). The objective of this course is to demonstrate the various applications of these three universal software tools so that the students are capable of applying them within the scope of their individual graduate studies of forest sciences and forest ecology. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Use any personal computers to design and write any text (an assay, paper, thesis, project or a book) professionally | 4,7 | | | LO - 2 : | Effective use of excel spreadsheet program to analyze raw data, conduct any calculations and graph the results appropriately | 4,7 | | | LO - 3 : | Design a database, input data, query the database with standard SQL and present the result in tabular form | 4,7 | | | LO - 4 : | Design an effective PowerPoint presentation | 4,7 | | | LO - 5 : | Prepare and present both the data and the analysis results in written form, graphical form using the appropriate computer programs | 4,7 | | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Word processing (Word): Creation of different types of documents, formatting documents using styles, using equation editor, applying page and section breaks, creating simple and complex headers and footers, creating and managing tables, inserting end notes to the top and bottom of pages, creating table of contents, table of figures/Tables and index for a document, finishing of a complete formal document.
Spread sheet (Excel): Data types, automatic data entry and control, basic calculations on a spread sheet, making statistical calculations, writing equations with absolute and relative addressing, creating X-Y charts of different type, producing histograms, copying these diagrams into word processor, filtering the data, conducting macros, creating summary table and preparing summary charts.
Database (Access): Data entry, creating input form, designing table formats and field data types, defining key columns, querying the database with standard SQL comments
Presentation (Powerpoint): Creating presentation background, choosing the color-font coupling, Selecting the appropriate font size and color, animating the presentation
|
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction to the course | | | Week 2 | System, model, data, information and information systems-informatics | | | Week 3 | System, model, data, information and information systems-informatics (continued) | | | Week 4 | Advanced wordprocessing applicaitons (MSWord: table of contents, indexing, format, heading etc) | | | Week 5 | Introduction to spreadsheet programs | | | Week 6 | Application of spreadsheet programs (MS Excel) | | | Week 7 | Applications of spreadsheet programs (equations in MSExcel) | | | Week 8 | Mid-term exam | | | Week 9 | Applications of spreadsheet programs (Graphics in MSExcel) | | | Week 10 | Applications of spreadsheet programs (summary table in MSExcel)
Assignment: Summarizing the forest classification data in a forest management plan | | | Week 11 | Macros and visual basic applicaitons in spreadsheet programs | | | Week 12 | Presentation programs with MS PowerPoint | | | Week 13 | Introduction to database programs | | | Week 14 | Sample applications of database programs (MSAccess) | | | Week 15 | Oral exam in front of the computer | | | Week 16 | End-of-term exam | | | |
| 1 | Microsoft office manuals (MS Word, MS Excel, MS Access, MS PowerPoint) | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 8 | 1011/2020 | 1 | 20 | | Quiz | 12 | 06/12/2020 | 1 | 30 | | End-of-term exam | 16 | 02/01/2021 | 1,5 | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 2 | 14 | 28 | | Sınıf dışı çalışma | 3 | 10 | 30 | | Laboratuar çalışması | 0 | 0 | 0 | | Arasınav için hazırlık | 5 | 1 | 5 | | Arasınav | 1 | 1 | 1 | | Uygulama | 2 | 14 | 28 | | Klinik Uygulama | 0 | 0 | 0 | | Ödev | 5 | 1 | 5 | | Proje | 0 | 0 | 0 | | Kısa sınav | 1 | 1 | 1 | | Dönem sonu sınavı için hazırlık | 8 | 1 | 8 | | Dönem sonu sınavı | 2 | 1 | 2 | | Diğer 1 | 0 | 0 | 0 | | Diğer 2 | 0 | 0 | 0 | | Total work load | | | 108 |
|