Learning Web-Spanish II

WHERE IN THE WORLD CAN I FIND THE BEST CRAFTS????                          

Grades 9-12   

by Donna R. Widener

Tennessee Modern Foreign Language Goals and Objectives

GOAL TWO: Gain Knowledge and Understanding of Other Cultures Standard 2.1 Students demonstrate knowledge and understanding of daily life, traditional ideas and perspectives, institutions, literary and artistic expressions, and other components and aspects of the cultures being studied.

• experience products of the culture such as songs, stories, games, traditional celebrations, and art. 
• identify, discuss and compare aspects of everyday life such as school transportation, clothing, and foods. 

GOAL FIVE: Participate in Multicultural Communities and Global Society Standard 5.1 Students will use the language both within and beyond the school setting with representatives of the target cultures in a variety of ways.

• locate on a map and pronounce the names of countries and cities in which the target language is spoken.

Objective:  To locate and name all 20 Spanish-speaking countries (one is a territory), identify unique products that they sell, convert their price to U.S. currency, and then present  three of your favorite artisan crafts.

The countries will be presented in a PowerPoint presentation, which relates one unique detail about each country's special crafts. The student will visit on-line stores that sell international crafts and set up a table on Excel, identifying three products in the table, the price in U.S. dollars and the price in foreign currency, converting where necessary. The international crafts information will be listed in a table created, including country, item, price in foreign currency, and conversion.

Higher Order Thinking:  The student will analyze information, convert foreign currency, and create a PowerPoint slide presentation.

Materials: Computer, Internet, PowerPoint, Excel

Duration:  Four days in the computer lab.

Scaffolding: This is a teacher led activity intended for level two of Spanish.  The students should be familiar with the 20 Spanish-speaking countries or territories.  They should be familiar with cultural differences.  They should also be familiar with basic computer navigation skills.  The teacher will demonstrate each part of the lesson prior to students participation and help with Internet, Excel and PowerPoint activities.

¡Empezamos !

Problem: 

You are consultants hired by an international import company and have been ordered to identify the 20 Spanish-speaking countries and territories.  As a consultant, you will visit these countries and determine the artisan crafts that would be most marketable to teens.  You will know the value of the product in US dollars and foreign currency in order to report the 3 best items, in your opinion, to the board of directors. If your products are accepted, you will win a two week trip to Spain, all expenses paid with an additional incentive of $50,000 (for spending money!)

Actividad #1: You will begin by locating and identifying all 20 of the countries, then create a PowerPoint presentation identifying the countries with one of their artisan craft products available for purchase.

Start by identifying 20 Spanish-speaking countries.  Click on the link below:

Where Spanish is spoken

Next, identify one craft product available from that country by clicking on the name of the country (Be sure to notate the prices of your 3 favorite craft items!):

Argentina

Colombia

Mexico

Spain

Venezuela

Peru

Bolivia

Chile

Cuba

Ecuador

Dominican Republic

Nicaragua

Paraguay

Puerto Rico

El Salvador

Honduras

Guatemala

Costa Rica

Uruguay

Panama

PowerPoint Instructions:

1. Now create a PowerPoint presentation, 3 countries per page, of Spanish-speaking countries and one craft that each country specializes in.  Be sure to notate the price of the item for a table you will create.
2. Open PowerPoint.  Click either the New icon (blank pg. on the upper left) or File-New.
3. From hanging menu, click on Format.  Go to Slide Design.  Choose a slide design. Save.
4. Format-Slide Layout.  In the Text Layouts, on the right side, select the Title slide of your choice.
5. Click in the top box of the slide.  Enter the names of the people in your group.  Highlight names and change font, and color as you wish.  Save.
6. Click in the bottom box of the same slide.  Enter the date.  Change font and style as you wish.  Save.
7. Place your cursor on the first slide appearing in the left margin.  Hit Enter to create another slide for the slide presentation. 
8. Place your cursor on the top of the 2nd slide.  Add the title (Example: Crafts Around the World)  Click on the bullet section and list 3 of the countries and their craft products.  Save.
9. Click on the bottom section and insert the picture of your choice to enhance your slide.  Adjust the picture to fit the space.  Save.
10. Repeat the above directions for the rest of the countries (6 more slides, 18 more countries).  Save after each slide or entry.
11. Finish with slide number 9, adding an ending slide.
12. Go to Edit, Select All, from hanging menu.
13. Go to Slide Show, Animation schemes.  Select an animation scheme for all or choose a different animation for individual slides in your presentation. Save.
14. Go to Slide Show.  View Show to view your work. 

Actividad #3:  You will create a table using 3 of the countries, identifying the following as headings:  Country, craft item, Cost in Foreign Currency, Cost in U.S. dollars.

Excel Instructions:

1. Using Excel, Open a new worksheet and save it as Country Project.
2. Input the following heading in A1, B1, C1, and D1:  Country, Craft Item, Cost in Foreign Currency, and Cost in U.S. Dollars.
3. Highlight the headings and click on Bold type in the toolbar at the top of the page.
4. Enter the three countries that you selected in the Column titled "Country."
5. Enter the Craft Item for that country in the next column under the heading Craft Item.
6. Enter the cost in Foreign  Currency  in the next column.  (Use currency converter link below to convert to dollars or vice versa if necessary.).
7. Enter the cost in U.S. dollars in the final column. 
8. Currency Converter

Assessment (Click on link--150 total pts.)

Acknowledgements:

Tennessee Curriculum Standards:

http://www.state.tn.us/education/ci/cistandards.htm