Computer Operator and Programming Assistant

Semester: 
Trade Theory Practical: 

Java Script

  • Familiarization with JavaScript elements.
  • Embedding JavaScript in HTML to display information in web pages. Documentation and Formatting.
  • Using JavaScript Variables, Data types, Constantsand Operators.
  • Working with Arrays, Control statements and Loops in JavaScript.
  • Writing functions in JavaScript.
  • Working with String, Math and Date functions in JavaScript.
  • Switch, Loops, Breaks and Errors.
  • Using Java Script Objects.
  • Working with JavaScript Libraries.
  • Using simple Open source web server (like XAMPP) and FTP software (For ex. Filezilla).
  • A simple project using JavaScript.

 

Programming with VBA

  • Familiarization with the VBA Editor.
  • Writing simple programs involving VBA Data types,Variables, Operators andConstants.
  • Working with string variables in VBA.
  • Creating and Manipulating Arrays in VBA.
  • Writing programs involving Mathematical,Conversion, Date andString Functions in VBA.
  • Working with conditional statements like If. Elseif, Select … Case statements in VBA.
  • Writing programs in involving Loops.
  • Creating Message boxes and Input boxes in VBA.
  • Creating Functions and Procedures. Passing Parameters and Using Returned Data.
  • Using VBA built in functions in programs.
  • Creating and editing macros.
  • Writing code to work with Excel VBA forms and form controls like buttons, Checkboxes, Labels, ComboBox, GroupBox, ListBox, Option Button, Scroll Bar and Spin button. Modification of object properties.
  •  Using ActiveX controls.
  • Programming with methods and events.
  • Debugging, Stepping Through Code, Breakpoints, Finding and Fixing Errors.
  • A simple project involving MS excel and VBA.

 

Using Accounting Software

  • Basic accounting practice.
  • Familiarization with the Tally interface.
  • Company creation,Account Creation, Voucher Entry in Tally.
  • Report Generation (Creating statements like Invoice, Bill, Profit & Loss account etc.).
  • Performing Cost Centre & Cost Category management.
  • Managing Budgeting Systems.
  • Scenario management and Variance Analysis.
  • Using Tally for Costing, Ratio Analysis,Cash Flow, Funds Flow Statements.
  • Analyzing and Managing Inventory.
  • Performing Point of Sales and Taxation. Performing Systems Administration and using other Utilities, User creation, Backup &Restore of Company.
  • Using the Multilingual Functionality

 

E Commerce

  • Familiarization with latest E commerce websites viz. E bay, Amazon, FlipCart, OLX, Quikr etc. and comparative study of the main features of these sites.
  • Using E Commerce Simulator Software for Marketplace Business Simulation.
  • Identifying and solving security issues inE- commerce and payment operations.

Typing practice

  • Typing Practice in Regional Language

Search engine adsence