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 in the Department of Chemical Engineering at the University of Toledo. He earned a B.S. degree from the University of Illinois at Chicago and M.S. and Ph.D. degrees from the University of Illinois at Urbana-Champaign, all in chemical engineering. From 2005 to 2015, he served on the faculty at the Colorado School of Mines. In 2018, he served as an Erskine Fellow at the University of Canterbury in New Zealand. His research involves the rheology of complex fluids, especially traditional and renewable energy fluids and materials, polymers, and colloids. His educational interests include developing problems from YouTube videos, active learning, learning analytics, and interactive textbooks. His interactive textbooks for Material and Energy Balances, Spreadsheets, and Thermodynamics are available from zyBooks.com. His website is: https://www.utoledo.edu/engineering/chemical-engineering/liberatore/

  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

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