States, Capitals, and Postal Abbreviations

The test is next Friday. Today I want you to take a practice quiz. Don’t use your study guide or look up the answers. Try to answer the questions without help so you can see where you are at as far as being prepared for the test.

Your username is your first name, your last name, 232     There are no commas and no spaces. For example, my username would be:  jacobosborne232

Yours should look exactly like that except you will insert your first and last name instead of mine.

You must use your official school name. For example, if your name is William, but you go by Will, you must use your proper name William.

If you have 2 last names make sure you use both last names on your log-in. For example: If your name is Jose Reyes-Lopez, you would need to put josereyeslopez232.

Your password is your Mosis #.

Access the practice quiz here.

The “secret word” is:  practice

After you finish your practice quiz, look at the chart below and compare to how many you got correct to see what your letter grade would be if this was an actual test.

23-25 = A

20-22 = B

18-19 = C

15-17 = D

14 and below = F

Population Vocab and Google Sheets

You need to try to finish the Population Vocabulary and Google Sheets assignments that you worked on this week. Turn them in whenever you are done. Monday we are moving onto something new.

With extra time, either study your study guides or go to my class links and visit one of the 3 links available in the States, Capitals, and Postal Abbreviations section.

Google Sheets

Here’s the directions posted again for the Population Sheets assignment:

1. Three Headings- Countries, Population, $GDP    I want you to use size 18 font for the headings and make them bold. All other cell’s font should be size 12.

2. In the countries column there are 15 countries I want you to include. They are: United States, China, Japan, India, Iraq, Afghanistan, Egypt, Brazil, Mexico, Guatemala, Russia, South Africa, Germany, France, and United Kingdom.

3. In the population column, you need to go to Google and type <name of country> population. Type their exact population next to the correct country in the population column.

4. Next you are going to find the GDP per capita. That’s a fancy way of saying how much money the average person makes in a country. If the number you get is in the millions, billions, or trillions, you didn’t use the correct link. In the $GDP column, you need to use this link to find the GDP per capita in each of the countries.  Type the GDP for each country in the column. Make sure you use dollar signs. You will need to change the numbers to “currency” inside of sheets. Also remember you can use ctrl+F to search for specific words on web pages.

-Make sure you change it so there are no decimals

5. After each column is finished, make a Column Chart for population. You will do it the exact same way that I did in the video.

6. Make a Bar Chart for GDP. You will do it the exact same way that I did in the video.

After you finish, turn it in.

***3 Tips***

1. You can’t have the word million or billion in your spreadsheet. Make sure you only use numbers. If you include words in your cells, it will mess up the charts and graphs.

2. If you add spaces to your cells that don’t need to be there, it will mess up your charts and graphs. Don’t add spaces

3. Make sure that you only highlight the selected cells that have data. If you highlight extra cells that don’t have data, they will mess up the charts and graphs.