 |
|
|
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
|
Aims and Objectives for this module of work. National Curriculum Orders What Key Skills will I be developing in this module of work?
Spreadsheet Homework Task; when told to, print out, take home to complete and bring back to lesson to mark. Spreadsheets are used to perform calculations. In school we used software called Microsoft Excel. Below is a basic introduction. |
|
 |
|
| Spreadsheets are great because they can do all the calculations you need. First though you need to write some formulas. Formulas are like writing the sum, but instead of putting the numbers in, you put in the cell reference. So that if the number in the cell changes, then the answer changes. | |
In this spreadsheet I want to add up the numbers in cells A1 and B1 and display the answer in cell C1. What does a formula start with? |
 |
| The result is shown. |  |
| Now if I change the value in cell A1, the result changes, as we'd expect. This time you can see the formula bar (with fx infront of it) showing you that the formula has not changed! |  |
| You are now going to work through some spreadsheet exercises yourself. Ask your teacher which one you need to do then click it and SAVE it into your user area. | |
Band A Spreadsheet Exercise |
Band B Spreadsheet Exercise |
 |
|
Both these spreadsheets use something called macros to mark the spreadsheet automatically. When you first open it, it won't work properly. Go to Tools - Macros - Security and change the macro security to Medium. Close the spreadsheet and open it up again. This time click Enable Macros when asked. When you are working on the spreadsheets, you will be marked on whether you got the answers right, but also whether you got the formula right too. Sometimes in Excel, there is more than one way to write a formula, but one way is usually clearer and therefore the best one to use. |
|
You can now move on to writing IF statements in spreadsheets. IF statements are simple logical statements and work on the basis of testing whether a condition is true. You do IF statements in your head all the time. For example: IF I am hungry THEN I will eat some food OTHERWISE I won't eat anything. In Excel, the THEN and the OTHERWISE are replaced by commas. The "logical test" (i.e. what you want to test) is usually a comparison of cell values. e.g. =IF(C7=14,"Passed","Failed") IF statement can be used to put comments in a spreadsheet. Text must be surrounded by " ". They can also be used to do different formulas depending upon the results of the condition. =IF(C7=14,C7-C8,C7+C8) In this example, IF C7 = 14, THEN we will take the value in C8 from C7, OTHERWISE we will add the value in C7 to the value in C8. |
|
| Here are two IF statement exercises to try out. Save them into your user area first. | |
 |
 |
| Extension exercise | |
| If you have finished, try out this extension spreadsheet. |  |
| EU Stats Extension | |
First open this folder. Copy the Euro folder inside it and save it into your Year8_Spreadsheets folder. Save the spreadsheet into the same folder. Select the hyperlinked countries in the list to find the missing data (it will connect you to the downloaded web pages).
|
 |
Highlight, copy and paste the required data into your spreadsheet. You will find the information under the following headings:- Population > People
|
|
| Now, save these Word documents in your user area and use your EU Stats spreadsheet to work through them. | |
 |
 |
