Computer PC OFFICE Objectives of the course The International Computer Driving Licence (ICDL), or International Driving Licence Computer , is a certificate attesting the knowledge of the main information technology concepts and the use of a personal computer in its applications the most common. To own this certification, involves the overcoming of seven exams, one theoretical and six practical; the ICDL is an international certification and its goal is to improve the level of knowledge of the information technologies and provide a recognized qualification in the world of work. It’s addressed to all those who are starting using the personal computer and to those who already use it but they improve their knowledge with the aim to sell themselves on the labor market with an internationally recognized qualification. Finally in Europe it also helps to increase your score in public competitions Prerequisites To follow this course you don’t need any prerequisites. Employment opportunities and Credits This course is the necessary basis for undertaking any informatic profession, but also presents itself as an attractive opportunity for those who, while are working in any other context, they want to interface with new technologies in everyday life Certifications that can be achieved by following this course This course aims to provide the necessary preparation for support the 7 exams of the European Computer Driving Licence Every students can decide to try to make the exams of ECDL or not. Course Syllabus Basic Concepts of ICT (Concepts of Information and Communication Technology) Using the computer and managing the Files (Using the Computer and Managing Files) Word processing (Word processing) Word Spreadsheet (Spreadsheets) Excel Use of databases (Using Databases) Access Presentation Tools (Presentation) Power Point Navigation and communication in the www network (Web Browsing and Communication) Internet Module 1 - Fundamentals What is an algorithm, what it is and how to represent it through the use of Diagrams The representation of the data and the different numbering systems Differences between the main programming languages Logical Operators Module 2 - Hardware Distinguish the hardware components in a personal computer and learn about their impact on the performance of a computer. To identify the most common types of computers and mobile devices To know the purpose of the most commonly used softwares Networks Types of existing networks and different speed of transfer of information ICT The Technologies of everyday life; learn about the different Internet services and learn the terms related to the world of communication and virtual communities Outlook Health Protection of the health of those who work frequently to the personal computer Recycling and Energy-saving environmental protection Safety Data Security Firewall Virus and Antivirus Legal Aspects Protection of personal data Copyright and reproduction rights Module 3 - Using the Computer and Managing Files Operating System How to start and shut down the computer Help Modify desktop settings Display the hardware features of the computer Install and uninstall software Management of your desktop icons and of the windows Managing Files and Folders Organizing Files and Folders (create, move, delete ) Recognize the different types of the files, estimate its size and exportability on differents media storage Antivirus Install and use antivirus software properly Print Management Create a document with a video editing software Starting and stopping the printing of a document Module 4 - Word Processing Creating a document Create a new document and save it in different formats Modify settings words ( user name etc. . ) Customize the working environment with the management of the toolbars Setting up the document , margins, header, footer Selections Select a word, paragraph, or entire document Perform copy / cut / paste portions of text Formatting Modify formatting of individual words and paragraph Styles Apply character styles and paragraph styles Use the Format Painter Formatting tables and graphic objects Using the Mail Merge function Print Trim and prepare a document for printing (spell check) Inserting breaks page Inserting page numbers Print Settings Module 5 - Spreadsheet (Spreadsheets) Excel Creating a spreadsheet Create a new spreadsheet and save it in different formats Customize the working environment with the management of the toolbars Use the correct data by formatting the cell depending on the type of data entered Selections Select a cell or groups of cells, columns and rows Perform copy / cut / paste Perform sort operations Assign names to cells and groups of cells Formatting Modes care formatting of individual cells or groups of cells Formulas Set simple arithmetic formulas Use function sum, average, minimum, maximum, count, count nonblank cells in a range, rounding Logic Function IF Charts Create and modify Charts Understand what type of chart is best suited to represent a certain set of data Print Finish a spreadsheet and prepare for printing Inserting breaks page Inclusion of information in the header and footer Automatic printing of lines title Partial content Print Settings Module 6 - Use of databases (Using Databases): Access Database in everyday life Understand what areas and for what purposes are commonly used databases Concept of data and information Designer User Admin Structure of a Database Fields Record Tables Relations Primary keys and Indexes Creating a database Analysis Design Creation Query Set Query Using Logical Operators and Wildcards Creating and Modifying Forms and Reports Printing of various objects in a database Module 7 - Presentation Tools (Presentation): Power Point Creating a Presentation Create a new presentation using predefined templates Create a new presentation using predefined layouts Add new slides Save a presentation in different formats Work Environment Modify powerpoint settings (user name etc..) Customize the working environment with the management of the toolbars Different modes of viewing slide shows Formatting Formatting text, tables and graphics Creating and managing organizational charts and graphs Finish the presentation Insertion of animation and transition effects Print the presentation of different media and with different format Module 8 - Navigation and communication network (Web Browsing and Communication) Fundamental Concepts What is the WWW, Internet Service Provider (ISP), URLs, hyperlinks, RSS Feed, Podcast Safety Protocol https, Firewall, Virus, Worms, Trojanorses, Spyware, Password Using the Browser Saving web pages and print Module 9 - Concepts and terms related to electronic communication SMS, VoIP, IM Security: Phishing, digital signature
Posted on: Fri, 02 May 2014 09:09:40 +0000
Trending Topics
Recently Viewed Topics
© 2015