Computers as a Teacher's Aid Project Requirements
 
Return to EdFolio site
  The review below is designed to help you determine the minimum requirements necessary for completion of the project assignments in professor Debren's "Computers as a Teacher's Aid" class. Remember that in addition to the requirements discussed below -- you must complete all homework assignments (as described in the Course Outline), including the class journal (or log)... and have a good attendance record in order to obtain a high grade for the course.  
 


  1. Classroom Newsletter: Please see the rubric handed out in class for details on the requirements for this project. In addition, make sure you have turned off Word's spelling and grammar checkers before uploading, and embedded the font with the file if you have used any unusual font styles in your newsletter.  
     
 

2. Classroom Gradebook: The rubric provided and description in the Course Outline adequately detail the requirements of this project. Note that the last 3 criteria of the rubric (student project evaluation) was not required in this class... however, you should understand this application of Excel as was described in class. Of particular importance, make sure you have included the criteria below in your Gradebook:

  
 
Include a title page as the first page of your workbook.
  
 
Make sure that you have used Excel to do all your math calculations as required.
  
 
Include both a Gradebook and student class attendance page.
  
 
Include a graph to present at least one evaluative criteria of your class.
  
 
Use conditional formatting to have Excel highlight important student statistics.
  
 
Have Excel convert point grades to letter grades using either "nested if" functions or a Lookup table. If using a Lookup table, remember to have Excel round your grade calculations to prevent letter grade errors.
  
 
Hide the row and column headers and grid lines, then use cell borders and background colors for a clean look.
  
 
Rename the tabs at the bottom of each page of the workbook.
  
 
Unlock the cells where you will enter data, then protect each worksheet. (This will prevent users - including yourself - from accidentally overwriting formulas during use.)
  
 
Before uploading your Excel workbook, make sure each page is at the top, left corner... then go to your title page and save the workbook at this page prior to uploading.
  
 
 
 
3. Website Directory (Directory of Resources): Refer to Course Outline -- Be certain that you have included all fields as described in the outline. If your directory is to be printed, make sure the site URL appears as a field.
  
     
 
4. Review of Two Educational Journal Articles: Please see item 7 below
  
 
 
 

5. PowerPoint Presentation: Refer to Course Outline -- Remember to set any pauses you may require for your in-class presentation on the final day of class.

  
     
 
6. EdFolio Site/Electronic Professional Portfolio: In developing your EdFolio site, only the title page and Class Assignment pages are required... however, look at the sites referenced on the "Reminders" page to see how you can continue work on your site following this class to develop a professional portfolio presentation. Key criteria required for the EdFolio site include:
  
  Remove the introductory "instructions" text and create a clean home page.  
  Make sure your name appears as Last Name, First Name in the top right corner.  
  Make sure your photo and email address appear on your EdFolio site.  
  Check to make sure that your link back to the Class WebRing is working.  
  Finally, test your site to be sure all assignments download & display properly.  
     
 
7. Digital Portfolio of Assignments with Class Log: Review the assignment descriptions on the Course Outline, then feel free to look at student's work from previous classes on the EdFolio and EdWeb class WebRings. Key criteria required for the class assignments include:
  
  The links to your assignments should be numbered as shown in the Course Outline (and shown on this page).  
  Include brief descriptions with your links... especially with the journal articles.  
  Your journal articles must cite the article source and author, and include a link to the source article. Be sure to include a summary of the article, and if you are certain you are not violating any copyright or usage policies, it is recommended that you include the source article on your site. (See details of how to do this on my EdWeb site -- Posting Assignments to Your Website.)  
  Include a link to your class journal (class log) on your assignments page. The log is described in the Course Outline, and should include your comments on the videotape viewed during the second class session. Your log should also include feedback on all class work and projects, and some details on relevant Listservs and/or Newsgroups you have either joined or have researched.  
 
 
 
IMPORTANT: Be sure to review the suggestions that can be found on the "Computers as a Teacher's Aid" Reminders page. Here you'll find many valuable tips that will help to insure your success in this class.
 
  Remember to backup your work: It's a good idea to save your work regularly in case of an application or network failure while working on your site. It's also highly recommended that you keep an up-to-date backup copy of all of your work off of the FDU system to recover from an unlikely (but possible) catastrophic failure and subsequent loss of all of your files. Copy your files to a hard-drive at home, a CD-ROM, or USB storage device. Note that a floppy disk is not recommended as an adequate backup device.  
  Finally: Don't forget the importance of a good attendance record, as FDU's attendance policy will be strictly enforced. Poor attendance will adversely effect your final grade.  
 
This page was last updated 11/23/2004
top
 
 Professor Allen Debren - School of Education - Fairleigh Dickinson University