Contents

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

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

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

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

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

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

7) NETWORKING

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

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