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