We have used the text Quantitative Chemical Analysis by Daniel C. Harris 1 for ten years, and we adopted the 4th edition in the Fall of 1995. This edition contains a major change in that it uses spreadsheets for student exercises within the chapters and in the problem sets. Using these spreadsheet exercises requires the development of some computer expertise in students who do not generally start the class with any computer experience. Also, the exercises often require significant time to complete, time that could be devoted to other types of study, problem-solving, or laboratory experiments. For these reasons, the efficacy of using spreadsheet exercises to help students better understand the course concepts needs to be evaluated. Here we present some preliminary results that indicate that the exercises are beneficial, the primary benefit being that they allow students to generate and manipulate graphs (pictures) of the relationships they encounter, which helps them achieve a better understanding of those concepts.
Bonicamp et al. (Sun,) studied this question.