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

详细信息	查看全文 | 推荐本文 |

• 作者：Kurt D. Thelen^a ; ^{thelenk3@msu.edu} ; Juan Gao^a ; John Hoben^a ; Leilei Qian^a ; Christopher Saffron^b ; Katherine Withers^a
• 关键词：Bioenergy ; Teaching model ; Biofuel crop
• 刊名：Computers and Electronics in Agriculture
• 出版年：2012
• 期刊代码：27_01681699
• 类别：abs
• 出版时间：July, 2012
• 卷：85
• 期：Complete
• 页码：157-163
• 文件大小：959 K

摘要

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 鈥渧irtual farm鈥?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鈥檚 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 鈥渟uperior鈥?or 鈥渁bove average鈥?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.