Masters of Business Administration:Computer Applications in Management

Aim : To introduce the concepts of information technology and their application in
management decision making.
Components of a Computer - Hardware & Software - Operating systems - Directories
and File properties.
MS OFFICE - Introduction to WORD, POWERPOINT and EXCEL.
WORD - Creating a new document with templates & Wizard - Creating own document -
Opening/modifying a saved document - converting files to and from other document
formats - Using keyboard short-cuts & mouse - Adding symbols & pictures to
documents - headers and footers - Finding and replacing text - spell check and
Grammar check - Formating text - paragraph formats - adjusting margins, line space -
character space - Changing front type, size - Bullets and numbering - Tables - Adding,
editing, deleting tables - Working within tables - Adding, deleting, modifying rows and
columns - merging & splitting cells.
EXCEL - Working with worksheets - cells - Entering, editing, moving, copying, cutting,
pasting, transforming data - Inserting and deleting of cells, rows & columns - Working
with multiple worksheets - switching between worksheets - moving, copying, inserting &
deleting worksheets - Using formulas for quick Calculations - Working & entering a
Formula - Formatting a worksheet - Creating and editing charts - elecments of an
EXCEL chart - Selecting data to a chart - Types of chart - chart wizard - Formatting
chart elements - Editing a chart - Printing charts.
POWERPOINT - Creating new presentations - Auto content wizard - Using template -
Blank presentation - Opening existing presentations - Adding, editing, deleting, copying,
hiding slides - Presentations - Applying new design- Adding graphics - Using headers
and footers - Animating text - Special effects to create transition slides - Controlling the
transition speed - Adding sounds to slides - Using action buttons.
TALLY - Introduction and Installation, Required Hardware, Preparation for installation
of Tally software, installation. Working in Tally : Opening new company, Safety of
Accounts or Password, Characteristics, Making Ledger Accounts, Writing voucher,
voucher entry, Making different types of vouchers, Correcting sundry debtors and
sundry creditors accounts, Preparation of Trial Balance, Books of Accounts, Cash Book,
Bank Books, Ledger Accounts, Group Summary, Sales Register and Purchase Register,
Journal Register, Statement of Accounts & Balance Sheet.
Practicals : Simple problems to be done in WORD, EXCEL and POWERPOINT using all
the above mentioned topics.