A spreadsheet-based model for teaching the agronomic, economic, and environmental aspects of bioenergy cropping systems

作者:Thelen Kurt D*; Gao Juan; Hoben John; Qian Leilei; Saffron Christopher; Withers Katherine
来源:Computers and Electronics in Agriculture, 2012, 85: 157-163.
DOI:10.1016/j.compag.2012.04.010

摘要

In order to assess and compare the economic and environmental sustainability of newly emerging bioenergy cropping systems, students need a comprehensive computer-based tool for cataloging attributes of various proposed bioenergy feedstock crops. We have developed a spreadsheet-based model whereby students develop financial budgets; energy budgets, and carbon budgets, for various bioenergy cropping systems. This paper details the rationale and development of the teaching tool spreadsheet-based model. At the beginning of the semester, students working in small groups consisting of 2-3 individuals are assigned ownership of a %26quot;virtual farm%26quot; in a designated geographical region. Throughout the semester, as particular bioenergy crops are discussed in lecture, the students use the teaching model to develop economic, energy, and carbon budgets for each crop specific to the geographical aspects of their virtual farm. The computer spreadsheet model helps students determine the approximate farmgate value of bioenergy feedstocks and determine the carbon and energy footprint associated with the various cropping systems. At the conclusion of the semester, students use the model generated results to contrast and compare their farm%26apos;s bioenergy cropping system economic and environmental performance to that of farms situated in other geographical areas. End-of-semester student evaluations of the course resulted in ratings of %26quot;superior%26quot; or %26quot;above average%26quot; for student interest and all other parameters associated with the course. The results demonstrate the effectiveness of the teaching tool and a motivation and willingness for students to acquire knowledge of bioenergy based systems as part of their formal education to prepare for future employment opportunities. Published by Elsevier B.V.

  • 出版日期2012-7