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

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