ECDL Advanced Tipperary Clonmel Kilkenny Waterford

Quicklinks to Training Courses


		Home
		Locations
		Contact Us


		Scheduled Courses
		Custom Solutions
		Services to Business
		Testing Available
		Accreditations
		Pay As You Learn
		News & Events


		Student Login
		Tutor Login

ECDL MODULE 4

Spreadsheets

The module tests the student's understanding of fundamental spreadsheet concepts, practical experience in spreadsheet design and implementation, and the understanding of the basic functions.

One exercise will be set. The tasks set will depend on the spreadsheet product in use. The exercise consists of basic and advanced tasks.

Basic Tasks

Open a spreadsheet file, make changes to it, add rows calculate new values.
Insert rows and columns -- create a new row or column in a specific place.
Create a spreadsheet and enter data
- Numbers
- Text
- Formulae
Format cells -- e.g. size, decimal points, currency, etc.
Adjust column widths and format columns and rows.
Sort the spreadsheet
Use the basic functions of a spreadsheet, such as
- Totalling
- Averaging
Print and save a spreadsheet
Create a header and footer
Use Help Functions

Advanced Tasks

Understand and use absolute and relative cell referencing in formulae.
Produce different types of charts and graphs from a spreadsheet figures to analyse the data.
Retrieve graphs from disc
Print graphs with titles and labels
Use 3--dimensional graphics
Move information between spreadsheets
Work with more than one spreadsheet
Use integrated software

Assessment

One exercise will be set, which will contain 8--10 tasks.

The five basic tasks must be completed correctly and the advanced tasks must be attempted. The pass mark is 100% for the basic tasks and 50% for the advanced tasks.

45 minutes is allowed for the test.


	Back to ECDL Main Page Next Module >