SOFTWARE SKILLS
Excel 2007: General spreadsheet tasks
The ticks indicate the suitability of resources for each Key Stage.
Resource |
KS3 |
KS4 |
KS5 |
Click Here |
Introduction to spreadsheets
Skills covered:
- Entering data
- Widen columns
- Basic formatting
- Autosum
- Insert row
- Delete row
- Header and footer
- Show gridlines
Kindly contributed by Jo Wallace from City of Bath College |
 |
|
|
Task |
Basic formatting task
Skills covered:
- Entering data
- Widen columns
- Format to 2dp
- Autosum
- Insert row
- Insert header
Kindly contributed by Jo Wallace from City of Bath College |
|
|
|
Task
|
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 |
Disco Task (2012 new version*)
Skills covered:
- enter data
- widen columns
- text formatting
- wrap text
- merge cells
- rename tabs
- delete worksheets
- insert worksheet
- copy worksheet
- multiplication formula
- SUM formula
- format as currency
- insert rows
- absolute cell reference
- insert footer
- borders
- cell alignment
- format date
- find and replace
- Undo
- format painter
- sort data
* this is NOT the same as the 2003 version of the disco task |
|
|
|
|
Burgers Task (2012 brand new version*)
Skills covered:
- rename tabs
- delete worksheet
- column widths
- text formatting
- SUM, AVERAGE, MIN, MAX formula
- replicate formula
- cell formatting - colours, borders, underline
- insert rows
- merge and centre
- decimal places
- select non adjacent columns
- column chart
- change chart style
- change chart colour
- add titles, axis labels
- move, resize chart
- undo, redo
* this is NOT the same as the 2003 version of the burgers task. It is a completely new task. |
|
|
|
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
|
|
|
|
Task
|
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
|
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
