Lesson Plans/Activities

Office Integration

Dance Party Project

Word Processing

FGCU Word 2007 Tutorial
http://www.fgcu.edu/support/office2007/Word/index.asp

Microsoft Word XP/2003 Tutorial
http://www.baycongroup.com/wlesson0.htm

Using Word Drawing Tools: 2 Activities
worddrawact.doc

Using Word Drawing Tools: Test
worddrawtest.doc

Using Word Drawing Tools to Create a Comic Strip: Interdisciplinary Activity for Social Studies
Download Word Format

Bulleted List Activity: RSI
wprsilist.html

FBLA Flyer Activity 1
fblaflyer1.html

Corel WP8: Creating Name Badges
namebadge.html

Animals from Around the World Copy/Paste activity
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/Animals_World.htm

Spreadsheets

FGCU Word 2007 Tutorial (w/links to Word, PPT, and Access)
http://www.fgcu.edu/support/office2007/Excel/index.asp

Spreadsheet Lesson Plans
http://www.manassas.k12.va.us/round/classweb/volz/excelweb/sslplan.htm

Datapig Excel Tutorials
http://www.datapigtechnologies.com/ExcelMain.htm

Lesson Plan: Let's Go Shopping
excelrecp.html

Santa's Elf Spreadsheet Lesson
http://www.ceap.wcu.edu/coulter/portfolio/subject_specific/spreadsheet/ss1.htm

Making a Mess O'Mousse Lesson
http://www.sfusd.edu/schwww/sch634/Webpages/7thgr/mousse.html

Fast Food Fun with Spreadsheets Lesson
http://www.wmburgweb.com/Resources/Lesson/index.htm

Lesson Activity: Class Party Spreadsheet
http://www.angelfire.com/ks/tonyaskinner/ssgrocer.html

Lesson Plan: Comparing Prices of Dream Cars (Excel Spreadsheet Project)
http://www.microsoft.com/education/dreamcar.mspx

Lemonade Stand Business--Spreadsheet, Internet, and Powerpoint Project
http://www.teachers.net/lessons/posts/1542.html

Lesson Plan: Table it or Spread it? (Word/Excel)
 

Databases

Access 2007 Tutorial--Basic

Yevol Access 2007 Tutorial--Advanced Concepts
http://www.yevol.com/en/access2007/index.htm

Function X Access 2007 Tutorial--Very Thorough
http://www.functionx.com/access/

Datapig Access Tutorials
http://www.datapigtechnologies.com/AccessMain.htm

Video Database Project Internet Required to complete

25 Most Wanted Music CD Project (by Martha Cubbage)

PowerPoint

(also see Multimedia webpage)

Using Action Buttons in Powerpoint
http://www.kenton.k12.ky.us/max/actionbuttons.pdf

Creating an Animated Sea Aquarium
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/underthesea.htm

Publisher

You're a Poet and Didn't Know It (DTP)
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/formattingtext.htm

Destination USA: Creating a Travel Brochure
http://neighbor.firn.edu/class/palm_beach/pahokee_ms/patricia_janann_nicholson/destinationusa/destinationusa.htm

 

Unclassified

Corel Presentations Assignment
corelpre1.html

Holiday Webpage Internet Project
holwp.html

Holiday Newsletter Project
holnews.html

Business Simulation Project
http://www.geocities.com/CollegePark/Quad/5687/cbp.html

Brochure Project
http://www.geocities.com/CollegePark/Quad/5687/brochure.html

Class Webpage Internet Project
http://www.geocities.com/CollegePark/Quad/5687/webassn.html

Newsletter Project
http://www.geocities.com/CollegePark/Quad/5687/nlr.html

Computer Collage Project
http://www.geocities.com/CollegePark/Quad/5687/compcoll.html

Jeopardy Review--Input, Output, and Basic Computer Info
http://www.geocities.com/CollegePark/Quad/5687/jeo1.html

Jeopardy Review--Computer Storage Devices
http://www.geocities.com/CollegePark/Quad/5687/jeo-stor.html

Certification (Online Skills Testing)

Expert Rating: Free online computer skills testing (look for free ones; can actually order a certificate for a fee if you pass)
http://expertrating.com/examlist.asp

NCS Academy: Free online computer skills testing (free to take; can pay if you want to be certified--areas include MS Office XP, individual areas of Office XP, Windows, HTML, and more!)
http://www.ncsacademy.com/freetest.cfm

Other Computer Links

Computer Lesson Plans/Class Outlines (Junior High by Rod Hames)
http://www.crews.org/media_tech/compsci/

Computer Mysteries Lesson Plan
http://youth.net/cec/ceclang/ceclang.90.txt

Spreadsheet Lessons (ideally for ClarisWorks, but adaptable)
http://mathforum.org/alejandre/spreadsheet.html

Computer Lesson Plans (from a Computer Club; lessons on spreadsheets, windows, and more)
http://web.ai/club/lessons.html

Computer Lessons for Kids and Small Adults
HTTP://www2.magmacom.com/~dsleeth/kids/lessons/starter.htm

Spreadsheet Basics
http://marthforum.org/sum95/math_and/spreadsheets/basics.html

Microsoft Excel Spreadsheet Lessons (lecture notes, but good reference)
http://www.uchaswv.edu/courses/cis101-02/ss1.html

Spreadsheet Lesson Plan for Works (student company)
http://cecasun.utc.edu/~tpa/mcallister/lesson/su95499_works_eliby.html

Microsoft Excel Lessons
http://www.microsoft.com/macoffice/work_xl_fs.htm

Lesson Plan: Investments and Future Value (spreadsheet)
http://fcit.coedu.usf.edu/scripts/fcit/tnt/lp.idc?lesson_id=lp181

Lesson Plan: Amortization of a Loan (spreadsheet)
http://fcit.coedu.usf.edu/scripts/fcit/tnt/lp.idc?lesson_id=lp178

Classroom Projects for Multimedia
http://www.sv400.k12.ks.us/tips/projects.html

Using a Computer to Draw Pictures
http://www.sillybilly.com/draw96.html

An Alien Database Activity
http://www.bushnet.qld.edu.au/~sarah/primary_computer/adb.html

Planet Database Activity
http://www.bushnet.qld.edu.au/~sarah/primary_computer/pdb.html

Using Spreadsheets in Math (ideas for activities)
http://www.math.byu.edu/~lfrancis/readings302/Spreadsheets.html

Introduction to Spreadsheets (good for understanding what they are and why they are used)
http://www.cs.indiana.edu/classes/a106-fulc/spreadsheet.intro.html

Free Excel file downloads (calendars, schedulers, etc.)
http://www.j-walk.com/ss/excel/files/index.htm

A Brief History of Spreadsheets
http://dss.cba.uni.edu/dss/sshistory.html

Spreadsheets and Graphs Lesson Plan (Clarisworks, but adaptable)
http://nisus.sfusd.k12.ca.us/americorps/Spreadsheets.html

Word Processing Using Microsoft Works
http://nisus.sfusd.k12.ca.us/americorps/Mworks.html

Computer Database Lesson Plan
http://nisus.sfusd.k12.ca.us/americorps/Databases.html

Excel 97 Lessons
http://www.microsoft.com/education/curric/excel97/explore.htm

Word 97 Lessons
http://www.microsoft.com/education/curric/word97/explore.htm

MS Works 4.0 Lessons
http://www.microsoft.com/Education/Curric/Works_I&O/Works95/

MS Publisher 98 Lessons
http://www.microsoft.com/education/curric/pub98/explore.htm

MS Office 97 Hands-on Exercises
http://www.microsoft.com/education/curric/office97/glance.htm

Lesson Plan: Use of the Computer as a Productivity Tool in the Business Environment
http://www.crpc.rice.edu/CRPC/GT/jbueno/Lessons/freedom2.html

OTAN Lesson Plans--Vocational Business, Computers, English, Office
http://www.otan.dni.us/cgi-bin/webdir.pl?dir=%2FLesson%20Plans%2FVocational

Computer Skills Lesson Plans--North Carolina Dept of Public Instruction
http://www.dpi.state.nc.us/Curriculum/Computer.skills/lssnplns/CompCurr.LP.html

Lesson Plan: Letters from Santa (word processing/telecommunications activity)
http://fcit.coedu.usf.edu/scripts/fcit/tnt/lp.idc?lesson_id=lp210

Ainsworth Computer Seminar
http://www.qwerty.com/startacs.htm

How Microprocessors Work--Classroom Activites by Intel
http://www.intel.com/intel/educate/mpuworks/teacher/index.htm

Interact with History
Journey back through time and help make the
decisions that led to the invention of the 4004.
http://www.intel.com/intel/museum/25anniv/index.htm

Lesson Plans for Technology--by Florida Center for Instructional Technology
(subject search for business or computing lesson plans)
http://stormy.coedu.usf.edu/tnt/subject_search.html

Collaborative Computer Lesson Plans
http://www.ariz.com/squawpeak/plans.html