Computer *Fun*damentals: New lessons in Word & Excel (...and the Internet, too)

1. Computer *Fun*damentals: New lessons in Word & Excel (...and the Internet, too) Ramona R. Santa Maria, Ph.D. Department of Computer Information Systems SUNY Buffalo State santamrr@buffalostate.edu

2. Shameless promotion • Early summer PD workshop • http://www.buffalostate.edu/cs4hs T4 2013

3. Objective: • Give teachers tools to “perk up” the way they integrate basic computer skills into lessons. • Refresh teachers toolbox, how to: • Integrate internet skills and foster reflective searches, • Use MS Word to become a collaborative (and funny) tool, • Model teaching Excel with ease. T4 2013

4. Materials • What you'll need: • Engaged students: • Who can use their imagination • Who are ready to have fun • Internet connection • MS office • M&M's and Dixie cups T4 2013

5. My normal order My training Computer support plan Internet skills Word Excel Today’s T4 order Word Excel My training Computer support plan Internet skills Traditional teaching structure T4 2013

6. Word (1) • Teaches basic skills • Movement is key • Movement creates collaboration • Collaboration fosters creativity • Creativity drives the lesson. T4 2013

7. Word (2) • Review result, analyze content, change plot • Create a carton • http://pbskids.org/go/studio/ • Http://www.toondoo.com/ T4 2013

8. Excel • Teaches basic skills • Removes math anxiety • Make graphing fun • Reflective: • Why would I want to analyze how many people have red M&M’s? • Why might student X have more M&M’s in their cup than student Y? T4 2013

9. Basic skills (1) • Computer support plan: • As students to be reflective and accountable. • What happens if your computer doesn't work? • How will you complete your assignments? _________ • When online what do I do if… • I encounter a questionable website? • I don’t feel safe online? • I’m being teased and pick on? T4 2013

10. Basic skills (2) • Get trained, educate others, understand internet safety • iSafe trainer • http://isafe.org/wp/ T4 2013

11. Internet skills (1) • Barebones • http://www.sc.edu/beaufort/library/pages/bones/bones.shtml • Choose your assignments • Ask for reflection T4 2013

12. Internet skills (2) • Barebones • http://www.sc.edu/beaufort/library/pages/bones/bones.shtml • Choose your assignments • Ask for reflection • Ideas: • List the specific skill(s) you've reviewed in the lesson. • Summarize what you have leaned In your • What did you learn about the Internet searching in this way? • Give evidence to support how the new way learned to search is different the way you’ve searched before. • Where were your searching speedbumps before this assignment? T4 2013

13. Internet skills (3) • Students create scavenger hunt questions • Display answers in a “timeline”http://www.dipity.com/ • Ideas: http://www.surfnetkids.com/online_scavenger_hunts.htm T4 2013

14. Now what? • What have you learned? • What can you use in your classroom next week? T4 2013