I learned of this website after attending the Computational Chemistry for Chemistry Educators (CCCE) workshop last summer '11. In this webpage you will find all the workshop lectures intended for audiences who do not have a computational expertise. You will also find lab exercises already written.
The learning goals here will depend on the lecture and lab from the webpage.
I have not used the lectures or the labs in this website in my classes because they are predominantly geared towards general, organic and physical chemistry. But, I still think this is a good resource for people who are interested in incorporating computational work in their classes.