Course Code/No. Course title L P U SLIT 501 Information Systems for Managers 22 3

(1)

THE ICFAI UNIVERSITY, JAIPUR

1 | P a g e

THE ICFAI UNIVERSITY JAIPUR

IBS Business School

Course Handout

MBA

First Semester: 2015-2016

Course Code/No.

Course title

L P U

SLIT 501

Information Systems for Managers

22 3

1. Instructor-in-charge : Aishwarya Vatsa

F-111

Email id: [email protected]

Mobile No: +91-791457714

2. Scope & Objective of the course:

To provide basic concepts of Information Systems in networked business environment. To develop proficiency

in solving business problems using personal productivity tools.

At the end of the course, the student will be able to:-



Demonstrate he understanding of basic concepts of information systems in networked

business environment



Analyze and classify information systems and their impact on business decision making

at various levels and across the functional areas in the organizations.



Ability to identify and define the needs for information systems and develop them using

various system designing methods.



Demonstrate and develop proficiency in solving business problems using personal

productivity tools like MS Excel, MS PowerPoint and MS Word.



Discuss the importance of information security and the latest trends in the digital era

3. (a) Textbook(s):

T1:Introduction to information

systems-supporting and transforming business

Turban and Potter, Wiley Indian Student Edition

T2: Management Information Systems, 9

th

e

O’Brien, Marakas, Behl, McGraw-Hill2010

T3: Microsoft Office

Ed Bott, Woody Leonhard, Pearson Education

(b) Reference book(s):

R1: Advanced Cases in MIS

Brady, J.A/Mark. EF. Course Technology-2000

R2:Information Technology for Management

Lucas, Henry C Jr. Tata McGraw Hill, Latest Ed

R3: 2007Microsoft Office 2010 Bible, 3

rd

e

Lisa A. Bucki, John Walkenbach, Faithe Wempen,

(2)

THE ICFAI UNIVERSITY, JAIPUR

2 | P a g e

4. Lecture-wise plan

Lecture/

Session

Nos.

Learning

Objectives

Topics to be covered

Reference

(Chapter/Sec./ Page Nos.

(of Text/ Ref. Books)

1-4

Basic Concepts: Understanding Data

and Information, System Concepts,

Open

System,

Closed

System,

Business as a System, What is

Information System, Classification of

IS in organization, Attributes of

Information Quality

Information Systems (IS) Concepts

T1: Part-I, Chapter-1&2

T2: Module-I, Chapter-1

5-8

Business

in

a

networked

environment: Basic concepts of

networks,

Network

architecture

(client server, 3-tier), work group

technologies, intranet,

extranet,

internet, world wide web and search

engines

Information Systems in Business

T1: Part-II,Chapter-6 and

Chapter-7

T2: Module-II, Chapter-3

T2: Module-V, Chapter-14,

Section-I

9-12

Decision Making, Types of Decision,

Decision-Making Levels, Transaction

Processing

System(TPS),

Management

Information

System(MIS)-role in organizational

development- Executive Information

System (EIS), Office Automation

System(OAS),

Collaboration

Technologies NPV, IRR, PMT

Introduction

to

Organizational

Systems

T1: Part-III, Chapter-9, 10

13-14

HR, Marketing, Finance, Production;

sources of competitive advantages, IS

for Competitive Advantages.

Information

Systems

in

Functional Areas

T1: Part-III, Chapter-9, 10

15-18

Structured system analysis and

design,

Approaches

to

IS

Development

Life

Cycle(SLDC:

Requirement

Analysis,

Design,

Implementation and Maintenance),

Prototyping, RAD, Make or Buy

Decision for IS Development, Tools of

IS Design, DFDs, Structured English,

Flow charts, decision tables and

decision trees.

Information System Development

Concepts

T1: Part-IV, Chapter-14

T2: Module-III, Chapter-7&8

19-26

Word processor Concepts, Overview

of MS Word user interface. Entering

text, formatting, styles, spell and

Advanced features in MS Word

T: Chapter : 13, 14, 15, 16

and 17

(3)

THE ICFAI UNIVERSITY, JAIPUR

3 | P a g e

grammar

check

and

printing

documents. Working with line

graphs, pictures and other objects.

Desk Top Publishing.Track changes,

document protection, revision, Mail

merge, forms, water marking,

headers

and

footers

manage

columns, OLE, thesaurus, working

with outline view.Tables, Templates,

Style sheets, annotating text and

generation of TOC, MS Outlook and

its configuration

27-35

Spreadsheet

basics:

Application

layout and user interface, Cell

referencing, Formulas and functions,

Graphs and Charts, Data validation,

Consolidation

and

conditional

formatting, Sorting and accessing

data from text and web. Analysis

Tools: Pivot table and pivot chart,

Filtering,

Goal

Seek,

Solver.

Advanced features: Macros Linking

multiple sheets and OLE. Functions:

Overview of lookup, mathematical

and database functions.

Advanced features in MS Excel

T3: Chapter: 18, 19, 20, 21

and 22

36-42

Role of PowerPoint in management

Communications, PowerPoint User

interface, Use of Templates and

presentation wizard, Guidelines for

designing

quality

presentations,

Designing slides, Slide Masters,

Embedding

clip

art,

graphics,

spreadsheet,

Tables,

Word

documents and Video/Audio clips,

Hyper linking, Use of Animation,

Action buttons, Transition effects,

Automatic

presentations,

Presentations through website, Use

of pps

(4)

THE ICFAI UNIVERSITY, JAIPUR

4 | P a g e

5. Evaluation Scheme:

Component

Duration

(hr/min)

Weightage

(%)

Course coverage/

Syllabus

Date/ Time

Remarks

Individual

Assignment 1

--

5 Sessions 1-4

Announcement

date: 29/06/15

Monday

Submission date:

07/07/2015

Tuesday

Library / web research

based assignment

Project

--

5 Sessions 6-10

Announcement

date:07/07/15

Tuesday

Submission date:

13/07/2015

Monday

Practical sessions based

project

Seminar 1

--

5 Sessions 10-12

Announcement

date: 14/07/15

Tuesday

Seminar date:

17/07/2015

Friday

Topic based on the

given sessions in

consultation with

instructor-in-charge

Academic

Interaction&

regularity in class

continuous 5

--

Evaluated by the

instructor in the middle

of the semester

Mid Term

Examination

1 hour

20 Sessions 1-12

30/07/15

Closed book written

Examination (4 subjective

questions)

Individual

Assignment 2

--

5 Sessions 13-16

Announcement

date: 04/08/15

Tuesday

Submission date:

10/08/2015

Monday

Library / web research

based assignment

IT Lab Practical

Test

1 hour

5 Sessions 17-21

Practical test

date:

17/08/2015

Monday

In supervision of lab

administrator and

instructor-in-charge

Group

Presentation

--

5 Sessions 22-25

Announcement

date: 21/08/15

Presentation

date:

31/08/2015

Monday

In groups of 3

candidates (PowerPoint

Presentation)

Academic

interaction&regula

continuous 5

--

Evaluated by the

instructor in the middle

(5)

THE ICFAI UNIVERSITY, JAIPUR

5 | P a g e

rity in class

and at the end of the

semester

End Term

Examination

40 (18+22) Sessions 1-25

18/09/2015

Closed book written

examination (1 hr 30

minutes) and IT Lab

Practical Examination (1

hr 30 minutes) 4 to 5

subjective

questions (18) and

practical examination

(22)

TOTAL

100

6. Chamber Consultation Hours:

Every Monday between 5:00 pm to 6:00 pm

7. Make-up Policy:

Make up tests will be allowed to the students only in case of genuine

circumstances. However, there has to be a Prior and proper intimation to the undersigned or the

Program Coordinator

AishwaryaVatsa

Date

: 02-06-2015Name & Signature of I/C