Contents
FUNDAMENTALS OF COMPUTER & e-SIKSHA
- COMPUTER SYSTEM:-characteristics and capabilities computer Hardware and software, Block Diagram of a computer, Different Data Processing , data process system, strong Data,. Types of computer: Analogue, Digital , Hybrid, General and Special Purpose Computers. Generation of Computers. Computer Systems: Micros, Minis & Main-frames.
- COMPUTER SYSTEM:- . Limitation of Micro Computer. Number systems: Decimal Number System, Binary number system, Octal & Hexadecimal number system,
- complement Codes: ASCII,EBCDI Codes, Gray code & BCD. Logic Gates: AND, OR, NOT GATES and their Truth tables, NOR, NAND & XOR gates
- UNIT -II COMPUTER PERIPHERALS Introduction to input Devices: Categorizing input Hardware, Keyboard, Direct Entry - Card Readers, Scanning Devices - O.M.R., Character Readers, Thumb Scanner, MICR, Smart Cards, Voice Input Devices, Pointing Devices - Mouse, Light Pen, Touch Screen. Computer Output: Output Fundamentals, Hardcopy Output Devices, Impact Printers, Non - Impact Printers, Plotters, Computer output Microfilm/Microfiche (COM) systems, Softcopy Output Devices, Cathode Ray Tube, Flat Screen Technologies, Projectors, Speakers.
- UNIT -III BASIC COMPUTERS & STORAGE Central Processing Unit: The Microprocessor , control unit, A.L.U., Registers, Buses, Main Memory, Main Memory (RAM) for microcomputers, Read Only Memory(ROM). Storage Devices: Storage Fundamentals, Primary and Secondary Storage, Data Storage and Retrieval Methods - Sequential, Direct & Indexed Sequential, Tape Storage and Retrieval Methods Tape storage Devices, characteristics and Limitations, Direct access Storage and Microcomputers - Hard Disk Cartridges, Direct Access Storage Devices for large Computer systems, Mass storage systems and Optical Disks, CD ROM.
- UNIT - IV COMPUTER SOFTWARE & LANGUAGES System Software: System software Vs. Application Software, Types of System Software, Introduction and Types of Operating Systems. Boot Loader, Diagnostic Programs, BIOS, Utility Programs. Application Software: Microcomputer Software, Interacting with the System, Trends in PC software, Types of Application Software, Difference between Program and Packages. Computer Languages: Definition, Generations of computer languages, Types of Languages, Language Processors: Assembler, Interpreter, Compiler, Linker and Loader. Programming constructs, Algorithm & flowchart.
Concept of software
- • Types of Software - System software, Application software, Utility software, Demo ware, Shareware, Freeware, Firmware, Free software.
- • Operating System - Functions, Types - Batch Processing, Single User, Multi User, Multiprogramming, Multi- Tasking.
- • Programming languages - Machines Assembly, High Level, 4 GL.
- • Data representation in computers .
- • Number System of computers - Binary, Octal, Hexa, Decimal - Representation & their conversion.
- • Coding System - ASCII, BCD, and EBCDIC etc.
- • Computer Viruses.
CONCEPT OF WINDOWS
- • Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin.
- • Windows Accessories - Calculator, Notepad, Paint, WordPad, Character map.
- • Windows Explorer - Creating folders and other Explorer facilities.
- • Entertainment - CD Player, DVD Player, Media Player, Sound Recorder, Volume Control.
- PAGE MAKER
MS WORD
- (HOME MENU)-New,Open,Close, Save, Save As, Formatting Text,Fontsize,Font Style, Font Color,Use The Bold, Italic, And Underlines. Line Spacing, Find ,Replace .Change The Text Case, Shanding With Tabs And Indents
- ( INSERT MENU):- Table Use, Shapes, Clipart And Picture, Word Art, Smart Art, Columns And Orderings- To Add, Columns To Document Change The Order And Objects, Smart Art, Hyperlink, Bookmark, Cross- Reference, Header And Footer, Page Number, Text Box, Quick Parts, Drop Cap, Signature Line, Date And Time, Equation Symbol
- (PAGE LAYOUT):-Themes, Margins, Orientation, Size, Columns Page Breaks, Line Numbers, Hyphenation, Watermark, Pagecolor, Page Borders, Left And Rigt Indent ,Before And After Spacing, Position, Bring Front, Send To Back, Text Warpping Align, Group, Rotate
- (REFERENCES):- Table Of Contents, Add Text, Update Table, Insert Footnote, Insert Endnote, Next Footnote, Show Notes, Insert Citation, Manage Sources, Style, Bibliography, Insert Caption Insert Table Of Figures, Update Table, Cross- References, Mark Entry, Insert Infex, Update Index, Mark Citation, Insert Table Of Authorities
- (MALLING )-Envelopes, Labels, Start Mail Merge, Select Recipients, Edit Recipients List, Highlight Marge Fields, Address Block, Greeting Line, Insert Merge Field, Rules, Match Fields Update Labels, Preview Results,Previous Record, Next Record, Last Record, Find Recipient, Auto Check For Errors, Finish & Merge
- (REVIEW)-Spelling & Grammar, Research, Thesaurus, Translate, Translation Screen tip, Set Language, Word Count, New Comment, Delete, Previous, Next, Track Changes, Balloons, Final Showing Markup, Show Markup, Reviewing Pane, Accept, Reject, Previous And Next, Compare, Show Source Documents, Protet Document
- (VIEW)- print layout, full screen, web layout, outline, draft, ruler, gridlines, document map, thumbnails, zoom, one page, two, page, page width, new window, arrange all, split, switch windows, macros
MS EXCEL (Advance)
- INTRODUCTIONTOCOMPUTERS Fontformatting Numberformatting Tableformatting Conditionalformatting Hide/Unhide Sort/filter Pastespecial Findandselect
- INSERT Illustrations Charts Te
- PAGE LAYOUT Basic Functions Sum/Average/Count/Max/ Min BasicText/date/time/lookup/information functions Name manager Formula Auditing
- DATA Import from web Import from text Text to columns Remove duplicates Grouping and ungrouping
- REVIEW Proofing Comments Protection
- VIEWS Typesofviews Zoom Windows
- DEVELOPER Enable developer Using checkbox/option buttons
- BASIC FORMULA Formulae that Add/Subtract/Multiply/Divide BODMAS/Formula Error Checking The Sum Function
- ABSOLUTE REFERENCING Problems with Absolute/ Relative Cell Referencing CreatingAbsolute/MixedReferences
- LOOK UP FUNCTIONS TheVLOOKUP/HLOOKUP Functions
- PIVOT TABLES Creating,FormattingSimplePivotTables PageFieldina PivotTable Formattinga PivotTable Creating/Modifyinga PivotChart
- LOGICALFUNCTIONS IFs and Nested IF Functions UsingAND/OR /NOTFunctions
- STATISTICALFUNCTIONS UsingTheSUMIF/COUNTIFFunctions UsingTheAVERAGE/COUNT/LARGER/SMALLERFunctions
- PIVOT TABLES–ADVANCE Adding new calculatedFields/Items ChangingtheSummaryFunction ConsolidatePivot table
- LOOKUPFUNCTIONS–ADVANCE MATCHwithVLOOKUP Functions INDEX&MATCH Functions OFFSET/INDIRECT functions
- LOGICALFUNCTIONS–ADVANCE If Loop and Nested IF LoopFunctions UsingIF/ISERRORFunctions
- CHARTDATATECHNIQUES TheChart Wizard ChartTypes AddingTitle/ Legends/ Lables PrintingCharts AddingDatatoaChart Formatting/Renaming/DeletingDataSeries ChangingtheOrderofData Series
- DATE/TIMEFUNCTIONS UsingTheToday Now& DateFunctions UsingTheDatedif/Networkdays/EomonthFunctions UsingTheWeeknumFunctions UsingTheEdate/Networkdays.Intl/Weekdays.IntlFunctions
- TEXTFUNCTIONSUSING TheMid/Search/Left/RightFunctions UsingTheTrim/Clean/Upper/Lower Functions UsingTheSubstitute/ TextFunctions UsingTheTrim/Clean/Proper/DollarFunction
- VALIDATIONS InputMessages/ErrorAlerts/Drop-DownLists ConditionalFormatting
- ADVANCEDFILTERS ExtractingRecordswithAdvancedFilter UsingFormulasinCriteria
- MANAGE CHARTS Create charts Create charts Create chart sheets Modify charts Add data series to charts Switch between rows and columns in source data Add and modify chart elements Format charts Apply chart layouts Apply chart styles Add alternative text to charts for accessibility
- PERFORMOPERATIONSBYUSINGFORMULASAND FUNCTIONS Insert references Insert relative, absolute ,and mixed references Reference named ranges and named tables in formulas Calculate and trans form data Perform calculations by using the AVERAGE(),MAX(),MIN(),and SUM() Count cells busing the COUNT(), COUNTA(), and COUNTBLANK()Functions Perform conditional operations by using the IF() function Format and modify text Format text by using RIGHT(), LEFT(), and MID() functions Format text by using UPPER(), LOWER(), and LEN() functions Format text by using the CONCAT() and TEXTJOIN() functions
- MANAGETABLESANDTABLEDATA Create and format tables Create Excel tables from cell ranges Apply table styles Convert tables to cell ranges Modify tables Add or remove table rows and columns Configure table style options Insert and configure total rows
- MANAGEDATACELLSAND RANGES Mani palate data in worksheets Paste data busing special paste options Fill cells busing AutoFill Insert and delete multiple columns or rows Insert and delete cells Format cells and ranges Merge and unmerge cells Modify cell alignment ,orientation, and indentation Format cells by using Format Painter Wrap text within cells Apply number formats Apply cell formats from the Format Cells dialog box Apply cell styles Clear cell formatting Define and reference named ranges Define named range Summarize data visually Insert Spark lines Apply built-in conditional formatting Remove conditional formatting
- ANAGEWORKSHEETSAND WORKBOOKS Importdataintoworkbooks Importdatafrom.txtfiles Importdatafrom.csv files Navigatewithinworkbooks Search for data within a workbook Navigatetonamedcells,ranges,orworkbook elements Insertandremovehyperlinks Formatworksheetsandworkbooks Modify page setup Adjust row height and column width Customize headers and footer Customize options and views Customize the Quick Access toolbar Display and modify workbook contenting different views Freeze work sheet rows and columns Change window views Modify basic workbook properties Display formulas
- IMPORTING&EXPORTINGDATA ImportingDatafromDatabase/TextFiles/Web ExportingData ChangingExternalDataRange
- SHARINGANDPROTECTINGWORKBOOKS SharingWorkbooks&Tracking Changes Protectingsheets/workbooks/Files
- CUSTOMVIEWS CreatingCustomViews DisplayingCustomViews DeletingCustomViews
- USINGAUDITINGTOOLS Displaying/RemovingDependent&PrecedentArrows EvaluateFormula–StepIN/StepOut
- CONSOLIDATION ConsolidatingDatawithIdentical/DifferentLayout
- OUTLINING Creating/WorkingwithanAutomatic/Manual Outline Grouping/Ungrouping
- SUMMARIZINGDATA CreatingSubtotals/Nested Subtotals SUBTOTALSFormula
- MATH&TRIGONOMETRYFUNCTIONS UsingSUMPRODUCTFunctions UsingFLOOR/CEILING/MROUND/MOD/QUOTIENT Functions
- HYPER/DATA LINKING Hyperlinkingdata,withinsheet/workbook Linking&Updating links between work books & application
- ADVANCEDSORTING SortingbyToptoBottom/Leftto Right Creating/DeletingCustom List SortbyusingCustomList
MS POWERPOINT
- (GETTING ACQUAINTED WITH POWERPOINT)The PowerPoint envirionmment,the title bar, the ribbon, the Microsoft office button, the quick access toolbar, the scroll bar, the presentation view buttons, the zoom slider, the status bar, the mini Toolbar, keyboard shortcuts
- ( CREATING BASIC PRESENTATIONS)-opening presentations, cloning presentations, creating new presentations, saving presentations, saving presentations, inserting new slides, applying slide layouts, using the "package for CD feature", working with power point file formats
- (USING PRESENTATIONS VIEWS)-normal view, slide sorter view, notes page view, slide show view.
- (USING TEXT) adding text to slides, basic object manipulation, font formatting, applying custom bullets and numbering, using tabs, setting text box options, checking spelling
- (USING CLIP ART) -Inserting Clip Art , And Pictures, Basic Graphic Manipulation, Using Picture Tools, The Format Picture Dialog Box
- (USING SMARTART)-Inserting And Manipulating Smart art, Formatting Smart art,
- (USING SLIDE SHOW VIEW)-Running a slide show, using custom shows.
- (PRINTING YOUR PRESENTATION)-
MS ACCESS
- 1. Introduction to Database Management :- Type of Database, Examples of DBMS
- 2. Definitions :- Table, Field, Field Name, Record, Database, Database Object
- 3. Opening Microsoft Access :- Start button & Desktop icon
- 4. Creating a Database file :- Designing a table - Field names, Data Types, Description
- 5. Data Types :- Text, Number, Data/Time, Yes/No, Currency, Memo, AutoNumber, Ole Object, Lookup Wizard
- 6. Entering Records within a table
- 7. Editing parts of a table :- Selecting, Renaming, Inserting, Deleting, Hiding, Freezing, Resizing
- 8. Sorting Records
- 9. Moving to specific records :- First, Last, Previous, Next, New
- 10. Formatting e table :- Font, Cells
- 11. Checking Spelling , Finding and Replacing data
VISULBASIC 6.0
- Getting Started- Procedure For Starting, Printing the Program, Saving the Program, Reloading a Program, Exiting Basic, Loading .tax Files.
- Screen Output- Programming Practices and conventions, The REM Statement, The CLS Command, The Print Command, print With a Semicolon, Print With a comma, On Your Own, Positioning output on the screen, Summary, Putting It All Together
- Input Values and Output Displays - Data Type Values, Variables, Assignment Statements, Displaying Values, Dialog Boxes, Numeric Values as Input. creating output Menus, Putting it all Together
- Numeric Calculations- operations, Functions and Expressions, Operation Hierarchy, Sub expressions, Built In Function, Concatenation, Formatting Output, Putting It All Together
- Decision Making - Simple comparisons, Numeric Comparisons, Strings, Character Representation, Dictionary Ordering, String comparisons, Conditional Statements, Simple if blocks, The Else option, compound conditional if Blocks, Multi-case if Blocks, Putting It All Together
- Branching - Ling Labels, Unconditional Branching, 3 Repetition of Code, Conditional Branching, Repetition a Number of Times, Sentinels, Prompt and Echo, 8 User Interrogation Technique, 9 Putting It All Together
- For ..Next Loops - The For ..Next loop, The Step Parameter, Program Applications, Generalized Functionality, Nested Loops , Putting It All Together
- Random Numbers - The Rnd Function, Using Randomize, Coin Tossing , Tossing a Biased Coin, Die Rolling, Scaling the Rnd Function , A Simulation , Putting If All Together
- Graphics- Resolution and Color, 2 Coloring Pixels , 3 Drawing Lines, Using the PSet Command, Using the Ling Command, 6 Drawing Rectangles, Drawing Circles , Drawing Arcs, Drawing sectors , Drawing Ellipses, Fill Styles, 12 A Pie chart, Histograms Putting If All Together
- Arrays and Tables - Defining an Array, The syntax of Defining Arrays, Assigning and Using Values in an Array, Finding the Average and the Standard Deviation, File Input, Using Arrays- Searching an Array , Using Arrays -Finding a Smallest Element in an Array, Using Arrays - interchanging Two Elements in an Array , using Arrays -sorting an Array , using Arrays - Finding a Distribution of Elements, Using Arrays - Parallel Arrays, Using Arrays - Drawing A Pie Chart, Using Arrays - Drawing a Histogram , Putting If All Together
HTML
- Introduction to web programming:-It talks about the architecture of a website and the different technologies used to design a website
- Introduction to HTML:-HTML tags versus HTML elements, history of HTML, how a design a first HTML page, HTML attributes , etc. are discussed in this subject
- HTML Basic Formatting Tags:-HTML colour coding , HTML basic tags, and formatting tags are covered here
- HTML- Grouping using Div Span:-The span and DIV tags used to format HTML web pages are introduced in this subject.
- HTML Lists:-The definition of HTML lists, their significance ,types of HTML lists like ordered and unordered lists, etc, are discussed here.
- HTML Images:-The use of image mapping in embedding images into HTML pages are explained in this module.
- HTML Hyperlink:- This subject focuses on uniform Resource Locator (URL) and related concepts. it also takes about URL encoding and the importance of hyperlinks in web pages.
- HTML Tables:- This module teaches how to represent tables in a webpage.
- HTML iFrame : How to use iFrame tag and attributes to embed one web page into another via nested browsing context is covered in this module.
- HTML Form:-It discusses the syntax used to integrate forms in web pages and also talks about their importance in websites.
- HTML Headers:-Scrip , Title, Base, and other elements of HTML headers are explained in this subject.
- HTML Miscellaneous:-HTML Meta, tag, XHTML, and HTML deprecated tags and attributes are covered in this module.
TALLY PRIME & G.S.T.
- BASIC OF ACCOUNTIN• introduction • types of accounts • accouting principles of concepts • mode of accounting • rules of accounting • double entry system of book keepingG
- FUNDAMENTALS OF TALLY • company features • configuration • geeting functions with tally prime • creation/ setting up of company in tally prime
- ACCOUNTING MASTERS • chart of groups • groups • multiple groups • ledgers • multiple ledgers
- INVENTORY MASTERS • stock groups • multiple stock groups • stock categories • multiple stock categories • unit of measure • stock items
- ACCOUNTING TRANSACTIONS VOUCHERS Account Transactions Vouchers a)payment (b)receipt (c) contra (d) sales (e)purchase (f)debit note (g) credit notes(h)journal
- INVENTORY TRANSACTIONS VOUCHER (a)stock journal (b) physical stock voucher (c)manufacturing journal (d) purchase order (e) sales order (f) goods receipt note. delivery note, rejection outwords, inwards
- ADVANCE ACCOUNTING bill-wise details cost centers and cost categories, multiple calculations, interest calculations, budget and controls , scenario management, bank reconciliation.
- ADVANCE INVENTORY order processing , recorder levels, batch- wise details, bill of materials, different actual and billed quantities, price lists, zero-valued entries, additional cost details ,pos
- TAX - TDS (Tax Deducted At Source)-understanding TDS, creating TDS masters, practical examples, TDS payment
- TAX - TCS-(Tax Collect At Source)-understanding TCS, creating TCS masters, practical examples, TCS payment
- GST--(Goods And Service Tax) about goods and services Tax(GST), Activating Tally in GST, setting UP GST (company level, ledger level or inventory level), GST Taxes & invoices, Understanding SGST ,CGST, IGST
NETWORKING
- (INTERNET TECHNOLOGY)-INTRODUCTION TO WWW-protocols and programs, secure connections. applications and development tools, the web browser,
- WEB DESIGN- web site design principles, planning the site and navigation,