This is an adaptation of Calling Bull's Case Study on how caffeine free is hot chocolate versus coffee in order to make it into a student project that uses R (though it could be easily adapted for Excel, and I encourage someone to do so!). This assumes that students have RStudio installed and know how to use it to perform arithmetic operations. It reviews making a script, saving scripts, and writing comments as professional practice outcomes. The Case Study itself gets us to think about assumptions, information at hand, units/stoichiometry, percents, and BS that is true, but meaningless marketing mumbo jumbo. In practice, I have them read the Case Study and the first couple of pages in advance of class and then students work in groups, and get "checked off" in class as complete during class or later in office hours or with a grader.
This activity is in R, but could easily be adapted to Excel/Google Spreadsheets and I encourage someone to fork/adapt and do it!
Cite this work
Researchers should cite this work as follows: