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.

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

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)

• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing

MS POWERPOINT

• ( 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 TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling

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

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
• (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
• (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 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

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,

TYPING- ENGLISH , BENGALI & OTHER REGONAL LANGUAGE

• Typing Practice in Englsh & Any one Regional Language

Contents

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.

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,
• 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.

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

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 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

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.

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.

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
• (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

Contents

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

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

CorelDraw

• • Logo Designing, Frame Settings • Graphical Tools, Bitmap & Shadow Effects
• • Special Effects such as Perspective • Blending, Text Settings into objects

Contents

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

Contents

TALLY PRIME & G.S.T.

• 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,

Contents

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.
• 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.

Contents

COMPUTER AIDED DESIGINING

• CAD PART 1 :: - o Foundamentals of computer. o Operating system (Dos/ windows xp,7/8). o Auto Cad & 3D. o Project. o Print.

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 -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 -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 - 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.

COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s
• • Installation parts of PC’s • Installation PC(OS, Drivers ,Software)
• • Troubles hooting techniques for OS&Software • Maintenance of PC ’components

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.

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,
• STYLE SHEETS- need for CSS,introduction to CSS, basic syntax and structure, using CSS,background images, colors, and properties.

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.

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,

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.

Contents

CODING PROGRAMME

• Semester – 1: 1) Fundamentals of Computer a. Computer History b. Computer Organization c. Classification of Computer d. Computer System Block Diagram e. Concept of Software f. Number System g. Digital Logic h. Computer Language i. Computer Virus 2) Operating System 3) Windows Application (Notepad, Paint, WordPad) 4) MS Office (MS Word, MS Power Point, MS Excel) 5) Codding with C language 6) Visual Basic
• Semester – 1: 1) Certificate in Computer Coding (CCC) + Semester – 2: 1) Advance Excel 2) DBMS with MS Access 3) Algorithm & Flowchart 4) Python Coding 5) Object Oriented Programming 7) C++

WEB TECHNOLOGY & DEVELOPMENT

• Semester – 1: 1) Concept of Networking 2) Photoshop 3) MS Flash 4) HTML & DHTML 5) Basic Webpage Design with HTML
• Semester – 2: 1) Learning CSS 2) Webpage Design with CSS 3) Browser side programming with JavaScript 4) Webserver & Hosting
• Semester - 3A: 1) Advance CSS 2) Responsive Web Design 3) Animation programming with JavaScript 4) Create dynamic Webpage with JQuery

Contents

WEB TECHNOLOGY & DEVELOPMENT

• 1. Select Diploma in Computer Coding Passed Student only.[DCC]
• Semester – 1: 1) Concept of Networking 2) Photoshop 3) MS Flash 4) HTML & DHTML 5) Basic Webpage Design with HTML

Contents

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.

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

NETWORKING

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

Contents

TROUBLE SHOOTING

• PC HANDLING ::- a. Understanding Machine Configaration. b. Cmos Set-Up. c. Harddisk Partitioning & Formatting. d. Making Startup/Bootable Disk. e. Windows & Linux Os Instalation & Troubleshooting. f. Problem Solving For Windows And Linux Os. g. M.S Word, Internet, Installation And Configuration Device. h. Virus Detection And Recovery. i. Configuration Memory.

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.).

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.).
• UNDERSTANDING IN FOREIGN LANGUAGE(ENG)::-- 1) Present Tense & Question Tag. 2) Past Tense. 3) Future Tense. 4) Part of Speech. 5) Pronunciation and Silent Letter in Words. 6) Use of Modals. 7) Uses of IT &THERE -Dummy Subject. 8) Uses Of Phrases.

Contents

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)-

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

Contents

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

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

Contents

PRINTER AND TELE COMMUNICATION

• TELE COMMUNACATION :: - o Computer Architecture. o Radiation & Microwave Technique. o Digital Signal processing. o System Programing. o Communication Network. o Image processing project.

Contents

ELECTRICAL HOUSE WAIRIRNG & CCTV INS.

• a. House Wiring. b. Electrical Safety Rules c. Blueprint Reading. d. Fundamentals of Electricity. e. Residential electrical system. f. Basic electrical circuits. g. Electrical measurement and testing equipment. h. Series and parallel circuits. i. Cable and termination. j. Switch and receptacles. k. Fixtures. l. NEC code.

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
• 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.

Contents

KCP-(LEVEL-1)

• CLASS - V_ 1: Theory : Computer Fundamentals a) Definition of Computer b) Computer History c) Computer Generation d) Computer Hardware & Software e) Classification of Computer f) System block diagram of Digital Computer g) Computer Memory h) File & Folder System i) Computer Virus

KCP-(LEVEL-2)

• CLASS - VI _1. Theory:- a) Concept of Software b) Number System and Data Representation c) Computer Organization d) Concept of Computer Networking *CLASS - VI _2. Practical: a) MS Word ( Advance Part) b) MS Power point ( Advance Part) c) MS Excel ( Basic Part) d) MS Logo Programming e) Internet *CLASS - VI_ 3.Project: a) MS Word ( Application Form, Advance Front Page Design, Certificate Design, Identity card, etc.) b) MS Powerpoint ( Create Presentation on various topic) c) MS Excel (Create invoice, Marksheet) d) MS Logo ( Create various type of shapes)

KCP-(LEVEL-3)

• 1) CLASS –VII_3.Project: a) MS Word (Create Mail Merge) b) MS Excel c) MS Logo (Create various type of shapes & animation ) d) C ( various type programme) 2) CLASS –VII_ 2.Practical: a) MS Word (Mail Merge System) b) MS Excel ( Advance Part) c) MS Logo (Create Animation) d) Programming with C Language (BasicPart) 3) CLASS –VII_ 1.Theory: a) Data Processing System b) Digital Logic & Logic Gates c) Concept of Programming d) Programming Language

Contents

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
• (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
• (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

TYPING- ENGLISH , BENGALI & OTHER REGONAL LANGUAGE

• Typing Practice in Englsh & Any one Regional Language

Contents

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

Contents

MOBILE REPAIRING

• SEMISTER -1A : o Basic of mobile communication and electronics. o Study of digital electronics. o Assembling & Disassembling of different types of mobile phones. o Use of various tools & instruments used in mobile phone repairing.
• SEMISTER -1B : o Details of various components used in mobile phones. o Study of basic parts of mobile phones.(speaker,ic,etc). o Testing of various parts with multimeter. o Use of Jhatka machine.o SEMISTER -1B o Details of various components used in mobile phones. o Study of basic parts of mobile phones.(speaker,ic,etc). o Testing of various parts with multimeter. o Use of Jhatka machine.
• SEMISTER-2A : a):- Basic of mobile communication and electronics. b):- Name of different BGA ICs. c):- Work of different BGA and Glass ICs. d):- How to recognise different ICs.

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
• Operator overloading
• Polymorphism input and output c++ programs
• Exception templates advanced featured
• Function and variables

Contents

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)

Contents

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

Contents

MOBILE REPAIRING

• SEMISTER -1A : o Basic of mobile communication and electronics. o Study of digital electronics. o Assembling & Disassembling of different types of mobile phones. o Use of various tools & instruments used in mobile phone repairing.
• SEMISTER-2A : a):- Basic of mobile communication and electronics. b):- Name of different BGA ICs. c):- Work of different BGA and Glass ICs. d):- How to recognise different ICs.
• SEMISTER -3 a):- introduction of various software faults. b):- introduction of different flosher Box. c):- Unlocking of handset through codes and software. d):- Use of Secret codes. e):- Downloading.
• SEMISTER -4 a):- Faults finding & troubleshooting. b):- Steps of repairing hardware and software problems. c):- Circuit tracing, jumpering techniques and solutions. d):- Troubleshooting through schematic diagrams. e):- Repairing procedure for fixing other new hardware faults. f):- Advanced troubleshooting techniques.

Contents

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.
• • Computer Viruses.

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

Contents

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

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

PARAMEDICAL

• PHYSIOTHERAPY :: A. Communicative English and computer Fundamentals. B. Anatomy, Physiology, Abnormal Psychology, and Pathology personal Hygiene. C. Basic Occupational Therapy, Nursing & First-aid. D. Biomechanics and Exercise therapy, Medical & Surgical condition. E. Orthopedics and Neurology & on the job training.

Contents

PARAMEDICAL

• PUBLIC HEALTH : 1. Public Health System. 2. Women and Child Health. 3. Community participation for Health. 4. Emerging issues in Health Sector. 5. Special focus areas in Healthcare.

Contents

ELECTRICAL HOUSE WAIRIRNG & CCTV INS.

• CCTV INSTALLATION.::- a. CCTV system introduction. b. Elements of CCTV system. c. Camera specification. d. Recording of footage and Backup of footage. e. Troubleshooting. f. Cabling and connector settings.

Contents

BEAUTICIAN

• 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

BEAUTICIAN

• BEAUTY COURSE : o Facial therapy. o Dermatology. o Massage. o Hot stone therapy. o Indian head massage. o Anatomy and physiology. o Manicure. o Pedicure. o Make up. o Cosmetic science. o Waxing. o Threading. o Eyebrow and eyelash tinting.

Contents

BEAUTICIAN

• 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.

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.

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

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.

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.
• 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.

Contents

CODING PROGRAMME

• Semester – 1: 1) Fundamentals of Computer a. Computer History b. Computer Organization c. Classification of Computer d. Computer System Block Diagram e. Concept of Software f. Number System g. Digital Logic h. Computer Language i. Computer Virus 2) Operating System 3) Windows Application (Notepad, Paint, WordPad) 4) MS Office (MS Word, MS Power Point, MS Excel) 5) Codding with C language 6) Visual Basic

Contents

DATA SCIENCE

• Module 1: PYTHON PROGRAMMING :: > A] Python Introduction & Setting UP the Environment. B] Python Basic Syntax and Data Types. C] Operators in Python. D] Strings in Python. E] Slicing, Indexing & using methods on Lists. F] Working with Tuples. G] Performing Set operation in program. H] Creating Dictionaries & using dictionaries Methods. I} Uses of Python Conditional Statements. J} [ ] Iterating with Loops in Python. K] Getting Started with HackerRank use cases and working on them. L] Using List & Dictionaries comprehension. M] Functions, Anonymous Functions with lambda, filter, map reduce in python. N] Creating & Using Generators. O] Modules, Exceptions and error handling. P] Class and Objects( OOPS). Q] Date and Time, Regex. R] Reading , Writing , Appending, Opening and closing Files. S] APIs the Unsung Hero of the Connected World. T] Python for WEB DEVELOPMENT- Flask, Hands-on Projects.
• MODULE 2- Data Analysis ::- A] Packages- Creating and Importing. B] Web Scraping - Working on Scraping Data from Static Dynamic Websites. C] Exploratory data analysis(EDA) using Pandas and NumPy. D] Data Visualization using Matplotlib, Seaborn, & Plothy, Instagram Reach Analysis. E] Database Access :- Working on SQL Queries. F] MS Excel :- Worksheet, Calculation, Fill Handle, Formula, Quick Functions, Charts & Visualizations, Advance Excel, Tableau and Power BI- Instagram Reach Analysis.
• MODULE 3:: - STATISTICS::- 1] Descriptive Statistics:: >- (Data- Types of data, A Measure of Central tendency -Mean- Median- Mode, A Measure of shape- Variance - standard deviation, Range, IQR, The measure of shape - Skewness, & kurtosis, Probability Distribution- Discrete and Continuous. Uniform Distribution. Expected values, Variance & Means. Gaussian/ Normal Distribution. Properties, mean, variance, empirical rule of normal distribution. Standard normal distribution and Z-Score). 2> Inferential Statistics : (Central Limit Theorem. Hypothesis testing - Null & Alternate hypothesis. Type -I & Type-II error. Critical Value, Significance level, p-value. One - tailed & two-tailed test. T- test- one sample, two-sample, and paired t-test, f-test. One way and two way ANOVA, Chi-Square test.

Contents

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.
• • Computer Viruses.

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.

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.
• PAGE MAKER

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,
• 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.
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
• 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.

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
• (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
• (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

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)

• BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
• LOOK UP FUNCTIONS  TheVLOOKUP/HLOOKUP Functions
• REVIEW  Proofing  Comments  Protection
• PIVOT TABLES  Creating,FormattingSimplePivotTables  PageFieldina PivotTable  Formattinga PivotTable  Creating/Modifyinga PivotChart
• LOOKUPFUNCTIONS–ADVANCE  MATCHwithVLOOKUP Functions  INDEX&MATCH Functions  OFFSET/INDIRECT functions
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting
• ADVANCEDFILTERS  ExtractingRecordswithAdvancedFilter  UsingFormulasinCriteria
• 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
• TEXTFUNCTIONSUSING  TheMid/Search/Left/RightFunctions  UsingTheTrim/Clean/Upper/Lower Functions  UsingTheSubstitute/ TextFunctions  UsingTheTrim/Clean/Proper/DollarFunction
• CONSOLIDATION  ConsolidatingDatawithIdentical/DifferentLayout
• CUSTOMVIEWS  CreatingCustomViews  DisplayingCustomViews  DeletingCustomViews
• 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
• 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
• 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
• VIEWS  Typesofviews  Zoom  Windows
• DEVELOPER  Enable developer  Using checkbox/option buttons
• 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)-

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

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.

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,

Contents

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 .

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.

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.

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,

Contents

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.

DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.

MS WORD

• (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
• (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
• (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

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.
• (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.
• (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
• (PRINTING YOUR PRESENTATION)-
• ( 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

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

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

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

MS EXCEL (Advance)

• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
• 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
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting

FUNDAMENTALS OF COMPUTER & e-SIKSHA

• 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.

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,

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,

Contents

CONCEPT OF WINDOWS

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

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 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)-

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.

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.

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

COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s

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.
• • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.

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.

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

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.

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.

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.

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.

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

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,

Contents

CONCEPT OF WINDOWS

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

Concept of software

• • Computer Viruses.
• Computer antivirus

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.

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.

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
• BASIC FORMULA  Formulae that Add/Subtract/Multiply/Divide  BODMAS/Formula Error Checking  The Sum Function
• 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
• 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
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• VALIDATIONS  InputMessages/ErrorAlerts/Drop-DownLists  ConditionalFormatting
• ADVANCEDFILTERS  ExtractingRecordswithAdvancedFilter  UsingFormulasinCriteria
• SUMMARIZINGDATA  CreatingSubtotals/Nested Subtotals  SUBTOTALSFormula
• CONSOLIDATION  ConsolidatingDatawithIdentical/DifferentLayout
• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing

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

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

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

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.

NETWORKING

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

Contents

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.
• • Computer Viruses.

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,
• 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.

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
• (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
• (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
• (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
• (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

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
• DATA  Import from web  Import from text  Text to columns  Remove duplicates  Grouping and ungrouping
• PAGE LAYOUT Basic Functions  Sum/Average/Count/Max/ Min  BasicText/date/time/lookup/information functions  Name manager  Formula Auditing
• 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

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,

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)-

Contents

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.

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.

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,

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.

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)-

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.

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.

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

Contents

DIGITAL MARKETIG

• Digital Marketing Level 1  Digital Marketing Overview  How Digital Marketing targets and grows businesses and its potential scope in the coming years.  Digital Marketing Strategy  Understanding concepts like the ripple effect, consumer behaviour, and creating custom marketing strategies.  Website Planning & Creation  Learn how to plan, design, and code your very own website using HTML and WordPress.  Search Engine Optimization  Learn how the usage of SEO techniques can help optimize your web content and rank on search engines.  Google Tag Manager  Learn event tracking and setting up tags and triggers using Google Tag Manager.  Social Media Marketing  Learn how to use paid and organic social media marketing strategies to engage with your audience.  Facebook  Introduction to Facebook marketing, understanding how its algorithm works, and ad campaign setup and configuration.  Instagram  Learn how to grow on Instagram, with content strategies, influencer marketing and tools for Instagram advertising.  Twitter  Understanding Twitter as a marketing platform using organic content, Twitter ads and analytics tools.  Reddit  Learn content curation using Reddit, and organic traffic generation using Reddit marketing strategies.  LinkedIn  Understanding the importance and benefits of using LinkedIn, with advertising and marketing strategies.  Mobile App Marketing  Create mobile app campaigns and learn how to promote and monetize your mobile applications.  Google Ads (Previously Adwords)  Creating, optimizing, and configuring ads on Google and its related properties.  Google Analytics (GA4)  Monitoring traffic and understanding your audience’s behaviour using the latest version of Google Analytics (GA4).
• Digital Marketing:: Level 2  Content Marketing  Learn to create a great content strategy, to influence your target audience using content.  YouTube Marketing  Learn strategies to create engaging content, optimize channels for growth and build it from the ground up.  Adsense and Blogging  Learn about Google AdSense, content curation for blogging, and using AdSense for ads on blogs and websites.  Affiliate Marketing  Become familiar with the different affiliate marketing programs, and master skills in utilizing them for monetization.  Email Marketing  Learn how to create effective email marketing campaigns, and build and nurture email lists.
• Digital Marketing :: - Level 3  AI usage in Digital Marketing  Learn content creation and curation using AI, using chatbots, and other emerging AI tools for digital advertising.  Creative Ads Writing  Learn the formulas and tactics to create compelling copy to attract and captivate buyers.  Graphic Design Essentials  Learn the fundamentals of graphic design, typography, fonts & colours, and industry-required video editing skills.  Understanding UI/UX  Learn about UI design, design kits, beginner tools & UX optimization.  Professional Video Editing  Master professional video editing, with industry-standard tools like Premiere Pro & Filmora.  Podcasting  Get started with podcasting, recording and editing audio content, and building and promoting your podcast.  Viral Marketing  Pick up the skills to implement viral marketing strategies to engage with your customers and use tools for the same.  Gaming & Live Streaming  Introduction to the world of gaming and live streaming, and the future of in-game marketing through engagement with gaming communities.  Gamification in Online Marketing  Introduction to Gamification, Gamification Marketing Strategies and elements of Game Marketing.

Contents

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.

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 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)-

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

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.

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,

Contents

WEB TECHNOLOGY & DEVELOPMENT

• 1. Select Diploma in Computer Coding Passed Student only.[DCC]
• Semester – 1: 1) Concept of Networking 2) Photoshop 3) MS Flash 4) HTML & DHTML 5) Basic Webpage Design with HTML
• Semester – 2: 1) Learning CSS 2) Webpage Design with CSS 3) Browser side programming with JavaScript 4) Webserver & Hosting

Contents

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.

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 - 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.

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 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

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
• PIVOT TABLES–ADVANCE  Adding new calculatedFields/Items  ChangingtheSummaryFunction  ConsolidatePivot table
• LOOKUPFUNCTIONS–ADVANCE  MATCHwithVLOOKUP Functions  INDEX&MATCH Functions  OFFSET/INDIRECT functions
• STATISTICALFUNCTIONS  UsingTheSUMIF/COUNTIFFunctions  UsingTheAVERAGE/COUNT/LARGER/SMALLERFunctions
• 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

COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s
• • Installation parts of PC’s • Installation PC(OS, Drivers ,Software)

TYPING- ENGLISH , BENGALI & OTHER REGONAL LANGUAGE

• Typing Practice in Englsh & Any one Regional Language

Contents

COMPUTER AIDED DESIGINING

• CAD PART 1 :: - o Foundamentals of computer. o Operating system (Dos/ windows xp,7/8). o Auto Cad & 3D. o Project. o Print.
• CAD PART 2: -i. Fundamentals of computer. ii. Operating System (win,7/8). iii. AutoCAD 2d & 3d. iv. Plotting. v. Drawing. vi. 3d max. vii. Project. viii. Print.

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.

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.

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

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

PERSONALITY DEVELOPMENT & SPOKEN ENGLISH

• Personality Development :: -1) English Communications in Corporate life. 2) Basic Computer knowledge. 3) Personality Development. 4) Performance Consulting. 5) Grooming. 6) Special class based on different subjects by different corporate heads. 7) Detailed interview & questionnaires preparation. 8) Group discussion session & mock interviews.

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.

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
• ACCOUNTING MASTERS • chart of groups • groups • multiple groups • ledgers • multiple ledgers
• 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.
• 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,

Contents

EMBROIDERY

• CRITERIA >> A. Identify and use embroidery tools, machine and operate following safety precautions. -- 1. Identify embroidery tools. 2. Identify all parts of equipment and their accessories. 3. Clean all parts of equipment. Plan and operate. 4. Identify basic faults and correct. 5. Safety and maintenance.
• CRITERIA >> B. Prepare sample basic hand stitches (Temporary & permanent stitch) -- 1. Identify and use the embroidery tools with safely. 2. Select raw material for Temporary & permanent basic hand stitches. 3. Prepare sample of Temporary stitches such as basting even, basting uneven, diagonal, slip basting. 4. Prepare sample of permanent stitches such as running, hemming, slip, run & back, over casting. 5. Explain difference between Temporary & Permanent stitch Sample should be properly finished and pressed.
• CRITERIA >> C. Demonstrate and prepare sample both technique (Hand and Machine). -- 1. Identify and use the Pressing and Embroidery tools with safety. 2. Select raw material, tools and equipment for tracing method. 3. Prepare sample of running, back, satin and cross stitch by hand embroidery technique. 4. Prepare sample of same stitches by computerized embroidery machine. 5. Explain difference between hand embroidery and machine embroidery. 6. Sample should be properly finished and pressed.
• CRITERIA>> D. Embroidery designs the following with suitable fabric design using coral draw software. (Indian Dresses, Western Dresses) -- 1. Open the software and do the required page setup for the design. 2. Identify and use the suitable tools for designing. 3. Sketch the garment with suitable fabric design. 4. Follow the designing principal. 5. Select the colors and colour combination. 6. Apply colour using colour filling tools. 7. Save the file in a folder and take the print out of the design using colour printer.
• CRITERIA>> E. Set up the machine and machine accessories as per requirement -- 1. Identify and use the Pressing and Embroidery tools with safety. 2. Decide the features and placement of the design (Border, Spray, Corner, Center, Link, etc) suitable for the part of the garment (Sleeves, Yokes, Cuffs, Neck, etc). 3. Draw the design using already installed by following the elements of design. 4. Apply suitable colors to the design by following color scheme. 5. Press the garment part. Transfer the design on the garment. 6. Fix the garment part properly on the embroidery frame. 7. Select suitable embroidery stitches for the design. 8. Start embroidery and complete the design step by step by applying suitable stitches at the required portions. 9. Remove the frame and trim the excess threads. 10. Follow the safety instructions throughout the process.
• CRITERIA >> F. Identify, select and troubleshoot the machine with proper maintenance procedure. -- 1. Machine oiling and maintenance 2. Trouble shoots the machine whenever required. 3. Comply with safe operating principal. 4. Follow the safety instructions throughout the process.
• CRITERIA >> G. Develop the skill to make computerizes design with the application of software -- 1. Select correct needle, Pressing and Embroidery tools with safety. 2. Open the software (Embroidery Software) and Select already install Design suitable for a Cushion Cover. 3. Digitized and editing stitches. 4. Apply suitable colours to the design. 5. Decide the placement of the design in the fabric. 6. Fix the cushion cover properly on the embroidery frame. 7. Select suitable Machine embroidery stitches for the design. 8. Do the upper and lower threading of the machine. 9. Start embroidery and complete the design step by step by applying suitable stitches at the required portions. 10. Remove the frame trim extra thread and press the cushion cover neatly. 11. Follow safety precaution
• CRITERIA >> H. Setup computerized Open the software and do the required design. embroidery machine for transferring the image::-- 1. Identify and use the suitable tools for designing. 2. Sketch the garment with suitable fabric design. 3. Follow the designing principal. Select the colors and color combination. 4. Apply color using color filling tools. 5. Decide the features and placement of the design. 6. Fix the pillow cover properly on the embroidery frame. 7. Select suitable Machine embroidery stitches for the design. 8. Do the upper and lower threading of the machine. 9. Start embroidery and complete the design step by step by applying suitable stitches at the required portions. 10. Remove the frame trim extra thread and press the pillow cover neatly.
• CRITERIA >> I.Run the computerized embroidery machine for all the digitizing process. -- 1. Open the embroidery software and do the required design. 2. Identify and use the tools for digitizing. 3. Sketch the garment with suitable fabric design. 4. Follow the designing principal. 5. Select suitable stitches for the design. 6. Select the colors and color combination. 7. Apply color using color filling tools. 8. Decide the features and placement of the design. 9. Select correct needles, frame, scissor and thread. 10. Fix the bed sheet properly on the embroidery frame. 11. Do the upper and lower threading of the machine. 12. Start embroidery and complete the design step by step by applying suitable stitches at the required portions. 13. Maintain hygiene. Maintain safety expects. 14. Maintain quality as per requirement. 15. Remove the frame trim extra thread and press the bed sheet neatly. 16. Produce a estimate and cost sheet.
• CRITERIA >> J. Prepare T-shirt used monogramming & logodesign. -- 1. Open the embroidery software and do the required design. 2. Identify and use the tools for digitizing. 3. Sketch the garment with suitable fabric design. 4. Follow the designing principal. 5. Select suitable stitches for the design. 6. Select the colors and color combination. 7. Apply color using color filling tools. 8. Decide the features and placement of the design. 9. Select correct needles, frame, scissor and thread. 10. Fix the T- shirt properly on the embroidery frame. 11. Do the upper and lower threading of the machine. 12. Start embroidery and complete the design step by step by applying suitable stitches at the required portions. 13. Maintain hygiene. 14. Maintain safety expects. 15. Maintain quality as per requirement. 16. Remove the frame trim extra thread and press the T- shirt neatly. 17. Produce a estimate and cost sheet.
• CRITERIA >> K. Identify, select and apply the digitizing design and use various techniques e.g. Appliqué work, Sequins work,Taping work, Cording work, Chenille work. -- 1. Open the embroidery software and do the required design. 2. Identify and use the tools for digitizing. 3. Sketch the garment with suitable fabric design. 4. Follow the designing principal. 5. Select suitable stitches for the design. 6. Select the colors and color combination. 7. Apply color using color filling tools. 8. Decide the features and placement of the design. 9. Select correct needles, frame, scissor and thread. 10. Fix the sari properly on the embroidery frame. 11. Do the upper and lower threading of the machine. 12. Start embroidery and complete the designs use appliqué, sequins, taping, cording and chenille step by step by applying suitable stitches at the required portions. 13. Maintain hygiene. Maintain safety expects. 14. Maintain quality as per requirement. 15. Remove the frame trim extra thread and press the bed sheet neatly. 16. Produce a estimate and cost sheet.

Contents

BEAUTICIAN

• BEAUTY COURSE : o Facial therapy. o Dermatology. o Massage. o Hot stone therapy. o Indian head massage. o Anatomy and physiology. o Manicure. o Pedicure. o Make up. o Cosmetic science. o Waxing. o Threading. o Eyebrow and eyelash tinting.
• 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.

Contents

CODING PROGRAMME

• Semester – 1: 1) Fundamentals of Computer a. Computer History b. Computer Organization c. Classification of Computer d. Computer System Block Diagram e. Concept of Software f. Number System g. Digital Logic h. Computer Language i. Computer Virus 2) Operating System 3) Windows Application (Notepad, Paint, WordPad) 4) MS Office (MS Word, MS Power Point, MS Excel) 5) Codding with C language 6) Visual Basic
• Semester – 1: 1) Certificate in Computer Coding (CCC) + Semester – 2: 1) Advance Excel 2) DBMS with MS Access 3) Algorithm & Flowchart 4) Python Coding 5) Object Oriented Programming 7) C++

Contents

KCP-(LEVEL-2)

• CLASS - VI _1. Theory:- a) Concept of Software b) Number System and Data Representation c) Computer Organization d) Concept of Computer Networking *CLASS - VI _2. Practical: a) MS Word ( Advance Part) b) MS Power point ( Advance Part) c) MS Excel ( Basic Part) d) MS Logo Programming e) Internet *CLASS - VI_ 3.Project: a) MS Word ( Application Form, Advance Front Page Design, Certificate Design, Identity card, etc.) b) MS Powerpoint ( Create Presentation on various topic) c) MS Excel (Create invoice, Marksheet) d) MS Logo ( Create various type of shapes)

KCP-(LEVEL-3)

• 1) CLASS –VII_3.Project: a) MS Word (Create Mail Merge) b) MS Excel c) MS Logo (Create various type of shapes & animation ) d) C ( various type programme) 2) CLASS –VII_ 2.Practical: a) MS Word (Mail Merge System) b) MS Excel ( Advance Part) c) MS Logo (Create Animation) d) Programming with C Language (BasicPart) 3) CLASS –VII_ 1.Theory: a) Data Processing System b) Digital Logic & Logic Gates c) Concept of Programming d) Programming Language

KCP-(LEVEL-4)

• CLASS - VIII _1.Theory a) Digital Circuit b) Database 1. What is database 2. Type of database 3. DBMS 4. Various type of database 5. System 6. RDBMS 7. Keys c) Programming 1. Flowchart 2. Algorithm *CLASS - VIII_ 2.Practical : a) MS Excel ( Advance Part) b) DBMS with MS Access c) DBMS with SQL d) C Programming ( Advance part) *CLASS - VIII_ 3.Project: a) MS Excel b) MS Access c) SQL d) C

KCP-(LEVEL-1)

• CLASS - V_ 1: Theory : Computer Fundamentals a) Definition of Computer b) Computer History c) Computer Generation d) Computer Hardware & Software e) Classification of Computer f) System block diagram of Digital Computer g) Computer Memory h) File & Folder System i) Computer Virus
• CLASS - V- 2. Practical : a) MS paint b) MS Notepad c) MS Wordpad d) Calculator e) Introduction to Windows f) MS word {Basic Part} g) MS Power Point { Basic Part}
• CLASS - V _ 3. Project: a) MS Paint Project b) MS Word Project [Letter, Font, Page Design] c) Power Point Project [Basic Presentation]

Contents

MOBILE REPAIRING

• SEMISTER -1A : o Basic of mobile communication and electronics. o Study of digital electronics. o Assembling & Disassembling of different types of mobile phones. o Use of various tools & instruments used in mobile phone repairing.
• SEMISTER -1B : o Details of various components used in mobile phones. o Study of basic parts of mobile phones.(speaker,ic,etc). o Testing of various parts with multimeter. o Use of Jhatka machine.o SEMISTER -1B o Details of various components used in mobile phones. o Study of basic parts of mobile phones.(speaker,ic,etc). o Testing of various parts with multimeter. o Use of Jhatka machine.
• SEMISTER-2A : a):- Basic of mobile communication and electronics. b):- Name of different BGA ICs. c):- Work of different BGA and Glass ICs. d):- How to recognise different ICs.
• SEMISTER -2B e):- Soldering & desoldering components using soldering iron. f):- Soldering & desoldering components using rework station. g):- Working on SMD/BGA ICs and the PCB.
• SEMISTER -3 a):- introduction of various software faults. b):- introduction of different flosher Box. c):- Unlocking of handset through codes and software. d):- Use of Secret codes. e):- Downloading.
• SEMISTER -4 a):- Faults finding & troubleshooting. b):- Steps of repairing hardware and software problems. c):- Circuit tracing, jumpering techniques and solutions. d):- Troubleshooting through schematic diagrams. e):- Repairing procedure for fixing other new hardware faults. f):- Advanced troubleshooting techniques.

Contents

DATA SCIENCE

• Module 1: PYTHON PROGRAMMING :: > A] Python Introduction & Setting UP the Environment. B] Python Basic Syntax and Data Types. C] Operators in Python. D] Strings in Python. E] Slicing, Indexing & using methods on Lists. F] Working with Tuples. G] Performing Set operation in program. H] Creating Dictionaries & using dictionaries Methods. I} Uses of Python Conditional Statements. J} [ ] Iterating with Loops in Python. K] Getting Started with HackerRank use cases and working on them. L] Using List & Dictionaries comprehension. M] Functions, Anonymous Functions with lambda, filter, map reduce in python. N] Creating & Using Generators. O] Modules, Exceptions and error handling. P] Class and Objects( OOPS). Q] Date and Time, Regex. R] Reading , Writing , Appending, Opening and closing Files. S] APIs the Unsung Hero of the Connected World. T] Python for WEB DEVELOPMENT- Flask, Hands-on Projects.
• MODULE 2- Data Analysis ::- A] Packages- Creating and Importing. B] Web Scraping - Working on Scraping Data from Static Dynamic Websites. C] Exploratory data analysis(EDA) using Pandas and NumPy. D] Data Visualization using Matplotlib, Seaborn, & Plothy, Instagram Reach Analysis. E] Database Access :- Working on SQL Queries. F] MS Excel :- Worksheet, Calculation, Fill Handle, Formula, Quick Functions, Charts & Visualizations, Advance Excel, Tableau and Power BI- Instagram Reach Analysis.
• MODULE 3:: - STATISTICS::- 1] Descriptive Statistics:: >- (Data- Types of data, A Measure of Central tendency -Mean- Median- Mode, A Measure of shape- Variance - standard deviation, Range, IQR, The measure of shape - Skewness, & kurtosis, Probability Distribution- Discrete and Continuous. Uniform Distribution. Expected values, Variance & Means. Gaussian/ Normal Distribution. Properties, mean, variance, empirical rule of normal distribution. Standard normal distribution and Z-Score). 2> Inferential Statistics : (Central Limit Theorem. Hypothesis testing - Null & Alternate hypothesis. Type -I & Type-II error. Critical Value, Significance level, p-value. One - tailed & two-tailed test. T- test- one sample, two-sample, and paired t-test, f-test. One way and two way ANOVA, Chi-Square test.
• MODULE 4 ::- Machine Learning ::> Introduction to machine learning, Introduction to data science and its applications, Data Engineering and pre processing, Model evaluation and Hyperparameter Tuning, Supervised Learning - Regression (house price prediction), Supervised Learning - Classification (Heart disease detection and food order prediction), SVM, KNN & Naive Bayes - contact Tracing & Sarcasm Detection. Ensemble Methods and Boosting- Medical Insurance Price Prediction. Unsupervised Learning - Clustering(Credit card clustering). Unsupervised Learning - Dimensionality Reduction, MNIST Data. Recommendation Systems, News Recommendation System. Reinforcement Learning- working with Open AI Gym. Developing API using Flask / Webapp with Sreamlit. Deployment of ML Models. Project work and Consolidation.
• MODULE 5 ::- NLP- Natural Language Processing , # Introduction to NLP, understand the basic of NLP, & its application, challenges, # Named Entity Recognition(NER), Understand the various approaches and tools used for NER, such as rule-based systems, statistical models, and deep learning. # Text Preprocessing : Learn about tokenization, stemming, lemmatization, stop word removal, and other techniques for text preprocessing. # Text Representation: Explore techniques such as Bag-of-Words(BOW), TF-IDF, and word embeddings(e.g., Word2Vec, Glove) for representing text data. # Sequential Models: Introduction to RNN, LSTM, Hands on Keras LSTM. # Sentiment Analysis: Study sentiment analysis techniques, build a sentiment analysis model using supervised learning, and evaluate its performance. # Real Time Sentiment Analysis.
• MODULE 6:: - Deep Learning -- # RISE OF THE DEEP LEARNING: - # Introduction # History of Deep Learning # Perceptrons # Multi-Level Perceptrons # Representations # Training Neural Networks # Activation Functions. ARTIFICIAL NEURAL NETWORKS:- # Introduction # Deep Learning # Understanding Human Brain # In-Depth Perceptrons # Example of Perceptron # Multi Classifier # Neural Networks # Input Layer # Output Layer # Sigmoid Function # Introduction to Tensorflow and Keras # CPU vs GPU # Introduction to Google collaboratory # Training Neural Networks # Understanding Notations # Activation Functions # Hyperparameter tuning in Keras # Feed-Forward Networks # Online offline mode # Bidirectional RNN # Understanding Dimensions # Back Propagation # Loss function # SGD # Regularization # Training for batches -- Facial Emotion Recognition. ** CONVOLUTION NEURAL NETWORKS{CNN} - (In Detail) ** CNN Transfer Learning:- # Introduction # AlexNet # GoogleNet # Resnet # Transfer learning using Keras ## face mask detection. ** RNN - Recurrent Neural Networks ** ( Details) - Covid-19 Cases Prediction. ** GENERATIVE MODELS & GANs:- # Introduction to Generative Models, # Understanding GANs( Generative Adversarial Networks) # GAN Architecture, # GAN Training, # Evaluating GAN Performance, # GAN Variants and Applications.
• MODUL1E 7:: - COMPUTER VISION :: > 1// Computer Vision # Intro to Open CV # Reading & Writing Images # Saving images # Face detection and Eye detection using CV # VGC # Real time Pose Estimator . 2// Projects & Case Study ::- # Real-time Rain Prediction using ML # Real-time Drowsiness Detection Alert System # House Price Prediction using LSTM # Customizable Chabot using OpenAI API # Fire and Smoke Detection using CNN

Contents

DIETETICS WITH NUTRITION

• Community Nutrition(Theory) -
• Community Nutrition(Practical)-
• Diet Therapy and Applied Nutrition(theory)
• Diet Therapy and Applied Nutrition(practical)
• Hygiene and Microbiology
• Physiology
• Institutional Food Administration(theory)
• Institutional Food Administration(practical)
• Social Welfare
• Project

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.

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.

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

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 (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
• 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
• 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
• 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
• 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
• 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
• IMPORTING&EXPORTINGDATA  ImportingDatafromDatabase/TextFiles/Web  ExportingData  ChangingExternalDataRange
• SHARINGANDPROTECTINGWORKBOOKS  SharingWorkbooks&Tracking Changes  Protectingsheets/workbooks/Files
• CUSTOMVIEWS  CreatingCustomViews  DisplayingCustomViews  DeletingCustomViews
• USINGAUDITINGTOOLS  Displaying/RemovingDependent&PrecedentArrows  EvaluateFormula–StepIN/StepOut
• CONSOLIDATION  ConsolidatingDatawithIdentical/DifferentLayout
• OUTLINING  Creating/WorkingwithanAutomatic/Manual Outline  Grouping/Ungrouping
• SUMMARIZINGDATA  CreatingSubtotals/Nested Subtotals  SUBTOTALSFormula
• MATH&TRIGONOMETRYFUNCTIONS  UsingSUMPRODUCTFunctions  UsingFLOOR/CEILING/MROUND/MOD/QUOTIENT Functions
• HYPER/DATA LINKING  Hyperlinkingdata,withinsheet/workbook  Linking&Updating links between work books & application
• ADVANCEDSORTING  SortingbyToptoBottom/Leftto Right  Creating/DeletingCustom List  SortbyusingCustomList

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

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

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.

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

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,

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

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.
• STYLE SHEETS- need for CSS,introduction to CSS, basic syntax and structure, using CSS,background images, colors, and properties.

DISK OPERATING SYSTEM (DOS)

• 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.
• DOS basic :- • Physical structure of disk, drive name, FAT, file & directory structure and naming rules, booting Process, DOS system files.
• • Introduction, History & Version of 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
• (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

Contents

WEB TECHNOLOGY & DEVELOPMENT

• 1. Select Diploma in Computer Coding Passed Student only.[DCC]
• Semester – 1: 1) Concept of Networking 2) Photoshop 3) MS Flash 4) HTML & DHTML 5) Basic Webpage Design with HTML
• Semester – 2: 1) Learning CSS 2) Webpage Design with CSS 3) Browser side programming with JavaScript 4) Webserver & Hosting
• Semester - 3B: 1) Learn PHP 2) Form Handling with PHP 3) Learn SQL 4) DBMS with MySQL 5) Connecting MySQL with PHP 6) Working with Web Serve

Contents

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.

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

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,
• 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.

COMPUTER HARDWARE (A+)

• • Fundamentals principal of using PC’s • Identify fiction partsofPC’s
• • Installation parts of PC’s • Installation PC(OS, Drivers ,Software)
• • Troubles hooting techniques for OS&Software • Maintenance of PC ’components

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
• • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.

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

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

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.

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

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

TALLY PRIME & G.S.T.

• FUNDAMENTALS OF TALLY • company features • configuration • geeting functions with tally prime • creation/ setting up of company in tally prime

COMPUTER NETWORKING (N+)

• • Fundamental of Networks • Configure the Lan, Man, Wan Networks

CorelDraw

• • Logo Designing, Frame Settings • Graphical Tools, Bitmap & Shadow Effects

PHOTOSHOP

• • All Tools (Marquee Tool, Magnetic Tool, Slice Tool, Patch Tool, Clone Stamp Tool, Gradient Tool, Smudge Tool, Blur Tool, Text Tool etc.)

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

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

Contents

ETHICAL HACKING

• SEMESTER -1 a):- Logic gate and Devices. b):- Comunication System. c):- Networking. d):- Programming in C .
• SEMESTER -2 a):- C++ b):- Java. c):- python. d):- Database. e):- Algorithm.
• SEMESTER -3 a):- Operating System.(Linux,Dos) b):- Personality Devlopment. c):- HTML d):- CSS
• SEMESTER -4 a):- JAVA Script. b):- PHP MySQL. c):- Advance Java. d):- .NET/ ASP
• SEMESTER -5 a):- Personality Development. b):- Android SDK. c):- introduction to hacking tools. d):- Foot printing and reconnaissance by kali Linux. e):- system hacking and season hijacking. f):- Scanning network and Malware threats.
• SEMESTER - 6 A);- Hacking web servers, Web application, Mobile platform B):- SQL Injection and dictionary attack C):- Cryptography and data Encryption D):- Project on real life

Contents

WEB TECHNOLOGY & DEVELOPMENT

• 1. Select Diploma in Computer Coding Passed Student only.[DCC]
• Semester – 1: 1) Concept of Networking 2) Photoshop 3) MS Flash 4) HTML & DHTML 5) Basic Webpage Design with HTML
• Semester – 2: 1) Learning CSS 2) Webpage Design with CSS 3) Browser side programming with JavaScript 4) Webserver & Hosting
• Semester - 3A: 1) Advance CSS 2) Responsive Web Design 3) Animation programming with JavaScript 4) Create dynamic Webpage with JQuery

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.
• 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.
• complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates

DISK OPERATING SYSTEM (DOS)

• • Introduction, History & Version of DOS.

CONCEPT OF WINDOWS

• • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.

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

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.
• 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 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 TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
• (USING SLIDE SHOW VIEW)-Running a slide show, using custom shows.

PAGE MAKER

• • Type Settings for Publication, • Page Layout, Word Wrapping, • Grouping, Merging two or more files,
• • Fonts, Mixing Text & Graphics, • Linking objects, Printing facility.

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

CorelDraw

• • Logo Designing, Frame Settings • Graphical Tools, Bitmap & Shadow Effects
• • Special Effects such as Perspective • Blending, Text Settings into objects

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.

HTML

• 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.

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

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
• 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

Contents

CODING PROGRAMME

• Semester – 1: 1) Fundamentals of Computer a. Computer History b. Computer Organization c. Classification of Computer d. Computer System Block Diagram e. Concept of Software f. Number System g. Digital Logic h. Computer Language i. Computer Virus 2) Operating System 3) Windows Application (Notepad, Paint, WordPad) 4) MS Office (MS Word, MS Power Point, MS Excel) 5) Codding with C language 6) Visual Basic
• Semester – 1: 1) Certificate in Computer Coding (CCC) + Semester – 2: 1) Advance Excel 2) DBMS with MS Access 3) Algorithm & Flowchart 4) Python Coding 5) Object Oriented Programming 7) C++
• Semester – 1: 1) Certificate in Computer Coding (CCC) + Semester – 2: 1) Diploma in Computer Coding (DCC) + Semester – 3: 1) Python Matplotlib 2) Java Programming 3) DBMS with SQL 4) Data Structure 5) HTML & DHTML

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

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.
• WORKING PROCEDURE: 1- The master craftsman does the marking on the rough stone. 2- The trainee or the helping craftsman who is/are semi-skilled or in learning stage removes the rough extra part of the stone. 3- The master craftsman himself does the final finishing.
• FINAL EXERCISE:1 • After getting the exact pictures of the sculpture, Dimensions of the figure to be manufactured are marked on a stone slab, the rough and extra portion are removed in order to get the basic shape, smooth or flat dressing is made to define each and every details. The marking on the stone is done by the red oxide in several layers. The red oxide is commonly available locally. The metal is crushed and then mixed with water in order to make red colour out of red oxide. The colour marks on the stone surface do not vanish while chiseling the surface.
• FINAL EXERCISE:2 • Final finishing of the surface is done by carborundam stones (Chane Kallu) & final polishing is done with water and emery papers. If the sculpture has to be painted in black, it is done with the colours which are extracted from local fruits, as sarkai, annabare and kenbabari (dry fruit) - these raw materials are heated, melted and used as colour pigment.
• THE MAIN TECHNIQUES USED ARE AS FOLLOWS: - 1.Cutting - Round chisel, Flat chisel, Hammer (all of different size). - 2. Grinding - Die grinder with different beats size, Channel cutter. - 3. Buffing - Hand buffer, traditionally made coconut shell hair brush. - 4. Polishing - Local fruits, as sarkai, annabari and kenbabari (dry fruit) are used.
• TOOLS: Common Tools used for Stone Crafts are: • Compass (Ttiwar) • Pencil • Steel ruler (L-shape) • Red oxide to mark centerand base of the statue • Hammer • chisels of different sizes and points • Blades • Grinding stone (to polish) • Brick to sharpen the tools • Cloth or brush to take the dust out (while polishing) • Power Drill • Die Grinder • Stone Cutter
• RAW MATERIALS: Raw materials used are: • Stone– Sandstone • Soft stone • Granite and marble, • Brass, Silver, Gold and Panch Loha (Bronze, Gun metal, Gold, silver, Copper) • Fibre (Acrylic and Fibre reinforced plastic)

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.

Contents

ART & CRAFT

• 1. Primary Level- Basic of Line Drawing, Basic of Colour Drawing

Contents

ART & CRAFT

• 2. Secondary Level- Basic of Line Drawing, Basic of Drawing, Basic of Pencil Sketch, Sketch Drawing, Colour in Landscape, Basic of Water Colour, Basic of Craft

Contents

ART & CRAFT

• 3. Junior Level - Basic of Drawing, Pencil Sketch, Use of Water colour in Drawing, Basic of Poster Colour in Design or Crafting, Basic of Clay Craft, Basic of mixed media with Drawing.

Contents

ART & CRAFT

• 4. Senior Level - Water Colour Painting, Design in Water Colour, Poster Colour & Acrylic Colour. Basic of Acrylic colour, Glass Painting, Craftship, Basic of Sculpture, Basic of Ink Painting.

Contents

ART & CRAFT

• Diploma Level - Water colour Painting,Acrylic colour painting, Sculpture, Ink Painting, Gouache painting, Landscape Painting, Basic of Realism Painting, Basic of Outdoor Painting, Basic of Abstract Painting, Basic of Pap Ant, Basic of Model Study