Strand I Assignment
Technology Outcomes and WINDOWS 98/2000/XP
Your assignment for Strand I is to complete the Windows tutorial and then perform the following tasks.

• In Notepad, with your first impressions of online learning.
  (i.e. describe what went well and what may not have gone well concerning your first experience with online learning.)
  Create a File Tutorial (Step-By-Step Tutorial)
  
• Save the file as Strand I Reflections on a floppy disk.
  Save File Tutorial (Step-by-step Tutorial)
• Create a folder on the same floppy disk and name it Strand I. 
  Create a Folder Tutorial (Step-by-step Tutorial)
• Move or Copy the file you created in Step 1 (Strand I Reflections) to the folder (Strand I) you created in Step 2. 
  Work with Files and Folders (Step-by-step Tutorial)
  Copy and Move Tutorial (Step-by-step Tutorial)
• Use the Find command, to find the file name Strand I Reflections on your floppy disk. 
  Find File Tutorial (Step-by-step Tutorial)
  
  Strand 1 Homework!
  Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand1TechEd1".
  
  Send the Notepad file, "Strand I Reflections.txt" as an attachment to the email message. 
  
  Top of Page

• In WORD, create a document that is useful to you in your position as an educator.  
  (This can be a letter, memo, newsletter, worksheet, etc.)
  Create Document Tutorial (Step-by-step Tutorial)
  
• Create a folder on the same floppy disk and name it Strand II. 
  Create a Folder Tutorial (Step-by-step Tutorial)
  Create a Folder Lesson (Just-In-Time Lesson)
• Save the file as Strand II Document 1 in the Strand II folder of the floppy disk.
  Save File Tutorial (Step-by-step Tutorial)
  Save File Lesson (Just-In-Time Lesson)
• Open the Strand II Document 1 file and Check Spelling. 
  Spell Check Tutorial (Step-by-step Tutorial)
  Spell Check Lesson (Just-In-Time Lesson)
• Replace a word in your document by selecting an alternate word using the Thesaurus tool. 
  Thesaurus Tutorial (Step-by-step Tutorial)
  Thesaurus Lesson (Just-In-Time Lesson)
• Include the following formatting features in your document.
  Change the font face, font size, and font color of text in your document. 
  Font Formatting Tutorial (Step-by-step Tutorial)
  Font Formatting Lesson 1 (Just-In-Time Lesson)
  Font Formatting Lesson 2 (Just-In-Time Lesson)
  Font Formatting Lesson 3 (Just-In-Time Lesson)
• Use a special symbol someplace in your document. 
  Insert Symbol Tutorial (Step-by-step Tutorial)
  Insert Symbol Lesson (Just-In-Time Lesson)
• Itemize some information in your document by formatting it as a numbered or bulleted list. 
  Bullets and Numbering Tutorial (Step-by-step Tutorial)
  Bullets and Numbering Lesson (Just-In-Time Lesson)
• Insert some Clipart in your document. 
  Insert Clipart Tutorial (Step-by-step Tutorial)
  Insert Clipart Lesson (Just-In-Time Lesson)
  
  Save your revised and formatted document as Strand II Document 2 in the Strand II folder of the floppy disk.
  
  Strand 2 Homework!
  Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand2TechEd1".  The body of the email message should include how the material covered in Strand 2 is useful to you.
  
  Send the WORD file, "Strand II document 2.doc" as an attachment to the email message. 
  
  Top of Page

• In Excel, create a worksheet according to the following specifications:
  Create Worksheet Tutorial (Step-by-step Tutorial)
• Include a title centered across columns (Merge and Center) that reads "Student Grades". 
  Formatting Tutorial (Step-by-step Tutorial)
• Include column headings: Name, Subject, Test 1, Test 2, Report, Grade
• Input several rows of data.  This data should be formatted in normal, black font. 
  Formatting Tutorial (Step-by-step Tutorial)
  Shading Lesson (Just-In-Time Lesson)
• In the "Grade" cell for the first student, include the formula or function to average the three scores.
  Formula / Function Tutorial (Step-by-step Tutorial)
  Formula / Function Lesson (Just-In-Time Lesson)
• Copy and Paste the correctly calculated formula or function to the "Grade" cell for the remain students.  Copy / Paste Tutorial (Step-by-step Tutorial)
• Form a new column named "Weighted Score". In the "Weighted Score" cells, input the formula to calculate the grade if each test is worth 30% of the total grade and the report is worth 40%.
• Below the row for the final student, input the function(s) necessary to calculate an average for each test and report. 
  Formula / Function Tutorial (Step-by-step Tutorial)
  Formula / Function Lesson (Just-In-Time Lesson)
  
  Create a folder on the same floppy disk and name it Strand III.
  
  Save the file as Strand III Worksheet 1 in the Strand III folder of the floppy disk.
  
  Strand 3 Homework!
  Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand3TechEd1".  The body of the email message should include how the material covered in Strand 3 is useful to you.
  
  Send the EXCEL file, "Strand III Worksheet 1.xls" as an attachment to the email message. 
  
  Top of Page

• Complete the Access95 or Access97 or Access 2000 tutorial (depending on which version you have) and then perform the following tasks.
• In Access, create a DATABASE according to the following specifications.
  Name your database StudentDB and save it on the floppy disk in a new folder named Strand IV. 
  Create Database Tutorial (Step-by-step Tutorial)
  Create Database Lesson (Just-In-Time Lesson)
• Create three TABLES as described below: 
  Create Table Tutorial (Step-by-step Tutorial)
  Create Table Lesson (Just-In-Time Lesson)
  1. Create a table named Students that consists of the following fields: Firstname, Lastname, Street, City, State, Zip, Schoolyear. 
  2. Create a table named Math Grades that consists of the following fields: Firstname, Lastname, Mathtest1, Mathtest2, Mathtest3, MathHomework.
  3. Create a table named Reading Grades that consists of the following fields: Firstname, Lastname, Readtest1, Readreport1, Readreport2, ReadHomework
• Create three FORMS (one for each table).  Name the forms Student Form, Math Form, and Reading Form, respectively.
  Create Form Lesson (Just-In-Time Lesson)
  Navigate Using Form Lesson (Just-In-Time Lesson)
• Enter sample data into the three tables you created earlier.
  Enter Data into Table Lesson (Just-In-Time Lesson)
  Enter Data into Form Lesson (Just-In-Time Lesson)
• Practice SORTING the data in your table.
  Simple Sort Lesson (Just-In-Time Lesson)
• Create three REPORTS (one for each table). 
  Create Report Lesson (Just-In-Time Lesson)
  • Name the reports Student Report, Math Report, and Reading Report, respectively. 
    (Select a different type of report for each table.) 
• Create a QUERY that links the Students table and the Math Grades table together.  The query should be named Math Student Query and should contain: Firstname, Lastname, Mathtest1, mathtest2, Mathtest3, Mathhomework. 
  Create Query Tutorial (Step-by-step Tutorial)
  
  
  Strand 4 Homework!
  Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand4TechEd1".  The body of the email message should include how the material covered in Strand 4 is useful to you.
  
  Send the Access file, "StudentDB.mdb" as an attachment to the email message.  This database file should include your forms, reports, and query.
  
  Top of Page

• Your assignment for Strand V is to complete the PowerPoint95 or PowerPoint97 or PowerPoint 2000 tutorial (depending on which version you have) and then perform the following tasks.
• In PowerPoint, create a presentation that is useful to you in your position as an educator. 
  Your presentation should include the following specifications.
  Create PowerPoint Presentation Tutorial (Step-by-step Tutorial)
  Create PowerPoint Presentation Lesson (Just-In-Time Lesson)
• Create slides as described below: 
  Create Presentation Tutorial (Step-by-step Tutorial)
  Create Presentation Lesson (Just-In-Time Lesson)
  1. Create a Title slide with the title of your presentation and a subheading.
  2. Create a Bullet slide listing several topics you wish to discuss during your presentation.
  3. Create a 2-Column slide
  4. Create a Table slide
• Check the Spelling in your presentation. 
  Check Spelling Tutorial (Step-by-step Tutorial)
• Alter the Font formatting on the slides you have created to make the text more visually appealing. 
  Change Font face, size, and colors. 
  Font Format Tutorial  (Step-by-step Tutorial)
• Insert Clipart on one or more of your slides. 
  Insert Clipart Tutorial (Step-by-step Tutorial)
• Change the background appearance of your slide(s). 
  Change Slide Appearance Tutorial (Step-by-step Tutorial)
  Create Presentation Lesson (Just-In-Time Lesson)
• Add Transitions and Animation Effects to some of your slides. 
  Transition and Animation Tutorial (Step-by-step Tutorial)
• Insert a sound into one of your slides. 
  Multimedia Effects Tutorial (Step-by-step Tutorial)
• Look at the different "VIEWS" of your PowerPoint Presentation.
  VIEW Presentation Lesson (Just-In-Time Lesson)
• Print slide handouts
  PRINT Presentation Lesson (Just-In-Time Lesson)
• Show your PowerPoint Presentation
  SHOW Presentation Lesson (Just-In-Time Lesson)
  
  This step may have been completed in a previous assignment.  Create a folder on the same floppy disk and name it Strand V.
  
  Save the file as Strand V PPT 1 in the Strand V folder of the floppy disk.
  
  Strand 5 Homework!
  Submit an email message to techtrain@techtrainteam.com.  The subject line of the message should be "Strand5TechEd1".  The body of the email message should include how the material covered in Strand 5 is useful to you.
  
  Send the PowerPoint file, "Strand V PPT 1.ppt" as an attachment to the email message. 
  
  Top of Page

• Your first assignment for Strand VI is to complete the Internet tutorial and then perform the following tasks:
  Internet Tutorial (Step-by-step Tutorial) .
  
  
• Assignment 1
  As you go through the tutorial, complete the following tasks. Because each organization can have a different system for accessing the Internet, you may need to contact your technology coordinator to determine what program(s) to use.
  • Email
    1. Send an email message to techtrain@techtrainteam.com. In the email, tell us your username, your domain name, and your reflections about online learning.  We will respond to your message.
       Send Email Tutorial (Step-by-step Tutorial)
    2. Reply to our response using the reply email function. 
       Reply Tutorial (Step-by-step Tutorial)
  • Lists and Newsgroups
    1. Subscribe to a list.
       A good source for lists is www.topica.com
       Subscribe / Unsubscribe Tutorial (Step-by-step Tutorial)
    2. After reading list messages for a few days, send us an email techtrain@techtrainteam.com) indicating the value of the list.
    3. If the list is not valuable, unsubscribe from the list. 
       Subscribe / Unsubscribe Tutorial (Step-by-step Tutorial)
    4. Read some Newsgroup messages. 
       Newsgroup Tutorial (Step-by-step Tutorial)
  • World Wide Web
    World Wide Web Tutorial (Step-by-step Tutorial)
    1. Determine the browser that you use, Internet Explorer or Netscape Navigator/Communicator. Also, determine the version number by looking in Help/About.
       Browser Tutorial (Step-by-step Tutorial)
    2. Using two or more search engines described in the tutorial, look up a topic of interest to you. 
       Search Engine Tutorial (Step-by-step Tutorial)
    3. Using some advanced search techniques, try the search again. Did the advanced techniques help narrow down the results? 
       Advanced Search Tutorial (Step-by-step Tutorial)
    4. After trying several searches, send an email to a colleague describing a site you have discovered that is valuable to you. Describe the search engine and advanced searching method used.
       Send a "computer copy" (carbon copy) of the message to us.  (techtrain@techtrainteam.com).

     

• Assignment 2
  Your second assignment for Strand VI is to complete the Web Page tutorial and then perform the following tasks:
  • Web Page Tutorial (Step-by-step Tutorial)
    • Build Your First Web Page. 
      Simple Web Page Tutorial (Step-by-step Tutorial)
    • Build Your Second Web Page. 
      Second Web Page Tutorial (Step-by-step Tutorial)
    • Link from One Page to Another. 
      Linking Tutorial (Step-by-step Tutorial)
    • 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)

Strand 6 Homework!
Submit the email messages described above to techtrain@techtrainteam.com.
When you have completed your Web Page assignment, submit an email message to techtrain@techtrainteam.com. The subject line of the message should be "Strand6TechEd1".  The body of the email message should include how the material covered in Strand 6 is useful to you.

Send, as attachments to your email message, your web page files (the ones with .htm or .html as the file extensions) and your graphic files (the ones with .gif or .jpg as the file extensions).

Top of Page

• Review some the resources in the Integration Using Educational Resources section.
  Integration Tutorial (Step-by-step Tutorial)
• 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 in their current issue. 

  (This is a great little FREE magazine.  If you don't already subscribe you should sign up for a free subscription.)

• Prepare a presentation to share with others. (You may select a project you created for this course.)
  The presentation may be a PowerPoint presentation, web pages you have developed, a WORD document you are proud of, a worksheet you have prepared, a database system, or another useful technology-related project.
• Save your project on a floppy disk, hard drive, or CD-ROM.
• Present your technology project to a group of colleagues.  In an email message to techtrain@techtrainteam.com, explain why your project is useful in education.  Describe the presentation setting, audience, etc. Describe the feedback you received from your audience.
  Send your project as an attachment.

  Strand 7 Homework!

• Present your technology project to a group of colleagues. 
• In an email message to techtrain@techtrainteam.com,
  • state your name and the name of your attachments.
  • Explain why your project is useful in education. 
    Describe the presentation setting, audience, etc.
    Describe the reaction and feedback you received from your presentation to colleagues or community members.
    Attach to the message the file(s) to be used in your project presentation
  • Describe and Discuss the article(s) you reviewed from T.H.E. Journal

Top of Page