June 22, 2003
June 22, 2003
June 25, 2003
8.1026.1 - 8.1026.11
Spreadsheet Applications for Materials Science
Michael L. Meier
Department of Chemical Engineering and Materials Science University of California, Davis
Abstract Spreadsheets have the potential to improve the teaching of the use of computers in solving engineering problems. Ideally, they would be integrated into existing courses, rather than teaching separate courses on spreadsheets. If this is done then homework assignments could be made much richer and their use in the laboratory courses would be invaluable. The author is developing a series of tutorials that address a wide range of materials science topics. The spreadsheet exercises in each tutorial start with simple calculations and progress to project-level calculations such as modeling ionic bonding or processing data from experiments. Spreadsheet skills developed include performing simple and complex calculations, importing and exporting data, graphing data, using the numerical tools, and producing attractive, presentable and reusable spreadsheet applications. With spreadsheets already on practically every home and school personal computer implementation of these tutorials can be done at little or no cost, a definite plus for smaller schools, and they will even allow the student to complete these assignments at home, reducing the need for schools to set up computer laboratories, a plus for high-enrollment courses.
Introduction When the pocket calculator first appeared in the classroom no one talked about technology in the classroom. In many cases it was reluctantly allowed in and eventually, after it seemed that nearly everyone had one, exams, homework and other assignment changed to accommodate and even take advantage of this new, personal, high technology device. Computers are similar in many respects. They have been on our desktops for over 20 years are have only recently began to become an integral part of our curricula. While many of the recent high-profile implementations center around the Internet, multimedia and other interactive software, spreadsheets, which have been on our desktop computers since the beginning, offer a low cost avenue for developing richer and more engaging assignments, much like the pocket calculator did. Like pocket calculators, they can take the tedium out of the number crunching, allowing the student to concentrate on the problem at hand. The spreadsheet’s easy learning curve, versatility and ubiquitousness, make them ideal for introducing the students to the use of computers to solving engineering problems.
“Proceedings of the 2003 American Society for Engineering Education Annual Conference and Exposition 2003, American Society for Engineering Education”
Meier, M. (2003, June), Spreadsheet Applications For Materials Science Paper presented at 2003 Annual Conference, Nashville, Tennessee. https://peer.asee.org/11930
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2003 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015