Project Steps

The Power Point Presentation

· Open PowerPoint.

· Go to: www.new7wonders.com

· Select YOUR 7 Wonders.

· Find 3 facts about EACH Wonder.

· Go to: www.worldatlas.com

· Find 5 facts about EACH country your wonders are in.

 

 

 

 

The Excel Portion

1.   Select cell A1.

 

2.   Type the project heading "The New 7 Wonders."

 

3.   Merge and Center the heading.

 

4.   Change the font size to 16 and select a font color of your choice.

 

5.   Select cell A2.

 

6. Type the heading "Wonder Name."

 

7.   Select cell B2.

 

8.   Type the heading "Country."

 

9.   Select cell C2.

 

10. Type the heading "Class Votes."

 

11. Highlight the headings in cells A2 through C2.

 

12.   Change the font size to 14 and select a font color of your choice.

 

13.   With cells A2 through C2 still highlighted, go to Format on the task bar. Slide down to Cells and select the Alignment Tab .

 

14. Find the Text Orientation Tool . Change the Orientation to 45º .

 

15.   In cell A3 list the name of one of the New 7 Wonders.

 

16. In cell B3 list the name of the country that Wonder is located in.

 

17. Leave column " C " empty for the time being.

 

18. Continue listing all Wonder Names in column "A" and the respective countries in column "B."

 

19. Once completed, the class will vote.

Class Vote

 

1. Fill in Column "C" with the number of class votes for EACH Wonder.

 

2. Once all of the Class Votes have been entered in column " C ," Highlight cells A3 through C23.

 

3. Select " Data " on the task bar, slide down to " Sort ."

 

4.   Sort by " Class Votes " and select the " Descending " button. Then sort by "Wonder name " and select the " Ascending " button. (Notice how the list is sorted with the most class votes down to the fewest class votes and the votes with the same number of votes are listed in alphabetical order.

 

5. Keeping Cells A3 through C23 highlighted, select " Insert " on the task bar. Slide down to Chart . Then select Pie Chart .

 

6. Create a Pie Chart showing the percentage of Class Votes for each of the New 7 Wonders.