1 / 10

French-Speaking Countries Data Project

French-Speaking Countries Data Project. Goals and Objectives. 8 th Grade students will create an Excel spreadsheet to show different data of French-speaking countries. NJCCCS World Language 7.1, 7.2 Timeline – 1 Week. Directions for Project.

naomi
Download Presentation

French-Speaking Countries Data Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. French-Speaking CountriesData Project

  2. Goals and Objectives 8th Grade students will create an Excel spreadsheet to show different data of French-speaking countries. NJCCCS World Language 7.1, 7.2 Timeline – 1 Week

  3. Directions for Project Choose 12 French-speaking countries using the following website – www.france.fr Create 2 columns – Name of each country in English and French. Create a column with the capital of each country. Create the following columns – Population, Area in Square Miles, Average High Temperature °F, Average Low Temperature °F. Use the following websites to obtain the above information – www.en.wikipedia.org, and www.worldweatheronline.com

  4. Students will do the following: Sort the countries into alphabetical order using the A-Z sort function. Find the total population of all 12 countries. Find the total area in square miles of all 12 countries. Find the minimum, maximum, average, and range of the population, area in square miles, and high and low temperature columns. Use conditional formatting to show population > one million in pink fill with red text and < 500,000 in light green fill with dark green text. Use conditional formatting to show area in square miles > 100,000 and < 10,000 using same colors as in the population column. Use conditional formatting to show average high temperatures > 80°F in red and average low temperatures < 32°F in blue. Freeze the top row so that you can scroll to the lower portions of the spreadsheet without losing the titles. Create a hyperlink from each country to its webpage in the wikipedia website – en.wikipedia.org/wiki/country name.

  5. Creating Charts Students will create a pie chart to show the population of each French-speaking country.

  6. Create a Bar Graph Students will create a bar graph to show the area in square miles of each French-speaking country.

  7. Using the Data After collecting the data and analyzing the differences in population, area, and temperatures, students would then be able to use that information as a tool in deciding which country they would like to visit. “Brainy Bits” Sense and Meaning – When students actually use real data as a tool, in this case finding differences between different French-speaking countries, there is sense and meaning and gives them a reason to learn French. Multiple Intelligences – Students are using the following multiple intelligences in this activity – kinesthetic, logical/mathematical, visual/spatial, verbal/linguistic, and intrapersonal.

  8. Assessment - Rubric 4 3 2 1

  9. Citations . The Official Site of France. N.p., n.d. Web. 21 Feb 2014. <www.france.fr>. . Wikipedia, The Free Encyclopedia. N.p.. Web. 21 Feb 2014. <en.wikipedia.org>. . World Weather Online. N.p., n.d. Web. 21 Feb 2014. <www.worldweatheronline.com>.

More Related