I. END-USER APPLICATION
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. FRONT-END LANGUAGE & LIBRARY
HTML5
HTML Basics – New Elements – Canvas – Multimedia – Form Elements, Semantic.
CSS3
Syntax – Id, Class, Tag Styling – Using Text – Fonts – Links – Lists and Tables – Box Model – Text Effects – Transition – Animations.
III. DATABASE MANAGEMENT SYSTEM
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.
IV. FINANCIAL ACCOUNTING TALLY PRIME with GST
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.
V. ADVANCED EXCEL & VBA PROGRAMMING
ADVANCED 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, Date and Time Functions, Information 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 – Excel Objects – Excel Events – Excel VBA Error Handling – Excel VBA and User forms – Connect with an external data – Work on automation project.
PROJECT*
Students are given projects using VBA Excel and it will be helpful to explore how to use VBA to automate different tasks or developing applications/ tools using VBA.
VI. DIGITAL MARKETING
Introduction to Digital Marketing, Traditional vs Digital Marketing, Organic vs Inorganic Marketing, Content Creation, Graphic Designing, Social Media Marketing, Facebook, Instagram, Youtube, Search Marketing, Google Ads, Google Analytics