Excel

**Excel Unit**


 * what is excel? **

Microsoft Excel is a spreadsheet program that is used to store, sort and efficiently calculate numbers. Accountants use Excel to keep track of transactions for their company. Anytime you are working with numbers, you can use Excel. If work at a business that deals with the buying and selling of items, you will probably need to know Excel. If you ever hope to manage or own a business or even work for yourself, you WILL need to know Excel.

Most jobs now will ask which computer applications you are familiar with and basic Excel experience is required by many more jobs than it used to be.

No matter what you are using Excel for it is important that you have the basic knowledge required to do the everyday operations you will encounter while using this program.



Save all Excel Assignments in your h:/ drive Excel Classroom Content folder:

Excel Assignments:











Excel Textbook Pages:

If you are done all of the above, get a Computer Applications textbook and complete the following assignments.

DO NOT PRINT, save in your Excel Folder under the name it will give you in the assignment.

page 360 - 1.5 income page 367 - 2.10 income

page 359 - 1.4 sales <span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">page 369 - 2.11 sales

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">page 358 - 1.3 payroll <span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">(note: to get the triangle in the top left hand corner of your cell, you enter an apostrophe ' ) <span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">page 371 - 2.12 payroll

<span style="font-family: 'Comic Sans MS',cursive; font-size: 220%;">Lemonade Stand OR Coffee Shop

<span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">Here is the spreadsheet to add your numbers into: <span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;"> <span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">[|Lemonade Stand.xls]

<span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">Save it on your H drive in the Custom Folder as Lemonade Stand or Coffee Shop.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">If you are doing the Coffee Shop game, you will need to make adjustments to the spreadsheet.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">Go to this website to start the game [|Lemonade Stand Game]

<span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">Make sure you are keeping track of all the items that are listed on the spreadsheet so that you can add the information after you have finished playing the game each day.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 160%;"><span style="font-family: 'Comic Sans MS',cursive; font-size: 170%;">Excel Charity Assignment - 50 marks.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 21px; line-height: 31px;"> <span style="font-family: 'Comic Sans MS',cursive; font-size: 21px; line-height: 31px;">Sample sheet for Charity Assignment

<span style="font-family: 'Comic Sans MS',cursive; font-size: 230%;">3rd World Farmer Assignment - 40 marks

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">A strong agricultural society forms the foundation of a prosperous and stable national economy. Unfortunately, for many 3rd world nations, building and sustaining a strong agriculural society is very difficult. In many countries, decades of war and dry terrain have made long lasting farming success rare.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">This is the Template for 3rd world farmer. Use the end-of-year box to fill out the results in the spreadsheet.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">For this assignment, you will play "3rd World Farmer" at []. This game simulates the annual difficulties that 3rd World farmers go through when trying to sustain a profitable farm. Oftentimes, success is determined not by the quality of farming, but by circumstances out of the farmer's control. Just as in a 3rd world country, you will be faced with challenges that make earning a livable wage difficult. Hopefully by the end of the game, you will have a clearer understanding of why it is so difficult to live in a country where your survival relies on circumstances you have no control over.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">__**Directions:**__

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">1. Log on and create a player account at []

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">2. At the end of each year (turn) a report will generate in regards to your crop output, financial situation, and reasons for why you had success or failure during that year. Please print off these reports and use them to create a spreadsheet in EXCEL. It is up to you to decide how you will organize your information into the columns and rows. 20 marks.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">3. Answer the following questions in MS Word and put in your h drive Excel folder. Each response should be EXPLAINED IN AT LEAST 5 SENTENCES EACH.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">//-At what points during the game did you experience failure? Why did you fail?//

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">//-Was it always your fault when you failed? Why or why not?//

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">//-What lessons can be taken from this game in regards to how we look at 3rd world farmers, who have had to experience decades of war and relying on the weather and land for their survival?//

<span style="font-family: 'Comic Sans MS',cursive; font-size: 190%;">More Textbook pages if you are done all of the above:

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">1. page 373, 2.13 balance

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">2. open your 2.11 sales, turn to page 376, make it look like the chart on page 377 Illustration B.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 140%;">3. open your 2.10 income, turn to page 380, change it to make it look like the chart on page 381.

<span style="color: #ff0000; font-family: 'Comic Sans MS',cursive; font-size: 150%;">Final Excel Assignment - 40 marks

<span style="font-family: 'Comic Sans MS',cursive; font-size: 150%;">Last spring, a fire burned 40% of the town of Slave Lake, Alberta. Families lost everything, fled to nearby communities and returned to start from scratch.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 150%;">Using a spreadsheet, document everything that you and your family would have to replace along with the cost, if this same disaster occurred in Flon Flon.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 150%;">Be sure to include the website address where you got your information from.

<span style="font-family: 'Comic Sans MS',cursive; font-size: 150%;">**Save in Excel Custom folder as Slave Lake.**