Novice Productivity Tools Links


| Tutorials | Spreadsheets & Databases | Wordprocessing | Trouble Shooting | Ohio SchoolNet |

| Spreadsheets as a "Teacher's Tool" | Advanced & Practitioner Links for each of these topics |

These links have been selected to provide additional assistance to Ohio Teachers developing their Productivity Tools Skills as defined by the Ohio SchoolNet Teaching and Learning Matrices of Skills. We offer more links for this "Tool" model on our Teacher Practioner Page as well.

Oops!  You might have wanted our MultiMedia Tools help at MultiMedia Workshop or in the Practitioner Workshop.

  • Tutorials
    • Tutorial Search Engine
    OnlineResources & Tutorials
    Trumbull County Educational Service Center Resources, Tips & Tricks, & handouts
    Orange County Schools Self Help Tutorials (even Inspiration!)
    University of N.Dakota's long list of online tutorials!
    Dr. Kevin Maney of Miami University has provided some links to spreadsheet, database, and wordprocessing lessons using Apple's ClarisWorks & AppleWorks Software packages. (It's still here in 2002, I don't know how long this is going to stay published.  Dr. Maney left Miami U. in 2000.)

    Microsoft's Tutorials for the Classroom, for Microsoft Products.

    This Teacher Network provides an excellent series of Technology Tutorials
    Learning Space Online Teacher Network. All kinds of Software & Tutorial help!
    And even more from Southwestern Ohio Instructional Technology Association!
    The Instructional Technology Academy has some excellent links;  try the "Training Materials" option at the drop down menu here and further Staff Development links here,(offered by Independent School District 196 of Minnesota) and at Orange Schools, Ohio.
     
    MultiPurpose Tutorials
  • Free OnLine courses from FreeEdu.com.
  • ZiffDavis offers courses, your district might already have an account for teachers with their new venture.
  • Spreadsheet and Database Tools:  "Tutorials" or "Teacher Tool"
    • "Appication Tutorials"
    Orange County Schools Excel Basics
    Trumbull County Resource Center's, Training Resources/handouts, Spreadsheet & Database tutorials and lessons.
    Their "Training Resources/Handouts," have a variety from MS Office (Word processing, Spreadsheet, Database, etc) MS Works, PowerPoint,  through HyperStudio.
    MicroSoft offers support for their products;  while their pages change regularly this one on Excel was available 2/14/2001.
    The University of South Dakota Tutorial resources, and those for Excel
    Spreadsheet Lessons using Appleworks and ClarisWorks along with extra lessons.
    Tutorials for ClarisWorks Spreadsheets can still be implemented in Excel.
    Several lessons for AppleWorks or ClarisWorks which can be easily modified for Excel!
    Database lessons for ClarisWorks and MicroSoft Works
     
    "Teaching Tool"
    How about some lesson plans and ideas using Spreadsheets?
    Maybe they're not your particulary grade level, but with a little creativity these might be revised:
     
    Using Spreadsheets as a "teaching tool"
    Conduct a Virtual Field Trip integrating Internet, Spreadsheet, HyperMedia, and Wordprocessing use! 
    Dr. Bitner's Virtual Field Trip Links>>>>>
    Virtual Field Trip:
    Description of project/handout
    Virtual Field Trip:
    Student Examples
    Help students understand graphing,  from National Center for Educational Statistics
    Applied academics (Algebra and employement data)
    Gather world population data across the Internet and prepare data for analysis
    Vocabulary Enrichment, A Picnic
    Develop a CandyGraph, calculate Baseball data
    A Heat Tracking Activity, track weekly expenses, 
    An M & M Spreadsheet activity:  might require revision for appropriate intellectual level
    Baseball, nutrient counting, astronomy and more!
    A variety of other ideas at: '97, '98, '99
    Use any of the "Productivity Tools" to
    Integrate a Game Show into your Review>>
    Use Powerpoint to Create a Jeopardy-type- Review with this file
    What other game shows can you come up with?  Millionaire?  Survivor?  more?
     
    More Spreadsheet & Database lesson plan ideas from Brandon University, Canada
     
    How about some ideas for using Databases with students?
    Integrating a Database in your classroom. (a couple lessons described for Claris or Appleworks, but easily modified for Excel!  Redevelopment going on.) 
  • WordProcessing
    • Word Processing handouts and other resources through Trumbull County Resource Center.
    MicroSoft offers support for their products;  while their pages change regularly this one on Word was available 8/30/2002
  • Trouble Shooting Help:
    • Every file format type in the world from Ace Net.
    Steps to using a variety of technologies,  a digital camera, scanners, Quicktime VR, etc.
    (even Steps to use an Apple ColorOne Scanner.)
    Tucows!  They have it all!  And Olmsted Falls Tech Help has the rest!
    What is that "FileType?"
    California Technology Assistance Project
    Frequently Asked questions of Apple Support, N.Olmsted has found this site helpful!
    Networking Support Links on the ILT's "Teacher Practitioner" Page
    Macintosh Trouble Shooting Hints, A Mac source from LowEndMac.
    Apple Support, Apple mailing list registrations
    Macintosh-Windows integration site MacWindows.com
    PC Trouble Shooting Hints, Windows online sources, Troubleshooting & repair guide,
    and another hardware guide from EverythingComputers.com and their software guide.
    And, don't forget to search Microsoft's Web site, www.microsoft.com/support/
    A no-nonsense, fast search engine that tries to infer what you are asking it to find, www.infind.com
    Trouble Shooting both platforms or troubleshooting Novell.
    General Software Help and help from TuCows Winsock Software.
    Internet Browser updates, plug-ins:
    Microsoft Plug-ins, select Downloads from their menu selections. (This is an excellent source for Windows Media Player & Internet Explorer)
    and more plug-ins at the ILT's SAVVY Cyber Tool Box.
     
    Microsoft also provides tutorials, but keep in mind that they are constantly improving the site, so pages often change locations and appearances.  You might have to navigate through several pages to get to the proper tutorial.
    Interested in a MicroSoft PowerPoint, Word, or Excel introductory Tutorial?  Microsoft Windows "Tips & Tweaks", just for those seeking tutorial information on using The Windows Operating System.  Check out the ZiffDavis University Page.  Select their Course Catalog from the left side of the page.  Their introductory courses are provided free as a promotional opportunity.
  • SchoolNet links, course materials, etc.
    • Ohio SchoolNet Teaching and Learning Matrices of Skills
    Orange Schools SchoolNet links to the SchoolNet Skill Builder Cards!
    Dr. Maney's Course at Miami University, Kent State University's Novice & Practitioner courses .
    The ILT's SchoolNet Page
     
    Be sure to return, as we continue to update this page
    based upon input from our participants!
     
    | Return to the Institute's other Workshop Pages | Instiute Home Page |

     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     

    Mike Baker teacher/coordinator
    Geoff Andrews Director of Technology
    The Instruction, Learning & Technology Leadership Institute
    Polaris Career Center
    7285 Old Oak Blvd.
    Middleburg Hts. OH 44130
    (440) 891-7694
    FAX (440) 891-7723

    This page last revised 9/04/2002