Search billions of records on Ancestry.com
   
Website logo - Click to go to Home page



European Computer Driving Licence

Module 4

Module 4 - Spreadsheets
The following is the Syllabus for Module 4, Spreadsheets, which provides the basis for the practice-based test in this module domain.
Module Goals Module 4 - Spreadsheets , requires the candidate to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she shall understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The candidate shall be able to accomplish standard mathematical and logical operations using basic formulas and functions. The candidate shall demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.
Category Skill Set Ref. Task Item
4.1 Getting Started 4.1.1 First Steps with Spreadsheets 4.1.1.1 Open a spreadsheet application.
4.1.1.2 Open an existing spreadsheet - make some modifications and save.
4.1.1.3 Open several spreadsheets.
4.1.1.4 Create a new spreadsheet and save.
4.1.1.5 Save an existing spreadsheet onto the hard disk or a diskette.
4.1.1.6 Close the spreadsheet.
4.1.1.7 Use application Help functions.
4.1.1.8 Close the spreadsheet application.
4.1.2 Adjust Basic Settings 4.1.2.1 Change spreadsheet view mode.
4.1.2.2 Use the page view magnification tool/zoom tool.
4.1.2.3 Modify toolbar display.
4.1.3 Document Exchange 4.1.3.1 Save an existing spreadsheet under another file format: txt file, document template, software type or version number etc.
4.1.3.2 Save a document in a format appropriate for posting to a Web Site.
4.2 Basic Operations 4.2.1 Insert Data 4.2.1.1 Enter numbers in a cell.
4.2.1.2 Enter text in a cell.
4.2.1.3 Enter symbols or special characters in a cell.
4.2.1.4 Enter simple formulas in a cell.
4.2.1.5 Use the undo command.
4.2.2 Select Data 4.2.2.1 Select a cell or range of adjacent or non-adjacent cells.
4.2.2.2 Select a row or column. Select a range of adjacent or non-adjacent rows or columns.
4.2.3 Copy, Move, Delete 4.2.3.1 Use the Copy and Paste tools to duplicate cell contents in another part of a worksheet.
4.2.3.2 Use the Cut and Paste tools to move cell contents within worksheet.
4.2.3.3 Move cell contents between active worksheets.
4.2.3.4 Move cell contents between active spreadsheets.
4.2.3.5 Delete cell contents in a selected cell range.
4.2.4 Search and Replace 4.2.4.1 Use the search command for specified cell content.
4.2.4.2 Use the replace command for specified cell content.
4.2.5 Rows and Columns 4.2.5.1 Insert rows and columns.
4.2.5.2 Modify column width and row height.
4.2.5.3 Delete selected rows or olumns.
4.2.6 Sort Data 4.2.6.1 Sort selected data in ascending or descending numeric order.
4.2.6.2 Sort selected data in ascending or descending alphabetic order.
4.3 Formulas and Functions 4.3.1 Arithmetic and Logical Formulas 4.3.1.1 Use basic arithmetic and logical formulas in a spreadsheet addition, subtraction, multiplication, division.
4.3.1.2 Recognise standard error messages associated with formulas.
4.3.1.3 Use the autofill tool/copy handle tool to copy or increment data entries.
4.3.1.4 Understand and use relative cell referencing in formulas or functions.
4.3.1.5 Understand and use absolute cell referencing in formulas or functions.
4.3.2 Working with Functions 4.3.2.1 Use the sum function.
4.3.2.2 Use the average function.
4.4 Formatting 4.4.1 Format Cells - Numbers 4.4.1.1 Format cells to display different number styles: number of decimal places, number of zeros after the decimal point, with or without commas to indicate thousands.
4.4.1.2 Format cells to display different date styles.
4.4.1.3 Format cells to display different currency symbols.
4.4.1.4 Format cells to display numbers as percent-ages.
4.4.2 Format Cells - Text 4.4.2.1 Change text size. Format text: bold, italic, font type.
4.4.2.2 Change text font colour.
4.4.2.3 Adjust text orientation.
4.4.3 Format Cells - Cell Ranges 4.4.3.1 Centre and align cell contents in a selected cell range: left and right; top and bottom.
4.4.3.2 Add border effects to a selected cell range.
4.4.4 Spelling 4.4.4.1 Use a spell-check program and make changes where necessary.
4.4.5 Document Setup 4.4.5.1 Modify document margin settings.
4.4.5.2 Adjust document setup to fit one page.
4.4.5.3 Add a Header and Footer.
4.4.5.4 Change document orientation - portrait or landscape, page size etc.
4.5 Printing 4.5.1 Printing simple spreadsheet documents 4.5.1.1 Use basic print options.
4.5.1.2 Preview a spreadsheet.
4.5.1.3 Print a spreadsheet or a worksheet.
4.5.1.4 Print part of a worksheet or a pre-defined cell range.
4.6 More Advanced Features 4.6.1 Importing Objects 4.6.1.1 Import objects into a spreadsheet: image files, graphs, text files etc.
4.6.1.2 Move and resize imported objects within a spreadsheet.
4.6.2 Charts and Graphs 4.6.2.1 Produce different types of charts and graphs from spreadsheet figures to analyse data, e.g. pie charts, column charts, bar charts.
4.6.2.2 Edit or modify a chart or graph: add a title or label, change the scale. Modify the colours in the chart or graph.
4.6.2.3 Change the chart type.
4.6.2.4 Move and delete charts or graphs.

JGC Logo Valid HTML5 Logo HTML5 Logo Valid CSS3 Logo JGC Logo
Copyright logo
This page (ecdlmod4.html) was last modified on Sunday 27/01/2013