Objective :
To equip the accountant of the New Age with Financial Accounting and
Financial Data Preparation on Computers. They should be able to present the
accounting / Financial data as per the organizational requirements
Duration
:
144
Hours.
Eligibility
:
Standard 10th
Pass under
10+2 System with English as one of the subject.
Content
:
Introduction to computers, Windows 2000, MS-Excel-2000, MS-Access-2000,
Computerized Financial Accounting , Fas Packages Tally , Munimji , Tata
Ex gn.
|
Sr.
No. |
Name of Topics |
Duration |
|
1 |
Computer Architecture and Fundamentals |
10 Hrs. |
|
2 |
Operating Systems & MS-DOS |
08 Hrs. |
|
3 |
MS Windows 2000 O.S. |
14 Hrs. |
|
4 |
Microsoft Office-2000 |
02 Hrs. |
|
5 |
Microsoft Word-2000 |
12 Hrs. |
|
6 |
Microsoft Excel-2000 |
12 Hrs. |
|
7 |
Microsoft Access-2000 |
12 Hrs. |
|
8 |
Tally 5.4 Financial Accounting Package |
74 Hrs. |
|
Total |
|
144
Hrs. |
Introduction to
Computers
§ Computers in Our World
§ Introduction
§ Necessity is the Mother of Invention
§ Capabilities of a computer
§ Classification of Computer
§ Application of Computers
§ Generation of computers
§ Addition Reading
§ Brief History of Computers
§ Computers and Hardware
§ Computer System
§ Input/Output Devices
§ Central Processing Unit abbreviated(CPU)
§ Brief Introduction to Memory
§ In Computers Everything is Binary
§ Input Data : Sources & Concepts
§ Keyboard
§ Graphical Input Devices
§ Those using Special Sensitivity
§ Those which senses Magnetic Ink
§ Industrial Robots
§ Output Devices and storage devices
· Why output is needed
· Monitor
· Printers
· Impact
· Non-impact Printers
· Plotters
· Storage Device
· Primary Devices
· Secondary Devices
· Magnetic Disks
· Those mounted in the computer
·
Those which can be removed and used on various machines
§ Computer Software & Data Communication
¨ Computer Software
¨ Application Software & System Software
¨ Computer and Data Communication
¨ Advantages of Data Communication
¨ concept of network
¨ Classification according to the area covered by network
§ Operating System
¨ Introduction to Operating System
¨ Booting Procedure
¨ Types of Files
¨ DOS PROMPT
¨
Introduction to Dos Commands
§ Understanding DOS-I
¨ Internal DOS Commands
¨ Wild Card Character in Dos
¨ Directory Related Commands
¨ File Related Commands
§ Understanding DOS II
¨ External DOS Commands AND Utilities
§ Filters & Redirection
¨ Redirection
¨ Input Redirection of a command
¨ Filter Commands
¨ Connecting Pipe
¨ Combining Redirection and Filters
§ Batch files
¨ Techniques of batch Files
¨ Create your first batch file
¨ Suppressing of On-screen display of commands
¨ Decision making with Batch files
v Importance of an Operating System
v A Guarantee to an Instant Start on MS-DOS
v Getting Started on DOS with Booting the System
v MSDOS.SYS
v Command COM
v Telling DOS the Data and Time
v Concepts Review
v Getting and Interpreting a Directory
v Making use of Pause Key to freeze scrolling
v Getting a Printed Copy of a Directory
v Using Wild Card Character
v What is a Wild Card Character ?
v Concepts Review
v Making use of Hierarchical Directories
v What are Hierarchical Directories ?
v Hierarchical Directory System
v Making use of MKDIR or MD command
v Making use of CHDIR or CD command
v Making use of the RMDIR or RD command
v Concepts Review
v Copying commands
v Copy command
v Copy Source file Destination file
v Disk copy source Destination
v Concepts Review
v Displaying the file contents
v Syntax
v Type Filename
v Print Filename(s)
v DEL Filename(s)
v Erase Filename(s)
v Formatting Disks
v FORMAT <DRIVE:>/<SWITCHES>
v Renaming Files
v Rename Original Filename New filename
v Clearing the Screen
v Displaying the Version Number
v VER
v Find
v
Sort Filename
Ø Introduction to Operating System
Ø What is an Operating system ?
Ø Why is it required ?
Ø What are the types of an Operating System ?
Ø What are the functions of an Operating System ?
Ø Terms often used for Windows 2000
Ø Introduction to Windows 2000
Ø Specialties of Windows 2000
Ø Terms often used in Windows 2000
TASKBAR -
WHAT IS GOING ON ?
Ø What is the Taskbar ?
Ø What are its functions ?
Ø Launching of applications with help of Launching Pad
Ø Explanation of title bar and buttons
Ø Switching between applications
Ø Changing the size and position of the Taskbar
Ø Properties of the Taskbar
DESKTOP - HOW DO I LOOK ?
v Introduction to the Desktop
v Main Icons on the Desktop
v Properties of the Desktop
Ø what does an Applet mean ?
Ø Different Applets under Windows 2000
Ø Clipboard Viewer
Ø Character Map
Ø Calculator
Ø Clock
Ø Games
Ø Media Player
Ø Paint
Ø Sound Recorder
Ø WordPad & Notepad
RECYCLE BIN - FLUSHING IS
REQUIRED
Ø Introduction to Recycle Bin
Ø Working with Recycle Bin
Ø Properties of Recycle Bin
MY BRIEFCASE - TAKE ME HOME
Ø What is Briefcase in Windows 2000 ?
Ø Linking files from the main computer to the laptop
Ø Copying back the updated files
WINDOWS EXPLORER-NOTHING IS
HIDDEN FROM ME
Ø Two modes in which Windows Explorer works
Ø My Computer
Ø Windows Explorer
Ø File Management Tools under Windows Explorer
NETWORK NEIGHBORHOOD-LOVE THY
NEIGHBORS
Ø Introduction
Ø Network Neighborhood in Open window
Ø Network Neighborhood in Explore window
Ø Sharing
Ø Sharing of files and folders
Ø Sharing of hard disk
Ø Sharing of Printers
Ø Connecting a device temporarily
CONTROL PANEL-MY TOOL KIT
Ø Introduction to Control Panel
Ø Tools under Control Panel
Ø Accessibility Options
Ø Add new Hardware
Ø Add Remove Programs
Ø Date/Time
Ø Display
Ø Fonts
Ø Keyboard
Ø Mouse
Ø Multimedia
Ø 32bit ODIALOG BOXC
Ø Passwords
Ø Printers
Ø Regional Settings
Ø Sounds
SHORTCUTS-SHORT BUT STRONG CUTS
Ø What are shortcuts ?
Ø Creating a shortcut on the Desktop
Ø Creating a shortcut in the Start menu
Ø Short-cut for Send To
Ø
Properties of short-cut
IN-BOX LET'S TALK WITH THE WHOLE WORLD
v At a glance :
Ø Introduction to In Box
Ø Sending & Receiving e-mail
Ø
Sending & Receiving Fax
MULTIMEDIA-SINGING ALL THE WAY
Ø What is a multimedia ?
Ø Playing of a CD with CD Player
Ø Playing of a CD with Media Player
Ø
Working with a Sound Recorder
v What is Windows
v What is suite of Software
v Selecting in Office Programs
v Using Tools and Menus
v Working in Documents
v Cutting, Copying, and pasting
v Saving a Document
v Getting Help
v Advantages of Word Processing under Windows
v Various Word Processors available under Windows
Microsoft
Office 2000
Introduction to Microsoft Office
Word 2000
File Menu
Edit Menu
Toolbar Shortcut
View Menu
Insert Menu
Format Menu
Tool Menu
Mail Merge-with Query
Tables
Inserting file from other Application
Excel 2000
File Menu
Edit Menu
Toolbar shortcut
View Menu
Function & Formulas
Creating a complete Worksheet
Tools Menu
Auto Format
Data Menu
Access 2000
Introduction to Database Concept
Creating New Table
Modify Structure
Open Table
Creating Auto Form
Modifying Design
Open & Entry
Creating Auto Report
Preview
Query Creation
Creating Complete Project
TALLY
5.4
Ø What Is Account?
Ø Advantages & Disadvantages
Ø Accounting Rules
Ø Accounting Systems
Ø Accounting Version
Ø Create & Select Company & Modify Company
Ø Trail Balance
Ø Single Ledger & Multy Ledger
Ø Voucher Type With Voucher Entry
Ø Same Item Scheme
Ø Different Item Scheme
Ø Cash Book With Printing
Ø Bank Book With Printing
Ø Sales Register With Printing
Ø Purchase Register With Printing
Ø Journal Book With Printing
Ø Memo & Revers Entry Optional & Regular Entry
Ø Multy Currency
Ø Multy Currency With Foren Transections
Ø Budjet Creation,Alter,Display
Ø Budjet With Voucher Entry
Ø Bill By Bill Entry
Ø Discount With Invoice
Ø Difference Actual & Billed Qty
Ø Purchase Tax Register
Ø Colunm Wise Details Register
Ø Export A File Word & Excel
Ø Inventory Creation,Display,Alter
Ø Delete A Voucher,Cancel,Duplicate,Add,Insert A Voucher
Ø Security Controls
Ø Secury Rights With Data Entry Oprator & Owner
Ø Balance Sheet & Printing
Ø Profit & Loss A/C & Printing.
Ø Inventory With Voucher Entry
Ø Opening & Closing Stock Report
Ø Sales Order – Sale- Receipt
Ø Purchase Order-Purchase-Payment
Ø Due Date Bills,Outstanding Bills
Ø Receivable & Payble Reports
Ø Debite Note & Credite Note
Ø Stock Categries
Ø Cost Centre With Voucher Entry
Ø Reversing Journal
Ø Allow 0 Values Entry.
Ø Manufacutring & Exp Date Bills Reports
Ø Purchase Book With Exp.Entry Register
Ø Sales Register In A Coloum Mode.
Ø Printing Export
Ø Ratio Analies.
Ø Closing Perio Printing
Ø Traking Nubers Entry
Ø Delivery Notes Entry
Ø Rejection In Out Entry
Ø Track Additional Cost Of Purchase Entry
Ø Imort of datas
Ø
Fuctions keys
· Creating Complete Project Work