Welcome to NATIONAL COMPUTER EDUCATION INSTITUTE

WELCOME TO NATIONAL COMPUTER EDUCATION INSTITUTE (NCEI) AN ISO 9001-2015 CERTIFIED

 
DIPLOMA IN OFFICE AUTOMATION ( M-DOA09 )

BASIC INFORMATION

  • Course Fees : 14450.00 16000.00/-
  • Course Duration : 1 YEAR
  • Minimum Amount To Pay : Rs.2450.00

Semester-I

Fundamental

Introduction of Computer

Generation of Computer

Computer Hardware and Software

UI- User Interface

CUI based OS (Operating System)

GUI based OS (Operating System)

OS- Operating System

MS-DOS

Introduction about Microsoft Disk Operating System-(MS-DOS)

Basic Internal and External Commands

Windows 10 / 11

What's new in Windows 11

Windows Start Menu

Fast Search

File Explorer

File folder management

Mouse Pointer

Windows Theme

Sticky Notes

Notepad

WordPad

Calculator

Desktop Personalize 

Mouse settings

Paint and Photo

Internet

Introduction to Internet

E-Mail

HTML- Basic

Introduction

Formatting of Text

Creating List

Creating Links

Semester II

Microsoft Office Package

Microsoft Word 2021

 

 

Introduction to MS-Word 2021

Working with Documents

Editing a document & Formatting Text

Formatting Paragraph, Table,

Mail Merge, Graphics, and Header & Footer

Page Layout and Page No

Project

Microsoft Excel 2021

 

 

Introduction to MS-Excel 2021

Screen Components and Windows Arrangement

Working With Workbook, Modifying Worksheet

Performing Basic Calculation

Working with Functions,

Data Sorting, Filter and Pivot Table,

Chart and Graphics

Worksheet Organizing

Page Setup and Printing configuration

Project

Microsoft PowerPoint 2021

 

 

Introduction to MS-PowerPoint 2021

Concept of Slide and Presentation

Slide, Place holder, Graphics in Presentation

Slide Design and layout

Transition and Animation

Slide show and slide Timing

Project

Database

·         Microsoft Access 2021

·         Introduction to MS-Access

·         Database Term

·         Data Type

·         Table, Form, Query, Report

·         Relationship

Semester-III

Accounting Introduction

Financial Accounting Concept

Introduction of Book Keeping and Accountancy

Type of Accounts

Process of Accounting

Debiting and Crediting Rules (Golden Rule)

Accounts Only in Tally Prime

Company Concept in Tally

Group, Ledger, and Voucher

Ledger Creation and Alteration

Voucher Entry

Contra Voucher (Banking Module)

Purchases Voucher

Sales Voucher

Payment Voucher

Receipt Voucher

Journal Voucher

Reports

Day Book

Purchases Register

Sales Register

Journal-Register

Ledger

Groups

Accounts With Inventory

Introduction to Accounts with Inventory

Stock Group

Stock Categories

Stock Item

Unit of Measure

Godowns

Inventory Voucher Entry

Receipts Notes

Purchases Bill Pending

Purchases Invoice Entry

Rejection Out

Debit Notes

Delivery Notes

Sales Bill Pending

Sales Invoice

Rejection In

Credit Notes

Stock Journal

Physical Stock Transfer / Multiple Godown

Consumption and Production

Reports

Stock Summary

Godown Summary

Purchases and Sales bill Pending

Stock Query

Day Book

Purchases Register

Sales Register

Stock Journal Reports

Invoice Printing

Goods and Services (GST)

Concept of GST

Concept of Inter-State and Intrastate Trading

ITC

GST Enable in Tally

Tax Ledger Creation

GSTIN Concept, HSN SAC

GST Enable in Ledger

GST Rate and HSN/SAC setup

GST Registration Type

GST Purchases Entry

Sales with GST

Invoice Printing

GSTR 1, GSTR 2, GSTR 3B Report

Export Data for Tally to Excel

Qualification: - 12th / Graduation etc.

Requirement : - Identity Proof, Address Proof, Residence Proof, 3 Photograph, Category Certificate