MENU
  • ASEE Logo
  • Give
    Give
    ASEE Donations...
    Classified Volunteer
    Login
  • Join Login Volunteer Classified Give
    Give
    ASEE Donations...



About
  • Overview
    • Mission, Vision, Goals
    • Public Policy Statements
    • Constitution
    • Bylaws
    • Organizational Structure
    • Investment Policy
    • Financial Policy
  • Our History
  • Staff Contacts
  • Leadership
    • Board Of Directors
    • Academy Of Fellows
    • Past Board Members
    • Advisory Committees
    • Representatives to External Organizations
    • Executive Director's Message
    • Meeting Minutes
  • Volunteer
  • Careers at ASEE
  • Privacy Statement
I Am A...
  • Member
      Login Required
    • Your Member Page
    • Membership Directory
    • Financials
    • Volunteer for Task Force
      • COVID Recovery
      • Engineering Culture
    • No Login Required
    • Awards
    • Divisions, Fellows, and Campus Reps
    • Sections and Zones
    • Resources
  • Prospective Individual/Organizational Member
    • About ASEE
    • Individual Membership
    • Institutional Membership
    • Major Activities
  • Donor
  • Prospective Partner or Sponsor
  • Advertiser
  • Fellowship Seeker
    • About Fellowships
    • High School
    • Undergraduate
    • Graduate
    • Post-Doctoral
    • Other Programs
Events
  • Conferences and Meetings
    • 2022 Annual Conference & Exposition
    • 2021 Virtual Annual Conference & Exposition
    • 2020 Virtual Annual Conference & Exposition
    • Section & Zone Meetings
  • Council Events
    • Conference for Industry and
      Education Collaboration (CIEC)
    • CMC Workforce Summit
    • Engineering Deans Institute (EDI)
    • Research Leadership Institute (RLI) (Formerly ERC)
    • Engineering Technology Leaders Institute (ETLI)
    • EDC Public Policy Colloquium (PPC)
  • Featured Events
    • Frontiers in Education
    • NETI
    • CoNECD
    • First Year Engineering Experience
    • Workforce Summit
  • Future Conference Dates
Publications
  • News
    • Newsletters
    • eGFI
    • Division Publications
  • Journals and Conference Papers
    • Overview
    • Journal of Engineering Education
    • Advances in Engineering Education
    • Conference Proceedings
    • Section Proceedings
    • Zone Proceedings
    • PEER
    • Plagiarism
  • Monographs and Reports
  • Prism Magazine
  • Data
    • Profiles of E&ET Colleges
    • Case Study Series: Engineering-Enhanced Liberal Education
Impact
  • Public Policy Statements
  • Data Analysis
  • Annual Reports
  • Diversity
Education & Careers
  • Academic Job Opportunities
  • Course Catalog
  • Engineering Education Research and Innovation
    • Engineering Education Community Resource
  • PreK-12
    • eGFI Teachers
    • eGFI Students
  • Engineering Teacher PD Endorsement
Calendar
2020 Annual Conference
The ASEE 2020 Virtual Annual Conference content is available.
See More....
  • International Forum
    • Past Forums
  • 2020 Research Leadership Institute(RLI) (Formerly ERC)
    • Overview
    • Registration
    • Housing
    • Program Schedule
    • ERC Past Conferences
  • 2018 Engineering Technology Leaders Institute (ETLI)
    • Engineering Technology Leaders Institute (ETLI)
    • Registration
    • Housing
    • Program Schedule
    • ETLI Sponsorship Options
  • 2017 Global Colloquium
  • Pre K-12 Workshop
    • Call for Proposals
    • Registration
    • Housing
    • Sponsors
    • Program Schedule
    • Past Conferences
  • STEP Grantees Meeting
  • Annual Conference
    • Past Conferences
  • International Forum
    • Past Forums
  • 2020 Research Leadership Institute(RLI) (Formerly ERC)
    • Overview
    • Registration
    • Housing
    • Program Schedule
    • ERC Past Conferences
  • 2018 Engineering Technology Leaders Institute (ETLI)
    • Engineering Technology Leaders Institute (ETLI)
    • Registration
    • Housing
    • Program Schedule
    • ETLI Sponsorship Options
  • 2017 Global Colloquium
  • Pre K-12 Workshop
    • Call for Proposals
    • Registration
    • Housing
    • Sponsors
    • Program Schedule
    • Past Conferences
  • STEP Grantees Meeting
  • Annual Conference
    • Past Conferences

2019 ASEE Annual Conference & Exposition

Identifying Challenging Spreadsheet Skills Using Reading and Homework Analytics from an Interactive Textbook

Presented at Computer-Based Learning in Chemical Engineering Courses

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.

Authors
  1. Prof. Matthew W. Liberatore Orcid 16x16http://orcid.org/0000-0002-5495-7145 University of Toledo [biography]

    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

  2. Kayla Chapman
Download paper (595 KB)

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.

» Download paper

« View session


  • Follow Us
  • twitter
  • facebook
  • youtube
  • instagram
  • linkedin
  • 1818 N Street N.W. Suite 600, Washington DC 20036

  • Telephone: 202.331.3500 | Fax: 202.265.8504

  • © 2025 Copyright: ASEE.org All rights reserved. Privacy Policy.