Friday, April 24, 2009

Excel and pH

The 6th grade Science students created a lookup table in Excel that showed the pH values and other characteristics of a dozen different everyday substances. The students learned how to hide columns and how to use the VLOOKUP function. They also used conditional formatting to simulate a pH paper test.