FOR 240 Introduction to Computing in Natural Resources
Syllabus
Class Notes
- Operating System Concepts
- Hardware, Software, File System, and Programming Languages
- Introduction to HTML Harvester Helicopter
- Excel Fundamentals
- Essential Spreadsheet Operations
- Excel Formulas and Functions
- Excel Charts and Analysis Tools
- Introduction to MS Access
- Tour of MS Access
- Introduction to SQL
- Access Tables and Queries
- Handheld computers and Windows CE
- Data Communication
- HP Jornada 720 HPC
- Handheld Applications in Forest Resource Management
- Introduction to Visual Basic Programming
- Understanding of VB Controls
- VB Project and Menu Design
- VB Programming Fundamentals I
- VB Programming Fundamentals II
- VB Programming Fundamentals III
- VB Applications in Forest Resource Management
- VBCE and its Application in Time Study of Timber Harvesting Operations
Lab, Homework Assignemtns, Project
- Lab 1: Creating your own web pages with HTML
- Lab 2: Using Excel formulas and functions to create timber sale report
- Lab 3: Analysis of DBH and merchantable height with Excel regression and chart tools
- Lab 4: Forest management planning using Excel Solver
- Lab 5: Timber cruising database application - tables and queries
- Lab 6: Timber cruising database application - forms and reports
- Lab 7: Using handheld to collect timber cruising data
- Lab 8: Using GPS to collect spatial data of timber cruising
- Lab 9: Using GIS to create maps and conduct spatial analysis of forest management
- Homework 1: Creating Gannt chart for project scheduling
- Homework 2: Mathematical programming in forest management with Excel Solver tool
- Homework 3: Using MS Access to create a database
- Homework 4: Using Data and DBGrid Controls to manipulate database Download Database
- Homework 5: Using VB Functions and Procedures to Calculate Basal Area and Volume of Trees
- Homework 6: Using VBA to create a cost analysis program for timber harvesting
- Course Project: Timber Cruising Management System