WINDOWS
Computer Fundamentals – Introduction to OS/GUI – WordPad – Notepad – Paintbrush – Windows Explorer – Control Panel.
MS OFFICE
Word Creating Text and Documents – Indexes and Tables – Embedding Picture – Table Manipulation – Mail Merge – Macro.
Excel Formatting Cells – Charts – Pivot table –Data Table- Forms – Scenarios – Goal seek – Macros and Models.
PowerPoint Creating Presentation – OLE – Enhancing Presentations – Adding Audio & Video – Special Effects.
INTERNET
Introduction to Internet, www , http & E-mail – Creating E-mail ID – Receiving & Sending E-mail – Chatting – Locating Information – Downloading.
II .Client / Server Technology
VISUAL BASIC
Controls – User Controls – Properties and Events – Control statements and Loops – Procedures and Functions – Error Handling – Creating Instances of Objects – Menu Editors – MDI Applications – Sequential, Random and Binary File Handling – Data Manager – ODBC – OLEDB- Data Controls and SQL – Active x – RDO – ADO – Data Report- DHTML.
MySQL
Client / Server Concepts – Relational Model – Data Definition Using SQL – Modify Tables – Using ALTER TABLE Queries, Add a Column, Add an Index, Add a Primary Key – INSERT and DELETE Queries – UPDATE Queries – Using Select Queries – SELECT, WHERE, LIMIT, ORDER BY, GROUP BY, JOIN -Constraints and Indexes – Views – Expressions – Grouping -Using Functions – Math Functions, Compare String values, Work with Dates – JOIN and Subqueries – Advanced MySQL Query Processing – Database Management, Stored Procedures, Triggers, etc.
PROJECT*
With our guidance students will undertake one Client- Server Project.
III. FINANCIAL ACCOUNTING
TALLY.ERP 9
Principles of Accounting – Tally fundamentals – Maintaining Company Data – F11 Features, F12 Configure.
TALLY VOUCHERS
Accounting Vouchers / Inventory – Accounting and item invoicing.
Reports
Balance Sheet – P & L A/c – Ratio Analysis – Cash flow, Fund flow Statements – Ageing Analysis – Movement Analysis.
ADVANCED ACCOUNTING
Bill wise Details – Cost Centres and Cost Categories – Voucher Classes and Cost Centre Classes – Multiple Currencies – Bank reconcilliation -interest Calculation – Budgets & Scenario – Job Costing.
ADVANCED INVENTORY
Order Processing – Recorder Levels – Tracking Numbers -Batch wise Details – Additional cost Details -Bill of Materials – Price List.
SYSTEM ADMINISTRATION AND OTHER UTILITIES
Consolidation of Accounts – Tally Vault – Security Control – Tally Audit – Back up and Restore – Split company Data – Export and Import of Data – ODBC Compliance.
POINT OF SALES
Predetermination of invoice – Multi Payment Modes – Small & Smart Bills – POS Sales Register.
MULTI LANGUAGE
Supporting OS – Translation or Transliteration – System & Phonetic Keyboard – Sourcing from Other Software.
GOODS & SERVICE TAX (GST)
Accounting of purchase or Sales returns – inter state Trade Accounting – Accounting of Exempted Items – Accounting Purchases from Unregistered Dealers – Accounting Input Credit on Capital Goods – GST Computation & Forms.
TDS & TCS
Entry – calculator – Reports – e Returns.
PAYROLL
Introduction to Payroll – Configuring Tally for payroll – Creation of payroll Masters – Recording of Attendance – Preparation of payroll Vouchers based on attendance – of a salary Disbursement Voucher – Payroll Reports.
PROJECT
Live simulated projects are given to students.
IV. ELECTIVE I : Web Programming
HTML
Tags – Links – Anchor – Adding Pictures – Lists – Tables – Frames – Forms – Menu Controls.
FRONT PAGE
Tables – Frames – Forms – DHTML effects.
VB SCRIPT
Functions –Procedures – Objects – Event Handling – Forms and Frames.
ASP
Forms – Cookies- ActiveX Server Components – Database Support – Reading and writing to Files – Security.
XML
Element – Attributes – Creating & Designing Tags Document Type Definition.
PROJECT
Development of Website.
IV. ELECTIVE II :
ADVANCE EXCEL & VBA PROGRAMMING
ADVANCE EXCEL
Introduction to MS Excel and Understanding Basic Working with it – Formatting Worksheet – Working with Formulas/Functions (Lookup and Reference Functions, Logical Function, Database Functions, Math and Trigonometry Functions, Statistical Functions, Text functions) – Conditional Formatting – Connect to other database – Data Sorting and Filtering – Pivot Tables & Charts.
VBA PROGRAMMING
VBA Overview – VBA Programming Variables – Conditional Logic – String and String Functions – Programming Loops – Programming Arrays – subs and Functions – Creating your first Macro – Excel VBA Error Handling – Excel VBA and User forms – Connect with an external data – Work on automation project.