techteam7-1

 

FrontPage

Page history last edited by Harold Olejarz 3 mos ago

Eisenhower Middle School

Wyckoff, New Jersey

 

 

Mr. Bonavitacola Mr. DeBlock
 Mr. Olejarz

 

 

Computer Technology 7-1

 

Click Here To Login To Eisenhower Google Apps

 

Click here to learn more about Google Apps

 

 

 

Collecting Data and Using it in a Spreadsheet

 

1. Olympic Data Project

 

Use the links below to create a spreadsheet based on Olympic statistics.

 

Use this link

http://www.olympic.org/uk/games/index_uk.asp

 

Back-up Link

http://www.databaseolympics.com/

 

Olympic Data Checklist

 

Formulas and Formatting (5 points each = total 50 points)

  1. Header is filled in (Title and Name)
  2. Bold Column/Row headings
  3. Column Widths adjusted or Text Wrapped
  4. Total Medals calculated
  5. Average medals calculated
  6. Maximum medals calculated
  7. Minimum medals Calculated
  8. Decimals adjusted to whole numbers
  9. A grid is applied to the entire table
  10.  The text is centered in all of the cells

 

Sorting  (10 points each = Total 30 points)

  1. Sort alphabetically by country name
  2. Sort by year with the most gold medals (high to low)
  3. Sort by year with the highest total medals (high to low)

 

Graph (5 points each = 20 Points)

  1. Title
  2. X axis Labeled
  3. Y axis labeled
  4. Scale adjusted if necessary

 

 

 

2. Student Info Data Project

 

Collect data from people in your class.   Learn how to sort and filter the data in the spreadsheet.

 

See the Directions Handout for more information.

See the Student Data Checklist for project requirements.

Download a sample spreadsheet of student data.

 

Extra Help with Excel:

How to Sort data in Excel

How to Filter data in Excel

 

Creating a merged document with student data.

 

 

3. Making a Bad Power Point Presentation

Students will create a simple Power Point Presentation that intentionally breaks the "rules" of making a great presentation. They will then fix their Power Point and assess the qualities of a good presentation.

 

1. Create a BAD Power Point - See the directions for making a Bad Power Point.

2.  View the Bad Power Points created by others and critque them using the Bad Power Point Evaluation.

3. Make your bad Power Point Good - See the directions for correcting your Power Point.

4. Complete the follow up questions to this activity, see the Make a Bad Power Point Presentation handout.

 

Power Point Tip:

How to Get Animated Clip Art for your Power Point Online

 

4. Website Review

Students will work in groups of two or three. Each group will be assigned a website to review using the checklist. Students will then report on the website to the class.

 

1. Evaluating a website Presentation - Presentation from the Springfield Township Virtual Library

2. Evaluating a Website Review Checklist

 

3.  "Dinosaur Research" Website Evalutaion  - check out these four dinosaur websites.  Which would you consider to be the best site for dinosaur research ? Why ?

 

4. Use a printed copy of this documnet to evaluate a website.

 

5. Student Website Presentation Template - Each group must download this file and use it as the template for their website evaluation presentation.

 

6. Website Evaluation Rubric.doc

 

7.   Use the Website Evaluation Checklist to make sure you have completed the requirements.

 

 

  • To find the sites that link to a website go to Google and type "link to: and the url of the website you are checking", for example link to: www.wyckoffschools.org
  • To find out who owns a web site or has published the material, go to www.easywhois.com.

 

Possible Websites to be Evaluated:

 

  1. Aluminum Foil Detector Beanie

  2. Ban Dihydrogen Monoxide

  3. Boilerplate, the Victorian Era Robot

  4. Burmese Mountain Dog

  5. Buy An Ancestor Online

  6. Click Monkeys

  7. California Velcro Crop

  8. Dog Island

  9. Funky Shoes

  10. Jackalope Conspiracy

  11. McWhortle Enterprises, Inc.

  12. Miskatonic University

  13. New Hartford, Minnesota

  14. The Republic of Cascadia

  15. Tree Octopus

  16. The Presidential Myths Quiz

  17. Varicella Vaccine
  18. Hurricane Myths and Tips
  19. Tornado Myths and Tips

  20. Missle Mail

  21. Rabbit Pests

  22. Toxic Mold

  23. The Pony Express

  24. Fisher Price Airplane

  25. Google Technology

  26. Google TiSP

  27. Google Gulp

 

Using Circles and Arrows in your Presentations.

 

 

5. Home Office Budget Project

 

Students will work in groups to create a $3,000 budget for a home office.  Students will use 2 competitors websites to create comparative price spread sheets.

 

Sample Project

 

 

 

 

 

 

 

Advanced PowerPoint Techniques 

  1. Photos, Graphics and PowerPoint

     

  2. Enhance Your PowerPoint Presentation With Animations

     

  3. Music, Timing and Narrating Your PowerPoint Presentation

     

  4. Printing Options in PowerPoint

     

  5. Macros, Master Slides and Web Pages

     

  6. Package Your PowerPoint Presentations

 

Create a PowerPoint Presentation using the above incorporating the advanced techniques listed above. 

Stock Project

 

Google Finance

 

Example of the performance of a stock over time - Historical prices for Home Depot

 

 

 

 

Comments (0)

You don't have permission to comment on this page.

Printable version
 
Anonymous Create an account or Log in