While I'm all for helping these students learn the more advanced functionality of word processors and spreadsheets, I don't think it's really enough for a course that counts as a science elective. That's why I redesigned the course last year to include some actual computer science. I also made a big effort to help the students see how computer science was relevant to their own interests. This year I'm continuing with that theme while trying to make the content all the more awesome using the great feedback I managed to get from last year's students in an anonymous and informal survey.
I was originally hoping that those who taught in the fall and winter terms would use at least some of my material. Unfortunately, both instructors continued to use the old stuff. I can't entirely blame them - it would take a fair amount of work to dissect my material and figure out a way to present it as their own. I also had a lot of activities better suited to my smaller classes than their 300+ student lectures (I know how I would adapt it, but it's much easier to do that when you came up with the material in the first place). All this to say that as I am hoping I can adjust things just enough that others will be willing to give it a try.
I kept my objectives the same as last year:
- Gain an appreciation of what computer science is and how it relates to the arts and social sciences.
- Practice computational thinking.
- Learn about the software and tools that will help you succeed in an undergraduate program.
- Introduction to computer science and computational thinking
- Introduction to Microsoft Word
- Basic programming with Scratch
- Binary numbers and data representation
- Introduction to Microsoft Excel
- Human-computer interaction
- Introduction to Microsoft PowerPoint
- Using the Internet effectively: useful software and tools
- Open source software
- Software tutorial in MS Word: choose software not presented in class that will be useful to them in the future and create a tutorial complete with screen shots, etc
- Programming in Scratch: set up a couple of specific exercises for them to complete that will teach them conditionals/loops/variables/broadcast; have them complete an interactive project of their choice
- Binary numbers, algorithms, and data representation: some conceptual questions followed by a couple of programming exercises in Scratch demonstrating the main concepts; some short Excel exercises
- HCI and Internet: Choose an area of interest (hobby, degree major, etc) and propose a new piece of technology that could improve activities within that area; use the HCI concepts to explain why the technology is designed well; write a Word document and create a compelling PowerPoint presentation; set up a web page to showcase this work (worth a bit more than the other assignments as it involves more work)