Summary
This course is for computer users who have limited or no computer experience, and may be used to help prepare for the International Computer Driving License Examination, Syllabus Version 4.0. The course provides an overview of computer hardware, software, storage, security and copyright considerations. This course also provides introductory instruction on using a PC and managing files, and using various PC applications including word processing, spreadsheet, database, presentation, browser, and electronic mail applications. The International Computer Driving Licence (or ICDL) is the registered trade mark of The European Computer Driving Licence Foundation Limited in Ireland and other countries. Presentation of the ICDL logo above, signifies that the courseware material distributed through this website has been developed by MindLeaders and has received the approval of the ECDL Foundation Ltd.
Certification:
The test that this series prepares students to take is a part of earning the International Computer Driving Licence (ICDL) 4.0 certification.
Audience:
This series is for those people who have never used a computer and for those who have some computer experience but no formal qualification proving their knowledge or skills. It is also for those people who are preparing to take the International Computer Driving Licence examination.
Summary
Modules Est. time
Concepts of Information Technology (IT) 3 hrs
Using the Computer and Managing Files 6 hrs
Word Processing 5 hrs
Spreadsheets 9 hrs
Database 5 hrs
Presentation 6 hrs
Information and Communication 6 hr
Concepts of Information Technology (IT)- 3 hrs
This course provides an overview of computer hardware and software, networking, and the use of computers in a number of everyday applications.
Topic:
- Information technology
- Understanding computer types
- Main parts of a personal computer
- Computer performance
- Input and output
- Computer storage devices
- Software
- Types of software
- Systems development
- Networks
- The electronic world
- Health
- safety
- and environment
- Security
- Copyright and the law
Using the Computer and Managing Files- 6hrs
This course shows learners how to start, shut down, and restart the computer; display system and desktop information and online help; work with icons and windows; organise files and folders; and edit and print data.
Topic:
- Starting and shutting down the PC
- Displaying system information
- Changing the PC's desktop configuration
- PC setup operations
- Introduction to icons
- Working with desktop icons
- Working with windows
- Using help
- Text editing
- File management
- Working with folders and files
- Deleting and restoring folders and files
- Searching for folders and files
- Compressing files
- Viruses
- Printer setup
Word Processing- 5 hrs
This course shows learners how to use a word processing application to create documents and manipulate and format text. It also shows how to prepare a document for printing, preview and print a document, create tables, import objects, and merge a mailing list with a document.
Topic:
- Opening and closing a word processing application and documents
- Saving documents
- Adjusting settings
- Inserting data
- Selecting and editing data
- Copying
- moving
- and deleting text
- Search and replace
- Formatting text
- Working with text formats
- Working with paragraphs
- Working with lists and borders
- Document formatting
- Headers and footers
- Creating tables
- Working with tables
- Inserting pictures
- images
- and charts
- Working with pictures
- images
- and charts
- Mail merge
- Preparing documents for output
- Printing documents
Spreadsheets- 9hrs
This course shows learners how to work with a spreadsheet application to insert and manipulate data. It also shows how to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts.
Topic:
- Opening and closing spreadsheets
- Creating and saving spreadsheets
- Using help
- Adjusting settings
- Cells
- Rows and columns
- Editing data
- Copying data
- Moving and deleting data
- Find and replace
- Sorting data
- Handling worksheets
- Working with formulas
- Cell referencing
- Working with functions
- The IF function
- Formatting numbers and dates
- Formatting cell contents
- Working with alignments and border effects
- Creating charts and graphs
- Editing charts and graphs
- Worksheet setup
- Printing worksheets
Database- 5 hrs
This course shows learners how to work with a database application to create a database; create, use, and change a data entry form; retrieve information; and create reports.
Topic:
- Database concepts
- Opening and closing a database application
- Adjusting settings
- Defining table fields
- Finalising tables
- Creating table relationships
- Adding and revising records
- Working with forms
- Searching records
- Filtering and sorting records
- Queries
- Advanced query functions
- Creating reports
- Working with reports
- Printing information
Presentation- 6 hrs
This course shows learners how to work with a presentation application to insert, manipulate, and format text, images, and slides. It also shows how to draw objects and produce charts for a presentation; how to print and distribute a presentation; and how to add special effects to a slide presentation.
Topic:
- Opening and closing an application and presentations
- Using help
- Adjusting settings
- Presentation views
- Slides and design templates
- The master slide
- Adding and editing text
- Formatting the slide layout
- Inserting images
- Creating charts and graphs
- Creating organisational charts
- Drawing objects
- Editing drawn objects
- Copying
- moving
- and deleting objects
- Adding slide show effects
- Preparing presentations
- Printing and delivering a presentation
Information and Communication- 6 hrs
This course shows learners how to open a Web browsing application, search for information on the Web, and use electronic mail to send and receive messages.
Topic:
- Internet concepts
- Security considerations
- Using a Web browser
- Adjusting settings
- Accessing Web pages
- Using bookmarks
- Using a search engine
- Printing Web pages
- E-mail concepts and security considerations
- Opening and closing an e-mail application
- Using help
- Adjusting settings
- Reading mail messages
- Replying to mail messages
- Sending mail messages
- Advanced messaging options
- Copying
- moving
- and deleting messages
- Mail management techniques
- Using address books
- Organizing messages
Printing messages
Purchase this course from our e commerce site at www.AuditExcel.com
|
Downloads and Free Trial
See how it
works with our
free Excel 2003
beginner course.
OR 
Convince you manager to pay for your education
OR 
More about the training material and how it works
Looking for something else? Search the site
|
.gif)
.gif)
