MC-R06

MC-R06
(PGPRM 2006-08 : Term-I)

Managerial Computing
(Faculty: Mr. Pravat Mohapatra)

Course Outline

Objectives:

With the phenomenal growth of information technology, computers have helped all professions in being more effective. However IT plays different role for different professions. One of the key task of managers in decision making in functional spheres of managers. Hence, we use the computer in this course as tools, which help in modeling decision-making situations and provide insight into the complex situations at hand.

We use the popular managerial decision making tools such as spreadsheets, statistical packages to do the modeling.

Further , the students will have to learn about the state of the art in information technology and relevance of the same for organizations working for in decision making.

Pedagogy:

The course will rely on class room lectures for discussion on IT topics, exercises and cases for horning the skills at using computers in decision making situations.

Contents :

1. Model building and Analysis with Spreadsheets

· Worksheet basics
· Calculations by using formula and Functions
· Editing and Formatting cell contents
· Functions
· Generating Graphs and chart
· Data analysis by using What-If, Goal seek and auditing
· Data management through sorting, filter, validation and consolidation.
· Generating pivot table report

2. Topics on general Information technology

Evaluation

Examination	Component Weightage	To be held on	Coverage
Class Room Test	10%	9th Day of training	Topics Covered till 8th Day
Practical Test-1	10%	12th Day of training	Topics Covered till 11th Day
Practical Test-2	10%	20th Day of training	Topics Covered till 19th Day
Case Study Presentation	20%	6th Day from Course Completion	Using the Features of MS-Excel
Final Test	50%	As per Course Calendar	Detail on MC

Day wise Breakups

Day 1 What is a computer and components of a personal computer?
Concept of Hardware and Software. OS concepts

Introduction to Excel as an office management software. Familiarizing with excel sheet. Storing
Data and formula on a sheet.

Day 2 Practical Session on Data storage in Excel Sheet, applying formula on data and data editing.

Day 3 Details about Operating System. Computer architecture and Microprocessor, memory.
Utilities of built-in functions in Excel application.

Day 4 Practical Session – Excel Built-in Function

Day 5 Data Processing Methodology (Batch Processing, On Line Processing), Multi Programming and
Multithreading, time-sharing, Spooling. Disk Defragmentation

Day 6 Practical Session on Decision making on Excel sheet

Day 7 Programming Languages and Programming Techniques.
Editing and Data Formatting on Excel Sheet

Day 8 Practical Session on data formatting and editing in Excel Sheet.

Day 9 1st ClassRoom test
Additional Cell formatting commands

Day 10 Practical Session on Advanced Data Formatting.

Day 11 Discussion on other Office Applications like Word, Access and PowerPoint

Data transfer and linking Excel data with other office applications. Discussion on a small case.

Day 12 1st Practical Test on linking Excel with other office applications.

Day 13 Database Concepts and Database Management System.
Graph generation on Excel data

Day 14 Practical Session on Excel Graph

Day 15 Concepts on Networking

Day 16 Practical Session on Data management through Excel.

Day 17 Internet Concepts

Day 18 Related Practical

Day 19 Concepts of e-Commerce
Additional Data management tools in Excel (Goal Seek, pivot table, data consolidation, what-if
Analysis)

Second Practical Test

Day 20 Related Practical Sessions.
Created By: Bijoy Kar on 07/19/2006 at 03:09 PM
Category: PGPRM - I Doctype: Document

...........................