SOFTWARE SKILLS
Excel 2003: General spreadsheet tasks
The ticks indicate the suitability of resources for each Key Stage.
Resource |
KS3 |
KS4 |
KS5 |
Click Here |
Workbook 1
Skills covered:
- Basic formulae
- Basic functions
- Displaying formulae
|
|
|
|
  
Task |
Discos Task
Skills covered:
- Basic formatting
- Word wrap
- Renaming a tab
- Deleting a worksheet
- Inserting a worksheet
- Basic formulae
- Basic functions
- Using the help menu
- Inserting rows
- Deleting a column
- Merging cells
- Footers
- Adding an image
- Absolute cell reference
- Entering and formatting the date
- Format painter
- Making a copy of the sheet
- Sorting data in a table
- Aligning text
- Text orientation
- Borders
- IF formula
- Charts
- Setting the print area
|
|
|
|
Task
discos.xls |
Formatting task
This workbook provides a clear step-by-step series of tasks to both show students and enable them to practice many of the common formatting and printing techniques. |
|
|
|
Task |
Burgers Task
Skills covered:
- Suitable column widths
- Renaming tabs
- Basic formatting
- Basic formulae
- Basic functions
- Sorting data
- Find tool
- Charts
- Absolute cell reference
- IF formula
- Setting print area
|
|
|
|
Task
burgers.xls |
Ringtones Task
Skills covered:
- Setting up a basic spreadsheet
- Basic formulae
- Basic functions
- Basic formatting
- Format painter
- Formatting currency
- Merging cells
- Adding and removing toolbars
- Freezing panes
- Hiding a column
- Creating a copy of the workbook
- Switching between windows
- Saving as a template
- IF formula
- Column chart
- Chart formatting
- Setting printing options
- Find and replace tool
- Sorting data in a table
|
|
|
|
Task
ringtones.xls |
|
Skills covered:
- Planning a spreadsheet
- Basic formulae
- Fitting to one page
- Printing gridlines
- Showing row and column headers
- Displaying formulae
(subscription only) |
|
 |
|
Task
|
Skiing Task
Skills covered:
- Setting up a spreadsheet
- Basic formula and functions
- Formatting a spreadsheet
- Inserting rows
- Borders
- Headers and footers
- Printing options
- Sorting data
- Hiding a column
|
|
|
|
Task
skiing.xls |
Supermarket Comparisons Task
Skills covered:
- Setting up a spreadsheet
- Basic formula and functions
- Formatting a spreadsheet
- Resizing columns
- Footers
|
|
|
|
|
Groovy Music
Skills covered:
- merge cells
- wrap text
- align titles
- basic formulae
- basic functions
- formatting cells
- borders
- gridlines
- sort data
- auto filter
- footers
- hiding cells
- freeze pane
- print area
- show formulas
- IF formula
- VLOOKUP
- charts
- absolute cell reference
|
|
|
|
Task (2003)
|
Online auctions
This spreadsheet exercise provides students with an opportunity to practise:
- adjusting column widths
- basic formatting and cell alignment
- inserting new columns and rows
- MIN, MAX and AVERAGE formulae
Extension tasks are provided
Contributed by Jon Bridgeman of Finham Park School |
|
|
|
auctions.xls |
Spreadsheet test
A test which should take most of an ICT lesson.
A good way to check the level of your students' skills
|
|
|
|
test instructions
test marksheet
completed spreadsheet
|
Copyright © www.teach-ict.com
