ECDL modules

MODUL 1 - INFORMATION TECHNOLOGIES BASIC CONCEPT 
General knowledge of principles of computer, software, hardware, input and output devices, types of memory devices, etc.   

MODUL 2 - USE OF THE COMPUTER AND OPERATING THE FILES

Working in a Windows environment, the basics of working with folders and files, the use of integrated tools.

MODUL 3 - TEXT EDITOR - MS WORD 
The basics of working in a word processing program (Microsoft Word)

MODUL 4 - SPREADSHEET PROGRAM - MS EXCEL 
The basics of the program for the electronic tables (Microsoft Excel)

MODUL 5 - DATA BASE - MS ACCESS 
The basics of creating and maintaining databases (Microsoft Access)

MODUL 6 – PROGRAMME FOR PRESENTATION AND DRAWING 
Basic techniques of multimedia presentations (Microsoft PowerPoint)

MODUL 7 - INTERNET AND E-MAIL - MS OUTLOOK
Basics of the Internet browser and work in the program for e-mail (Microsoft Internet Explorer and Outlook)

MODULE 1

INFORMATION TECHNOLOGIES BASIC CONCEPT

I Section – Information technologies basic concept
Basic computer components
Concept of the operating system
Functioning of the computer program
Concept of data saving
Basic memory units - byte
Development of the computer systems
GUI – Graphic user interface, the functioning principles
Understanding the multimedia concept

II Section – Applications and using of the computer
Importance of the computer usage and the possibilities of this usage
Types and characteristics of the computer systems used in business
Types and characteristics of the computer systems used in industry
Types and characteristics of the computer systems used in education
Types and characteristics of the computer systems used at home, for domestic budget and working at home
Types and characteristics of the computer systems used in everyday life, for example in supermarkets, libraries, ordination
Usage of the smart cards
System and application software

III Section – Information technologies and society, ergonomic
Results of the increasing usage of the computer
Concept of the "Informatics society"
Usage of the computer in case of higher reliability
Steps in case of breakdown
Possible danger on health and safe of the computer users
Consequences of working with computer in inadequate circumstances
IV Section - Security, author rights and legislation
Author right and copy of the legal issues
Data protection, request for identification while entering protected data
Protection of the personal data
Security and protection of the computer, data, codes, data copy
Viruses and anti-virus programmes, way of virus entering the computer system and way of protection
Steps in case of electricity blackout

V Section – Hardware and software
Difference between hardware and software
Characteristics of the different memory types, RAM and ROM
Types of memory, capacity and save
Function of in- and outgoing parts
Different printer types and their usage
Speed and capacity of the computer, clock, memory and processor

VI Section – Net services
Communication using modern information systems
E-mail
Hardware and software needed for E-mail on PC
Connection to communication net
Internet – Characteristics and basic services
Technology of computer network
LAN, WAN, global net


MODULE 2

USE OF THE COMPUTER AND OPERATING THE FILES

Start and shut down of the computer
Parts of desktop and windows
Desktop setting
Work with basic programmes in Windows (WordPad, Paint, NotePad), create and save
Basic rules of use Windows Explorer
Create of folders and understanding structure of the maps
Searching content of the folders, number of files, size of files and data of the classified files
Operation with files (copy, remove, delete and rename)
Format of disc
Spare copy of floppy disc, onto another floppy disc or hard disc (HDD) or into another map on disc
Archiving of files onto floppy disc
Choosing printer from the list of printers to install
Operation with Recycle Bin
Finding files or folders (order Find)
Setting of parameters in Control Panel

MODULE 3

TEXT EDITOR - MS WORD

Finding and starting programme for text processing
Elements of Word - window and setting of the window elements
Archiving and open existing file
Write, insert, and delete of text
Moving throw the text
Selecting of the text
Using options from menu File
Using options from menu Edit (Find, Replace)
Create header and footer
Use of options from menu Format, basic operations of text edit
Use of options from menu Insert (date, footnote, picture, object)
Move and copy of text inside file and between files
Use of drawing tools 
Use of spelling
Printing of files
Changing page break
Page numbers
Mail merge
Insert and edit table, menu Table
Use of tabs
Create and use of style
Use of templates
Integrating programme for text edit with another programmes (tables, data base, graphic design)
Use of options from menu Tools
Use of Help functions



MODULE 4

SPREADSHEET PROGRAM - MS EXCEL
 
Finding and starting of Excel
Elements of Excel window and setting of form and content of the window
Moving and marking in worksheet and map
Inserting, changing and deleting of data in cells
Archiving and opening files with tables and inserting changes
Series of data (rows), create and use
Inserting of rows and columns and calculate new values
Creating of tables and data inserting: numbers, text, formulas
Cell format, number of decimals, values, etc.
Data sorting in the table
Using of basic mathematical and logical function: SUM, AVERAGE, IF, MIN, MAX
Printing of tables
Creating of header and footer
Understanding and using of relative and absolute address in formulas
Creating different diagrams and charts from tables and analyses of data
Editing of charts (title and axis, legend, labels)
Creating formulas between tables
Using of integral software wich has text processor, data base and graphic software.
Using of Help functions

MODULE 5

DATA BASE - MS ACCESS
 
Introduction in data base
Relation data base
Outlook and basic elements of Access window
Planning of data base
Creating the entries
Entering of data in the base
Saving and opening of data base
Entering and classification of data
Adding and deleting of entries
Defining simple questions
Defining question on given criteria
Defining question by using the tables
Work with forms, creating forms with Wizard and tools
Searching, choosing and sorting of data by given criteria
Representation of chosen data in separated place on the screen and in the report
Finding and logging in the existing data base
Modifying the structure of data base
Work with macros
Using of Help functions

MODULE 6

PROGRAMME FOR PRESENTATION AND DRAWING

Basic notion of presentation
Adding a new slide in the presentation
Different ways of slide show
Basic rules and tools for formatting
Insert of Text-box
Using of existing symbols and signs from Clip-art 
Drawing of simple drawings
Using of frames
Text editing (font, style, justify, numbering)
Animation of objects inside the slide
Adding diagrams
Using Slide show for preparing of presentation
Packing and moving of presentation
Creating of Web presentation


MODULE 7

INTERNET AND E-MAIL - MS OUTLOOK

Access to Internet
World Wide Web and Web addresses
Internet browser
Searching in Internet
Connecting and logging in on e-mail
Sending and receiving messages with e-mail
Composing and opening message with attachments
Saving of mails
Printing of messages