Contents

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
• COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
• UNIT -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.
• UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.
• e- SIKSHA :: o Computer Fundamentals. o Operating system (windows xp,7/8). o M.S Word (concept). o Online banking, internet, Emailing, online mobile recharge, online rail ticket & flight ticket booking.

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.
• • Windows Explorer - Creating folders and other Explorer facilities.
• • Entertainment - CD Player, DVD Player, Media Player, Sound Recorder, Volume Control.
• PAGE MAKER

DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.
• DOS basic :- • Physical structure of disk, drive name, FAT, file & directory structure and naming rules, booting Process, DOS system files.
• Basic DOS Commands :- • Internal - DIR, MD, CD, RD, copy, DEL, REN, VOL, DATE, TIME, CLS, PATH, TYPE etc. • External - CHKDSK, PRINT, DISKCOPY, DOSKEY, MOVE, LABEL, FORMATE, SORT, FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS, etc. • Executable V/S Non executable files in DOS.

MS WORD

• (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
• ( INSERT MENU):- Table Use, Shapes, Clipart And Picture, Word Art, Smart Art, Columns And Orderings- To Add, Columns To Document Change The Order And Objects, Smart Art, Hyperlink, Bookmark, Cross- Reference, Header And Footer, Page Number, Text Box, Quick Parts, Drop Cap, Signature Line, Date And Time, Equation Symbol
• (PAGE LAYOUT):-Themes, Margins, Orientation, Size, Columns Page Breaks, Line Numbers, Hyphenation, Watermark, Pagecolor, Page Borders, Left And Rigt Indent ,Before And After Spacing, Position, Bring Front, Send To Back, Text Warpping Align, Group, Rotate
• (REFERENCES):- Table Of Contents, Add Text, Update Table, Insert Footnote, Insert Endnote, Next Footnote, Show Notes, Insert Citation, Manage Sources, Style, Bibliography, Insert Caption Insert Table Of Figures, Update Table, Cross- References, Mark Entry, Insert Infex, Update Index, Mark Citation, Insert Table Of Authorities
• (MALLING )-Envelopes, Labels, Start Mail Merge, Select Recipients, Edit Recipients List, Highlight Marge Fields, Address Block, Greeting Line, Insert Merge Field, Rules, Match Fields Update Labels, Preview Results,Previous Record, Next Record, Last Record, Find Recipient, Auto Check For Errors, Finish & Merge
• (REVIEW)-Spelling & Grammar, Research, Thesaurus, Translate, Translation Screen tip, Set Language, Word Count, New Comment, Delete, Previous, Next, Track Changes, Balloons, Final Showing Markup, Show Markup, Reviewing Pane, Accept, Reject, Previous And Next, Compare, Show Source Documents, Protet Document
• (VIEW)- print layout, full screen, web layout, outline, draft, ruler, gridlines, document map, thumbnails, zoom, one page, two, page, page width, new window, arrange all, split, switch windows, macros

MS-EXCEL

• -CREATE WORKSHIT AND WORKBOOKS- create a workbook, import data from a delimited text file, add a worksheet to an existing workbook, copy and move a worksheet.
• NAVIGATE IN WORKSHEETS AND WORKBOOKS- search for data within a workbook, navigate to NAMED cell, range, or workbook element, insert and remove hyperlinks.
• Format worksheets and workbooks- change worksheet tab color, raname a worksheet, change worksheet order, insert and delete columns,or rows, change workbook themes , Adjust row height and column width, insert headers and footers,

TALLY PRIME & G.S.T.

• BASIC OF ACCOUNTIN• introduction • types of accounts • accouting principles of concepts • mode of accounting • rules of accounting • double entry system of book keepingG
• FUNDAMENTALS OF TALLY • company features • configuration • geeting functions with tally prime • creation/ setting up of company in tally prime
• ACCOUNTING MASTERS • chart of groups • groups • multiple groups • ledgers • multiple ledgers
• INVENTORY MASTERS • stock groups • multiple stock groups • stock categories • multiple stock categories • unit of measure • stock items
• ACCOUNTING TRANSACTIONS VOUCHERS Account Transactions Vouchers a)payment (b)receipt (c) contra (d) sales (e)purchase (f)debit note (g) credit notes(h)journal
• INVENTORY TRANSACTIONS VOUCHER (a)stock journal (b) physical stock voucher (c)manufacturing journal (d) purchase order (e) sales order (f) goods receipt note. delivery note, rejection outwords, inwards
• ADVANCE ACCOUNTING bill-wise details cost centers and cost categories, multiple calculations, interest calculations, budget and controls , scenario management, bank reconciliation.
• ADVANCE INVENTORY order processing , recorder levels, batch- wise details, bill of materials, different actual and billed quantities, price lists, zero-valued entries, additional cost details ,pos
• TAX - TDS (Tax Deducted At Source)-understanding TDS, creating TDS masters, practical examples, TDS payment
• TAX - TCS-(Tax Collect At Source)-understanding TCS, creating TCS masters, practical examples, TCS payment
• GST--(Goods And Service Tax) about goods and services Tax(GST), Activating Tally in GST, setting UP GST (company level, ledger level or inventory level), GST Taxes & invoices, Understanding SGST ,CGST, IGST
• GST(Goods And Service Tax) --Taxes & invoices, understanding SGST,CGST,&IGST, creating GST masters in tally, updating GST masters for suppliers, practical on inter- state purchase entry in GST(SGST+CGST) practical on inter-state purchase entry in gst(IGST), GST purchase entry for undergistered dealer in tally.
• GST(Goods And Service Tax) --GST time of supply, GST place of supply, Transitional problems, input Tax credit GST valuation GST returns , GST registration , GST payment , GST Assessments, GST refund ,GST penalties, GST Advance Ruling , GST advance ruling ,GST ftp, GST customs Duty, GST moot Court, GST Ethical Practice.
• TECHNOLO LOGICAL ADVANTAGES tally vault, security controls, tally audit, backup and restore, split company data, create a company logo,
• PAYROLL ACCOUNTING employee Creation, salary define, employee attendance register, pay heads creation, salary report
• GENERATING REPORTS financial statements, trading account, profit a loss account, balance sheet, accounts books and reports, inventory books and reports ,exception reports,
• ASSIGNMENTS QUESTIONS what is financial accounting? Objectives of financial accounting classification of accounts, explain the features of tally, what is security? explain types of security control, difference between manual accounting and electronic accounting, what is ledger? explain the various types of ledger. what is balance sheet, profit & loss & trail balance? short note on VAT, difference between input and output vat. what is budget? types of budgets. write short note on cost center. explain the various types of voucher in tally ? minimum 12 vouchers. write note GST,IGST, CGST adjustment entries of GST,

NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,
• WEB DESIGN- web site design principles, planning the site and navigation,
• INTRODUCTION TO XHTML-xml, Move to xhtml. Meta tags, character entitites,frames and frame sets.inside browser.

COMPUTER NETWORKING (N+)

• • Fundamental of Networks • Configure the Lan, Man, Wan Networks
• • Configure the peer to peer & server client Networking • Networking Transmission Media(Wire,Wireless,UTP, STP,Fiber Optic,Coaxial)
• • Networking Device(Hub,Switch,Bridge,Router) • Network Operating System
• • Installing Lan Card & configure IP Addressing • Infrastructure of networking
• • The OSI Model &TCP/IP Model
• • Lan & Wan remote access technologies • Networking Troubleshooting

C LANGUAGE

• Introduction and First Program :- why Programming, History of Language, Hello World Program Variables and Data types :- Identifiers in C, Variables and Data types, Constants
• Console IO Operations :- Peintf Scanf, Unfomatted IO Functions
• Operators and Expressions :- Expressions and Arithmetic Operators, Relational and Logical Operators, Bitwise Operators
• Control Flow Statements :- If Statements, Switch Statement, Unconditional Branching using goto Statement, While Loop, For Loop, Break and Continue, Special Cases
• Working with Functions :- Introduction and Writing Functions, Scope of Variables, Storage Classes, Pass by Value and reference Recursion
• Working with Arrays :- Arrays Declaration and Initialization, Sample Programs using Arrays, Arrays as Function Parameters, 2-Dimensional Array
• Pointers :- Introduction to Pointers, Pointers as Function Parameter, pointers Arithmetic, Pointers and Arrays, Function Pointers, Dynamic Memory Allocation using malloc
• String Handling :- Introduction to Strings, Sample Program, More Sample Programs, Standaed String Library Functuion, Array of String
• Structures and Unions :- Declaring and Instantiating Structures, Structure as Parameter and pointer to Structure, ENumetated Data Type, Union, Bit Fields
• File Handling :- What is a stream, File Handling-Writing and Reading Characters, Writing and Reading structure in Text Format, Writing and Reading in Binary Format
• Pre-Processor Directives :- Understanding Pre-Processor directives, Header Files and Project
• Command Line Arguments and Variable Arguments :- Command Line Argument, Variable Number of Arguments

JAVA (Core Java and Advanced Java Syllabus Introduction)

• Introduction Programming language Types and Paradigms, Computer Programming Hierarchy, How Computer Architecture Affects a Language ? , Why Java ? ,Flavors of Java, Java Designing Goal, Role of Java Programmer in Industry, Features of Java Language, JVM –The heart of Java , Java’s Magic Bytecode.
• The Java Environment: Installing Java, Java Program Development , Java Source File Structure ,Compilation, Executions.
• Basic Language Elements: Lexical Tokens, Identifiers, Keywords, Literals, Comments ,Primitive Datatypes, Operators Assignments.
• Object Oriented Programming Class Fundamentals , Object & Object reference , Object Life time & Garbage Collection, Creating and Operating Objects , Constructor & initialization code block, Access Control, Modifiers, methods Nested , Inner Class &Anonymous Classes ,Abstract Class & Interfaces Defining Methods, Argument Passing Mechanism , Method Overloading, Recursion, Dealing with Static Members, Finalize() Method, Native Method. Use of “this “ reference, Use of Modifiers with Classes & Methods, Design of Accessors and Mutator Methods Cloning Objects, shallow and deep cloning, Generic Class Types.

PYTHON COURSE SYLLABUS

• Our Python course syllabus is framed by our Industry experts. This Python and Django course content covers all the latest topics from basics to advanced level like Python for Machine Learning, AI, Web development and Data Science.
• Module 1: An Introduction to Python  What can Python do?  Why Python?  Good to know  Python Syntax compared to other programming languages  Python Install
• Module 2: Beginning Python Basics  The print statement  Comments  Python Data Structures & Data Types  String Operations in Python  Simple Input & Output  Simple Output Formatting  Operators in python
• Module 3: Python Program Flow  Indentation  The If statement and its’ related statement  An example with if and its related statement  The while loop  The for loop  The range statement  Break &Continue  Assert  Examples for looping
• Module 4: Functions& Modules  Create your own functions  Functions Parameters  Variable Arguments  Scope of a Function  Function Documentations  Lambda Functions& map  n Exercise with functions  Create a Module  Standard Modules
• Module 5: Exceptions Handling  Errors  Exception handling with try  handling Multiple Exceptions  Writing your own Exception
• Module 6: File Handling  File handling Modes  Reading Files  Writing& Appending to Files  Handling File Exceptions  The with statement

HTML

• Introduction to web programming:-It talks about the architecture of a website and the different technologies used to design a website
• Introduction to HTML:-HTML tags versus HTML elements, history of HTML, how a design a first HTML page, HTML attributes , etc. are discussed in this subject
• HTML Basic Formatting Tags:-HTML colour coding , HTML basic tags, and formatting tags are covered here
• HTML- Grouping using Div Span:-The span and DIV tags used to format HTML web pages are introduced in this subject.
• HTML Lists:-The definition of HTML lists, their significance ,types of HTML lists like ordered and unordered lists, etc, are discussed here.
• HTML Images:-The use of image mapping in embedding images into HTML pages are explained in this module.
• HTML Hyperlink:- This subject focuses on uniform Resource Locator (URL) and related concepts. it also takes about URL encoding and the importance of hyperlinks in web pages.
• HTML Tables:- This module teaches how to represent tables in a webpage.
• HTML iFrame : How to use iFrame tag and attributes to embed one web page into another via nested browsing context is covered in this module.
• HTML Form:-It discusses the syntax used to integrate forms in web pages and also talks about their importance in websites.
• HTML Headers:-Scrip , Title, Base, and other elements of HTML headers are explained in this subject.
• HTML Miscellaneous:-HTML Meta, tag, XHTML, and HTML deprecated tags and attributes are covered in this module.

Contents

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
• COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
• UNIT -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.
• UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.
• e- SIKSHA :: o Computer Fundamentals. o Operating system (windows xp,7/8). o M.S Word (concept). o Online banking, internet, Emailing, online mobile recharge, online rail ticket & flight ticket booking.

DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.
• DOS basic :- • Physical structure of disk, drive name, FAT, file & directory structure and naming rules, booting Process, DOS system files.
• Basic DOS Commands :- • Internal - DIR, MD, CD, RD, copy, DEL, REN, VOL, DATE, TIME, CLS, PATH, TYPE etc. • External - CHKDSK, PRINT, DISKCOPY, DOSKEY, MOVE, LABEL, FORMATE, SORT, FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS, etc. • Executable V/S Non executable files in DOS.

MS WORD

• (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
• ( INSERT MENU):- Table Use, Shapes, Clipart And Picture, Word Art, Smart Art, Columns And Orderings- To Add, Columns To Document Change The Order And Objects, Smart Art, Hyperlink, Bookmark, Cross- Reference, Header And Footer, Page Number, Text Box, Quick Parts, Drop Cap, Signature Line, Date And Time, Equation Symbol
• (PAGE LAYOUT):-Themes, Margins, Orientation, Size, Columns Page Breaks, Line Numbers, Hyphenation, Watermark, Pagecolor, Page Borders, Left And Rigt Indent ,Before And After Spacing, Position, Bring Front, Send To Back, Text Warpping Align, Group, Rotate
• (REFERENCES):- Table Of Contents, Add Text, Update Table, Insert Footnote, Insert Endnote, Next Footnote, Show Notes, Insert Citation, Manage Sources, Style, Bibliography, Insert Caption Insert Table Of Figures, Update Table, Cross- References, Mark Entry, Insert Infex, Update Index, Mark Citation, Insert Table Of Authorities
• (MALLING )-Envelopes, Labels, Start Mail Merge, Select Recipients, Edit Recipients List, Highlight Marge Fields, Address Block, Greeting Line, Insert Merge Field, Rules, Match Fields Update Labels, Preview Results,Previous Record, Next Record, Last Record, Find Recipient, Auto Check For Errors, Finish & Merge
• (REVIEW)-Spelling & Grammar, Research, Thesaurus, Translate, Translation Screen tip, Set Language, Word Count, New Comment, Delete, Previous, Next, Track Changes, Balloons, Final Showing Markup, Show Markup, Reviewing Pane, Accept, Reject, Previous And Next, Compare, Show Source Documents, Protet Document
• (VIEW)- print layout, full screen, web layout, outline, draft, ruler, gridlines, document map, thumbnails, zoom, one page, two, page, page width, new window, arrange all, split, switch windows, macros

MS-EXCEL

• -CREATE WORKSHIT AND WORKBOOKS- create a workbook, import data from a delimited text file, add a worksheet to an existing workbook, copy and move a worksheet.
• NAVIGATE IN WORKSHEETS AND WORKBOOKS- search for data within a workbook, navigate to NAMED cell, range, or workbook element, insert and remove hyperlinks.
• Format worksheets and workbooks- change worksheet tab color, raname a worksheet, change worksheet order, insert and delete columns,or rows, change workbook themes , Adjust row height and column width, insert headers and footers,

MS EXCEL (Advance)

• INTRODUCTIONTOCOMPUTERS  Fontformatting  Numberformatting  Tableformatting  Conditionalformatting  Hide/Unhide  Sort/filter  Pastespecial  Findandselect
• INSERT  Illustrations  Charts  Te
• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
• DATA  Import from web  Import from text  Text to columns  Remove duplicates  Grouping and ungrouping
• REVIEW  Proofing  Comments  Protection
• VIEWS  Typesofviews  Zoom  Windows
• DEVELOPER  Enable developer  Using checkbox/option buttons
• BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
• ABSOLUTE REFERENCING  Problems with Absolute/ Relative Cell Referencing  CreatingAbsolute/MixedReferences
• LOOK UP FUNCTIONS  TheVLOOKUP/HLOOKUP Functions
• PIVOT TABLES  Creating,FormattingSimplePivotTables  PageFieldina PivotTable  Formattinga PivotTable  Creating/Modifyinga PivotChart
• LOGICALFUNCTIONS  IFs and Nested IF Functions  UsingAND/OR /NOTFunctions
• STATISTICALFUNCTIONS  UsingTheSUMIF/COUNTIFFunctions  UsingTheAVERAGE/COUNT/LARGER/SMALLERFunctions
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• LOOKUPFUNCTIONS–ADVANCE  MATCHwithVLOOKUP Functions  INDEX&MATCH Functions  OFFSET/INDIRECT functions
• LOGICALFUNCTIONS–ADVANCE  If Loop and Nested IF LoopFunctions  UsingIF/ISERRORFunctions
• CHARTDATATECHNIQUES  TheChart Wizard  ChartTypes  AddingTitle/ Legends/ Lables  PrintingCharts  AddingDatatoaChart  Formatting/Renaming/DeletingDataSeries  ChangingtheOrderofData Series
• DATE/TIMEFUNCTIONS  UsingTheToday  Now& DateFunctions  UsingTheDatedif/Networkdays/EomonthFunctions  UsingTheWeeknumFunctions  UsingTheEdate/Networkdays.Intl/Weekdays.IntlFunctions
• TEXTFUNCTIONSUSING  TheMid/Search/Left/RightFunctions  UsingTheTrim/Clean/Upper/Lower Functions  UsingTheSubstitute/ TextFunctions  UsingTheTrim/Clean/Proper/DollarFunction
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting
• ADVANCEDFILTERS  ExtractingRecordswithAdvancedFilter  UsingFormulasinCriteria
• ADVANCEDSORTING  SortingbyToptoBottom/Leftto Right  Creating/DeletingCustom List  SortbyusingCustomList
• HYPER/DATA LINKING  Hyperlinkingdata,withinsheet/workbook  Linking&Updating links between work books & application
• MATH&TRIGONOMETRYFUNCTIONS  UsingSUMPRODUCTFunctions  UsingFLOOR/CEILING/MROUND/MOD/QUOTIENT Functions
• SUMMARIZINGDATA  CreatingSubtotals/Nested Subtotals  SUBTOTALSFormula
• OUTLINING  Creating/WorkingwithanAutomatic/Manual Outline  Grouping/Ungrouping
• CONSOLIDATION  ConsolidatingDatawithIdentical/DifferentLayout
• USINGAUDITINGTOOLS  Displaying/RemovingDependent&PrecedentArrows  EvaluateFormula–StepIN/StepOut
• CUSTOMVIEWS  CreatingCustomViews  DisplayingCustomViews  DeletingCustomViews
• SHARINGANDPROTECTINGWORKBOOKS  SharingWorkbooks&Tracking Changes  Protectingsheets/workbooks/Files
• IMPORTING&EXPORTINGDATA  ImportingDatafromDatabase/TextFiles/Web  ExportingData  ChangingExternalDataRange
• ANAGEWORKSHEETSAND WORKBOOKS  Importdataintoworkbooks  Importdatafrom.txtfiles  Importdatafrom.csv files  Navigatewithinworkbooks  Search for data within a workbook  Navigatetonamedcells,ranges,orworkbook elements  Insertandremovehyperlinks  Formatworksheetsandworkbooks  Modify page setup  Adjust row height and column width  Customize headers and footer  Customize options and views  Customize the Quick Access toolbar  Display and modify workbook contenting different views  Freeze work sheet rows and columns  Change window views  Modify basic workbook properties  Display formulas
• MANAGEDATACELLSAND RANGES  Mani palate data in worksheets  Paste data busing special paste options  Fill cells busing AutoFill  Insert and delete multiple columns or rows  Insert and delete cells  Format cells and ranges  Merge and unmerge cells  Modify cell alignment ,orientation, and indentation  Format cells by using Format Painter  Wrap text within cells  Apply number formats  Apply cell formats from the Format Cells dialog box  Apply cell styles  Clear cell formatting  Define and reference named ranges  Define named range  Summarize data visually  Insert Spark lines  Apply built-in conditional formatting  Remove conditional formatting
• MANAGETABLESANDTABLEDATA  Create and format tables  Create Excel tables from cell ranges  Apply table styles  Convert tables to cell ranges  Modify tables  Add or remove table rows and columns  Configure table style options  Insert and configure total rows
• PERFORMOPERATIONSBYUSINGFORMULASAND FUNCTIONS  Insert references  Insert relative, absolute ,and mixed references  Reference named ranges and named tables in formulas  Calculate and trans form data  Perform calculations by using the AVERAGE(),MAX(),MIN(),and SUM()  Count cells busing the COUNT(), COUNTA(), and COUNTBLANK()Functions  Perform conditional operations by using the IF() function  Format and modify text  Format text by using RIGHT(), LEFT(), and MID() functions  Format text by using UPPER(), LOWER(), and LEN() functions  Format text by using the CONCAT() and TEXTJOIN() functions
• MANAGE CHARTS  Create charts  Create charts  Create chart sheets  Modify charts  Add data series to charts  Switch between rows and columns in source data  Add and modify chart elements  Format charts  Apply chart layouts  Apply chart styles  Add alternative text to charts for accessibility

MS POWERPOINT

• (GETTING ACQUAINTED WITH POWERPOINT)The PowerPoint envirionmment,the title bar, the ribbon, the Microsoft office button, the quick access toolbar, the scroll bar, the presentation view buttons, the zoom slider, the status bar, the mini Toolbar, keyboard shortcuts
• ( CREATING BASIC PRESENTATIONS)-opening presentations, cloning presentations, creating new presentations, saving presentations, saving presentations, inserting new slides, applying slide layouts, using the "package for CD feature", working with power point file formats
• (USING PRESENTATIONS VIEWS)-normal view, slide sorter view, notes page view, slide show view.
• (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
• (USING CLIP ART) -Inserting Clip Art , And Pictures, Basic Graphic Manipulation, Using Picture Tools, The Format Picture Dialog Box
• (USING SMARTART)-Inserting And Manipulating Smart art, Formatting Smart art,
• (USING SLIDE SHOW VIEW)-Running a slide show, using custom shows.
• (PRINTING YOUR PRESENTATION)-

MS ACCESS

• 1. Introduction to Database Management :- Type of Database, Examples of DBMS
• 2. Definitions :- Table, Field, Field Name, Record, Database, Database Object
• 3. Opening Microsoft Access :- Start button & Desktop icon
• 4. Creating a Database file :- Designing a table - Field names, Data Types, Description
• 5. Data Types :- Text, Number, Data/Time, Yes/No, Currency, Memo, AutoNumber, Ole Object, Lookup Wizard
• 6. Entering Records within a table
• 7. Editing parts of a table :- Selecting, Renaming, Inserting, Deleting, Hiding, Freezing, Resizing
• 8. Sorting Records
• 9. Moving to specific records :- First, Last, Previous, Next, New
• 10. Formatting e table :- Font, Cells
• 11. Checking Spelling , Finding and Replacing data

C LANGUAGE

• Introduction and First Program :- why Programming, History of Language, Hello World Program Variables and Data types :- Identifiers in C, Variables and Data types, Constants
• Console IO Operations :- Peintf Scanf, Unfomatted IO Functions
• Operators and Expressions :- Expressions and Arithmetic Operators, Relational and Logical Operators, Bitwise Operators
• Control Flow Statements :- If Statements, Switch Statement, Unconditional Branching using goto Statement, While Loop, For Loop, Break and Continue, Special Cases
• Working with Functions :- Introduction and Writing Functions, Scope of Variables, Storage Classes, Pass by Value and reference Recursion
• Working with Arrays :- Arrays Declaration and Initialization, Sample Programs using Arrays, Arrays as Function Parameters, 2-Dimensional Array
• Pointers :- Introduction to Pointers, Pointers as Function Parameter, pointers Arithmetic, Pointers and Arrays, Function Pointers, Dynamic Memory Allocation using malloc
• String Handling :- Introduction to Strings, Sample Program, More Sample Programs, Standaed String Library Functuion, Array of String
• Structures and Unions :- Declaring and Instantiating Structures, Structure as Parameter and pointer to Structure, ENumetated Data Type, Union, Bit Fields
• File Handling :- What is a stream, File Handling-Writing and Reading Characters, Writing and Reading structure in Text Format, Writing and Reading in Binary Format
• Pre-Processor Directives :- Understanding Pre-Processor directives, Header Files and Project
• Command Line Arguments and Variable Arguments :- Command Line Argument, Variable Number of Arguments
• Searching and Sorting :- Linear Search, Iterative Binary Search, Recursive Binary Search, Bubble Sort, Selection Sort, Insertion Sort, Quick Sort, Merge Sort
• Stack :- Introduction to Data Structures.

PHOTOSHOP

• • All Tools (Marquee Tool, Magnetic Tool, Slice Tool, Patch Tool, Clone Stamp Tool, Gradient Tool, Smudge Tool, Blur Tool, Text Tool etc.)
• • Fill, Stroke Option • Histogram, Group, Ungroup
• • Lock Object, Color Range • Feather, Modify
• • Grow, Filter • Liquify, Artistic
• • Blur, Video Option etc.

CorelDraw

• • Logo Designing, Frame Settings • Graphical Tools, Bitmap & Shadow Effects
• • Special Effects such as Perspective • Blending, Text Settings into objects
• • Alignment Setting • Tabs, Power Line
• • Power Clip • Contour
• • Import & Export Facility

HTML

• Introduction to web programming:-It talks about the architecture of a website and the different technologies used to design a website
• Introduction to HTML:-HTML tags versus HTML elements, history of HTML, how a design a first HTML page, HTML attributes , etc. are discussed in this subject
• HTML Basic Formatting Tags:-HTML colour coding , HTML basic tags, and formatting tags are covered here
• HTML- Grouping using Div Span:-The span and DIV tags used to format HTML web pages are introduced in this subject.
• HTML Lists:-The definition of HTML lists, their significance ,types of HTML lists like ordered and unordered lists, etc, are discussed here.
• HTML Images:-The use of image mapping in embedding images into HTML pages are explained in this module.
• HTML Hyperlink:- This subject focuses on uniform Resource Locator (URL) and related concepts. it also takes about URL encoding and the importance of hyperlinks in web pages.
• HTML Tables:- This module teaches how to represent tables in a webpage.
• HTML iFrame : How to use iFrame tag and attributes to embed one web page into another via nested browsing context is covered in this module.
• HTML Form:-It discusses the syntax used to integrate forms in web pages and also talks about their importance in websites.
• HTML Headers:-Scrip , Title, Base, and other elements of HTML headers are explained in this subject.
• HTML Miscellaneous:-HTML Meta, tag, XHTML, and HTML deprecated tags and attributes are covered in this module.

VISULBASIC 6.0

• Getting Started- Procedure For Starting, Printing the Program, Saving the Program, Reloading a Program, Exiting Basic, Loading .tax Files.
• Screen Output- Programming Practices and conventions, The REM Statement, The CLS Command, The Print Command, print With a Semicolon, Print With a comma, On Your Own, Positioning output on the screen, Summary, Putting It All Together
• Input Values and Output Displays - Data Type Values, Variables, Assignment Statements, Displaying Values, Dialog Boxes, Numeric Values as Input. creating output Menus, Putting it all Together
• Numeric Calculations- operations, Functions and Expressions, Operation Hierarchy, Sub expressions, Built In Function, Concatenation, Formatting Output, Putting It All Together
• Decision Making - Simple comparisons, Numeric Comparisons, Strings, Character Representation, Dictionary Ordering, String comparisons, Conditional Statements, Simple if blocks, The Else option, compound conditional if Blocks, Multi-case if Blocks, Putting It All Together
• Branching - Ling Labels, Unconditional Branching, 3 Repetition of Code, Conditional Branching, Repetition a Number of Times, Sentinels, Prompt and Echo, 8 User Interrogation Technique, 9 Putting It All Together
• For ..Next Loops - The For ..Next loop, The Step Parameter, Program Applications, Generalized Functionality, Nested Loops , Putting It All Together
• Random Numbers - The Rnd Function, Using Randomize, Coin Tossing , Tossing a Biased Coin, Die Rolling, Scaling the Rnd Function , A Simulation , Putting If All Together
• Graphics- Resolution and Color, 2 Coloring Pixels , 3 Drawing Lines, Using the PSet Command, Using the Ling Command, 6 Drawing Rectangles, Drawing Circles , Drawing Arcs, Drawing sectors , Drawing Ellipses, Fill Styles, 12 A Pie chart, Histograms Putting If All Together
• Arrays and Tables - Defining an Array, The syntax of Defining Arrays, Assigning and Using Values in an Array, Finding the Average and the Standard Deviation, File Input, Using Arrays- Searching an Array , Using Arrays -Finding a Smallest Element in an Array, Using Arrays - interchanging Two Elements in an Array , using Arrays -sorting an Array , using Arrays - Finding a Distribution of Elements, Using Arrays - Parallel Arrays, Using Arrays - Drawing A Pie Chart, Using Arrays - Drawing a Histogram , Putting If All Together

PAGE MAKER

• • Type Settings for Publication, • Page Layout, Word Wrapping, • Grouping, Merging two or more files,
• • Creating columns, Tab settings, • Paragraph settings, Hyphenation, • Paper Style, Index & Table of Contents
• • Fonts, Mixing Text & Graphics, • Linking objects, Printing facility.

Concept of software

• • Types of Software - System software, Application software, Utility software, Demo ware, Shareware, Freeware, Firmware, Free software.
• • Operating System - Functions, Types - Batch Processing, Single User, Multi User, Multiprogramming, Multi- Tasking.
• • Programming languages - Machines Assembly, High Level, 4 GL.
• • Data representation in computers .
• • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.
• • Coding System - ASCII, BCD, and EBCDIC etc.
• • Computer Viruses.

Contents

C LANGUAGE

• Introduction and First Program :- why Programming, History of Language, Hello World Program Variables and Data types :- Identifiers in C, Variables and Data types, Constants
• Console IO Operations :- Peintf Scanf, Unfomatted IO Functions
• Operators and Expressions :- Expressions and Arithmetic Operators, Relational and Logical Operators, Bitwise Operators
• Control Flow Statements :- If Statements, Switch Statement, Unconditional Branching using goto Statement, While Loop, For Loop, Break and Continue, Special Cases
• Working with Functions :- Introduction and Writing Functions, Scope of Variables, Storage Classes, Pass by Value and reference Recursion
• Working with Arrays :- Arrays Declaration and Initialization, Sample Programs using Arrays, Arrays as Function Parameters, 2-Dimensional Array

C++.Net technology

• C++ overview
• Function and variables
• Operator overloading
• Initialisation assignment

Contents

TAILOR TRAINING

• 1. Stitching techniques. 2. Dress measurements & Techniques. 3. Anatomy of Drafting Garments calculation and Drafting patterns. 4. Method to Fold the Fabric for patterns. 5. Terms used in Tailoring janala ( A top for n new born child or a small kid). 6. Frock petticoat. 7. Summer frock. 8. Yoke frock. 9. Frock with a separate body and skirt. 10. Flared skirt. 11. Umbrella skirt. 12. Saree petticoat. 13. Plain blouse. 14. Cut blouse with plain sleeve. 15. Cut blouse with puff sleeve. 16. Saree blouse with liming. 17. Salwar kameez. 18. SKIRT TOPS:- 19. Skirt tops 1:- Magyar pattern and front full opening. 20. Skirt tops 2:- Top with full opening and collar. 21. Ladies Night Dress.

Contents

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
• COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
• UNIT -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.
• UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.

NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,
• WEB DESIGN- web site design principles, planning the site and navigation,

COMPUTER NETWORKING (N+)

• • Fundamental of Networks • Configure the Lan, Man, Wan Networks
• • Configure the peer to peer & server client Networking • Networking Transmission Media(Wire,Wireless,UTP, STP,Fiber Optic,Coaxial)
• • Networking Device(Hub,Switch,Bridge,Router) • Network Operating System
• • Installing Lan Card & configure IP Addressing • Infrastructure of networking
• • The OSI Model &TCP/IP Model
• • Lan & Wan remote access technologies • Networking Troubleshooting

CCNA/Cisco Certified Network Associate

• • Introduction reference Model • Internetworking of Router& Switch
• • Network Types &Media • Configure the TCP/IP, Subletting
• • IP Addressing &Routing Protocols • WAN Technology &Protocols
• • Operating &Configuring Cisco IOS device • Managing your Network Environment
• • Extending Switched Networking with VLANs • Spanning Tree Protocol Overview
• • Determining Route • Enhanced IGRP and OSPFP protocol.
• • Managing IP Traffic with Access Lists • Establishing Serial Point-to-Point Connections
• • Establishing Frame Relay Connections • Building NAT(Network Address Translation)

Contents

COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s
• • Installation parts of PC’s • Installation PC(OS, Drivers ,Software)
• • Install Configure Optimize and Upgrade PC’s • Printer &Scanners Installation and using.
• • Troubles hooting techniques for OS&Software • Maintenance of PC ’components

Contents

BEAUTICIAN

• BEAUTY MANAGEMENT: o Business management + professional conduct. o Nutrition, dietary and figure control. o Sterilization and hygiene.
• SKIN & HAIR TREATMENT: o Manage saloon with latest equipment & technology. o Prepare cosmetics for their own use. o Run slimming center with latest gadgets. o Treat different types of skin with facial techniques. o Set & cut hair in different/latest style. o Give high fashion look to hair by perming & colouring. o Accenture good features and hide out bad features by corrective make-up.
• MAKEUP ARTIST :o Professional Makeup. o H.D. Make-up. o Party Makeup. o Personal Grooming. o Different types of hair style,sari Draping. o International products knowledge.

Contents

C++.Net technology

• C++ overview
• Function and variables
• Operator overloading
• Initialisation assignment
• Polymorphism input and output c++ programs
• Introduction to . Net framework... . Net framework architecture

Contents

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
• COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
• UNIT -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.
• UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.
• e- SIKSHA :: o Computer Fundamentals. o Operating system (windows xp,7/8). o M.S Word (concept). o Online banking, internet, Emailing, online mobile recharge, online rail ticket & flight ticket booking.

Concept of software

• • Types of Software - System software, Application software, Utility software, Demo ware, Shareware, Freeware, Firmware, Free software.
• • Operating System - Functions, Types - Batch Processing, Single User, Multi User, Multiprogramming, Multi- Tasking.
• • Programming languages - Machines Assembly, High Level, 4 GL.
• • Data representation in computers .
• • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.
• • Coding System - ASCII, BCD, and EBCDIC etc.
• • Computer Viruses.

HTML

• Introduction to web programming:-It talks about the architecture of a website and the different technologies used to design a website
• Introduction to HTML:-HTML tags versus HTML elements, history of HTML, how a design a first HTML page, HTML attributes , etc. are discussed in this subject
• HTML Basic Formatting Tags:-HTML colour coding , HTML basic tags, and formatting tags are covered here
• HTML- Grouping using Div Span:-The span and DIV tags used to format HTML web pages are introduced in this subject.
• HTML Lists:-The definition of HTML lists, their significance ,types of HTML lists like ordered and unordered lists, etc, are discussed here.
• HTML Images:-The use of image mapping in embedding images into HTML pages are explained in this module.
• HTML Hyperlink:- This subject focuses on uniform Resource Locator (URL) and related concepts. it also takes about URL encoding and the importance of hyperlinks in web pages.
• HTML Tables:- This module teaches how to represent tables in a webpage.
• HTML iFrame : How to use iFrame tag and attributes to embed one web page into another via nested browsing context is covered in this module.
• HTML Form:-It discusses the syntax used to integrate forms in web pages and also talks about their importance in websites.
• HTML Headers:-Scrip , Title, Base, and other elements of HTML headers are explained in this subject.
• HTML Miscellaneous:-HTML Meta, tag, XHTML, and HTML deprecated tags and attributes are covered in this module.

SQL

• . Introduction to SQL (What is SQL?, Purpose of SQL, Who should learn SQL?, What are the subsets of SQL?, Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL)
• Introduction to Databases and RDMBS (What is a Database?, Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases vs. No SQL Databases)
• . Install a Database Engine (Download MS SQL Server or Oracle or MySQL Database Engine, and Install. Launch SQL Server Management Studio, Select New Query, and launch SQL Query. Type SQL
• SQL Syntax (Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.)
• SQL Data Types (SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and Miscellaneous data types.)
• SQL Operators (SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators)
• SQL Expressions (SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression)
• SQL Comments (SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments)
• . SQL – Data Definition Language Commands and Operations. (SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename. Data Definition Language Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.)
• SQL – Data Manipulation Language Commands and Operations (Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE. Data Manipulation Language Operations, Retrieving data from a table, Inserting data into a table, Updating existing data into a table, and Deleting all records from a table.)
• SQL – Data Control Language Commands DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.
• . DCL Operations (Providing the users the access or privileges to the database objects, and Taking back or canceling the privileges or permissions previously allowed or denied to the users.)

C LANGUAGE

• Introduction and First Program :- why Programming, History of Language, Hello World Program Variables and Data types :- Identifiers in C, Variables and Data types, Constants
• Console IO Operations :- Peintf Scanf, Unfomatted IO Functions
• Operators and Expressions :- Expressions and Arithmetic Operators, Relational and Logical Operators, Bitwise Operators
• Control Flow Statements :- If Statements, Switch Statement, Unconditional Branching using goto Statement, While Loop, For Loop, Break and Continue, Special Cases
• Working with Functions :- Introduction and Writing Functions, Scope of Variables, Storage Classes, Pass by Value and reference Recursion
• Working with Arrays :- Arrays Declaration and Initialization, Sample Programs using Arrays, Arrays as Function Parameters, 2-Dimensional Array
• Pointers :- Introduction to Pointers, Pointers as Function Parameter, pointers Arithmetic, Pointers and Arrays, Function Pointers, Dynamic Memory Allocation using malloc
• String Handling :- Introduction to Strings, Sample Program, More Sample Programs, Standaed String Library Functuion, Array of String
• Structures and Unions :- Declaring and Instantiating Structures, Structure as Parameter and pointer to Structure, ENumetated Data Type, Union, Bit Fields
• File Handling :- What is a stream, File Handling-Writing and Reading Characters, Writing and Reading structure in Text Format, Writing and Reading in Binary Format
• Pre-Processor Directives :- Understanding Pre-Processor directives, Header Files and Project
• Command Line Arguments and Variable Arguments :- Command Line Argument, Variable Number of Arguments
• Searching and Sorting :- Linear Search, Iterative Binary Search, Recursive Binary Search, Bubble Sort, Selection Sort, Insertion Sort, Quick Sort, Merge Sort
• Stack :- Introduction to Data Structures.

JAVA (Core Java and Advanced Java Syllabus Introduction)

• Introduction Programming language Types and Paradigms, Computer Programming Hierarchy, How Computer Architecture Affects a Language ? , Why Java ? ,Flavors of Java, Java Designing Goal, Role of Java Programmer in Industry, Features of Java Language, JVM –The heart of Java , Java’s Magic Bytecode.
• The Java Environment: Installing Java, Java Program Development , Java Source File Structure ,Compilation, Executions.
• Basic Language Elements: Lexical Tokens, Identifiers, Keywords, Literals, Comments ,Primitive Datatypes, Operators Assignments.
• Object Oriented Programming Class Fundamentals , Object & Object reference , Object Life time & Garbage Collection, Creating and Operating Objects , Constructor & initialization code block, Access Control, Modifiers, methods Nested , Inner Class &Anonymous Classes ,Abstract Class & Interfaces Defining Methods, Argument Passing Mechanism , Method Overloading, Recursion, Dealing with Static Members, Finalize() Method, Native Method. Use of “this “ reference, Use of Modifiers with Classes & Methods, Design of Accessors and Mutator Methods Cloning Objects, shallow and deep cloning, Generic Class Types.
• Extending Classes and Inheritance Use and Benefits of Inheritance in OOP, Types of Inheritance in Java, Inheriting Data members and Methods , Role of Constructors in inheritance , Overriding Super Class Methods ,Use of “super” , Polymorphism in inheritance ,Type Compatibility and Conversion Implementing interfaces.
• Package Organizing Classes and Interfaces in Packages , Package as Access Protection , Defining Package ,CLASSPATH Setting for Packages , Making JAR Files for Library Packages Import and Static Import Naming Convention For Packages.
• Exception Handling: The Idea behind Exception ,Exceptions & Errors ,Types of Exception ,Control Flow In Exceptions, JVM reaction to Exceptions ,Use of try, catch, finally, throw, throws in Exception Handling ,In-built and User Defined Exceptions, Checked and Un-Checked Exceptions.
• Array & String : Defining an Array, Initializing & Accessing Array, Multi –Dimensional Array, Operation on String, Mutable & Immutable String, Using Collection Bases Loop for String, Tokenizing a String, Creating Strings using String Buffer .
• Thread : Understanding Threads , Needs of Multi-Threaded Programming ,Thread Life-Cycle, Thread Priorities ,Synchronizing Threads, Inter Communication of Threads ,Critical Factor in Thread –Dead Lock
• A Collection of Useful Classes Utility Methods for Arrays ,Observable and Observer Objects , Date & Times ,Using Scanner Regular Expression, Input/Output Operation in Java(java.io Package),Streams and the new I/O Capabilities ,Understanding Streams, The Classes for Input and Output, The Standard Streams, Working with File Object, File I/O Basics, Reading and Writing to Files, Buffer and Buffer Management, Read/Write Operations with File Channel, Serializing Objects
• GUI Programming Designing Graphical User Interfaces in Java, Components and Containers, Basics of Components, Using Containers, Layout Managers, AWT Components, Adding a Menu to Window, Extending GUI Features Using Swing Components, Java Utilities (java.util Package) The Collection Framework : Collections of Objects , Collection Types, Sets , Sequence, Map, Understanding Hashing, Use of ArrayList & Vector.
• Event Handling Event-Driven Programming in Java, Event- Handling Process, Event-Handling Mechanism, The Delegation Model of Event Handling, Event Classes, Event Sources, Event Listeners, Adapter Classes as Helper Classes in Event Handling
• Database Programming using JDBC Introduction to JDBC,JDBC Drivers & Architecture, CURD operation Using JDBC, Connecting to non-conventional Databases
• Java Server Technologies Servlet Web Application Basics, Architecture and challenges of Web Application, Introduction to servlet, Servlet life cycle, Developing and Deploying Servlets, Exploring Deployment , Descriptor (web.xml), Handling Request and Response

NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,
• WEB DESIGN- web site design principles, planning the site and navigation,
• INTRODUCTION TO XHTML-xml, Move to xhtml. Meta tags, character entitites,frames and frame sets.inside browser.

Contents

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.
• • Windows Explorer - Creating folders and other Explorer facilities.
• • Entertainment - CD Player, DVD Player, Media Player, Sound Recorder, Volume Control.

MS WORD

• (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
• (PAGE LAYOUT):-Themes, Margins, Orientation, Size, Columns Page Breaks, Line Numbers, Hyphenation, Watermark, Pagecolor, Page Borders, Left And Rigt Indent ,Before And After Spacing, Position, Bring Front, Send To Back, Text Warpping Align, Group, Rotate

MS-EXCEL

• -CREATE WORKSHIT AND WORKBOOKS- create a workbook, import data from a delimited text file, add a worksheet to an existing workbook, copy and move a worksheet.

MS POWERPOINT

• (GETTING ACQUAINTED WITH POWERPOINT)The PowerPoint envirionmment,the title bar, the ribbon, the Microsoft office button, the quick access toolbar, the scroll bar, the presentation view buttons, the zoom slider, the status bar, the mini Toolbar, keyboard shortcuts
• (USING PRESENTATIONS VIEWS)-normal view, slide sorter view, notes page view, slide show view.

NETWORKING

• (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,

Contents

PRINTER AND TELE COMMUNICATION

• PRINTER REPAIRING :: - o Introduction of printer. o DMP printer. o Inkjet printer o Laser printer. o Hardware Understanding o Trouble Shooting.

Contents

STONE CRAFT

• Process and Techniques: The carving process essentially has the following sequence:
• SELECTION OF STONE: The stone used to make idols for temples as well as of a human consists of Black and grey granite which are locally available. In traditional language the artisans of the village call the black granite as ‘Purush Shila’ (Male Stone) and the grey granite as ‘Stree Shila’ (Female Stone), which is less hard, than the male stone. The artisan chooses the stones for making the idols according to the characteristics of the god or goddesses. • Selection of the stone (Hard granite, Soft Gray granite, Mysore stone, White granite) is done on the basis of the sculpture to be made, depending on male or female carving the artist wants.
• ROUGH EXERCISE: • The artist prepares detailed Sketching of the sculpture in the form of template on the hard paper, if necessary he also makes the clay models too. If there is a change in the figure style e.g., cloth draping etc., he also makes a wax model of the sculpture, in small scale. All these techniques not only give the artist the rough idea of the sculpture, but it also helps them to understand the proportion of the sculpture. This helps the master craftsmen to communicate with their fellow craftsmen who work under them as trainee regarding the understanding of the form
• WORKING PROCEDURE: The master craftsmen divide the work of sculpting into the three parts depending on the shape and size of the structure to be made.

Contents

PYTHON COURSE SYLLABUS

• Our Python course syllabus is framed by our Industry experts. This Python and Django course content covers all the latest topics from basics to advanced level like Python for Machine Learning, AI, Web development and Data Science.
• Module 1: An Introduction to Python  What can Python do?  Why Python?  Good to know  Python Syntax compared to other programming languages  Python Install
• Module 2: Beginning Python Basics  The print statement  Comments  Python Data Structures & Data Types  String Operations in Python  Simple Input & Output  Simple Output Formatting  Operators in python
• Module 3: Python Program Flow  Indentation  The If statement and its’ related statement  An example with if and its related statement  The while loop  The for loop  The range statement  Break &Continue  Assert  Examples for looping
• Module 4: Functions& Modules  Create your own functions  Functions Parameters  Variable Arguments  Scope of a Function  Function Documentations  Lambda Functions& map  n Exercise with functions  Create a Module  Standard Modules
• Module 5: Exceptions Handling  Errors  Exception handling with try  handling Multiple Exceptions  Writing your own Exception
• Module 6: File Handling  File handling Modes  Reading Files  Writing& Appending to Files  Handling File Exceptions  The with statement
• Module 7: Classes in Python  New Style Classes  Creating Classes  Instance Methods  Inheritance  Polymorphism  Exception Classes & Custom Exceptions
• Module 8: Generators and iterators  Iterators  Generators  The Functions any and all  With Statement  Data Compression
• Module 9: Data Structures  List Comprehensions  Nested List Comprehensions  Dictionary Comprehensions  Functions  Default Parameters  Variable Arguments  Specialized Sorts
• Module 10: Collections  namedtuple()  deque  Chain Map  Counter  OrderedDict  Default dict  UserDict  User List  User String
• Module 11: Writing GUIs in Python (Tkinter)  Introduction  Components and Events  An Example GUI  The root Component  Adding a Button  Entry Widgets  Text Widgets  Check buttons
• Module 12: Python SQL Database Access  Introduction  Installation  DB Connection  Creating DB Table  INSERT, READ, UPDATE, DELETE operations  COMMIT & ROLLBACK operation  handling Errors
• Module 13: Network Programming  Introduction  A Daytime Server  Clients and Servers  The Client Program  The Server Program
• Module 14: Date and Time  sleep  Program execution time  more methods on date/time
• Module 15: Few more topics in-detailed  Filter  Map  Reduce  Decorators  Frozen set  Collections
• Module 16: Regular Expression  Split  Working with special characters, date, emails  Quantifiers  Match and find all  character sequence and substitute  Search method
• Module 17: Threads ESSENTIAL  Class and threads  Multi-threading  Synchronization  Treads Life cycle  use cases
• Module 18: Accessing API ESSENTIAL  Introduction  Face book Messenger  Open weather
• Module 19: DJANGO  Django Overview  Django Installation  Creating a Project  Usage of Project in depth Discussion  Creating an Application  Understanding Folder Structure  Creating a Hello World Page  Database and Views  Static Files and Forms  API and Security

Contents

WEB TECHNOLOGY & DEVELOPMENT

• To Develop New Website Contact Office through email or Phone with proper documents submissions. + Consultation charges

Contents

PERSONALITY DEVELOPMENT & SPOKEN ENGLISH

• Introduction in Foreign Lang.::- (English) -- 1) How to Greet. 2) Simple Sentences. 3) How to Respond. 4) Request, Order, and Advice. 5) The Art of Wishing. 6) Posing and Answering Questions. 7) Commonly Used Phrases/Sentences. 8) BE- Verne (BE, BEING,BEEN,IS,AM,ARE etc.).
• Professional in foreign Lan. [english]::- MODULE 1:- a):- Taking to your superiors. MODULE 2:- a):- Elements of a story. MODULE 3:- a):- Personal Pronouns. MODULE 4:- a):- Demonstrative Pronouns. MODULE 5:- a):- Casual Conversation while Shopping. MODULE 6:- a):- Uses of HERE and THERE. MODULE 7:- a):- Talking to Children. MODULE 8:- Telephone Etiquette. MODULE 9:- a):- Business Communication. MODULE 10:- a):- Conversation with a Doctor. MODULE 11:- a):- Participating in Group Discussion. MODULE 12:- a):- Conducting Meetings. MODULE 13:- a):- Attending Interviews.

Contents

LASER CUTTING & EMBROIDERY DESIGN

• LASER CUTTING:: -o Fundamentals of Laser Machine. o Coreldraw out line drawing. o Laser work software. o Making 3D models with MDF.

EMBROIDERY

• LEARNING OUTCOME ::- STEP 1 .. 1. Identify and use embroidery tools, machine and operate following safety precautions. 2. Prepare sample basic hand stitches (Temporary & permanent stitch). 3. Attain the skill to prepare sample by both the technique (Hand and Machine). 4. Embroidery Design the following with suitable fabric design using coral draw software. (Indian Dresses, Western Dresses) 5. Set up the machine and machine accessories as per requirement.
• LEARNING OUTCOME ::- STEP 2 ..6. Identify, select and troubleshoot the machine with proper maintenance procedure. 7. Develop the skill to make computerizes design with the application of software. 8. Setup computerized embroidery machine for transferring the image. 9. Run the computerized embroidery machine for all the digitizing process. 10. Prepare T-shirt used monogramming & logo design. 11. Identify, select and apply the digitizing design and use various techniques e.g. Appliqué work, Sequins work, Taping work, Cording work, Chenille work.