IT USER SVQ – LEVEL 2 - SQA



IT User SVQ — Level 1

Unit Title — DJ5E 04 Spreadsheet Software 1

NB: It is possible to achieve this unit by APA, however, the relevant evidence must be referenced within the portfolio

|Skills and Techniques |

|a Handling files |

|Expansion — Using basic file handling techniques for the software, such as create, open, save (as) and print. |

|b Combining information |

|Expansion — Using basic techniques to combine information, such as insert, size and position. |

|c Entering and editing spreadsheet data; Formatting spreadsheets, Checking spreadsheets using basic tools |

|Expansion — Inserting data into single cells. Using basic editing techniques appropriately in simple spreadsheets such as: add and delete rows and columns and clear cells; and cut, copy, paste, drag and drop,|

|find and replace. Formatting simple spreadsheets using appropriate tools and techniques for: cells — such as numbers, decimal place, font and alignment; rows and columns — such as height, width, borders and |

|shading; charts — such as titles and labels; and pages — such as size, orientation, margins, page numbers, date and time. Checking if figures entered in a simple spreadsheet are correct. |

|NB: A selection from the list is required, although the list is not exhaustive. |

|d Using simple functions and formulae |

|Expansion — Use appropriate functions and formulas in simple spreadsheets, such as sum, operators and fractions. |

|NB: A selection from the list is required, although the list is not exhaustive. |

|e Analysing and interpreting, and presenting simple data |

|Expansion — Using appropriate tools and techniques for analysing simple data, such as automatic sub-totals and sorting a cell range. Using appropriate methods to present simple data, such as tables, bar |

|graphs, pie charts and lists. |

|NB: A selection from the list is required, although the list is not exhaustive. |

|Knowledge and Understanding (K & U) |

|1 How to produce information that is suitable. Know who and what the information is for, where it will be used (eg on screen or hard copy) and when it is needed). |

|2 Understand how to produce simple spreadsheets that are accurate and well laid out. Simple documents will have structure that is simple and producing them may involve entering data into an existing |

|spreadsheet or working from an existing example. |

|3 How to analyse and interpret, simple data and understand the methods used for simple data. |

IT User SVQ — Level 1 Candidate Name: __________________________

(Please Print Name)

Unit Title — DJ5E 04 Spreadsheet Software 1 Assessor Name: __________________________

(Please Print Name)

NB: It is possible to achieve this unit by APA, however, the relevant evidence must be referenced within the portfolio

|Enter data into cells and use spreadsheet software effectively to produce simple spreadsheet documents |

|Ref |Evidence Description |Skills and Techniques |K & U |

|No. |(Minimum of two straightforward tasks) | | |

| |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download