Spreadsheets provide a user-friendly environment to complete many calculations for engineering students as well as practicing engineers. Spreadsheet programs have been available for decades, including Microsoft Excel, Google Sheets, and many others; numerous formulas, functions, and other tasks are common across versions and platforms (e.g., Windows, Mac, iOS, Android). An interactive textbook from zyBooks titled Spreadsheets Essentials provides students opportunities to step through animations, complete question sets, and perform spreadsheet functions on auto-graded, randomized problems. Advanced topics include solver, error, statistics, interpolation, numerical integration, matrix operations, and more. The interactive format creates ‘big data’ on student behaviors, such as reading completion, auto-graded problem success, and auto-graded problem attempts. Providing nominal course credit led to very high reading rates in 2018. Specifically, at least 75% of students (n=98) completed 100% of the reading participation encompassing over 250 clicks across 12 sections. In addition, animation view rates quantified repetition with rates as high as 118%. Finally, success on over 100 auto-graded questions was higher for basic skills and formulas than more advanced topics, such as integration and interpolation.
Matthew W. Liberatore is a Professor and Department Chair in the McKetta Department of Chemical and Bioprocess Engineering at Trine University in Angola, Indiana. He previously served on the faculty at the University of Toledo and at the Colorado School of Mines. Professor Liberatore earned his B.S. degree from the University of Illinois Chicago (UIC) and his M.S. and Ph.D. degrees from the University of Illinois Urbana-Champaign, all in chemical engineering. His expertise lies in the unique rheology measurements of complex fluids as well as engineering education research related to novel uses of technology and big data. He has authored several interactive textbooks with zyBooks and has published over 100 peer-reviewed articles.
https://www.trine.edu/academics/colleges-schools/faculty/engineering/liberatore-matthew.aspx
Are you a researcher? Would you like to cite this paper? Visit the ASEE document repository at peer.asee.org for more tools and easy citations.