Computer Operator and Programming Assistant
Submitted by Anand on 21 December 2019 - 4:39pm

Semester:
Trade Theory Practical:
Introduction to Computers and Windows Operating System
- History,Generations, Types, Advantages and Applications of Computers.
- Concepts of Hardware and Software. Computer Hardware basics.
- Introduction to various processors.
- Introduction to the functions of an Operating System, Popular Operating Systems in Use.
- Main features of Windows O.S
- Various Input/ Output devices in use and their features.
- Using Scanner, Printer and Webcam
Computer Hardware basics and Software Installation
- Introduction to the booting process, BIOS settings and their modification.
- Introduction to various types of memories and their features.
- Basic Hardware and software issues and their solutions.
- Formatting and Loading O.S and Application software and Antivirus.
Introduction to DOS Command Line Interface & Linux Operating System.
- Introduction to basic DOS Internal and External Commands.
- Introduction to Open Source Software.
- Introduction to Linux Operating System features, structure, files and processes.
- Introduction to various Linux Shells.
- Basic Linux commands.
Word Processing
- Introduction to the various applications in office.
- Introduction to Word features, Office button, toolbars.
- Creating, saving and formatting and printing documentsusing Word.
- Working with inserting objects, macro, mail merge, templates and other tools in Word.
- Page setup and Printing Documents using word.
Spread Sheet Application
- Introduction to Excel features and Data Types.
- Cell referencing. Use of functions of various categories, linking Sheets.
- Introduction to various functions in all categories of Excel.
- Concepts of Sorting, Filtering and Validating Data.
- Analyzing data using charts, data tables, pivot tables, goal seekingand scenarios.
- Introduction to Reporting.
Image editing, Creating presentations & Using Open Office
- Introduction to Open Office.
- Introduction to the properties and editing of images.
- Introduction to Power Point and its advantages.
- Creating Slide Shows.
- Fine tuning the presentation and good presentation techniques.
Database Management Systems
- Concepts of Data, Information and Databases. Overview of popular databases, RDBMS, OODB and NOSQL.
- Rules for designing good tables. Integrity rules and constraints in a table.
- Relationships in tables.
- Introduction to various types of Queries and their uses.
- Designing Access Reports and Forms.
- Introduction to macros, designer objects controls, their properties and behavior.
Networking Concepts
- Introduction to Computer Networks, Necessity and Advantages.
- Client Server and peer to Peer networking concepts.
- Concept of Proxy Server and proxy firewall server.
- Network topologies. Introduction to LAN, WAN and MAN.
- Network components, viz. Modem, Hub, Switch, Router, Bridge, Gateway etc.
- Network Cables,Wireless networks and Blue Tooth technology.
- Concept of ISO - OSI 7 Layer Model.
- Overview of various Network protocols Viz. TCP/IP, FTP, Telnet etc.
- Logical and Physical Addresses, Classes of Networks.
- Network Security &firewall concepts.
- Concept of DHCP Server
Internet Concepts
- Introduction to WWW, Concept of Internet, Web Browsers, internet servers and search engines.
- Concepts of Domain naming Systems and E mail communication.
- Introduction to video chatting tools, VOIP and Social Networking concepts.
- Concept of Cloud storage and Open Web Server.
- Introduction to Internet Security, Threats and attacks, Malicious Software types, Internet security products and their advantages.
Web Design Concepts
- Concepts of Static and Dynamic Web pages.
- Introduction to HTML and various tags in HTML.
- Creating Forms with controls using HTML.
- Concepts of CSS and applying CSS to HTML
- Introduction to open source CMS viz,. Joomla, Wordpress etc. and Web authoring tools viz. Kompozer,FrontPageetc.