Duration-One Year (I^st+II^nd+III^rd+IV^th Semester)

Certificate In Data Entry Operator
Semester-1 (4 Month Duration)

Fundamental of Computer

Computer & its feature, task of computer, peripherals devices, computer generation(description) memory & it measurement, commuter architecture ,binary & decimal conversion.

Networking

Networking, types of networking, topology, protocol, ISO-OSI model

Operating system

CUI(character User Interface)-Disk Operating System. GUI(graphic User Interface)-window7,window 8,window 10.

Window

Work with taskbar, task manager, work control panel, operating system accessories-notepad, WordPad ,paint.

Office automation (MS Office):2019,2021 and other upgraded version

Ms Word

Create a new document, open, save and print a document, Edit and format text, change the page layout, background and borders, format document, work with text object, work with References Insert headers and footers, Insert and edit tables, Insert clip art and pictures to document, Perform a mail merge, share and review shared document files. Project Work : Resume creation, form creation, and other professional document.

Ms – Excel

Introduction of excel workbook, shortcut key and various selection techniques, customizing Excel, Freezing panes. Using Basic Function: sum(), Average(), Max(), Min(), Count(). Mathematical function: Sumif(), Countif(), sumifs(). Other function: today(), now(), day(), date(), Upper(), Lower(), etc Formatting and proofing: Formating cell, Alignment, Border its, using conditional formatting. Managing worksheets: Data sorting & data Filtration, Excel sheet protection.

Advance Excel

Data Analysis, Goal seek, Data table (PMT Function), Logical function, data Validation, Lookup function, Pivort chart in excel chart various chart: Bar chart, pivot chart, pie chart, Line chart etc. Database function : Dsum(), Dcount(), Dmax(), Dmin() etc. Work with VBA Application(Project),Form Designing in VBA.

Power Point

Create presetation, work with colour & Theme in powerpoint, Insert clipart, Image, shapes to slide. Add sound & video, to a slide presentation, work with Animation in presentation, Final Preparation present a presentation.

Internet and Web design

Introduction of Browser, Domain name system. Work with Email : Email A/c creation & Email composing and file attachment. Online form felling and file attachment, online shopping. File upload and downloading

Semester-II:(4 Month Duration)
(Computerize Accounting & Tally)

Basic Accounting Terms

Capital,Assets,Drawing,Debit,Credit,Creditor, Debtor,Principal Of Accounting ,Ledger,Voucher,Day Book ,Balance Sheet,P&L A/C ,Journal Entries.

Tally overview

Getting Function Of Tally.ERP9,Creating/Setting Up Of Company,Accounting Master In Tally.ERP9 ,F11:Feature,F12:Configuration,Setting Up Account Heads. Inventory In Tally.ERP9:Stock Group,Stock Category,Location/Godown,Unit Of Measurement,Stock Item Voucher Entry In Tally: Accounting Voucher , Inventory Voucher,Invoicing.

Advance Accounting In Tallyerp.9

Credit Limit ,Bill Wise Detail, Interest Calculation, Cost Center & Cost Categories, Advance Inventory In Tally Erp.9

Advance Inventory

Order Processing: Purchase Order Processing ,Sale Order Processing, Additional Cost Detail, Bill Of Material(BOM),Price Level And Price List Of Stock Valuation ,Difference Actual And Billed Quantities, Zero Value Entries.

Point Of Sale (Pos)

Feature Of Point Of Sale, Entries Pos Transaction, Pos Report.

Taxation

Tax Deduction At Source (TDS)

Basic Concept Of Tds, Configuring Tds In Tally.Erp9, Processing Transaction Tds Reports.

Tax Collected At Source(TCS)

Basic Concept Of Tcs , Configuring Tcs In Tally.Erp9,Processing Transaction Tcs Reports.

Goods And Service Tax(Gst)

Basic Concept Of Gst, Basic Concept Of Cgst, Sgst, Igst, Configuration Gst In Tallyerp.9,Work With Different Rate Of Gst, Gst Implementation With Item Rate & Item Value Create Sale & Purchase Invoice With GST..

Payroll Accounting

Configuration Payroll In Tally.Erp9 ,Creating Payroll Masters ,Processing Payroll In Tally.Erp9,Generating Payroll Reports.

Other Feature

Bill Printing With Compony Logo Security & Control , Backup & Restore ,Security Control Utilization Banking Reports, Export & Import, Challan Reports, Statement Reports, Closing Stock.  

Semester-III:(2 Month Duration)
Python Programming (with Live Project)

An Introduction to Python

Why Python?, Good to know Python Syntax compared to other programming languages, Python Install.

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,

Python Program Flow

Indentation, The If statement and its’ related statement, An example with if and it’s related statement, The while loop, The for loop, The range statement, Break &Continue, Assert, Examples for looping.

Functions& Modules

Create your own functions, Functions Parameters, Variable Arguments, Scope of a Function, Function Documentations, Lambda Functions& map, Exercise with functions, Create a Module, Standard Modules.

Exceptions Handling

Errors, Exception handling with try, handling Multiple Exceptions, Writing your own Exception.

File Handling

File handling Modes, Reading Files, Writing& Appending to Files, Handling File Exceptions, The with statement.

Classes In Python

New Style Classes, Creating Classes, Instance Methods, Inheritance, Polymorphism, Exception Classes & Custom Exceptions.

Generators and iterators

Iterators, Generators, The Functions any and all, With Statement, Data Compression.

Writing GUIs in Python (Tkinter)

Introduction, Components and Events, An Example GUI, The root Component, Adding a Button, Entry Widgets, Text Widgets, Check buttons.

Python SQL Database Access

Introduction, Installation, DB Connection, Creating DB Table, INSERT, READ, UPDATE, DELETE operations, COMMIT & ROLLBACK operation, handling Errors.

OR

Desktop Publication

ADOBE PHOTOSHOP CS6

Introduction to workspace, working with groups & layers, Tools & their applications, Gif creation with animation, Intro to blend modes and their applications, Removing background, Some special effects:- Neon light effect, fire effects, Rainbow effects, Retro effect, etc

Corel Draw x12

Introduction to entire pasteboard, Menu Bar and related options, Tool & their uses, Visiting & invitation card printing, Boucher creations, working with bitmap, Logo designs such as Social Media icons, Batman, etc

Semester-IV:(2 Month Duration)
PROGRAMMING & WEB DEVELOPMENT

PROGRAMMING LANGUAGE(C&C++)

Introduction Of Computer Programming, Programming Tools and Technique, Introduction of Software Development. Develop Program With C&C++ Platform.

WEB DESIGNING AND DEVELOPMENT

Introduction And Basic Tags Of HTML, Work with CSS And Boot Strap,Jquery.
Website Creation: Using HTML, CSS And Bootstrap.

RDBMS(Realational Database Management System)

SQL (BACK-END PROCESS) Brief Description of Database, Entity and Attributes, Datatype In SQL, Database Creation, Table Creation, Inserting, Updating, Selecting and Deleting Data In SQL, Data Analysis Tools and Techniques, Procedure in SQL Data Joining Etc.