I wish to file my Friday chemistry class under 'lessons that worked' . The lesson could apply to many areas. The general components of this style of lesson format were:
1) Take students to the computer lab to assess themselves by an online survey (a teenager's favorite subject "Who am I?") and then
2) Let them compile their result within the context of an entire group of people to see where they fit (make it socially relevant).
3) Use Xcel (introduce a marketable skill)
It was at the end of a chemistry unit on gases. We have been have been studying the ratio of atmospheric gases and how they interact with visible and infrared light (an excellent javascript simulation is at PhET Colorado). To connect this with climate change we went online in the computer lab and each student answered a bunch of questions about themselves, resulting in a household carbon footprint estimate and a personal carbon footprint estimate.
I don't know about them, but after seeing that our students' annual outputs are all individually well over a ton of carbon dioxide I went home that day and was extra diligent about turning off unused lights.
Then, this is the marketable skills part, they got their first ever lesson in putting formulas into Microsoft Xcel. Only two students out of 60 had ever used Xcel before (this is a tenth grade class). I had them share each other's results as a class, total everyones results from the first two columns together, convert the result from tons of CO2 to liters in a fourth column, sort it, use Series Fill to insert ranking numbers, and then sort it by alphabetical order on the student names.
To my surprise, they found the calculating abilities of Xcel very interesting. One student looked at the screen for a minute, realized the possibilities of a spreadsheet, and started yelling out That's hot! That's hot! That's so hot! Yo... I agree.
Recent Comments