Computer Activities for Adult Students

No formal break until lunch at 12:30. Stretch or “exit” as needed.

http://www.chiresources.pbwiki.com

 

MORNING

A.    INTROS, INTERESTS AND GOALS SURVEY

B.    GO OVER AGENDA

C.    MS OFFICE APPLICATIONS

Assignment: As we cover concepts, think of what you want to create during the day. Later, work with a partner or team. Create one NEW activity using a MS Office application that you will go back and teach your students to use.

Consider that like most of us, our students long for community, thrive on honest appreciation, want space and time to explore their own skills, and learn by doing.

Consider also that we like to be able to see that we are learning. That’s what rubrics are for. Use rubrics for each assignment. http://rubistar.4teachers.org/index.php

MS OFFICE RESOURCES

http://www.microsoft.com/education/howto.mspx - Loads of tutorials on how to create activities using MS Office Applications.

http://www.educationworld.com/a_tech/archives/techtorials.shtml - Techtorials are quick, interactive, visual tutorials on technology. Check out the archives and titles on this long page.

 

PRE-GED CONTENT

http://netschool.edu/ILP/Menu/menu.asp - Independent Learning Project Units for Pre-GED students who wanted to get ready to study for the GED.

 

WORD 10:15 – 11:15

 

Review Word 2007 navigation and tools.

Create tables (quick tables), insert images from the Web, create shapes (prepositions, math), enter columns (news), print and modify screen images (teach), templates.

 

·        CLOZE

Select writing passages from a Web source. Paste into Word. Remove every 7^th word or words of your choice. Students study the passage and then complete the blanks.

 

Example: http://www.practicalmoneyskills.com/english/resources/tutor/terms.php

http://fog.ccsf.cc.ca.us/~lfried/stories/ihtm4mushrooms.html

http://www.soon.org.uk/page2.htm - Excellent source

http://members.EnchantedLearning.com/artists/projects.shtml/

http://members.EnchantedLearning.com/biomes/ ---

http://members.EnchantedLearning.com/biomes/label/desert/

http://web2.uvcs.uvic.ca/elc/studyzone/330/reading/index.htm - Nasreddin

http://web.archive.org/web/20040606113031/doug-j.org/lupita/Lu.htm - Lupita

 

·        CARTOON DIALOGS (MS and Google images or other clipart and Word Shapes)

 

·        TABLES– for historical information, surveys, pictures ID (http://content.techrepublic.com.com/2346-10878_11-262568-6.html - Presidential Images

 

·        PAMPHLETS, cards - create and adapt templates

 

·        Dictation with check (Create sound file.)

 

·        VENN DIAGRAMS (Insert-> Smart Art -> Select from Diagram Gallery

 

·        MINI BOOKS (http://grok.lsu.edu/Article.aspx?articleId=8141)

 

·        RUBRICS (From table)

 

ACTIVITY LINKS

1.       *http://teach.fcps.net/TALK/apps.asp?appsName=Microsoft%20Word - Click on different activities for MSOffice applications, many of which have handouts.

2.       http://www.homeandlearn.co.uk/mw/s5p8.html - Create a booklet - step by step.

3.       *http://members.EnchantedLearning.com/

      Username: fourcorners4498;  Password: banana68

o    Cloze

o    Music

4.       http://www.edzone.net/~mwestern/tutorials.html -Several great project ideas for students.

5.       http://www.ehow.com/how_2289541_make-easter-themed-minibook.html - Create a mini-book

6.       http://powayusd.sdcoe.k12.ca.us/teachers/kjain/intro%20to%20comp/Microsoft%20Word/Word%20projects.htm - Create a biographical report, a travel pamphlet, history of computers report, job application packet, MS Help Book,

7.       *http://www.janinelim.com/bc/2tues/word2.pdf - Compare two objects using Venn Diagrams; Create a database in Word

8.       *http://pages.sbcglobal.net/cdefreese/foldables/fractions.pdf - Fractions booklet printout

9.       http://www.brainstorminc.com/cbt/microsoft/help.php?file=word8 – Work with columns for a newsletter or report.

 

POWER POINT 11:15 – 12:00

 

Review PP 2007 navigation and tools.

Views

Templates

Animation

Shapes

Word Art

 

SENTENCE ORDER (has United States The elected president new a .)

 

LINKED MAP

 

SOUND CLIP

 

PP ACTIVITIES

 

***http://www.internet4classrooms.com/on-line_powerpoint.htm - Lots of good tutorials; keep scrolling down the page for game templates for free download (!).

http://www.esu5.org/techteacher/powerpoint.htm - Game template, samples, and more.

http://www.easternct.edu/depts/edu/powerpoint.html - Download free projects

http://www.awesomebackgrounds.com/powerpointtutorials.htm - Tutorials with different ideas.

 

EXCEL Noon – 12:30

 

Review Excel 2007 navigation and tools.

Formulas and Functions

 

ENTER TEXT AND MOVE CELLS

 

CHART DATA

 

CROSSWORD PUZZLE (Review -> comments)

 

***http://www.rapides.k12.la.us/region6tltc/Hot%20Lists/Using%20Excel%20for%20Classroom%20Activities.doc – All you need to create a project for your students!

http://spreadsheet123.com/excel_tut/Excel/ - Has some step-by-step projects along with tutorials on basic Excel usage.

http://www.teacherlink.org/content/math/interactive/interactiveexcel.html - Great interactive math projects. Get the instructions and download the projects to your own computer.

http://www.mrexcel.com/tip126.shtml - Download the projects after you learn how to use them. The interactive pie chart is great for teaching fractions.

http://collaboratory.nunet.net/hou/i_excel/interactive_excel.htm- Download these science and technology interactive projects.

*http://www.chiresources.pbwiki.com - Lots of downloads there.

http://www.tangischools.org/dept/tech/science/Above%20and%20Beyond/07activeexcel.pdf - PDF file with lost of ideas and resources.

http://spreadsheets.about.com/ - Long list of tutorials

 

Lesson Plans and Other Ideas for Technology Integration

 

*http://www.internet4classrooms.com/integ_tech_lessons.htm - Huge list of links for many categories.

 

LUNCH – 12:30 to 1

 

ASSIGNMENT

1PM – 2PM – Work with a partner or team. Create a student activity using a MS Office application.

AFTERNOON – WEB TOOLS 2 – 4 PM

BLOGS and YOUTUBE

Create a blog

 

GOOGLE MAPS: Summary Video with a list of other Map clips

 

http://www.youtube.com/watch?v=ADbeCHQLUpk&feature=PlayList&p=98DA918472BB3131&index=0

Create a route

Find another person’s home town and add it to My Maps

Tour Paris or another city

 

CARTOONING -

http://www.readwritethink.org/student_mat/student_material.asp?id=21 - The Comic Creator invites students to compose their own comic strips for a variety of contexts (prewriting, pre- and post-reading activities, response to literature, and so on). The organizers focus on the key elements of comic strips by allowing students to choose backgrounds, characters, and props, as well as to compose related dialogue (shown at left).

·  Retell a familiar story using the Comic Creator.

·  Illustrate newly-learned vocabulary words.

·  Recreate a favorite cartoon or graphic novel with the Comic Creator.

·  Create a comic strip with a partner: one person can illustrate the comic strip while another crafts the text to accompany the illustrations.

 

This site has links to lesson plans and student activities that adopt cartoon –making features.

 

·  http://www.toondoo.com/j_security_check  - Sign in (free) and get started. This site has many more options than the one above.

·  http://www.cartoonmagic.com/ - Create great flash cartoons starring your friends, your boss, your teachers, your favorite celebrities - absolutely anyone you choose!

 

OTHER SITES

·              *http://www.khake.com/page56.html - Huge, huge resource with links to hundreds of activities and resources

·              http://www.britishcouncil.org/kids-writing-storymaker.htm - Write your own story online.

·              http://www.readwritethink.org/materials/stapleless/ - Create your book online and print.

·              http://pages.sbcglobal.net/cdefreese/foldables/folding_the_fraction_mini_book.htm - Folding the Fraction mini-books (http://pages.sbcglobal.net/cdefreese/foldables/fractions.pdf )

·              http://powayusd.sdcoe.k12.ca.us/teachers/kjain/intro%20to%20comp/Microsoft%20Word/Word%20projects.htm - Word Projects

·              http://www.homeandlearn.co.uk/index.html - Free Computer Tutorials

·              http://techintegration.cciu.org/ - Lost of tutorials on different topics, including blogging, podcasting, and more.

·              http://maps.nationalgeographic.com/map-machine#s=r&c=43.749999999999986,%20-99.71000000000001&z=3 - Interactive National Geographic site filled with goodies.

·              http://school.discoveryeducation.com/curriculumcenter/ - Discovery Channel Curriculum Center

·              http://school.discoveryeducation.com/teachingtools/teachingtools.html - Some great teaching tools (puzzle, math squares, clipart and lots more)

·              *http://www.brainpop.com/free_movies/ - Great movies on many, many topics. Ignore the intros and think of the content. This page lists the free movies. A long additional list is also available with a subscription.

·              http://www.microsoft.com/education/lessonplans.mspx - MS lesson plans for everyone.

·              ***http://www.rapides.k12.la.us/region6tltc/Hot%20Lists/Using%20Excel%20for%20Classroom%20Activities.doc– All you need to create a project for your students!

 

ASSIGNMENT: Work with a partner or team. Create one NEW activity using a Web Tool that you will go back and teach your students to use.