POGIL and quantitative literacy: Combining two learning initiatives

CHED 489

Cheryl Coolidge, ccoolidge@colby-sawyer.edu, Department of Natural Sciences, Colby-Sawyer College, 541 Main Street, New London, NH 03257
In addition to regular in-class use of paper POGIL activities, I have developed and piloted several guided inquiry activities that require students to build a spreadsheet and perform “what if” analyses by changing cell values. The computational power of a spreadsheet and ease of graph production enables students to perform more robust inquiry than can be accomplished using a calculator. Students are not given the formulas required to create the spreadsheet models; rather, they must develop the necessary quantitative literacy and computer skills to reproduce the model. As well as exploring content, students learn how to sort data, produce graphs, create trendlines, use the TREND function, use the LOG and LN functions, and develop other spreadsheet skills. Student response to and preliminary assessment of spreadsheet modules for equilibrium, kinetics, and gas laws will be discussed.