Computer components and Windows Operating System

• Disassembling,Identification of components and Reassembling a Desktop computer.
• Familiarization with Windows O.S desktop, using icons,buttons and customizing the desktop.
• Managing files and folders, using removable drives.
• Viewing system properties and control panel details.Viewing and setting environmental variables.
• Working with MS Paint.

 

Computer Hardware basics and Software Installation

• Viewing the BIOS and changing the Boot order.
• Identify and rectify common hardware and software issues.
• Formatting the hard disk and loading O.S and necessary application software.
• Installation of DVD, using different types of hard disks.
• Bluetooth Configuration, DVD write techniques

 

Familiarization with DOS CLI & Linux Operating Systems.

• Using basic DOS commands for directory listing, file and folder management etc.
• Using Basic Linux commands for directory listing, file and folder management, password etc.
• Using the Linux graphical user interface for file and folder management, exploring the system etc

 

Using Word Processing Software

• Familiarization with the Word window components.
• Creating, saving and editingdocuments using Word.
• Inserting and formatting tables and other objects.
• Using templates,autocorrect tools, macrosand the mail merge tool.
• Working with Page layout settings and printing documents.
• Typing practice using open source typing tutor tools.
• Practice of using shortcut keys

 

Using Spread Sheet Application

• Creating, Saving and Formatting Excel Spreadsheets.
• Using Absolute and Relative referencing, linking sheets, Conditional formatting etc.
• Using Excel functions of all major categories.
• Using various data types in Excel, Sorting, filtering and validating data. Creating and formatting charts.
• Importing & Exporting Excel Data.
• Performing data analysis using “what if” tools.
• Modifying Excel Page setup and printing.
• Simple projects using Excel & Word

 

Image editing, Creating presentations & Using Open Office

• Use of windows and open source image editing software like Open Office Draw, GIMP, Irfan View or a similar tool.
• Creating Slide shows, Inserting objects.
• Animating Slide transitions and Objects.
• Creating a simple presentation project using Open Office.
• Working with Open Office for word processing and spreadsheet application.

 

Database Management

• Creating database and designing a simple tables in Access.
• Enforcing Integrity Constraints and modifying the properties of tables and fields.
• Creating Relationships and joining tables.
• Creating Forms.
• Creating simple select queries with various criteria and calculations.
• Creating Simple update, append, make table, delete and crosstab queries.
• Modifying form design with controls, macros and events.
• Importing and exporting data to and from Access.
• Compressing and Encrypting databases.

 

Configuring and Using Networks

• Viewing Network connections.
• Connecting a computer to a network and sharing of Devices, files and Folders.
• Familiarization with various Network devices, Connectors and Cables.
• IP Addressing and Subnetfor IPV4 / IPV6,Masking, pinging to test networks.
• Configuring Hub and Switch.
• Setting up and configuring LAN in a Computer Lab as peer to peer network.
• Setting up a proxy server/ DHCP Server with firewall.
• Setting up video conferencing.
• Using various tools for computer maintenance, Network security.

 

Internet Concepts

• Browsing the Internet for information.
• Creating and using e – mail for communication.
• Communication using text, video chatting and social networking sites.
• Identifying various threats to the system connected to the net.
• Protecting the computer against various internet threats.
• Configure Outlook, mail service in mobile phones. Using tools like Skype, Google+ etc.

 

Designing Static Web Pages

• Designing simple web pages with text, pictures, tables,lists, hyperlinks, frames, marquees etc. using HTML tags.
• Designing Web Pages with Forms and Form Controls using HTML tags.
• Creating Web Pages using CSS.
• Using WYSIWYG web design tools to design and edit web pages with various styles.