Following+these+steps,+create+a+spreadsheet+and+bar+graph!

USE YOUR PENCIL AND CHECK OFF EACH STEP AS YOU DO IT! STEP 1 1. Click on Green Excel icon (usually next to Blue Word icon). Select “Excel Workbook” and “Open”. 2. Fill in your chart so that the first two columns look like this. Start with the titles of the columns! I copied these figures from Wikipedia’s chart “European population” and just cut and pasted the figures. It helps to have Firefox open in a window next to your document if you are going to do this.
 * Countries || Population ||
 * Russia || 141,927,297 ||
 * France || 65,447,374 ||
 * Poland || 38,192,000 ||
 * Germany || 81,757,600 ||
 * United Kingdom || 62,041,708 ||
 * Spain || 46,030,109 ||
 * Italy || 60,418,711 ||
 * Belgium || 10,574,595 ||
 * Netherland || 16,518,199 ||
 * Sweden || 9,360,113 ||
 * Switzerland || 7,785,000 ||
 * California || 37,172,015 ||
 * United States || [[image:file:///Users/scottanders/Library/Caches/TemporaryItems/msoclip/0/clip_image001.png align="left" caption="Text Box: "]]308,745,538 ||
 * Total Euro. Popultion || =Sum(highlight) ||
 * European Average || =Average(highlight) ||

STEP 2 To Calculate the Total European Population on your chart: Total European Pop. “=sum (highlight cell range in B column to add up- don’t include top row of titles (the word Country or Population) and do not include CA and US!). Put an end on the parenthesis and click “enter/return”

STEP 3 To Calculate the Average of all the European countries on your chart: European Average =average (highlight cell range in B column to average- don’t include CA and US!) Put an end on your parenthesis and click “enter”. You should see the figures appear.

STEP 4

To Create the Bar Graph: 1. Highlight everything except the first line (except the top row: the words “countries and population”) 2. Go up to the toolbar and click the bar graph icon that looks like this: 3. Select the first chart option (column bar graph). Click “next”. Give it the title: Western European Populations”. 4. Add “as object in sheet 1” 5. You should see your chart like this: 6. You can click on the box around the bar g raph and move in next to your column. BE CAREFUL ABOUT CLICKING ON THE INFO OF THE CHART, IT COULD CHANGE IT.

STEP 6 Saving your Document, sending it to Ms. Anders Save As: yournameexcel.doc onto the DESKTOP Open up your email (yahoo.com or gmail.com or cox.com). Create an email (New message). Fill in info (aanders@guhsd.net subject=excel document) Write: Here is my European population chart! Put your full name on the message. Click the ATTACH button and select the document from the desktop. Click SEND

STEP 7 Uploading your document to ebackpack Make sure you have saved your document on the DESKTOP (yournameexcel.doc) Go to Ebackpack on the student HOME site (guhsd.net and select student) Click Ebackpack and log on with your ID and password Click onto Geography folder and then UPLOAD. Find your document using BROWSE on Desktop. Click “start upload” at the bottom.