| Lessons released: Detailed Directory |
|
Module 1 - Concepts of Information Technology (IT)
Module 2 - Using the Computer and Managing Files
Module 3 - Word Processing
Module 4 - Spreadsheets
Module 5 - Database
Module 6 - Presentation
Module 7 - Information and Communication
Module 1 - Concepts of Information Technology (IT) [Top]
General Concepts: Hardware, Software, Information Technology
1.1.1.1 Understand the terms hardware, software, Information Technology (IT).
Types of Computer
1.1.2.1 Understand and distinguish between mainframe computer, network computer, personal computer, laptop, personal digital assistant (PDA) in terms of capacity, speed, cost, and typical users.
Main Parts of a Personal Computer
1.1.3.1 Know the main parts of a personal computer such as: central processing unit (CPU), hard disk, common input and output devices, types of memory. Understand the term peripheral device.
Computer Performance
1.1.4.1 Know some of the factors that impact on a computer’s performance such as: CPU speed, RAM size, the number of applications running.
Hardware: Central Processing Unit
1.2.1.1 Understand some of the functions of the CPU in terms of calculations, logic control, immediate access memory. Know that the speed of the CPU is measured in megahertz (MHz) or gigahertz (GHz).
Memory
1.2.2.1 Understand different types of computer memory such as: RAM (random-access memory), ROM (read-only memory) and distinguish between them.
1.2.2.2 Know how computer memory is measured: bit, byte, KB, MB, GB, TB. Relate computer memory measurements to characters, files and directories/folders.
Input Devices
1.2.3.1 Identify some of the main devices for inputting data into a computer such as: mouse, keyboard, trackball, scanner, touchpad, lightpen, joystick, digital camera, microphone.
Output Devices
1.2.4.1 Identify common output devices for displaying the results of processing carried out by a computer, such as: monitors, screens, printers, plotters, speakers. Know where these devices are used.
Input/Output Devices
1.2.5.1 Understand some devices are both input/output devices such as: touchscreens.
Storage Devices
1.2.6.1 Compare the main types of memory storage devices in terms of speed, cost and capacity such as: diskette, Zip disk, data cartridges, CD-ROM, internal, external hard disk.
1.2.6.2 Understand the purpose of formatting a disk.
Types of Software
1.3.1.1 Distinguish between operating systems software and applications software.Understand the reasons for software versions.
Operating System Software
Describe the main functions of an operating system and name some common operating systems.
Applications Software
1.3.3.1 List some common software applications such as: word processing, spreadsheet, database, Web browsing, desktop publishing, accounting, together with their uses.
Graphical User Interface
1.3.4.1 Understand the term Graphical User Interface (GUI).
Systems Development
1.3.5.1 Understand how computer-based systems are developed. Know about the process of analysis, design, programming and testing often used in developing computer-based systems.
Intranet, Extranet
1.4.1.1 Understand the terms, local area network (LAN), wide area network (WAN). Understand the term client/server.
1.4.1.2 Understand the terms, local area network (LAN), wide area network (WAN). Understand the term client/server.
LAN, WAN
1.4.2.1 Understand what an intranet is and understand the distinction between the Internet and an intranet.
1.4.2.2 Understand what an extranet is and understand the distinction between an intranet and an extranet.
The Internet
1.4.3.1 Understand what the Internet is and know some of its main uses.
1.4.3.2 Understand what the World Wide Web (WWW) is and distinguish it from the Internet.
The Telephone Network in Computing
1.4.4.1 Understand the use of the telephone network in computing. Understand the terms Public Switched Telephone Network (PSTN), Integrated Services Digital Network (ISDN), Asymetric Digital Subscriber Line (ADSL).
1.4.4.2 Understand the terms analogue, digital, modem, transfer rate, (measured in bps – bits per second).
Computers at Work
1.5.1.1 Identify some situations where a computer might be more appropriate than a person for carrying out a task and where not.
1.5.1.2 Know some of the uses of large-scale computer applications in business such as: business administration systems, airline booking systems, insurance claims processing, online banking.
1.5.1.3 Know some of the uses of large-scale computer applications in government such as: public records systems (census, vehicle registration), revenue collection, electronic voting.
1.5.1.4 Know some of the uses of large-scale computer applications in hospitals/healthcare such as: patient records systems, ambulance control systems, diagnostic tools and instruments, specialist surgical equipment.
1.5.1.5 Know some of the uses of computer applications in education such as: student registration and timetabling systems, computer-based training (CBT), distance learning, homework using the Internet.
1.5.1.6 Understand the term teleworking. List some of the advantages of teleworking such as: reduced or no commuting time, greater ability to focus on one task, flexible schedules, reduced company space requirements. List some disadvantages of teleworking such as: lack of human contact, less emphasis on teamwork.
Electronic World
1.5.2.1 Understand the term electronic mail (e-mail) and know its main uses.
1.5.2.2 Understand the term e-Commerce. Understand the concept of purchasing goods and services online, including giving personal details before a transaction can be carried out, payment methods, consumer’s basic right to return unsatisfactory goods.
1.5.2.3 List some of the advantages of purchasing goods and services online, such as: services available 24 hours a day, opportunity to view a wide range of products. List some of the disadvantages of purchasing goods and services online such as: choosing from a virtual store, no human contact, risk of insecure payment methods
Ergonomics
1.6.1.1 Understand what elements and practices can help create a good working environment such as: appropriate positioning of monitors, keyboards and adjustable chairs, use of a mouse mat, use of a monitor filter, provision of adequate lighting and ventilation, frequent breaks away from the computer.
Health Issues
1.6.2.1 List some common health problems which can be associated with using a computer such as: injuries to wrists caused by prolonged typing, eye strain caused by screen glare, back problems associated with poor seating or bad posture.
Precautions
1.6.3.1 List some safety precautions when using a computer such as: ensuring power cables are safely secured, power points are not overloaded.
The Environment
1.6.4.1 Be aware that recycling printed outputs, recycling printer toner cartridges, using a monitor that consumes less power while the computer is inactive can help the environment.
1.6.4.2 Understand that using electronic documents can help reduce the need for printed materials.
Information Security
1.7.1.1 Understand the term information security and the benefits to an organisation of being proactive in dealing with security risks such as: adopting an information security policy with respect to handling sensitive data, having procedures for reporting security incidents, making staff members aware of their responsibilities with respect to information security.
1.7.1.2 Know about privacy issues associated with computers, such as adopting good password policies. Understand what is meant by user ID and differentiate between user ID and password. Understand the term access rights and know why access rights are important.
1.7.1.3 Know about the purpose and value of backing up data, software to a removable storage device.
1.7.1.4 Be aware of possible implications of theft of a laptop computer, PDA, mobile phone such as: possible misuse of confidential files, loss of files, loss of important contact details if not available on a separate source, possible misuse of telephone numbers.
Computer Viruses
1.7.2.1 Understand the term virus when used in computing and understand that there are different types of virus. Be aware when and how viruses can enter a computer system.
1.7.2.2 Know about anti-virus measures and what to do when a virus infects a computer. Be aware of the limitations of anti-virus software. Understand what "disinfecting" files means.
1.7.2.3 Understand good practice when downloading files, accessing file attachments, such as: use of virus scanning software, not opening unrecognised e-mail messages, not opening attachments contained within unrecognised e-mail messages.
Copyright
1.8.1.1 Understand the concept of copyright when applied to software, and also to files such as: graphics, text, audio, video. Understand copyright issues involved in downloading information from the Internet.
1.8.1.2 Understand copyright issues associated with using and distributing materials stored on removable media such as CD's, Zip disks, diskettes.
1.8.1.3 Know how to check the Product ID number for a software product. Understand the terms shareware, freeware, end-user license agreement.
Data Protection Legislation
1.8.2.1 Know about data protection legislation or conventions in your country. Understand the implications of data protection legislation for data subjects and data holders. Describe some of the uses of personal data.
______________________________________________________
Module 2 - Using the Computer and Managing Files [Top]
Computer Environment: First Steps with the Computer
2.1.1.1 Start the computer.
2.1.1.2 Shut down the computer using an appropriate routine.
2.1.1.3 Restart the computer using an appropriate routine.
2.1.1.4 Shut down a non-responding application.
Basic Information and Operations
2.1.2.1 View the computer’s basic system information: operating system and version number, installed RAM (random access memory).
2.1.2.2 Change the computer’s desktop configuration: date & time2, volume settings, desktop display options (colour settings, screen pixel resolution, screen saver options).
2.1.2.3 Set, change keyboard language.
2.1.2.4 Format removable disk media: diskette, Zip disk.
2.1.2.5 Install, uninstall a software application.
2.1.2.6 Use keyboard print screen facility and paste contents into a document.
2.1.2.7 Use available Help functions.
Text Editing
2.1.3.1 Launch a text editing application. Open, create a file.
2.1.3.2 Save the file to a location on a drive.
2.1.3.3 Close the text editing application.
Desktop: Work with Icons
2.2.1.1 Recognize common desktop icons such as those representing: files, directories/folders, applications, printers, recycle in/wastebasket.
2.2.1.2 Select and move desktop icons.
2.2.1.3 Open a file, directory/folder, application from the desktop.
2.2.1.4 Create a desktop shortcut icon, desktop menu alias.
Managing Files: Concepts
2.3.1.1 Understand how an operating system shows drives, folders, files in a hierarchical structure.
2.3.1.2 Know that the devices used by an operating system to store files and folders are the hard disk, diskette, CD-ROM, network drives.
Directories/Folders
2.3.2.1 Navigate to a file, folder on a drive.
2.3.2.2 Create a directory/folder and a further subdirectory/ sub-folder.
2.3.2.3 Open a window to display directory/folder name, size, location on drive.
Working with Files
2.3.3.1 Recognize common file types: word processing files, spreadsheet files, database files, presentation files, image files, audio files, video files, compressed files, temporary files.
2.3.3.2 Count the number of files, files of a particular type, in a folder (including any files in subfolders).
2.3.3.3 Change file status: read-only/locked, read-write.
2.3.3.4 Sort files by name, size, type, date modified.
2.3.3.5 Understand the importance of maintaining correct file extensions when re-naming files.
2.3.3.6 Re-name files, directories/folders.
Duplicate, Move
2.3.4.1 Select a file, directory/folder individually or as a group of adjacent, non-adjacent files, directories/folders.
2.3.4.2 Duplicate files, directories/folders between directories/folders and between drives.
2.3.4.3 Move files, directories/folders between directories/folders and drives.
2.3.4.4 Understand why making a ‘backup’ copy of files to a removable storage device is important.
Delete, Restore
2.3.5.1 Delete files, directories/folders to the recycle bin/wastebasket.
2.3.5.2 Restore files, directories/folders from the recycle bin/wastebasket.
2.3.5.3 Empty the recycle bin/wastebasket.
Searching
2.3.6.1 Use the Find tool to locate a file, directory/folder.
2.3.6.2 Search for files by content, date modified, date created, size, wildcards.
2.3.6.3 View list of recently used files.
Compressing Files
2.3.7.1 Understand what file compression means.
2.3.7.2 Compress files in a folder on a drive.
2.3.7.3 Extract compressed files from a location on a drive.
Print Management: Setup
2.5.1.1 Change the default printer from an installed printer list.
2.5.1.2 Install a new printer on the computer.
Print Outputs
2.5.2.1 Print a document from a text editing application.
2.5.2.2 View a print job’s progress using a desktop print manager.
2.5.2.3 Pause, re-start, delete a print job using a desktop print manager.
______________________________________________________
Module 3 - Word processing [Top]
3.1 create a basic document using OpenOffice Writer.
* Explore the Writer interface so that you can identify the tools and commands that will help you in creating a document.
* Customize the Writer environment using the Customize dialog box to quickly access commonly used commands.
* Enter text in a blank document so that the text appears in the text area.
* Use the Help feature of OpenOffice Writer to obtain help in the time of a query.
* Save a document using the Save and Save As functions, so that it is available for future use.
* Print a document using the Print dialog box to obtain the hard copy.
3.2 edit a document and proof it using OpenOffice Writer.
* Modify text using various editing options.
* Find and replace text using the Find & Replace dialog box.
* Proof a document using various tools to eliminate common mistakes.
3.3 format a document using OpenOffice Writer.
* Format text using various formatting tools to improve readability.
* Format paragraphs using the Paragraph dialog box to improve readability.
* Format paragraphs as a list using the Formatting toolbar to convert paragraphs to lists.
3.4 add tables using OpenOffice Writer.
* Create a table using the Insert Table dialog box to arrange data into tables.
* Modify a table using the Table toolbar to insert or delete rows, columns, and cells.
* Format a table using the Table Format dialog box to apply a variety of formatting options.
* Work with table data using various options available on the Table toolbar.
3.5 add visual effects to a document using OpenOffice Writer.
* Add visual effects to text using various options such as special characters, frames, and fontwork.
* Work with pictures by inserting or modifying a picture.
* Create charts using the Chart wizard to incorporate better readability.
3.6 control a document's page setup and its overall appearance using OpenOffice Writer.
* Control the page layout using the Page Style dialog box for better print output.
* Insert breaks using the Insert Break dialog box to present content effectively.
* Add headers and footers using the Header and Footer options on the Insert toolbar.
3.7 work with styles and templates using OpenOffice Writer.
* Work with styles using the Styles and Formatting window.
* Work with templates using the Templates dialog box.
3.8 automate tasks using OpenOffice Writer.
* Perform a mail merge using the Address Book Data Source wizard to send identical email to multiple contacts.
* Mail merge envelopes and labels using the Envelop and Labels dialog boxes.
* Use macros to automate tasks using the Macros option on the Tools toolbar.
3.9 secure a document using OpenOffice Writer.
* Secure a document using OpenOffice security options.
* Secure portions of text in a document using the Edit Sections dialog box.
* Apply macro security using the Macro Security dialog box.
______________________________________________________
Module 4 - Spreadsheets [Top]
4.1 explore the various elements of the OpenOffice Calc interface.
* Explore the components of the OpenOffice Calc interface.
* Customize the interface using the various customization options provided in OpenOffice Calc.
* Use the OpenOffice Help feature.
4.2 create a spreadsheet by entering data and saving the spreadsheet.
* Enter data in a spreadsheet.
* Save a spreadsheet using the Save and Save As commands available in OpenOffice Calc.
4.3 perform calculations using the basic and advanced formulas and functions available in OpenOffice Calc.
* Calculate using basic formulas and functions.
* Calculate using advanced functions.
4.4 modify and locate data in a spreadsheet using various methods and tools available in OpenOffice Calc.
* Manipulate data using the Insert and Delete options in the OpenOffice Calc application.
* Sort and filter data.
* Search for data in a spreadsheet.
* Spell check a spreadsheet.
4.5 format a spreadsheet to improve its visual appeal and make it easier for users to locate required information.
* Format cells.
* Apply conditional formatting.
4.6 audit data in a spreadsheet by using tools to trace cells and rectify incorrect formula.
* Trace cells.
* Troubleshoot errors.
* Add data validation criteria.
4.7 analyze data using the Scenarios, Goal Seek, Solver, and DataPilot tables.
* Create scenarios.
* Analyze data using Goal Seek.
* Analyze data using Solver.
* Analyze data using DataPilot.
4.8 present data using charts so that numerical data can be depicted graphically for easy comprehension.
* Create a chart.
* Modify a chart.
4.9 finalize a spreadsheet by protecting files, freezing cells, and exporting to different formats.
* Prepare a spreadsheet for distribution.
* Present a spreadsheet in different formats.
______________________________________________________
Module 5 - Database [Top]
5.1 Getting Started with OpenOffice Base
* Understand database concepts.
* Explore the OpenOffice Base interface.
* Customize the Base environment.
* Obtain help in OpenOffice Base.
5.2 Designing a Database
* Describe the relational database design process.
* Review existing data.
* Determine the structure of tables in a database.
* List the guidelines for grouping fields into tables.
* Normalize data in a database.
* Designate primary and foreign keys.
* Determine table relationships.
5.3 Building a Database
* Create a database.
* Create a table.
* Enter data in a table.
* Modify the table design.
* Manage tables in a database.
* Create relationships between tables.
* Access data from external data sources.
5.4 Managing Data in a Table
* Modify data in a table.
* Sort records in a table.
* Filter records in a table.
5.5 Querying the Database
* Create a query.
* Add criteria to a query.
* Add a calculated field to a query.
* Perform calculations on a record group.
* Create a view.
5.6 Designing Forms
* Create a form.
* Work with a form.
* Modify the design of a form.
* Modify form controls.
5.7 Generating Reports
* Create a report.
* Modify the layout of a report.
* Enhance the appearance of a report.
* Add a calculated field to a report.
______________________________________________________
Module 6 - Presentation tools [Top]
Using the Application: First Steps with Presentations
6.1.1.1 Open (and close) a presentation application.
6.1.1.2 Open one, several presentations.
6.1.1.3 Create a new presentation (default template).
6.1.1.4 Save a presentation to a location on a drive.
6.1.1.5 Save a presentation under another name.
6.1.1.6 Save a presentation in another file type such as: Rich Text Format, template, image file format, software specific file extension, version number.
6.1.1.7 Switch between open presentations.
6.1.1.8 Use available Help functions.
6.1.1.9 Close a presentation.
Adjust Settings
6.1.2.1 Use magnification/zoom tools.
6.1.2.2 Display, hide built-in toolbars.
6.1.2.3 Modify basic options/preferences in the application: user name, default directory/ folder to open, save presentations.
Presentation Views
6.2.1.1 Understand the uses of different presentation view modes.
6.2.1.2 Change between presentation view modes.
Slides
6.2.2.1 Add a new slide with a specific slide layout such as: title slide, chart and text, bulleted list, table.
6.2.2.2 Change between built-in slide layouts.
6.2.2.3 Change background colour on specific slide(s), all slides.
6.2.3 Using Design Templates 6.2.3.1 Apply an available design template to a presentation.
6.2.3.2 Change between available design templates.
Master Slide
6.2.4.1 Insert a picture14, image, drawn object into a master slide. Remove a picture, image, drawn object from a master slide.
6.2.4.2 Add text into Footer of specific slides, all slides in a presentation.
6.2.4.3 Apply automatic slide numbering, automatically updated date, non-updating date into Footer of specific slides, all slides in a
presentation.
Text and Images: Text Input, Formatting
6.3.1.1 Add text into a presentation in standard, outline view.
6.3.1.2 Edit slide content, notes pages content by inserting new characters, words.
6.3.1.3 Change text appearance: font sizes, font types.
6.3.1.4 Apply text formatting such as: bold, italic, underline.
6.3.1.5 Apply case changes to text.
6.3.1.6 Apply different colours to text.
6.3.1.7 Apply shadow to text.
6.3.1.8 Align text: left, centre, right in a slide.
6.3.1.9 Adjust line spacing before and after bulleted, numbered points.
6.3.1.10 Change between the style of bullets, numbers in a list from built-in standard options.
6.3.1.11 Use the undo, redo command.
Pictures, Images
6.3.2.1 Insert a picture into a slide.
6.3.2.2 Insert an image into a slide.
Duplicate, Move, Delete
6.3.3.1 Duplicate text, pictures, images within the presentation, between open presentations.
6.3.3.2 Move text, pictures, images within the presentation, between open presentations.
6.3.3.3 Resize pictures, images in a presentation.
6.3.3.4 Delete text, pictures, images in a slide.
Using Charts/Graphs
6.4.1.1 Input data to create, modify different kinds of built-in charts/graphs in a slide: column, bar, line, pie.
6.4.1.2 Change the background colour in the chart/graph.
6.4.1.3 Change the column, bar, line, pie slice colours in the chart/graph.
6.4.1.4 Change the chart/graph type.
Organisation Charts
6.4.2.1 Create an organisation chart with a labelled hierarchy. (Use a built-in organisation chart feature).
6.4.2.2 Change the hierarchical structure of an organisation chart.
6.4.2.3 Add, remove managers, co-workers, subordinates in an organisation chart.
Drawn Objects
6.4.3.1 Add different types of drawn object to a slide: line, free drawn line, arrow, rectangle, square, circle, text box, and other available shapes.
6.4.3.2 Change drawn object background colour, line colour, line weight, line style.
6.4.3.3 Change arrow start style, arrow finish style.
6.4.3.4 Apply a shadow to a drawn object.
6.4.3.5 Rotate, flip a drawn object.
6.4.3.6 Align a drawn object: left, centre, right, top, bottom of a slide.
6.4.3.7 Resize drawn object, chart within the presentation.
6.4.3.8 Bring an object to the front, back.
Duplicate, Move, Delete
6.4.4.1 Duplicate a chart/graph, drawn object within the presentation, between open presentations.
6.4.4.2 Move a chart/graph, drawn object within the presentation, between open presentations.
6.4.4.3 Delete a chart/graph, drawn object.
Preset Animation
6.5.1.1 Add preset text, image animation effects to slides. Change preset animation effects on text, images.
Transitions
6.5.2.1 Add transition effects between slides. Change slide transition effects between slides.
Preparation
6.6.1.1 Select appropriate output format for slide presentation such as: overhead, handout, 35 mm slides, on-screen show.
6.6.1.2 Spell-check a presentation and make changes such as: correcting spelling errors, deleting repeated words.
6.6.1.3 Add notes for the presenter to slides.
6.6.1.4 Change slide setup, slide orientation to portrait, landscape. Change paper size.
6.6.1.5 Duplicate, move slides within the presentation, between open presentations.
6.6.1.6 Delete a slide, slides.
Printing
6.6.2.1 Print18 entire presentation, specific slides, handouts, notes pages, outline view of slides, number of copies of a presentation.
Deliver a Presentation
6.6.3.1 Hide, show slides.
6.6.3.2 Start a slide show, start a slide show on any slide.
______________________________________________________
Module 7 - Information and Communication [Top]
7.1 explore the user interface elements of Mozilla Firefox 3.0.
* Get familiar with the Internet.
* Explore Mozilla Firefox.
* Customize the Mozilla Firefox interface.
* Get help using the Mozilla Firefox help feature.
7.2 browse websites using Mozilla® Firefox®.
* View web pages on tabs.
* Navigate through a web page.
7.3 search and download information from the web using Mozilla® Firefox®.
* Search for information using the search bar.
* Search for information about people and businesses using online directories.
* Customize the search settings of Mozilla Firefox.
* Download information from the web.
7.4 communicate with other online users.
* Communicate using email.
* Subscribe to a newsgroup.
* Collaborate with newsgroup messages.
7.5 manage information from the web using bookmarks and save web pages on to your local system.
* Manage bookmarks.
* Manage live bookmarks.
* Save a web page.
* Print a web page.
7.6 configure the privacy and security settings in Mozilla® Firefox®.
* Configure browsing history settings.
* Configure the pop-up settings.
* Enable the anti-phishing function.
|
|
|
 |
 |
 |
|
|
|
Syllabus
