• Go to the Michigan Department of Education Web site (www.michigan.gov/mde) and look at the following information.
  
  • Technology Outcomes
    Look at the technology outcomes desired for students in the grade level(s) you work with.
    
  • Michigan Curriculum Framework
    Look at the content standards for students in the grade levels and content areas you teach.
    
• Go to the following Web sites and look at the information available on each:
  
• Dialogue Web Project (www.dialogueweb.org)
• AccessMichigan (accessmichigan.lib.mi.us)
• Teacher's Network (www.teachers.net)
  

Homework!
Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand1TechEd2".

1. In the message, identify how each of the web resources introduced in this module can assist you in your educational activities. 
2. Also, Identify ways in which you can be assisted that are not currently a part of any of the projects named in this module. 

Top of Page

• Use this equipment and develop a portfolio of still pictures to be used throughout the course.
  
• From the internet, collect copyright-free graphics for use throughout the course.
  Get Help at:
  Download a Graphic (Just-In-Time Lesson)
  
• Search the internet for digital cameras, scanners, and graphics software to learn what types of devices are available.
  
• Visit the JASC site (www.jasc.com) and download Paint Shop Pro. 
  Evaluate this software for the thirty day trial period.
  
• Visit the QuickTime movie site on the internet (www.apple.com/quicktime) and
  download the QuickTime movie player..  (www.apple.com/quicktime/download/)
  Pay special attention to the section on QuickTimeVR (virtual reality)
  

Homework!
Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand2TechEd2".

1. In the message, state your name and the name of your attachments. 
2. Identify how each of the web resources introduced in this module can be useful to you in your educational activities. 
3. Describe what tools you used to create your graphic files (digital camera, scanner, Internet download)
4. Attach to the message:
   1. a scanned or digital camera picture
   2. a graphic downloaded from the Internet 

Top of Page

• Part I
  In WORD, create a mail merge document according to the following specifications.
  
  • Use the Mail Merge function of Word in combination with a simple Access database to create a form letter or mailing labels.
    Get Help at:
    Access Mailmerge Tutorial (Step-By-Step Tutorial)
  • Save your form letter or mailing labels as xyzStrand3Mailmerge.doc (where xyz are your initials) in the Strand III folder on your floppy disk.
    
  
  
• Part II
  In WORD, create a WORD document that involves publishing classroom or school activities in a newsletter format according to the following specifications.
  
• Use WORD to create a desktop publishing document that includes columns, graphics and pictures.
  Get Help at:
  WORD Column Tutorial (Step-By-Step Tutorial)
  WORD Clipart and WordArt Tutorial (Step-By-Step Tutorial)
  WORD Graphics Toolbar Lesson (Just-In-Time Lesson)
  WORD Graphics AutoShapes Lesson (Just-In-Time Lesson)
  WORD 3-D Graphics Lesson (Just-In-Time Lesson)
  WORD Graphics Shadow Effects Lesson (Just-In-Time Lesson)
  WORD Graphics Banner Lesson (Just-In-Time Lesson)
• Save your newsletter as xyzStrand3News.doc, (where xyz are your initials).
  

Homework!
Submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand3TechEd2".

1. In the message, state your name and the name of your attachments.
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message the two WORD files:
   
   1. xyzStrand3MailMerge.doc, (where xyz are your initials)
   2. xyzStrand3News.doc, (where xyz are your initials)

Top of Page

• Create a worksheet that contains data for a series of charts. 
  Some the data should represent data over time.  (For example, student grades in several assignments, student attendence averages for several weeks or months, air or water temperatures during different seasons, etc.)
  
• Use three or more functions of Excel in calculations within your worksheet.
  Get Help at:
  Excel Advanced Functions Lessons
  Average Function Lesson (Just-In-Time Lesson)
  IF Function Lesson (Just-In-Time Lesson)
  Maximum Function Lesson (Just-In-Time Lesson)
  Minimum Function Lesson (Just-In-Time Lesson)
  Standard Deviation Function Lesson (Just-In-Time Lesson)
  
• Format your worksheet similar to the worksheets depicted in the tutorial. 
  Use shading and borders to highlight your data.
  Get Help at:
  Excel Advanced Formatting Lessons
  Border Lesson (Just-In-Time Lesson)
  Shading Lesson (Just-In-Time Lesson)
  
• Create charts
  • Create a Column chart that depicts the data over time
    
  • Create a Line chart that depicts the data over time
    
  • Evaluate the data using a pie chart
    Get Help at:
    Excel Advanced Formatting Lessons
    Excel Chart Tutorial (Step-By-Step Tutorial)
• Alter the charts to:
  • change the colors of lines or bars or pie segments.
    
  • input different legends
    
  • input different titles
    Get Help at:
    Excel Advanced Chart Lessons
    Change Colors Lesson (Just-In-Time Lesson)
    Change Legend Lesson (Just-In-Time Lesson)
    Change Title Lesson (Just-In-Time Lesson)
• Save the File as Strand4Charts1.xls. 
  
• Open Microsoft WORD and create a memo describing the conclusions you would reach from reading one of your Excel charts. 
  
• Import the selected chart into the WORD document
  Get Help at:
  Import Chart Lesson
  Import a Chart from Excel to WORD Lesson (Just-In-Time Lesson)
• Save the WORD file as xyzStrand4Import.doc, (where xyz are your initials), in the Strand IV folder of the floppy disk.
  

Homework!
Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand4TechEd2".

1. In the message, state your name and the name of your attachments. 
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message the two files:
   
   1. xyzStrand4charts1.xls, (where xyz are your initials)
      
   2. xyzStrand4Import.doc, (where xyz are your initials)

Top of Page

• Develop tables
  Create Table Tutorial (Step-by-step Tutorial)
  Create Table Lesson (Just-In-Time Lesson)
  
• Develop queries
  Create Query Tutorial (Step-by-step Tutorial)
  
• Develop forms
  Create Form Lesson (Just-In-Time Lesson)
  
• Develop reports
  Create Report Lesson (Just-In-Time Lesson)
  
• Include OLE objects (Object Linking and Embedding) in your database (graphics, sounds, etc.)
  Get Help at:
  Include OLE Tutorial (Just-In-Time Lesson)
  
• Create a Menu-driven Application
  Get Help at:
  Create Menu-driven Application Tutorial
  (Complete the tutorials in the following order.)

1. Add Text to Menu Form (Just-In-Time Lesson)
2. Change Menu Form Background Color (Just-In-Time Lesson)
3. Add Buttons to Menu Form (Just-In-Time Lesson)
   

• Integrate Access with other applications by importing information from one of your Access tables or queries into Excel.
  Get Help at:
  Import/Export Database Tutorial
  Export Data from a Form (Just-In-Time Lesson)
  Export Data from a Query (Just-In-Time Lesson)
  Export Data from a Report (Just-In-Time Lesson)
  Export Data from a Table (Just-In-Time Lesson)
  
• Save the Excel file as Strand5Export.xls
  
  

Homework!
Submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand5TechEd2".

1. In the message, state your name and the name of your attachments.
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message the two files:
   
   1. xyzStrand5database.mdb, (where xyz are your initials)
      
   2. xyzStrand5Export.xls, (where xyz are your initials)

Top of Page

• Create a PowerPoint presentation for use in your classroom to present a topic to students, or in your school to present a school-related topic to educators or community members.
  
• Download FREE animations and effects for PowerPoint from Microsoft
  Get Help at:
  Download Clipart Tutorial (Just-In-Time Lesson)
  Download Template Tutorial (Just-In-Time Lesson)
  
• Use NEW animation effects
  Get Help at:
  Animation Effects Tutorial -
  • Spiral (Just-In-Time Lesson)
  • Stretch (Just-In-Time Lesson)
  • Swival (Just-In-Time Lesson)
  • Zoom (Just-In-Time Lesson)
    
• Include voice narration
  Get Help at:
  Voice Narration Tutorial (Just-In-Time Lesson)
  
• Create your OWN custom design template
  Get Help at:
  Design Template Tutorial (Just-In-Time Lesson)
  
• Use PowerPoint Show and Pack and Go
  Get Help at:
  Pack and Go Tutorial
  Save and Compress (Just-In-Time Lesson)
  Extract at Destination (Just-In-Time Lesson)
  
• Create Web Pages from your PowerPoint Slides
  Get Help at:
  Web Page Tutorial (Just-In-Time Lesson)
  

Homework!
Submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand6TechEd2".

1. In the message, state your name and the name of your attachments.
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message the two files:
   
   1. xyzStrand6PowerPoint.ppt, (where xyz are your initials)
   • Your PowerPoint presentation should include, as a minimum, the following:
     
     • A Custom Design Template
       
     • Sound Narration (if necessary equipment is available)
       
     • Files saved as HTML
   2. Series of web page files created from your PowerPoint slides. (One file for each Web page/slide)

Top of Page

• Develop a web site for your classroom or school that incorporates the following:
  Get Help at:
  
  • Web Page Tutorial (Step-by-step Tutorial)
    1. Build Your First Web Page. 
       Simple Web Page Tutorial (Step-by-step Tutorial)
    2. Build Your Second Web Page. 
       Second Web Page Tutorial (Step-by-step Tutorial)
    3. Link from One Page to Another. 
       Linking Tutorial (Step-by-step Tutorial)
    4. Include Graphics on Your Web Pages. 
       Graphics Tutorial (Step-by-step Tutorial)

    We believe educators should have a basic understanding of HTML (the language of the World Wide Web), so please complete the HTML tutorials.
    However, if you prefer to use a different application to help you create your Web pages for Assignment, you may do so.
    Create Web Pages Using WORD Lesson (Just-In-Time Lesson)
    Create Web Pages Using PowerPoint Lesson (Just-In-Time Lesson)
    Publisher Web Site Tutorial (Step-By-Step Tutorial)

• Graphics
  Get Help at:
  Web Graphics Tutorial (Just-In-Time Lesson)
• Tables (to position objects on the screen)
  Get Help at:
  Web Table Tutorial
  Create a Table in WORD (Just-In-Time Lesson)
  Save Table as HTML (Just-In-Time Lesson)
• Frames
  Get Help at:
  Web Frames Tutorial
  (Complete the tutorials in the following order.)

1. Create a 2-Column Frameset (Just-In-Time Lesson)
2. Create a Menu(Just-In-Time Lesson)
3. Create Main Page (Just-In-Time Lesson)
4. Create 2-Column Frameset Date Definition (Just-In-Time Lesson)

• Links to educational resources
  

Homework!
Submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand7TechEd2".

• Create a Web site that includes, as a minimum, the following:
  • Graphics
  • Text
  • Links to valuable educational resources

1. In the message, state your name and the name of your attachments. (Include your initials in your filenames. For example, xyzPage1.html, where xyz are your initials)
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message all the files you need for your web site. 
   These include
   1. graphics files (.gif) ,
   2. web page files (.html), and
   3. frame data definition files (frames are optional)

IMPORTANT:  Include all your web page (.html) files and your graphics (.gif or .jpg) files in the same Strand VII folder.

Top of Page

• Develop a Business Card using Publisher
  Publisher Business Card Tutorial
• Develop an Announcement using Publisher
  Publisher Invitation Tutorial
  
• Develop a web site using Publisher
  Publisher Web Site Tutorial
  
• Develop a classroom or school newsletter
  Publisher Newsletter Option
  
• Save the files you create using Publisher in a folder named Strand VIII on the hard drive of your computer.  They will probably be too large to fit on a floppy disk.
  

Homework!

1. In the message, state your name and the name of your attachments. (Include your initials in your filenames. For example, xyzStrand8BusinessCard.pub, where xyz are your initials)
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Attach to the message the following files:
   
   1. xyzStrand8BusinessCard.pub (where xyz are your initials)
   2. xyzStrand8Announcement, (where xyz are your initials)
   3. xyzStrand8Newsletter, (where xyz are your initials)
   4. series of web pages and graphic files (One file for each Web page and graphic)

• Your Publisher assignments should, as a minimum, include the following:
  • Graphics
  • Fonts
  • Colors

Top of Page

• Listen to Audio and watch Video via the Internet using RealPlayer
  
  Download RealPlayer from the RealPlayer web site
  Make sure you select the FREE download of the Player (other options are not free)
  

• Interactive Television (ITV) - Read the material related to interactive television use by educators.
  The online articles are:
  1.  Teaching via ITV: Taking Instructional Design to the Next Level
  2.  Go to the site http://www.thejournal.com/ and select any article of interest to you intheir current issue.  (This is a great little FREE magazine.  If you don't already subscribe you should sign up for a free subscription.)
  

• Project Presentation - Prepare a presentation of one of your technology projects (one you have already completed, not a new one) to present to a group of your colleagues or community members either in person or via the Internet
  
  

Homework!
Submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand9TechEd2".

1. In the message, state your name and the name of your attachments.
2. Identify how each topic introduced in this module can be useful to you in your educational activities. 
3. Describe your experiences downloading and using RealPlayer
4. Describe and Discuss the article(s) you reviewed from T.H.E. Journal
5. Describe the reaction and feedback you received from your presentation to colleagues or community members.
6. Attach to the message the file(s) to be used in your project presentation

Top of Page