Computer Operator and Programming Assistant

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.