Syllabus Link
|
Viewlet Presentation Number
|
S1. Understand and Use a Spreadsheet
|
ES1
|
S1
|
S2
|
S3
|
| S-SL1 |
7000
|
Understands the purpose/structure of a spreadsheet
|
|
|
I
|
R
|
| S-SL2 |
7001 |
Interprets data from a simple existing spreadsheet
|
|
|
I
|
R
|
| S-SL3 |
7002 |
Understands terminology - column, row, cell
|
|
|
I
|
R
|
| S-SL4 |
7003 |
Understands cell addressing
|
|
|
I
|
R
|
|
7004 |
Understands active cell
|
|
|
I
|
R
|
| S-SL6 |
7005 |
Enters data (labels, values) in a cell
|
|
|
I
|
R
|
| S-SL7 |
7006 |
Edits data in a cell (bold, alignment etc)
|
|
|
I
|
R
|
| S-SL9 |
7007 |
Changes column width and row height
|
|
|
I
|
R
|
| S-SL10 |
7008 |
Adds a column
|
|
|
I
|
R
|
| S-SL10 |
7208 |
Adds a row |
|
|
I
|
R
|
| S-SL10 |
7308 |
Deletes a column |
|
|
I
|
R
|
| S-SL10 |
7408 |
Deletes a row |
|
|
I
|
R
|
| S-SL10 |
7508 |
Moves a column |
|
|
I
|
R
|
| S-SL10 |
7608 |
Moves a row |
|
|
I
|
R
|
| S-SL11 |
7009 |
Uses sum formula and undertakes basic calculations
|
|
|
I
|
R
|
|
7010 |
Generates appropriate graphs - bar, column, line
|
|
|
I
|
R
|
| S-SL15 |
7011 |
Prints selected area
|
|
|
I
|
RU
|
|
7012 |
Understands the concepts of text, numbers and formulas in a
cell
|
|
|
|
I
|
|
7013 |
Formats data to currency, time, number, percentage
|
|
|
|
I
|
|
7015 |
Create simple calculation formulas
|
|
|
|
O
|
|
7016 |
Sorts data
|
|
|
|
O
|
|
7017 |
Filters data
|
|
|
|
O
|
|
7018 |
Works with Ranges
|
|
|
|
O
|
|
7019 |
Uses basic functions (sum, average, max, min, count)
|
|
|
|
O
|
|
7020
|
Uses fill down/across
|
|
|
|
O
|
