The link below has several modules and courses aimed at teaching earth sciences at the university/college level. Topics range from climate change to mineral resources to natural hazards! I worked with a team to develop the "Map Your Hazards! – Assessing Hazards, Vulnerability and Risk" module. When we piloted the module in our courses (including courses at CWI), we found that the majority of students were both more excited and more engaged in the subject matter. Check it out!
http://serc.carleton.edu/integrate/teaching_materials/modules_courses.html