Week 8

Next week you will still work with your current partner, but I’m treating today like a make up day. The reason for this is because next week, we have a project that will last the entire week. My goal is for you to have all of your assignments done going into the project so that can be your only focus.

Check Infinite Campus to make sure you have the following assignments finished and turned in. If you have a grade for the assignment, I’ve got it from you. If you don’t have a grade for the assignment, I don’t have it from you.

These are the assignments from the current rotation that you need to make sure you have finished:

-Africa Map

-Southeast Asia Scavenger Hunt

-Southeast Asia Economy Excel Assignment

Week 8

In our next assignment we are going to look at the economy of Southeast Asia. You will use Excel to complete the assignment. You will have today and tomorrow to work on this.

If you don’t remember how to use Excel, you can watch the tutorial video that I made. Go to the  (V) Drive. Inside the V Drive, I want you to click the following: Osborne>Computer Tutorials>Semester 2 Excel Basics.

I want you to create a document that has:

1. 5  Headings- Countries$GDP, Life Expectancy, Literacy Rate, and Classification.    I want you to use size 20 font for the headings and make them bold.

2. In the countries column there are 15 countries I want you to include. They are: India, Pakistan, Nepal, Bhutan, Bangladesh, Sri Lanka, China, Mongolia, North Korea, South Korea, Philippines, Singapore, Thailand, Vietnam, and Japan.

3. 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. If you want to you can do what I did in the video and highlight the column and change the numbers to currency instead of typing the $ sign. I want whole numbers. I don’t want your decimal point to show cents. Ex. $32,ooo       not   $32,000.oo

4. Use this link to find the life expectancy rates for each country. Round each number so there aren’t any decimal points. They should all be whole numbers.

5. Use this link to find the literacy rates for each country.Use the literacy rates for the total population.  Round each number so there aren’t any decimal points. They should all be whole numbers as a percent.

**To make it easy on yourselves, highlight the cells and format them as a percentage and 0 decimal places BEFORE you type the numbers in the cells for Literacy Rate. If you type the numbers first, you will have to manually go in and delete extra zeros from your cells**

6. For the Classification column, I want you to look at the data to determine whether you believe they are a developed, developing, or a middle income country. Write which one you believe each country is.

You can use this chart as a guide to help you determine the classification.

DEVELOPED (rich)

MIDDLE-INCOME

DEVELOPING (poor)

LIFE EXPECTANCY

M – 70 and above

F – 80 and above

M – 60’s & 70’s

F – 70’s

M – below 60

F – below 70

INFANT MORTALITY

Below 10

11 – 25

Above 25

LITERACY RATE

97% or above

80% – 96%

Below 80%

PER CAPITA GDP

$15,000 – $30,000 or higher

$5,000 – $14,000

Below $5,000

7. After each column is finished, make a 2-D Column Chart for GDP. You will do it the exact same way that I did in the video.

8. Make a 2-D Bar Graph for Life Expectancy. You will do it the exact same way that I did in the video.

After you finish save it.  hr-last name-last name-AsiaExcel

Turn it in

Week 8

Today you are going to take your test over Africa. You will not be allowed to use the internet, previous assignments, or your study guide. You and your partner may discuss the answers, but you must whisper. If you are too loud, both you and your partner will take the test separately.

You can access the test here. 

This is the same website you have used for your common assessment tests.

Your username is your first name, followed by your last name, and then 318. Ex. jacobosborne318

Your password is your Mosis #.

The “secret word” for this assignment will be given to you.

Whenever you finish the test today:

Finish and turn in your Africa map if you didn’t finish on Friday.

After you turn your Africa map in you may:

-work on homework from another class

-read a book

-visit class links (Since it is a test day, I will allow you to visit cool math if you have everything done (That’s only for today though))

Week 7

Monday we are having a test over Africa! It will be worth 50 points. Since this is our first test in this class, you may work on it with your partner. You won’t be allowed to use your study guides, the internet, or any other resources.

Today you are going to continue working on the assignment from yesterday. This assignment will require you to read and follow directions very carefully! You are going to be creating a map by using the tools in Word.

Most of you already watched the video yesterday, but if you don’t remember how to do something and you need to watch it again, the video is located at    Video (V) Drive>Osborne>Computer Tutorials>Inserting Shapes to Word   (Note: It’s NOT the video titled, “Copying and Adding Shapes in Word”)

While you work, it would be a good idea to have your study guide out so you can double check to make sure that your map is correct.

Here are the directions for the assignment. Make sure you read them closely and double check them to make sure you don’t skip any steps.   Africa Map Directions

The directions don’t tell you how to label the Nile and Congo Rivers. Use size 14 Blue font, with no color for the fill and line color.

Here is the Map you will use for your assignment:  Africa Map

Whenever you are finished, save and turn it in.

Hr-Last Name- Last Name-Africa Map

Week 7

Today you will only have about half the class to work with your current partner and then you will be getting new partners. You will have about 20 minutes to work on any missing assignments. In this rotation you have been assigned:

-Middle East Sorting

-Africa Scavenger Hunt

-Africa Digital Book Project

Study Guide for Monday’s test (not for a grade)

Check Infinite Campus so you can see what your grades were. I will announce what assignments are missing.

 

Do not work on anything below here until after I have you log off and you get your new partners. 

This assignment will require you to read and follow directions very carefully! You are going to be creating a map by using the tools in Word.

You need to watch a video first. The video you need to watch is located at    Video (V) Drive>Osborne>Computer Tutorials>Inserting Shapes to Word   (Note: It’s NOT the video titled, “Copying and Adding Shapes in Word”)

While you work, it would be a good idea to have your study guide out so you can double check to make sure that your map is correct.

Here are the directions for the assignment. Make sure you read them closely and double check them to make sure you don’t skip any steps.  Africa Map Directions

The directions don’t tell you how to label the Nile and Congo Rivers. Use size 14 Blue font, with no color for the fill and line color.

Here is the Map you will use for your assignment:  Africa Map

Whenever you are finished, save and turn it in.

Hr-Last Name- Last Name-Africa Map

Week 7

The snow day has thrown things off a little bit. I will give you today to finish your project. Tomorrow will be a catch up day. You likely won’t get the full class period! We will probably get new groups and new assignments during tomorrow’s class. The following are the assignments that you should have finished by the end of class tomorrow:

-ME Sorting

-Africa Scavenger Hunt

-Africa Digital Book Project

-Africa Test Study Guide

The first priority today is to finish your project. If you have your project finished and turned in, you are going to work on a study guide for next week’s test. You need to pick up a study guide off of the desk at the front of the room. The one by the bookshelf. Everyone needs their own copy of the study guide. You can use the internet or previous assignments to answer the questions on the study guide.

***Reminder*** You will receive no credit for any slides that have copied and pasted text. I have had a couple of groups that have turned assignments in and they are earning F’s because they copied and pasted. 

Week 6

***FYI*** You will receive no credit for any slides that have copied and pasted text. I have had a couple of groups that have turned assignments in and they are earning F’s because they copied and pasted. 

I’m hoping that several of you will finish your projects today, but I know there will be several groups who don’t finish. All of my classes have done a great job of staying on task and almost everyone’s been working really hard. You will have Tuesday to work on this assignment as well. I will have an assignment for you as you get finished on Tuesday.

Enjoy your 3 day weekend!

Week 6

I’ve been very pleased with how well you’ve been working so far. You’ve done a great job of staying on task. Today you will continue working on the project. Make sure you are finding good facts about your topics and interesting facts that are actually interesting. I will be grading pictures on effort. If I can tell you worked hard on it, you will get a good grade for it. If it looks like you just flew through it, you’ll be losing some points.

If you are able to finish the project, you need to save it and turn it in like normal.

hr-last name-last name-africa project