| Key objective | QCA Website | |
| Activity 1 What do spreadsheets do? |
Download a spreadsheet file and open it in Excel. Explore some of the functions that spreadsheets can perform. | 9 dart finish.xls |
| Activity 2 How do they do it? |
Examine the structure of the above spreadsheets paying particular reference to the formulae. | |
| Activity 3 Spreadsheet formulae |
Download the Word document 'Spreadsheet formulae' for reference on the conventions of spreadsheet formulae. | Spreadsheet formulae.doc |
| Activity 4 Creating a spreadsheet |
Create a budgeting spreadsheet from scratch for planning a party. The structure of this will closely resemble the 'Invoice' file. |
| Key objective | Is able explore the effects of changing data in a spreadsheet. | QCA Website |
| Activity 1 Area and perimeter of a rectangle |
Devise a spreadsheet formula to calculate the area and perimeter of a
rectangle from any given length and width. Consider alternative formulae. Copy the formula down the sheet and change the variables. |
|
| Activity 2 Multiplication tables |
Create a multiplication table by copying formulae down a page thus:
Explore the effect of changing the numbers in A B.
|
|
| Activity 3 Graphing |
Download and open file 'Square numbers'. Examine
the effect of changing the numbers and what happens to the graph. Create from scratch a similar workbook for the formulae y=2x and y=x+3 |
Square numbers |
| Activity 4 | Prepare a spreadsheet model to find out the
maximum area that can be included in a rectangular field of fixed perimeter. Graph of the areas to see where the maximum point is. |
Fields and fences |
