ALL TYPE LAPTOP DESKTOP SALES AND SERVICE CENTRE AVAILABLE ...
CONTACT VIA FACEBOOK INSTAGRAM WHATS APP USE THIS NUMBER 7805016502
ALL TYPE COMPUTER EDUCATION CENTRE
ms office
Microsoft Office Word 2016 Syllabus
1. Create and Manage Documents
1.1. Create a Document
• Create a blank document
• Create a blank document using a template
• Open a PDF in Word for editing
• Insert text from a file or external source
1.2. Navigate Through a Document
• Insert hyperlinks
• Search for text
• Create bookmarks
• Move to a specific location or object in a document
1.3. Format a Document
• Modify page setup
• Apply document themes
• Apply document style sets
• Insert headers and footers
• Insert page numbers
• Format page background elements
1.4. Customize Options and Views for Documents
• Change document views
• Customize views by using zoom settings
• Customize the Quick Access toolbar
• Add document properties
• Show or hide formatting symbols
1.5. Print and save documents
• Inspect a document for hidden properties or personal information
• Inspect a document for accessibility issues
• Inspect a document for compatibility issues
2. Format Text, Paragraphs, and Sections
2.1. Insert Text and Paragraphs
• Find and replace text
• Cut, copy and paste text
• Replace text by using AutoCorrect
• Insert special characters
2.2. Format Text and Paragraphs
• Apply font formatting
• Apply formatting by using Format Painter
• Set line and paragraph spacing and indentation
• Clear formatting
• Apply a text highlight color to text selections
• Apply built-in styles to text
• Change text to WordArt
2.3. Order and Group Text and Paragraphs
• Format text in multiple columns
• Insert page, section, or column breaks
• Change page setup options for a section
3. Create Tables and Lists
3.1. Create a Table
• Convert text to tables
• Convert tables to text
• Create a table by specifying rows and columns
• Apply table styles
3.2. Modify a Table
• Sort table data
• Configure cell margins and spacing
• Merge and split cells
• Resize tables, rows, and columns
• Split tables
• Configure a repeating row header
3.3. Create and Modify a List
• Create a numbered or bulleted list
• Change bullet characters or number formats for a list level
• Define a custom bullet character or number format
• Increase or decrease list levels
• Restart or continue list numbering
• Set starting number value
4. Create and Manage References
4.1. Create and Manage Reference Markers
• Insert footnotes and endnotes
• Modify footnote and endnote properties
• Create bibliography citation sources
• Modify bibliography citation sources
• Insert citations for bibliographies
• Insert figure and table captions
• Modify caption properties
4.2. Create and Manage Simple References
• Insert a standard table of contents
• Update a table of contents
• Insert a cover page
5. Insert and Format Graphic Element
5.1. Insert Graphic Elements
• Insert shapes
• Insert pictures
• Insert a screen shot or screen clipping
• Insert text boxes
5.2. Format Graphic Elements
• Apply artistic effects
• Apply picture effects
• Remove picture backgrounds
• Format objects
• Apply a picture style
• Wrap text around objects
• Position objects
• Add alternative text to objects for accessibility
5.3. Insert and Format SmartArt Graphics
• Create a SmartArt graphic
• Format a SmartArt graphic
• Modify SmartArt graphic content
6. Manage document options and settings
6.1. Manage Documents and Templates
• Manage document versions
• Compare and combine multiple documents
• Link to external document content
• Enable macros in a document
• Display hidden ribbon tabs
• Change the application default font
6.2. Prepare Documents for Review
• Restrict editing
• Mark a document as final
• Protect a document with a password
6.3. Manage Document Changes
• Track changes
• Manage tracked changes
• Lock or unlock tracking
• Add comments
• Manage comments
Design advanced documents
7.1. Perform Advanced Editing and Formatting
• Find and replace formatting and styles
• Set advanced page setup layout options
• Link text boxes
• paragraph pagination options
• Resolve style conflicts by using Paste Options
7.2. Create Styles
• Create paragraph and character styles
• Modify existing styles
8. Create Advanced References
8.1. Create and Manage Indexes
• Mark index entries
• Create indexes
• Update indexes
8.2. Create and Manage References
• Customize a table of contents
• Insert and modify captions
• Create and modify a table of figures
8.3. Manage Forms, Fields, and Mail Merge Operations
• Add custom fields
• Modify field properties
• Perform mail merges
• Manage recipient lists
• Insert merged fields
• Preview merge results
CPCT
Detailed Syllabus for CPCT
Sr. No Competency and Sub Topics
1.0 Familiarity with computer systems
1.1 Awareness about different aspects regarding computer hardware such as
generations and types of computers, printers, input and output devices and
hardware components such as Central Processing Unit (CPU) like arithmetic logic
unit, control unit, memory unit; Universal Serial Bus (USB), Liquid Crystal Display
(LCD), Motherboard, Sound Card, Graphics Card, and related concepts; Input
Devices such keyboard, mouse, light pen, touch screens, graphics tablets,
joystick, Microphone, Optical Character Reader, MICR, Scanner, digital or web
camera, card reader, barcode reader, biometric sensor; Output Devices such as
Monitor or visual display unit, printer (impact or non-impact), speaker, plotter;
and Secondary Storage Devices such as USB Pen Drives, floppy disks, Compact
Disk (CD), Digital Video Disk (DVD), Blue Ray Disk, Solid State Drive etc.;
1.2 Awareness regarding different aspects about computer software including
software categories such as System Software, Application Software, Embedded
Software, Proprietary Software, Open Source Software; Computer Languages
such as Machine Level Language, Assembly Level Language, High Level Language,
Interpreter, Compiler; Operating Systems such as Windows and Linux etc. and
concepts of Memory Units such as Bit, Byte, Megabyte, Gigabyte, Terabyte etc.
2.0 Knowledge of Basic Computer Operations
2.1 Awareness of generic steps required for setting up a computer, booting and
shutting down, logging on and off to a network, determining an IP address,
verifying physical connectivity to a network, installing and updating software
packages, disabling applications from running on start-up, uninstalling a software
from computer, customising desktop background, resizing windows, volume
controls of computer, setting up a new printer or webcam or scanner or other
peripheral devices, understanding of steps to protect computers from power
disturbances and basic troubleshooting including power backups.
2.2 Awareness of System Administration and Security concepts such as setting
options and preferences in an Operating System; encryption of data; keeping
personal data private and secure; creating strong passwords; changing
passwords; checking a system for bugs, spyware or other malicious application
through virus scanners;
2.3 Awareness of concepts and processes related to file management functions such
as copying files to memory disk, undoing mistakes, using default help modules,
connecting to the Internet and downloading and uploading files, setup and
printing of documents Compressing files; identifying and selecting suitable file
formats and using them for transferring data
3.0 Proficiency in general IT skills
3.1 Word processing skills such as creating a document, using spellcheck, creating
tables, working with headers or footers, mail merge, document formatting etc.
and common word processing related keyboard commands;
3.2 Numeric Skills to deal with numbers and digits, using formulas, references,
macros, tables, graphs through spreadsheets and common keyboard commands
for spreadsheets. Presentation skills for sharing and understanding data in form
of charts, graphs and data.
3.3 Internet skills such as using search engine effectively to get the best desired
result within short time; uploading and downloading information from the
Internet and usage of Internet applications such as web sites, browsers, blogs,
and Internet services such as Email, video conferencing, Online Collaboration etc.
4.0 Reading Comprehension
4.1 Ability to read and understand passages in English comprising questions
regarding locating information, identifying relationships, interpreting ideas,
moods, characteristics of characters, tone of passage and getting the central
theme
5.0 Mathematical & Reasoning Aptitude
5.1 Mathematical Aptitude comprising concepts from
Discount, Compound Interest &
Annuities, Ratio & Proportions, Time, Work & Distance, 2 D & 3D Figures- Areas &
Volumes)
5.2 Reasoning Aptitude focusing on Verbal and Logical Reasoning focusing on
deriving conclusions from logical premises or assess the validity of arguments
based on statement of facts.
6.0 General Awareness
6.1 Indian History & Indian Geography, Indian Economy, Indian Constitution, Science
& Technology, Trends in Current Affairs
7 Keyboard Skills
7.1 Typing in English
7.2 Typing in Hindi
CPCT Assessment Pattern
CPCT consist of two sections:
MCQ (Multi Choice Question) having 75 questions from specified syllabus.
Typing Skill Assessment
o English Typing test
o Hindi Typing test
Specifications
1. All Multiple Choice Questions (MCQ) shall have 4 (four) options with one (1) correct option.
2. All MCQ questions shall be available in English and Hindi.
3. Reading Comprehension (RC) shall comprise one (1) passage with 5 MCQ questions.
4. Typing test content will be a passage with possible keystrokes.
Test Duration
1. The Test shall be of two hours (120 Minutes) duration distributed as under
2. 75 minutes for 75 Questions in Sections 1 – 6
3. 15 Minutes for English typing test
4. 15 Minutes for Hindi typing test
5. 15 Minutes for reading instructions and switchover between languages in typing tests
Disclaimer
The above syllabus describes broader areas of Computer Proficiency for CPCT Exam. The questions
appear in CPCT Exam may or may not lay directly in the described broader areas of syllabus.
Maharishi Mahesh Yogi Vedic Vishwavidyalaya
DIRECTORATE OF DISTANCE EDUCATION
Syllabus
DIPLOMA IN COMPUTER APPLICATION (DCA)
MMYVVDDE
FUNDAMENTALS OF MAHARISHI VEDIC SCIENCE
(MAHARISHI VEDIC SCIENCE – I)
UNIT - 1
Meaning & importance of Guru Pujan.
Meaning of meditation, Mann, Intelligence, Chita, Ego, Thought .
UNIT - II
Name of forty areas of Vedic Science and their expression in Human Physiology and
characteristics of consciousness.
Consciousness, types of consciousness, characteristics of higher stages of consciousness.
UNIT - III
Maharishi’s Yoga, Transcendental Meditation- a general Introduction, Types of Speech, TM
Sidhi Programme, Principle of Yoga Asanas and their Concept.
UNIT - IV
Introduction: Maharishi Vedic Management.
Fundamental elements of Vedic Management –Totality
Management of Science and Art .
UNIT - V
Vedic Management and Leadership.
The Idea Leadership is based upon the Totality of Employee’s Style
Suggested Readings:
Chetna –His Holiness Maharishi Mahesh Yogi Jee
Maharishi Sandesh - 1 and 2 , II-His Holiness Maharishi Mahesh Yogijee
Scientific Yoga Ashanas –Dr. SatPal.
Dhyan Shailly by Brahmchari Dr. Girish Ji
MMYVVDDE
FUNDAMENTALS OF COMPUTER AND INFORAMATION TECHNOLOGY
UNIT-1
Introduction to computer and information technology : History of development of computers,
computer system concept , characteristics, capabilities and limitation , types of computer –
analog, digital, hybrid, general, special purpose, micro, mainframe, super, generation of
computer, personal computer (PCs) –IBM PCs, characteristics, PC/PCXT/PCAT-configurations,
Pentium and Newer PCs specification and main characteristics, types of PCs-Desktop, Laptop,
Notebook, Palmtop, Workstation etc , their characteristics.
Computer Organizations and Working: Basic component of a computer system –control unit,
ALU, INPUT /Output function and characteristics, memory –RAM, ROM, EPROM, PROM and
other types of memory.
UNIT-II
Input Devices: Keyboard, Mouse, Trackball, Joysticks, Digitizing tablet, Scanner, Digital
Camera, MICR, OCR, OMR, BAR-CODE Reader, Voice Recognition, Light Pen, and Touch
Screen.
Output Devices: Monitor –characteristics and types of monitor –digital, analog size, resolution,
refresh rate, Interlaced /Non Interlaced, Dot Pitch, Video Standard –VGA,SVGA,XGA etc,
Printer –Daisy wheel, Dot Matrix, Inkjet, Laser, line printer , plotter, sound card and speakers.
UNIT-III
Storage Devices: Storage Fundamental –Primary VS Secondary, Data Storage and Retrieval
method –Sequential, Direct and Index Sequential, Various Storage Devices –Magnetic Tape
,Magnetic disks, Cartridge Tape, data drives, hard disk drives, floppy (Winchester disks), Disks,
Optical Disks, CD,VCD,CD-R,CD-RW, ZIP Drive.
Computer Software: Need, types of software –system software, application software, system
software-operating system, utility program, programming Language, assemblers, compiler and
interpreter.
UNIT-IV
Operating System: Function, types –Batch, Single, Multiprogramming, Multiprocessing.
Programming languages- Machine, Assembly, High Level and 4GL. Merit and Demerits of
Programming Languages.
MMYVVDDE
Disk Operating System (Dos) Introduction History & version of Dos basic –physics structure of
disk drive name , Fat ,File & directory structure and naming rules , booting process , Dos system
files. Dos command: Internal –DIR , MD , CD,RD,COPY,DEL, REN ,
VOL,DATE,TIME,CLS,PATH, TYPE etc. External – CHKDSK, XCOPY, PRINT,
DISKCOPY, DISKCOMP, DOSKEY, TREE,MOVE, LABEL, APPEND, FORMAT, SORT,
FDISK, BACKUP, EDIT, MODE, ATTRIB , HELP, SYS ,etc Executable V/s Non executable
file in Dos.
Number System: Data representation in computer, number system of computer –Binary, Octal,
Hexa-Representation & their conversion, coding system –ASCII, BCD, EBCDIC etc.
UNIT-V
Data Communication and Networks: communication channels –twister, coaxial, fiber, optic.
Types of Networks –LAN, WAN, MAN etc, Topologies of LAN –Ring, BUS, STAR, MESH
and TREE topologies , components of LAN-media , NIC,NOS, Bridges, HUB, Routers Repeater
and Gateway .
Computer virus: Virus working principles, types of viruses, virus detection and prevention,
viruses on networks. Use of communication and IT in daily life.
An Introduction: Modern Science and Vedic Science, Unified field based computer Science.
Text & Reference Books:-
1. Learning Window 98 step by step by Rajeev Mathur , BPB Publication.
2. Learning Word 97 for Window by Rajeev Mathur , BPB Publication,
3. Learning Excel 97 for Window by Rajeev Mathur , BPB Publication.
4. A First Course in Computer by Sanjay Saxena , Vikas Publishing House New Delhi.
5. Microsoft Office 2000 by A. Mansoor by Pragya Publications.
6. Office 97 Interactive Course by Greg Perry, Tec media.
7. Microsoft Office 2000 by A. Mansoor by Pragya Publications.
MMYVVDDE
PC PACKAGES
UNIT-I
Word-processing : MS-Word : Introduction to word processing, introduction to MS –Word:
features, creating ,saving and opening document in word , interface , Toolbars , Ruler, Menus,
Keyboard Shortcut, Editing a document – moving, scrolling in a document, opening multi
document window, editing text selecting , inserting, delete , moving text, previewing document,
printing document – Print a document from the standard toolbars, print a document from the
menu , shrinking a document to fit a page, reduce the number of pages by one, formatting
document: paragraph format, Aligning text and Paragraph, Border and shading, header and
footer, multiple columns.
UNIT-II
Word-processing: Advanced Feature of MS Word: Find and replace, checking the grammar and
spelling, formatting via find and replace, using the thesaurus, using Auto correct, Auto complete
and Auto Text, Word count, Hyphenating, Mail merge, mailing labels Wizard and Templates,
handing graphic, tables insert and modification, converting of tables, converting a word
document into various formats like – Text, Rich Text Format, Word Perfect, HTML etc.
UNIT-III
Worksheet : MS-Excel : Worksheet basics, Creating worksheet, entering data into worksheet,
heading information, data, text dates, alphanumeric, values, saving & quitting worksheet,
opening and moving around in an existing worksheet, toolbars and menus , keyboard shortcut ,
working with single and multiple worksheet , coping, renaming, moving between work books,
working with formulas & cell referencing – Auto sum, Coping formulas, absolute & relative
addressing, working with range – creating editing and selecting range, formatting of worksheet –
Auto format, changing –alignment, character styles, column width, date format , border & colors,
currency sign.
UNIT-IV
Worksheet : MS-Excel: Previewing & Printing Worksheet- Page setting , print titles ,Adjusting
margins, page break , headers and footer, graphs and chart – using wizard, various chart types,
formatting grid lines & legends , previewing & printing charts , database – creation , sorting,
query & filtering a database , function – database , date and times, maths & Trigonometry,
statistical, Text and logical function, creating and using macros, multiple worksheet – concept,
creating and using.
MMYVVDDE
UNIT-V
MS PowerPoint: Introduction and area of use, working with MS PowerPoint, creating a new
presentation working with presentation, using wizards, slides& different views, deleting coping
slides, working with notes, handout, columns and list, adding graphics, sound and movies to a
slide, working with power point objects designing and presentation of a slide show, printing and
presentation, notes, Handouts with print options.
Outlook Express: Setup E-mail account with outlook, sending and receiving mail through
outlook, concepts of CC,BCC, forwarding mail, draft message, formatting E-mail message,
Concept of MIME protocol, attaching files and items into messages, inserting hyperlink using
outlook editor and using send and receive group mails, opening received message, opening
message with attachment, replying to mail forward message flagging for further action, setting
email options, managing contacts with outlook, setting up multiple email accounts on single
machine.
Reference Books:
• Window XP Complete Reference , BPB Publication
• MS Office XP Complete BPB Publication
• IT Tools and Applications Pragya Publications
MMYVVDDE
PROGRAMMING METHODOLOGY AND C PROGRAMMING
UNIT - I
Program Concept, Characteristics of Programming, Various Stages in Program Development, Algorithms,
Flow Charts, Programming Techniques – Top Down, Bottom Up, Modular, Structured, Features, Merits,
Demerits and Their Comparative Study. Programming Logic - Simple, Branching, Looping, Recursion,
Programming Testing & Debugging.
UNIT- II
Introduction to C Language, C Language Standards, Features of C, Structure of C Program, Introduction
to C Compilers, Creating and Compiling C Programs, IDE, Features of Turbo C Compiler. Keywords,
Identifiers, Variables, Constants, Scope and Life of Variables, Local and Global Variable, Data Types,
Expressions. Operators - Arithmetic, Logical, Relational, Conditional and Bit Wise Operators, Precedence
and Associativity of Operators, Type Conversion. Basic Input/Output Library Functions ,Character
Input/Output getch(), getchar(). getche(), putchar(). Formatted Input/Output - printf() and scanf(),
Mathematical & Character Functions.
UNIT- III
Declaration Statement, Conditional Statement - if Statement, if else Statement, Nesting of if... .else
Statement, else if Ladder, The ?: Operator, switch Statement. Iteration Statements - for Loop, while Loop,
do-while Loop. Jump Statements: break, continue, goto, exit(). Arrays - Concept of Single and Multi
Dimensional Arrays Strings: Declaration, Initialization, Functions .
UNIT – IV
The Need of C Functions, User Defined and Library Function, Prototype of Functions, Prototype of
main() Function, Calling of Functions, Function Arguments, Argument Passing: Call By Value and Call
By Reference, Return Values. Nesting of Function, Recursion, Array as Function Argument, Command
Line Arguments, Storage Class Specifier - Auto, Extern, Static, Register.
UNIT - V
Defining Structure, Declaration of Structure Variable, Type def, Accessing Structure Members, Nested
Structures, Array of Structure, Structure Assignment, Structure as Function Argument, Function that
Return Structure, Union.
TEXT & REFERENCE BOOKS:
• BALAGURUSWAMY, "PROGRAMMINGIN C ", TMH PUBLICATIONS
• GOTTFRIED SCHAUMS OUTLINE SERIES, "PROGRAMMING WITH C ", TMH PUBLICATIONS
• MAHAPATRA, " THINKING IN C ", (PHI)PUBLICATIONS
• ANURAG SEETHA, "INTRODUCTION TO COMPUTERS AND INFORMATION TECHNOLOGY",
RAIN PRASAD & SONS, BHOPAL
• S.K. BASANDRA, "COMPUTERS TODAY", GALGOTIA PUBLICATIONS.
• PETER JULIFF "PROGRAM DESIGN" PHI PUBLICATIONS
MMYVVDDE
DESK TOP PUBLISHING (DTP)
Unit - I
Introduction to DTP. Definition, Importance, characteristics. Use of DTP in publishing &
Newspaper Printing. Various DTP Software. Bit stream & vector graphics. Printers –Dot Matrix,
Inkjet and Laser. Introduction to offset printing technology. Typography – history , element ,
selection of fonts, point use of blank spaces and dashes, white spaces , various breaks ,Good
designing and Easy readability . Different Measurement used in DTP printing
Unit - II
Introduction to Adobe PageMaker. Why Page Maker popular in publication. Toolbox , Styles,
Menus, Templates. Page Orientation & Page Setup . Importing &Text block. Spell Check & find
& Replace. Working with text and graphics. Columns & gutters. Different Page Layouts. Master
page , page Numbering. Auto flow. Story Editor & Layout view. Attribute setting , Alignments ,
grids, and Guides etc. Tab setting.
Unit - III
Import & Export of files. Styles & Palettes. Using colors. Fonts: Post script font , true types
fonts, bit stream & vector fonts. Column Balancing , Breaks. I Reverse Text. Reverse Command
. Printing Options. Placing Text Graphic. Picture Editing . Bullets, Masking. Window & Orphan
Lines. Text Wrapping. Drop Caps. Control PaletteClips & Image Files. OLE & Embedding .
Plugging. Tables Editors . Filters , Layer , PDF files. Header & Footers. Key board Control.
Linking . Mathematics equation. Printing Options. Frame options.
Unit - IV
Photoshop- History & introduction, the file menu, the tools, Drawing lines & shapes. Inserting
picture and shapes, filling colors, text effects, working with layers, filters. Creating design
patterns, Photoshop presentations -static & dynamic presentation. WEB & WEB GALLERY
using internet explorer in photo shop. Creating animations using image ready, creating
animations & presentations . Tips and tricks in Photoshop.
Unit - V
Corel draw –An overview, menus and tools. Drawing –lines, shapes .inserting-pictures, objects,
tables, templates. Adding special effects, Exporting drawings, outlining & filling objects,
inserting symbols & Clip arts. Working in Corel draw presentation –adjusting the position,
resizing, positioning, merging, color shades & shadows .working with advanced effects, special
interactive effects. Creating- business cards, pamphlets, banners, news papers, books. Shortcut
keys in Corel draw.
MMYVVDDE
Maharishi Vedic Science – II
UNIT – I
Classical and Scientific introduction about forty areas of Vedic Science.
UNIT – II
Third Law of Thermodynamics.
Miessener’s effect.
Maharish’s Effect-Society, Environment, Behavior and effect on moral value.
UNIT – III
Pradhavansabhav, Atantabhav, Annyonabhav, Pragbhav.
Meaning of “Yogastha Kuru Karmani”
Meaning of “Gyanam Chetanayam Nihitam”
UNIT – IV
Theory of Karma-Prarabadha, Kriyamana, Sanchieta.
Theory of Invincibility .
Introduction to Maharishi absolute theory of Government.
UNIT – V
Theory of Ayurved.
Theory of Dincharya & Ritucharya.
Text and Reference Books : -
Maharishi Sandesh Part – I, II
Chetna Vigyan- His Holiness Maharishi Mahesh Yogi Ji. MMYVVDDE
INTERNET & WEB PAGE DESIGNING
Unit - I
Internet: Evolution, Protocols, Concept, Internet Vs Intranet, growth of Internet, ISP,
Connectivity ,Dial-up, leased line, VSAT etc, URls, Domain names, Portals, Application.
E-Mail: Concept, POP and Web Based E-mail, merit, address basics of sending & Receiving, Email protocols, mailing list, and free E-mail services.
Unit - II
File transfer Protocols, Telnet & chatting: Data Transmission Protocols, Client /Server
Architecture & its Characteristics, FTP & Its usages telnet Concept, Remote Logging, Protocols,
Terminal Emulation Massage Board, Internet chatting –voice chat, text chat.
Unit - III
World Wide Web (WWW): History, Working, Web Brower, its function, Concept of Search
Engine, Searching the web HTTP, URLS, Web Server, Web Protocols.
Unit - IV
Web Publishing: Concept , Domain name Registration , space on Host Server for web site,
HTML, Design tools, HTML editor , Image editor , issues in web site creation & maintenance,
FTP software for upload web site.
Unit - V
HTML: Concept of Hypertext , Version of HTML , Element of HTTML, syntax , head & body
section Building HTML document , Inserting Text , Image , Hyperlinks , Background and color
controls , different HTML tag , Tables , Tables layout and presentation use of size & Attributes ,
List types and its tags.
Text & Reference Books
1. Level Madul M. 1.2 Internet & Web page Designing by Y.K Jain, BPB Publication
2. Internet for Dummies –Pustak Mahal , New Delhi.
3. Internet & E-commerce A. Mansoor & Dr.Anrag Seetha ,Pragya Publication .
MMYVVDDE
PROGRAMMING IN VISUAL BASIC
Unit-I
Integrated Development Environment of Visual Basic: Integrated Development Environment of
VB, User Interface Designing, Basic of Event Driven Programming. From – designing, Showing
& hiding.
Unit-II
Visual Basic Language: Data types, variable & Constant, arrays, dynamic array, array as
function , collections, procedures, arguments passing , function return values.
Control flow statements: if –then –else, select case, looping statement: Do-loop, for-next, WhileWend, Nested Control Structure, Exit stmt.
Unit-III
Building Blocks of Visual Basic: Basic Active X Control & their Use –Textbox, list box, combobox, scrollbar, slider & fire controls.
Graphic controls, Image Handling in VB, Coordinate System, Graphic method- Text Drawing,
lines& shape, filling shape and grid methods.
Unit-IV
Components of visual Basic: Menu editor: pull down and pop-up menus, Multiple Document
interface –parent & Child form & Methods.
Error handing: Types of Error, Error handing method and function.
Unit-V
Database Programming with VB: Database programming with VB-Data Control – method ,
Properties, Connectivity with database.
Ref. Books:-
Beginner’s Guide to V.B. 6 by Reeta Sahoo
V.B. by Pragya Publication
MMYVVDDE
DBMS using MS Access
UNIT–I
Introduction To Database Systems Purpose of Database System, View Of Data, Characteristics
of Database Approach, Architecture for a Database System, Advantages and Disadvantages Of
DBMS, Database Users and Administrator, Database Design and ER Model , Data Model
Classification. Why use a Relational Database.
UNIT–II
Introduction to MS Access. Create a Table in MS Access -Data Types, Field Properties, Fields:
names, types, properties--default values, format, caption, validation rules Data Entry, Add
record, delete record and edit text, Sort, find/replace, filter/ select, rearrange columns, freeze
columns. Edit a Tables- copy, delete, import, modify table structure, find, replace.
UNIT–III
Add a relationship, set a rule for Referential Integrity, change the join type, delete a relationship,
save relationship Queries & Filter - difference between queries and filter, filter using multiple
fields ,Create Query with one table, find record with select query, find duplicate record with
query, find unmatched record with query, run query, save and change query.
UNIT–IV
Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, Main/ Sub-forms,
add headers and footers, add fields to form, add text to form use label option button, check box,
combo box, list box Forms Wizard, Create Template, Navigation between forms.
UNIT–V
Introduction to Reports, Types of Basic Reports: Single Column, Tabular Report Groups/Total,
single table report, multi table report preview report print report, Creating Reports and Labels,
Wizard COMPUTERISED ACCOUNTING
UNIT-I
Basic Concept of Accounting Financial Statements, Financial, Statements, Analysis, Cost
Centre, Basic concept of Inventory, Tally Configuration & INI setup, Data Directory & Folder,
Configuration, Single &Multiple User Tally Screen Components, Mouse / keyboard Convention
&Key, Combination switching between screen areas, Quitting Tally. Maintaining Company data
Create/Alter/Select/load/Close a Company, Chart of Account, Company Features, Configuration.
UNIT-II
Create, Alter & display Groups, Ledgers, All accounting voucher types and transactions ,create
and Alter new Voucher types, Item and Account Invoice Transaction, Excise Invoice, Export
Invoice, Transaction using Bill-wise detail create, Alter &Display Cost Center and Cost
Categories, Cost centre& cost Category allocation in voucher entry, Creating Cost centre Class,
Invoice entry in a Class situation, Create , Alter & Delete Foreign Currencies, Voucher entry
using foreign currency Bank reconciliation, Interest calculation using simple &advance
parameter, Interest calculation on outstanding balance &on invoices, Use of voucher class,
adjustment of interest, Creation of voucher class Invoices entry in a class situation.
UNIT-III
Create, Alter & delete Budgets for groups, Ledger & cost center, Defining Credit Limit & Credit
period, Display Budgets & variances, Create Alter &Delete a scenario. Enabling Job Costing in
Tally, Master creation &configuration for job costing , creation of voucher types & Voucher
class for stock Transaction , Creation of Transfer journal for transfer of stock between godowns,
Consumption journal Transaction, Payment voucher , Go down summary Report , job Works
Analysis , Material consumption summary . Report Like balance sheet , profit &loss account
Ratio analysis, Trial Balance Account books Like cash /bank books, All Ledger Group summary
&voucher , Sales , purchase &journal registers , cost centre &category summary , cost centre
breakup, ledger & group breaker, outstanding receivables & payables, interest receivable
&payable, statistics, cash &fund flow, day books, list of Accounts, Reversing journals, optional
voucher, post –dates vouchers.
UNIT-IV
Create, Alter & Display Stock Group and Stock Item, Stock item behaviour using costing and
market valuation method, other behaviour like treating all sales as new manufacture, treating all
purchase as consumed, treating all rejection inward as scrap, ignoring negative balances, treating
difference due to physical counting, Create Alter & display stock categories, Create, Alter,
Display simple &compound units of measures, stock item using alternate units , Defining
standard cost & selling prices , Defining Rate of duty, Defining MRP, Create ,Alter &Display
MMYVVDDE
Godown, Allocation of item to the Godowns, All Inventory voucher types and transaction,
Inventory detail in accounting voucher. Defining re-order Level, Transaction using tracking
number, Use of batch –wise detail in accounting voucher, Additional cost detail in voucher,
creating Bill of material, cost estimation, creating prices list & defining Prices levels, invoices
using Prices List, Zero valued entries, Transaction in case of Different actual & billed quantities
.Report Like Stocks summary, Inventory books Like Stock item, Group summary, Stock transfer,
physical stocks register, Movement analysis, stock group & item analysis, stock category
analysis, Ageing analysis, sales order & Purchase order books , Statement of inventory related to
Godowns, categories, stocks query, Reorder status, Purchase & sales order summary, Purchases
&sales bill pending, exception report stocks & Ledger, overdue receivables & payables,
memorandum voucher, optional voucher, post –dated voucher, reversing journals.
UNIT-V
Cheque Printing, Common Printing options, Different printing formats, Multi-Account printing,
Dynamic Report specific options. Creating Group company, Use of Tally vault, Using security
control & defining different security Levels, Use of Tally Audit, Backs –Up & Restore, splitting
company data, Export & Import of data, ODBC compliance, use of E-Mail, Internet publishing,
Upload, Web browser & online help, Rewrite data
PGDCA
OPERATING SYSTEM
UNIT-I
Disk Operating System (DOS) Introduction History & version of DOS basic –physics structure of disk drive name ,
Fat ,File & directory structure and naming rules , booting process , DOS system files. DOS command: Internal –DIR
, MD , CD,RD,COPY,DEL, REN , VOL,DATE,TIME,CLS,PATH, TYPE etc. External – CHKDSK, XCOPY,
PRINT, DISKCOPY, DISKCOMP, DOSKEY, TREE,MOVE, LABEL, APPEND, FORMAT, SORT, FDISK,
BACKUP, EDIT, MODE, ATTRIB , HELP, SYS ,etc Executable V/s Non executable file in DOS.
UNIT-II
Window XP introduction to Window XP and its features. Hardware requirement of Window , Window concept ,
Window Structure , Desktop , Taskbar , Start Menu, My Picture , My Music ,Working with recycle bin-restoring a
delete file , emptying the recycle bin. Managing files, folder and disk-navigating between folder , manipulating files
and folder , creating new folder , searching files and folder ,my computer –exploring hard disk , coping and moving
files and folder from one drive to another map, paint , command prompt window explore –exploring hard disk ,
coping and moving files and folder from one drive to another , formatting floppy drive and other Explore facilities
burning CD Entertainment CD player , DVD Player , Media Player , sound Recorder , volume Control , movies
maker.
UNIT-III
Advances Feature of window XP: Managing hardware & Software – Installing of Hardware & Software , using
Scanner web camera , printer sharing tools-backup , Character map , clipboard viewer , disk defragmenter , drive
space , scandisk , system information , system monitor , drive converter (FAT 32) , disk cleanup , using window
update . communication – Dial up Networking Direct Cable connection , hyper terminal , phone dial , Browsing the
web with internet explorer , communication through outlook express , Multiple user feature of Window Creating and
deleting user , changing user password , etc Accessibility Feature of window –Sharing Information Between
Program , Sharing folder and drives browsing the entire networks , mapping window shared drives , using shared
printer –understanding OLE-Embed/link Using cut and paste a Embed /link using Insert Object –Manage
embedded / Linked Object.
UNIT-IV
Linux : history & feature of Linux Structure file system of Linux , hardware requirement of Linux various flavors
of Linux Program & process , Process creation and process identifier , function of profile and login file in Linux
kernel.
UNIT-V
Multi –User feature of Linux , login and logout from Linux system ,Linux command – be, cal , cat , cd, chgrp,
chmod, clown ,clear , cmp, copy, date, find, ps, kill, is, mail, mkdir, more, my, rm, rmdir, wc, who, who is, grep,
write, telnet, pipeline, concept, using, floppy, and cdrom, in linux, vi editor.
Text & Reference book:
• Dos Quick reference by Rajeev Mathura , Golgotha publication
• Linux computer by BPB publication
• Peter Norton Complete Guide To Linux By peter Norton .
PC PACKAGES
UNIT-I: Office Packages – Office activities and their software requirement., word Processing,
spreadsheet, presentation graphics, database, introduction and comparison of various office suites like MS
office, Lotus Office, Star Office, Open Office etc, MS Word Basics: Introduction to MS Office;
Introduction to MS Word; Features & area of use. Working with MS Word; Menus & Commands;
Toolbars & Buttons; Shortcut Menus, Wizards & Templates; Creating a New Document ; Different Page
Views and layouts; Applying various Text Enhancements; Working with – Styles, Text Attributes;
Paragraph and Page Formatting; Text Editing using various features; Bullets, Numbering, Auto
formatting, Printing & various print options.
UNIT – II: Advanced Features of MS-Word : Spell Check, Thesaurus, Find & Replace; Headers &
Footers; Inserting – Page Numbers, Pictures, Files, Auto texts, Symbols etc.; Working with Columns,
Tabs & Indents; Creating & Working with Tables including conversion to and from text; Margins &
Space management in Document; Adding References and Graphics; Mail Merge, Envelops & Mailing
Labels.
UNIT – III: MS Excel: Introduction and area of use; Working with MS Excel.; concepts of Workbook &
Worksheets; Using Wizards; Various Data Types; Using different features with Data, Cell and Texts;
Inserting, Removing & Resizing of Columns & Rows; Working with Data & Ranges; Different view of
Worksheets; Column Freezing, Labels, Hiding, Splitting etc.; Using different features with Data and Text;
Use of Formulas, Calculations & Functions; Cell Formatting including Borders & Shading; Working with
Different Chart Types; Printing of Workbook & Worksheets with various options.
UNIT – IV: MS Power Point: Introduction & area of use; Working with MS Power Point; Creating a
New Presentation; Working with Presentation; Using Wizards; Slides & its different views; Inserting,
Deleting and Copying of Slide; Working with Notes, Handouts, Columns & Lists; Adding Graphics,
Sounds and Movies to a Slide; Working with Power Point Object; Designing & Presentation of a Slide
Show; Printing Presentations, Notes, Handouts with print options.
UNIT – V: Outlook Express: Setup E-mail account with outlook, sending and receiving mail through
outlook, concepts of CC and BCC, forwarding mail, Draft messages, formatting E-mail message, Concept
of MIME Protocol, attaching files and items into messages, inserting hyperlink using outlook editor
creating and using send and receive group E-Mails, opening received messages, opening messages with
attachment, replying to mail forwarding messages flagging for further action, setting email option,
managing contacts with outlook, Setting up multiple email accounts on single machine.
TEXT & REFERENCE BOOKS:
Windows XP Complete Reference, BPB Publications.
MS Office XP Complete BPB Publication.
MS Windows XP Home edition complete, BPB Publications.
I.T. Tools and Applications, A. Mansoor, Pragya Publications.
Programming Fundamentals using C
UNIT - I
Program Concept, Characteristics of Programming, Various Stages in Program Development, Algorithms,
Flow Charts, Programming Techniques – Top Down, Bottom Up, Modular, Structured, Features, Merits,
Demerits and Their Comparative Study. Programming Logic - Simple, Branching, Looping, Recursion,
Programming Testing & Debugging.
UNIT- II
Introduction to C Language, C Language Standards, Features of C, Structure of C Program, Introduction
to C Compilers, Creating and Compiling C Programs, IDE, Features of Turbo C Compiler. Keywords,
Identifiers, Variables, Constants, Scope and Life of Variables, Local and Global Variable, Data Types,
Expressions. Operators - Arithmetic, Logical, Relational, Conditional and Bit Wise Operators, Precedence
and Associativity of Operators, Type Conversion. Basic Input/Output Library Functions ,Character
Input/Output getch(), getchar(). getche(), putchar(). Formatted Input/Output - printf() and scanf(),
Mathematical & Character Functions.
UNIT- III
Declaration Statement, Conditional Statement - if Statement, if else Statement, Nesting of if... .else
Statement, else if Ladder, The ?: Operator, switch Statement. Iteration Statements - for Loop, while Loop,
do-while Loop. Jump Statements: break, continue, goto, exit(). Arrays - Concept of Single and Multi
Dimensional Arrays Strings: Declaration, Initialization, Functions .
UNIT – IV
The Need of C Functions, User Defined and Library Function, Prototype of Functions, Prototype of
main() Function, Calling of Functions, Function Arguments, Argument Passing: Call By Value and Call
By Reference, Return Values. Nesting of Function, Recursion, Array as Function Argument, Command
Line Arguments, Storage Class Specifier - Auto, Extern, Static, Register.
UNIT - V
Defining Structure, Declaration of Structure Variable, Type def, Accessing Structure Members, Nested
Structures, Array of Structure, Structure Assignment, Structure as Function Argument, Function that
Return Structure, Union.
TEXT & REFERENCE BOOKS:
• BALAGURUSWAMY, "PROGRAMMINGIN C ", TMH PUBLICATIONS
• GOTTFRIED SCHAUMS OUTLINE SERIES, "PROGRAMMING WITH C ", TMH PUBLICATIONS
• MAHAPATRA, " THINKING IN C ", (PHI)PUBLICATIONS
• ANURAG SEETHA, "INTRODUCTION TO COMPUTERS AND INFORMATION TECHNOLOGY",
RAIN PRASAD & SONS, BHOPAL
• S.K. BASANDRA, "COMPUTERS TODAY", GALGOTIA PUBLICATIONS.
• PETER JULIFF "PROGRAM DESIGN" PHI PUBLICATIONS
Maharishi Vedic Science – II
UNIT – I
Classical and Scientific introduction about forty areas of Vedic Science.
UNIT – II
Third Law of Thermodynamics.
Miessener’s effect.
Maharish’s Effect-Society, Environment, Behavior and effect on moral value.
UNIT – III
Pradhavansabhav, Atantabhav, Annyonabhav, Pragbhav.
Meaning of “Yogastha Kuru Karmani”
Meaning of “Gyanam Chetanayam Nihitam”
UNIT – IV
Theory of Karma-Prarabadha, Kriyamana, Sanchieta.
Theory of Invincibility .
Introduction to Maharishi absolute theory of Government.
UNIT – V
Theory of Ayurved.
Theory of Dincharya & Ritucharya.
OOPS AND PROGRAMMING WITH C++
UNIT-I
PRINCIPLES OF OBJECT-ORIENTED PROGARAMMING: Object-Oriented Programming Paradigm, Basic
Concepts of Object- Oriented Programming, Benefits of OOPs, Object-Oriented Languages, Applications of OOP,
C++ Statements, Class, Structure of C++, Program, Creating the Source File, Compiling and Linking.
UNIT-II
TOKENS, EXPRESSIONS AND CONTROL STRUCTURES: Introduction Tokens, Keywords, Identifiers, Basic
Data types, User Defined Data Types, Derived Data Types, Symbolic Constants, Type Compatibility, Declaration of
Variables, Dynamic Initialization of Variables, Reference Variables, Operators in C++, Scope Resolution Operator,
Member Dereferencing Operators, Manipulators, Type Cast Operator, Expressions and Implicit Conversions,
Operator Precedence, Control Structures.
UNIT-III
CLASSES AND OBJECTS: Specifying a class, Defining Member Function, making an Outside Function Inline,
Nesting of Member function, private member function, Arrays within a class, Memory Allocation for Objects, Static
Data Member, Static Member Functions, Arrays of Objects, Object as Function Arguments.
CONSTRUCTORS AND DESTRUCTORS: Introduction, Constructors, parameterized Constructors, Multiple
Constructors with Default Arguments, Dynamic Initialization of Objects, Copy Constructors, Dynamic Constructors
and Destructor.
FUNCTIONS IN C++: The Main Function, Function Prototyping, call by Reference, Return by reference, Inline
Functions, Default Argument, Const. Arguments ,Function Overloading, Friend and Virtual Function.
UNIT-IV
OPERATOR OVERLOADING AND TYPE CONVERSIONS: Introduction, Defining Operator Overloading,
Overloading Unary Operators, Overloading Binary Operators Using Friends, Manipulation of strings using
operators, Rules for Overloading Operators, Type conversions.
UNIT-V
INHERITANCE: EXTENDING CLASSES: Introduction, Defining Derived Classes, Single Inheritance Making a
Private Member Inheritable, Multilevel Inheritance, Multiple Inheritance ,Hierarchical Inheritance, Hybrid
Inheritance.
POINTERS. VIRTUAL FUNCTIONS AND Compile time, run time , Pointers to Objects, This Pointer, Pointers to Derived Classes, Virtual Functions, Pure Virtual
Functions.
TEXT & REFERENCE BOOKS:
Object Oriented Programming with C++ by E. Publications ISBN 0-07-462038-x
Object Oriented Programming in C++ by SAMS PHI Pvt. Ltd.
Insights into OOPS & C++. Publications .
System Analysis and Design
UNIT-I
The System Concept, Characteristics, Elements and Types of a system, System Development
Life Cycle (SDLC) , Considerations for candidate systems and Prototyping. The role of System
Analyst.
UNIT-II
System planning and Initial Investigation Information Gathering, information gathering tools.
Structured Analysis, The Tools of Structured Analysis (DFD, Data Dictionary, Decision tree and
Pseudo Codes Decision Tables), pros and cons of each tool. System performance definition,
description of outputs, Feasibility Study Cost/ Benefit Analysis: Data Analysis, Cost/Benefit
Analysis, The system proposal.
UNIT-III
The process and Stages of System Design: Design methodologies, development activities. Input
design, output design forms design, types of forms, and basics of form design, layout
considerations and forms control.
UNIT-IV
File structure, file organization, objectives of database, data structure. System Testing and
Quality Assurance, Why system testing, what do we test for, the test plan quality assurance,
trends in testing, role of data processing auditor. Training and Documentation.
UNIT-V
Implementing and software maintenance, Conversion, combating, resistance to change, post
implementation review, software maintenance. Hardware/Software Selection and the Computer
Contract, suppliers, procedure for hardware/software selection, financial considerations in
selection, the computer contract. System Security, Disaster Recovery Planning . • Information Technology & Computer Applications, • System Analysis and .
DATA BASE MANAGEMENT SYSTEM
UNIT – I DBMS: An Introduction : Data Base Management System-Basic Concepts, Data and Database, Database
System: Concept and Meaning, Disadvantages of File Systems, Advantage of Database Approach, Disadvantages of
Using a DBMS, Database Languages, Database Administrator, .
UNIT- IV Relational Database Design : Functional Dependencies, Anomalies in Databases, Functional
Dependencies, Inference Rules fur FDs, Attribute Closure, Normal Forms, First Normal Form, Second Normal
Form, Third Normal Form, Boyce-Codd Normal Form, Decomposition and Other Dependencies, Attribute
Preservation, Loss-Less Join Decomposition, Dependency Preservation, Multi-Valued Dependency, Join
Dependencies, The Process of Normalization.
UNIT – V Database organization. PHI
PROGRAMMING WITH VB. NET
UNIT-I
Introduction to Net, Net framework feature & architecture, CLR common Type System, MSIL,
Assemblies and class libraries. UNIT-III
Working with form: Loading showing and hiding form, controlling , one form within another . GUI
Programming with window form: Textbox , label , Button , list box, combo box, checkbox, picture box,
radio button , panel , scroll bar, timer , list view , tree view , toolbar , status bar , There properties ,
method and events . Open file Dialog. Save file Dialog, font Dialog , color Dialog , print Dialog , link
label . Designing menus: context Menu & shortcut Keys.
UNIT-IV
Object oriented programming: classes & object, field properties, Method & Event, Constructor, and
Inheritance. Access specifies: Public Private, Projected. Overloading , my base & My class Keyword ,
Overview of OLE, Accessing the Win 32 API from VB.net .com technology , advantage of com+, com &
.net , create User control , register User control , access com component in net application.
UNIT-V
Database programming with ADO.Net – Overview of ADO, from ADO to ADO.net Accessing data using
server explore, creating connection, command, data Adapter and data set with OLEDB and SQLDB.
Display data on data bound control, display data on data grid.
COMPUTER HARDWARE AND NETWORKING
Hardware and Networking Course
Syllabus
Jaora infotech is one of its kind Institute which not only equips you in technology skills but will trainyoufor free in Aptitude skills, Soft Skills, Mock Interviews, Interview Skills, Work ethics andCorporate Values that you need to know to get into IT Industry. Our training is given by expertreal time development experienced trainers and we enable each and every student of ourstodo their own real time projects by the end of the program. We do not buy you a job by bribing companies to secure a place in IT, instead we equipyouwith the skills needed to get employed in IT and will support you with unlimited number of
relevant interview opportunities so that your career in IT becomes assured. Our support will bethere until you get placed in an IT Company as that’s our mission too.
If you want to just have an IT certification, you can do your course anywhere. Basic Hardware and Networking Content
Basic Introduction About (Hardware & Software)
Os installation (Windows & Linux)
Ms-Dos command & Basic Unix command
Hardware device (SMPS, RAM & ROM, Hard Disk, Mother Board, Processor)
Hardware Troubleshooting
System Assembling & Assembling
Mail configuration & Mail Backup
System Image Backup & Types of Data Backup
RAID Configuration
A+ Course Content
Operating Systems (Edition, Requirement, Types of Installation, Driver Installation)
Dual OS installation, Dos Command, Backup and Restore, User Control, Control Panel
Computer Peripherals – (Input and Output Devices, Primary Component, Computers
Language, Serial and parallel Communication, SMPS)
Motherboard (Type, form factor, BUS, IRQ, Chipset, I/O Ports and Connectors, CMOS)
Memory (Type, Memory Modules, Development of RAM
Comparison of RAM, Virtual Memory, BIOS, POST)
Hard Disc (Type, Port, File systems, jumper Setting, Disk Type, Components)
Processor (Type, ZIF and SEC, Supports, Virtual Support, Cache, Cores information)
External Drives (CD and DVD Drive, Blue-ray, Floppy Disk, Modem, and Printers)
Ubuntu (H/W Requirement, basic Command, installation)
Assembling and Dis-assembling components, Component upgrade
Troubleshooting N+ Course
Content
Introduction (Types of Network, Topology, protocols, and Ports)
Networking devices (Routers, Switches, Hub, Repeater, NIC Cards, Bridge)
Networking Media (Wire, Wireless, Cables, Crimping, UTP)
Networking Layers (OSI, TCP/IP)
IP Addresses (Version, Classes, Types)
Subnetting (VLSM, FLSM, CIDR, Super netting)
tally accounting course
Detailed Syllabus of Tally.ERP9 With GST
1. Company Info Menu
Select Company
Shut company
Create company
Alter company
Security control
Change tally vault
Split company data
Backup
Restore
Tally audit feature
2. Accounting Information
Accounting Configuration &
Features
Group Creation
Multiple Group Creation
Ledger Creation
Multiple Ledger Creation
New Voucher Creation
Advance Ledger Creation
3. Inventory Information
Inventory configuration &
features
Inventory info. Menu
Stock groups
Stock categories
Stock item
Unit of measurement
Bills of materials
Locations / Godowns
Batches & Expiry
Inventory voucher types
HSN Code Updates
4. Voucher Entry
Accounting voucher
Inventory voucher
optional & non-accounting
voucher
Order processing
Advanced voucher entry
5. Advanced Accounting
Features
Cost category & cost
centres
Budgets
Interest calculations
Cheque printing
Credit limits
Scenario management
Reorder levels & reorder
quantity
Price level & price lists
6. Quick setup
Tally .net
Excise for manufactures
Excise for dealer
Value-Added Tax
Tax deducted at source
Tax collected at source
7. Taxation
Excise for manufacture
Service tax
Tax deducted at
source(TDS)&TCS
Value added tax(VAT)
Central state tax(CST)
Payroll features of Tally
8. Data management &
Administration
Backup & Restore
Split a company, export &
Import of data
E-Capabilities (E-mail a
report from tally. E.R.P9)
Uploading the reports
generated from tally.E.R.P9
Tally ODBC, Inward
connectivity
Security controls
Tally Audit Feature
Tally Vault
9. Reports
Display financial statements
(Display balance – sheet,
configuring the balance sheet,
Integrate accounts with
inventory, setting closingstock manually in the balance
sheet with different stock
valuation methods)
Display profit & loss
A/c(configuring profit & loss
A/c , income/expense
statement instead of P&L)
Display trial balance
(configuring in trial balance)
Display registers & ledgers
(display sales register ,
purchase register, cash book ,
bank book, journal register,
day book, statement of
accounts
10. Online Taxation Return
Fill online ITR(Income Tax
Return) download and filling
forms.
Fill online VAT,CST Return
Excise Return & Forms
Online service tax return
TCS,TDS return
11. Introduction to GST
Concept of GST
Rate of GST
GST in other countries
Categories of GST
Other concepts.
12. GST (Goods & Services Tax)
Start Using Tally.ERP9
For GST Compliance
Activating GST For Your
Company
Setting Up GST Rates
Updating Stock Items
and Stock Groups for
GST Compliance
Updating a Service
Ledger for GST
Compliance
Updating Sales and
Purchase Ledgers for
GST Compliance
Updating Party GSTIN
Creating GST Ledgers
Creating Income and
Expense Ledgers
Recording Sales and
Printing Invoices
Recording Purchases
Recording a Tax
Payment
Transferring Tax Credits
of VAT, excise and
service tax to GST
Other Scenarios
Sales - Nil Rated,
Exempt, SEZ, and
Deemed Export
Recording Sales Returns
Recording Purchase
Returns
Recording Export Sales
Reverse Charge under
GST
Recording an Advance
Receipt from Customer
Recording an Advance
Payment to Supplier
Recording Journal
Vouchers for
Adjustments Against Tax
Credit
Recording a Journal
Voucher for TDS
Adjustment
Recording a Journal
Voucher for TCS
Adjustment
Recording a Journal
Voucher for Refund of
Tax Credit
Recording a Journal
Voucher for ISD Credit
Recording a Journal
Voucher for Transitional
Credit
Recording Journal
Vouchers for Other
Liabilities
Recording Journal
Vouchers for Reversal of
Tax Credit
GSTR-1
Returns Summary
Particulars (Computation
Details)
Summary of Exceptions
Table-wise GSTR-1
Status Reconciliation
Exporting GSTR-1
Challan Reconciliation
