Finish Population Vocabulary

I will give you about 15 minutes to finish the Population Vocabulary then I will go over a PowerPoint with you. If you get this finished and have extra time; continue to study for next week’s states and capitals test.

Population PowerPoint

I will go over a PowerPoint about Population 15 minutes into class.

After the PowerPoint

Today you will be working in a new program. In this assignment you are going to learn the basics of Google Sheets. It’s similar to a program called Excel, but it’s a little easier to use. Most of you have never used this program before. The first thing I want you to do is to watch the tutorial video that I made. Go to Google Drive>Shared Drives>Videos>Osborne>Computer Tutorials>Google Sheets

After you watch the video, you need to go to Google Classroom and open the Google Sheets assignment. I want you to create a document that has:

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

Missing Assignments

Since I wasn’t here on Friday, I will give you another 20 minutes today to finish up missing assignments. In 20 minutes, we will get a new seating chart and begin the lesson below. Don’t start that lesson until you get your new seating chart.

Population

We are going to spend a few days this week talking about population. That might sound like a boring topic, but it actually is pretty interesting. Today we need to build a little background knowledge though. You are going to find definitions and pictures for some of the words we will be discussing over the next couple of days.

You need  to go to Google Classroom and open the Population Vocabulary assignment. Use the internet to find the definitions. The easiest way to do this is to go to Google and type, “define and then the word you are looking for” for example: for Birth Rate, I would go to google and type, “define birth rate”. Google would give me the definition. All of the definitions today are in reference to human population. That’s the topic we are talking about so make sure that your definitions make sense with the topic.

 

On each slide, you need to find a picture that represents the vocabulary word. I did the first one for you as an example. I typed the definition for “population” and then I found a picture online that represented it. The world population is now over 7 billion people. You need to do the same thing on the remaining slides. On some of the slides, I’ve already inserted pictures for you, but you still need to find the definitions. On most slides you will need to type the definition and find a picture on the internet that is an example of the word. When you finish, every slide will have a definition and a picture on it.

Whenever you finish, turn it in.

States, Capitals, and Postal Abbreviations Test

Whenever you finish, it would be a great idea to study for your States, Capitals, and Postal Abbreviations test. That test will be next week.

It will be broken into 3 parts:

1. Identify the states on a map
2. Match the state with the capital
3. Match the state with the Postal Abbreviations

You can either work on the study guide that is on the desk in the front or go to my class links and use 1 of the 3 links under the States, Capitals, and Postal Abbreviations section.