Duration-One Year (Ist+IInd+IIIrd+IVth 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.
What Student Say?
Here are testimonials from students..
Institute is quite good....teachers re very helpful....and good atmosphere inside the institute.....
Gautam Negi
Best institute for computer studies and best teachers
Amit Kumar
Qualified teachers with proper education and faculty
A best learning institute for the students with better environment
Teacher's behaviour regarding to the students is very nice
A well disciplined coaching centre
Diksha Pandey