Eisenhower Middle School

Wyckoff, New Jersey

 

 

Mr. Bonavitacola

Mr. DeBlock

Mr. Olejarz

 

---

 

Computer Technology 7-1

 

---

 

 

Collecting Data and Using it in a Spreadsheet

 

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

 

 

---

 

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.

 

---

 

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.

 

Design a 3 slide Power Point using one of the following topics:

1.    My Family – discuss any information about family members – ages, names, characteristics, etc

2.    My favorite _____________________ is…

               (hobby, team, TV show, band, etc)

 

Your Power Point presentation will include the following:

     3 Slides in total

          -A Title Slide with your name on it

          -2 slides containing information about you topic

Below is a list of guidlines for making a great Power Point.  Your Power Point should break at least 3 of them.

 

Guidelines for making a good Power Point presentation (in this project, you will break them)

A.  Do not use sentences and paragraphs, instead use bulleted points when appropriate

B.   Do not use more than 7 bulleted points on a slide, or more than 7 words in a bulleted point ( the 7X7 Rule)

C.  Do not use too many sounds and animations in your power point. 

D.  Sounds and animations should be appropriate to the topic.

E.  The font size should be easy to read.

F.  The font style should be easy to read.

G. The font color and background should be easy to read.

 

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

 

Bad Power Point Evaluation.doc

 

Students will view other people's "bad" presentations in small groups and use the Evalution Handout to critique them.

 

Power Point Tip:

How to Get Animated Clip Art for your Power Point Online

---

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.

 

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

 

Evaluating a Website Review Checklist

 

"Dinosaur Research" Website Evalutaion

 

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

 

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

 

Website Evaluation Rubric.doc

 

• 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.

 

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. Fisher Price Airplane

17. Google Technology

18. Google Gulp

19. Google TiSP

     

 

Using Circles and Arrows in your Presentations.

 

 

---

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