Computer Operator and Programming Assistant

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.

Search engine adsence