ECDL & Diploma in Office Administration Skills

At the end of this Module the learner should be able to:

• Understand key concepts relating to ICT, computers, devices and software.
• Start up and shut down a computer.
• Work effectively on the computer desktop using icons, windows.
• Adjust the main operating system settings and use built-in help features.
• Create a simple document and print an output.
• Know about the main concepts of file management and be able to efficiently organise files and folders.
• Understand key storage concepts and use utility software to compress and extract large files.
• Understand network concepts and connection options and be able to connect to a network.
• Understand the importance of protecting data and devices from malware, and the importance of backing up data.
• Recognise considerations relating to green IT, accessibility, and user health.

At the end of this Module the learner should be able to:

• Understand the key concepts relating to online collaboration and cloud computing.
• Set up accounts to prepare for online collaboration.
• Use online storage and web-based productivity applications to collaborate.
• Use online and mobile calendars to manage and plan activities.
• Collaborate and interact using social networks, blogs, and wikis.
• Schedule and host online meetings and use online learning environments.
• Understand key mobile technology concepts and use features such as e-mail, applications, and synchronisation.

At the end of this Module the learner should be able to:

• Work with documents and save them in different file formats.
• Choose built-in options such as the Help function to enhance productivity.
• Create and edit small-sized word processing documents that will be ready to share and distribute
• Apply different formats to documents to enhance them before distribution and recognise good practice in choosing the appropriate formatting options.
• Insert tables, images and drawn objects into documents.
• Prepare documents for mail merge operations.
• Adjust document page settings and check and correct spelling before finally printing documents.

At the end of this Module the learner should be able to:

• Work with spreadsheets and save them in different file formats.
• Choose built-in options such as the Help function within the application to enhance productivity.
• Enter data into cells and use good practice in creating lists.
• Select, sort and copy, move and delete data.
• Edit rows and columns in a worksheet.
• Copy, move, delete and appropriately rename worksheets.
• Create mathematical and logical formulas using standard spreadsheet functions.
• Use good practice in formula creation and recognise error values in formulas.
• Format numbers and text content in a spreadsheet.
• Choose, create and format charts to communicate information meaningfully.
• Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets.

At the end of this Module the learner should be able to:

• Understand what a database is and how it is organised and operated.
• Create a simple database and view the database content in various modes.
• Create a table, define and modify fields and their properties; enter and edit data in a table.
• Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database.
• Understand what a form is and create a form to enter, modify and delete records and data in records.
• Create routine reports and prepare outputs ready for distribution.

At the end of this Module the learner should be able to:

• Work with presentations and save them in different file formats.
• Understand different presentation views and when to use them, choose different slide layouts and designs.
• Enter, edit and format text in presentations.
• Recognise good practice in applying unique titles to slides.
• Choose, create and format charts to communicate information meaningfully.
• Insert and edit pictures, images and drawn objects.
• Apply animation and transition effects to presentations and check and correct presentation content before finally printing and giving presentations.

At the end of this Module the learner should be able to:

• Understand and identify the main concepts underlying the secure use of ICT in daily life.
• Use relevant techniques and applications to maintain a secure network connection.
• Use the Internet safely and securely.
• Manage data and information appropriately.
• Understand the key concepts relating to the importance of secure information and data, physical security, privacy and identity theft.
• Protect a computer, device or network from malware and unauthorised access
  Understand the types of networks, connection types and network specific issues including firewalls.
• Browse the World Wide Web and communicate on the Internet securely.
• Understand security issues related to communications including email and instant messaging.
• Backup and restore data appropriately and safely, and securely dispose of data and devices.