PgD in Management Executive

PgD in Management Executive

A.1. Introduction:

The Study is running with fully computerised and IS philosophy based so that the company is controlled in IT infrastructure and IS strategy will be described here for the future benefit of the company. By adopting frameworks necessary in characterising comprehensiveness, focus and formulation, firms may be able to increase rationality, while inducing increased participation and enhanced consistency. Improving the planning cycles of IS and SDLC (System Development Life Cycle) activities have also been proven instrumental in enhancing planning effectiveness. In some cases, such difference manifests itself through policies to save all enterprise information indefinitely, or to delete all data after brief periods of time. Traditional approaches to information management are often designed to mitigate risk; firms respond to regulatory and compliance requirements. Information compliance investments, for example, should be cost-managed, as providing compliance in excess generally adds little value and can be an inhibitor. The information to answer such questions often exists within an organization's IT systems, and requires minimal effort to answer once the key questions are identified by the senior executive team and business leaders. Answering key questions often requires minimal information and investment. Using an experimental approach similar to statistical sampling can provide the answers to key business questions quickly and dynamically.

Aims and purpose of the Study: Many firms are focusing on using integrated databases and end-user computing which some experts believe threatens the role of the 'information provider' in organisations. However, providers of data have contributions to make associated with decision making which are beyond just interpreting or supplying information. Some common decision-making-linked roles include facilitating a common database for group decisions; supplying effort and expertise in gathering information; and providing audit trails of data associated with certain decisions. Firms interested in maximising the contributions of 'information providers' are advised to clarify and incorporate providers' roles into the development of significant information systems within firms. Information systems strategy , management, development and security

Understanding computer hardware:

It's the physical and tangible part of a computer like keyboard, mouse, ram, hard disk, sound card, wires etc. Without hardware it's not possible to run the computer.

CPU - central processing unit

At the core is the processor. Speed is measured in Mhz or GHz. One other parameter of the CPU to investigate is the L1 cache, commonly from 256 kilobytes and up.

RAM - random access memory

Access Memory (RAM) provides space for computer to read and write data to be accessed by the central processing unit (CPU). This determines how many files you can open at once, or how big a file you can open.

Hard disk capacity

Hard disk is a storage device that store digitally encoded data on rapidly rotating platters with magnetic surfaces. It Measured by MB or GB

Video card

The amount of RAM and quality (and number) of microprocessors on the video card determine things like how big a monitor you can use, how large a window you can display video on, and the speed with which large complex graphic images display. Some of the newer video cards have 4 MB to 120 MB or more. Sometimes it is possible to upgrade a video card by adding a graphics accelerator card rather than replacing the video card with another newer version.

Sound card

Sound card is a computer expansion card that facilitates that input and output of audio signal to and from a computer under control of computer. Computer can run without a sound card. The MIDI standard is used to convey music from computer to computer, (or keyboard to computer etc...) and most good soundcards will play at least 32 MIDI voices. The other aspect of a soundcard is how well it plays digital sound files (like from a CD). Most of them do this extremely well also. If you are interested in music or sound, you want to investigate the software that comes bundled with your soundcard (or whatever software you have purchased to work with your soundcard). Traditionally, the sound card also has a port on it to plug in your joystick(s) if you play games on the computer.

Removable storage

Choices range from 3.5" 1.44MB floppy drives, 100MB zip drives, 120MB super drives, 700 MB CD-R, and 4.7 GB DVD-R removable hard drive cartridges and higher now. Of course there are thousands of other choices including tape, optical drives, and surely many more available. Remember to price the storage media per Megabyte when buying. I personally like the CD-R idea since more people have CD-ROMs to read the recorded data.


A computer network is any set of computers or devices connected to each other with the ability to exchange data.

* 1.2 Local area network (LAN), which is usually a small network constrained to a small geographic area.

* 1.3 Wide area network (WAN) that is usually a larger network that covers a large geographic area.

* 1.4 Wireless LANs and WANs (WLAN & WWAN) are the wireless equivalent of the LAN and WAN.

All networks are interconnected to allow communication with a variety of different kinds of media, including twisted-pair copper wire cable, coaxial cable, optical fiber, power lines and various wireless technologies.The devices can be separated by a few meters (e.g. via Bluetooth) or nearly unlimited distances.

Difference & Analysis Between IS and IT

Information System (IS): In a general sense, Information System (IS) refers to interaction between people, process and technology. Data records and activities that process the data and information in an organization, and it include the organization's manual and automated processes. In a narrow sense, the term information system (or computer-based information system) refers to the specific application that is used to store data records in a computer system and automates some of the information-processing activities of the organization. Computer-based information systems are in the field of information technology. The discipline of business process modelling describes the business process supported by information systems.

Information technology (IT), as defined by the Information technology Association of America (ITAA), is "the study, design, development, implementation, support or management of computer-based information systems, particularly software applications and computer hardware."[1] IT deals with the use of electronic computer and computer software to convert, store, protect, process, transmit and transmit and securely retrieve information Today, the term information technology has ballooned to encompass many aspects of computing and technology, and the term has become very recognizable. The information technology umbrella can be quite large, covering many fields. IT professionals perform a variety of duties that range from installing applications to designing complex computer networks and information databases.

In Computer Security, an information system is described by the following components:

* Repositories, which hold data permanently or temporarily, such as buffers, RAM, hard disks, cache, etc. Often data stored in repositories is managed through a database management system.

* Interfaces, which support the interaction between humans and computers, such as keyboards, speakers, scanners, printers, etc.

* Channels, which connect repositories, such as routers, cables, wireless links, etc.

Information Systems has a number of different areas of work:

* Information systems strategy

* Information systems management

* Information systems development

* Information systems security

Information systems development methodology or ISDM is a tool kit of ideas, approaches, techniques and tools which system analysts use to help them translate organizational needs into appropriate Information Systems;


Organization Name: Warwick University

Type of the organization: Education providing organization

Objective of the Organization: To provide innovative, excellent, competitive, and knowledgeable to the education seeker.

Company summary

Warwick university of uk, has decided to set up and establish their foreign branch campus in Asia region to expand their high ranked education proficiency through out the world. Our new campus of Warwick University is named Warwick University (Asian campus) is going to establish in Singapore. It has already mentioned that it is a branch campus of main Warwick of UK. New campus of Warwick is very much concerned to maintain the level of the high standard of the main campus as so far. It's main mission, vision and goal is to be leading the higher education provider worldwide at a profit in the next five years (2010-2025), during which time a formal update to the strategic university plan (2010-2015) is expected, but at the same time with the concern that it is the most competitive, affordable, and advantageous foreign university campus at the surrounding regions.

It is going to set up in Singapore at Bukit punjang, on a 443 acre position. Our main focus is both the international and regional students. Warwick Singapore campus will commence enrolling students from March 2010. The campus will have the capacity to enrol a maximum of 13,000 students, of which at least 60 percent will be drawn from international location and up to 40 percent from Singapore internal region.

Client focus

Like other companies we do have client and customers but the difference is that our customers are student unlike the ordinary customers. Warwick campus serves the community at large in a region that focus about three million people. Clients includes regional students, international students or learners, rural communities, disable person, at risk youth, unemployed, under employed, aboriginal communities.

1.2 The Information System PROPOSAL:

The information System, in to use requires office information system. The accounting system both formal and informal information should be used. There are so many things to be considered when a student comes or apply for university admission. Why we should use IS in University management system. Let us give a brief description of the system. The first thing of the accounting system is to calculate the bill for each student. Then the student is given a receipt after paying some advance of his total dues. The details information of the student is kept in a ledger book. Receptionist is the responsible for this process. Then the information goes to the department head teacher. The student will categorizes here in to two parts. One category is existing student students details and others new student. At the end of each month staff payment are calculated. After deducting all expenses an accounting report is send to the management

1.3 Objective of the Information System:

The objective of the information system currently should be installed to maintain all the records of the students, the system is fully computerized. A computer is needed for calculating expenses, salary and student reports & accounting reports. Basically one operator receptionist is responsible for the accounting, billing, and printing operation.

2. Functions of the System:


The input of the system is the raw data, which represents information of the students name who referred the student, subject information about advance payment and due payment etc. The operator will record the input information into a ledger book.


The output of the System is generally the report about the students, accounting reports for the management and staff's payment information.


The processing includes all rearrangements, total calculating, summarization for reporting purpose and selection of data with the help of a given criteria. Informal processing is done by MS-Excel. Here Ms- Word is used as the students report generating tools. The raw data that is collected is used for conversion, manipulation and analysis of the account report.


The storage material in this system is the student's information. Most of the storage is performed by computerized ledger book using SQL Server At and to derive data structured software need to be installed and also the computer using MS-Excel files performs some of operation such as record the payment for staff.

Management Procedure

Secretary of court Mr. A is the head of centralkiim administration; it's divided into six divisions:

Student and staff support

Financial business resources

External relation and marketing

Management service

Academic support


* The raw data is collected from the student, which is filled by the receptionist. Although the data is not stored into a relational database, it is kept on manual storage. The operator of the university has broadened the raw data in their manual reports.

* The data fields of a student's information system should contain the name, address, subject, date, payment condition etc.

Process data are kept in the ledger book. MS-Excel only deals with numeric calculation of student's data.



ü COMPUTERS: The computers having Cyrix-233MHz processor.

ü PRINTERS: There are three printers where one is Laser, one is Hp 1052c and one is cannon 930 printer.


These computers will be connecting with others computer via internet.

3. The Report management Sub-system:

Information systems development methodology or ISDM is a tool kit of ideas, approaches, techniques and tools which system analysts use to help them translate organizational needs into appropriate Information Systems;

B. Report Writing

OLAP (Online Analytical Processing) is a Decision Support System (DSS) and also complete business intelligence solution; it's fast, agile, and allows us to build powerful business models, from virtually any data source, in a matter of seconds. OLAP is a Business Performance Management/Business Intelligence software solution that empowers business decision makers with the intelligence they need for planning, analytics, reporting, budgeting and forecasting activities, through a single platform. The web based or standalone solutions dynamically connect to back end databases, accessing data in real-time, through an Excel user interface.

Internet Data Services (IDS): IDS allows for the widespread deployment of the OLAP solution to multiple, dispersed locations across the web. The web interface provides easy access to OLAP data via a standard web browser, taking advantage of OLAP as an HTTP Server. IDS web functionality now supports write-back capability.

Google and OLAP for Reporting: Given the new IDS functionality, users have the ability to perform OLAP manipulations with real-time organizational data, using Google's free spreadsheet as your front end. This gives users a fast, efficient and cost effective report publishing and distribution platform for free and powered by the speed and flexibility of the OLAP solution.

Mobile OLAP: Web access to OLAP gives users access to reports, budgets, forecasts on our PDA. Access to important real-time business data immediately, when you need it.

Excel Pivot Tables and OLAP: Access to OLAP data via the web, with Excel Pivot Table front end, provides a clientless zero install, zero footprints.

OLAP for Budgeting and Planning: Many Budgeting and Planning products on the market today can not support the simultaneous usage of hundreds of people in an organization that need to have real-time access to their data to get their job done without significant system performance issues. IDS now allow thousands of employee's real-time access to data to perform OLAP manipulations, without any system performance issues. Our solutions deliver faster, more compact aggregate information than our competitors.
All the OLAP Clients are web deployable: The OLAP clients, Designer, Leonardo ActiveX and OLAP Excel, can be deployed directly from the Server webpage.
Designer features Drill Down on Members and Data: We can now double click on a Dimension member and drill down to successive levels of detail directly from the OLAP Slice. We can expand Year into Quarters, then into months, even days. Double Click again and the hierarchy will collapse back to the consolidated member. We can drill through on a data point and drill down to the detail data or through to the source records.

Designer Slices can be fully Formatted and Printed: Designer allows us full formatting capabilities to display data within the grid. We can create borders and individually format cells, changing Style, Fonts, Color, and Size. Now Designer can be used directly to publish reports with a professional appearance without requiring Excel. We can also print these reports, directly from the designer or Leonardo. Of course We can still use Excel, Xcelcius and many other applications to publish OLAP data.

Create and Publish Dynamic Multidimensional Graphs with Designer: Designer features full multidimensional graphics. We can build rich charts and graphs that are completely dynamic with a Slice of data: if we change the row, column or page dimension, or any data point, the graph will update to show the new perspective. There are 15 basic types of graphs, each with hundreds of formatting options. We can display the graph—or both the graph and the Slice—on the Web, or within most Windows applications. We can choose what level of control the end-user will have over the display, from simply viewing a locked dynamic image, to provide complete modeling capabilities. We can zoom in or out on a graph, set alarm zones, see values of points on a graph and drill down or through on those points. We can print the graphs or save them as jpg or png files.

OLAP MDB Server is now a Web Server: OLAP now eliminates the need for IIS or any other Web server and eliminates the need for two additional servers. Most OLAP Web applications require three dedicated servers: a data server; and application server and a Web server. OLAP allows all three of these applications to reside on a single server, with the same approximate specifications of a single application server. The OLAP MDB Server has complete http-compliant capabilities. Further we can add SSL security to it.
Enhancements to Analysis Services Integration: In addition to the New Linked Cube function introduced in previous versions, the OLAP engine now serves as a budgeting, forecasting and planning engine for Microsoft Analysis Services. OLAP can leverage data in MS AS reporting applications to create a budget model and write back the results to the MS AS cube in real time. This technique gives true robust multidimensional budget/planning/forecasting modeling capabilities.

Most of the Diversified businesses organizations are using this software. Because by using this software all kind of business can take their business related decision quickly and which is very useful.

My business design is to open a new university branch in Singapore. So we have to keep record for all students, transaction and take decision for better service and business which can help this software. Because we have to take decision quickly so this software can be helpful.

Understand Computer-Aided tools

Computer-Aided Software Engineering (CASE), in the field of Software Engineering is the scientific application of a set of tools and methods of software which is meant to result in high-quality, defect-free, and maintainable software products. It also refers to methods for the development of information system together with automated tools that can be used in the software development process.

The term "Computer-aided software engineering" (CASE) can refer to the software used for the automated development of system software, i.e., computer code. The CASE functions include analysis, design, and programming. CASE tools automate methods for designing, documenting, and producing structured computer code in the desired programming language.

Two key ideas of Computer-aided Software System Engineering (CASE) are:

* The harboring of computer assistance in software development and or software maintenance processes.

* An engineering approach to the software development and or maintenance.

Some typical CASE tools are:

* Cofiguration management tools

* Data Modeling tools

* Model transformation tools

Many CASE tools not only output code but also generate other output typical of various systems analysis and design methodologies such as

* Data flow diagram

* Entity relationship diagram

* Program specification

C.1. Case Study

a) What decision made in strategic planning, managerial control and operational control area are discussing bellow:

Strategic Planning: Because of information system waiter can get the information about stock of food level and the price, bill generate automatically so it's very time consuming, organised communication so management can take every decision very quickly.

Management Control: By advantage of information system management can control

1) Stock level

2) Fix the sale target

3) Cost control

4) Improve the food quality and service based on reason of voidance etc.

Operational Control: Using the information system management can control bellow operation

1) Individual responsibilities,

2) Rapid order process,

3) Stock information,

4) Flexible managerial action etc.

Requirement of making decision: We need bellow information for make the decision

1) Information about labour and maintenance cost.

2) Individual item sales and their food cost,

3) Improving the ordering system,

4) Customer feedback,

5) Information about wastage etc.

b) If we do only transaction that's not a complete MIS so for complete MIS we need to add some more information such as:

1) Labour cost

2) Maintenance cost

3) Point of sales

4) Cost of products of foods

5) Stock information

6) Profit margin

7) Wastage information

c) Probable effect that make the system more formal by customer and management point of view:

Customer point of view:

§ Easy to decision make because getting all information rapidly by the information system.

§ Quick feedback

§ Customer satisfaction

Management point of view:

§ Effective operational management

§ Requirement of proper training to adopt the system

§ Efficient team work

§ Cost control analysis.

C1.2 Case Study 2

a) In described situation the security loopholes are:

§ System x transmitted all information by email but few computer they had not changed their default e-mail password which was in user name. It's a big security loophole for the company.

§ Maximum computer don't have updated anti-virus.

§ Local mail sever was open but it was running which is risky.

We can plug these situations by taking following action:

§ David should arrange to update all the anti-virus software.

§ They should take necessary step to change all e-mail passwords which were not change yet and also take appropriate step about the server.

C1.3 Case Study 3

a) As per the scenario of this Multibase Company Limited I would propose Online Analytical Processing (OLAP) system. Which will provide broader category of business intelligence, relational reporting, data mining, business reporting for sales, marketing, management, reporting business process management(BPM), budgeting and forecasting, financial reporting and similar areas, so senior executive no need to give long time for the strategic thinking which is very difficult for various kind business type of company.

b) Present competitive environment senior executive have to spend more time for strategic thinking but he don't have enough time for strategic thinking so I can add Online Analytical Processing (OLAP) with Computer based Information system (CBIS) that can help to take strategic decision quickly. Online Analytical Processing system help broader category of business intelligence, relational reporting, data mining, business reporting for sales, marketing, management, reporting business process management(BPM), budgeting and forecasting, financial reporting and similar areas which can meet the various manufacturing unit type company need.

c) This Multibase Company Limited is a diversified business group also they have large operation in all over the country. And also each unit has operational autonomy strategic decision and involving with the head quarter which is located in London. Senior executive need to be analysis strategic thinking for the eight units which is very important to run their business in this competitive environment. They already using CBIS so CEO aware about that system. CEO knows how company benefited from this system, that's why he proposed to develop the suitable computer based system which will be helpful and understanding the various manufacturing company's needs.

C1.4 Case Study 4

a) It is not justified to say digital systems are unreliable and carries enormous risks, but some time it can be unreliable and carries enormous risks.

Digital system can save time, money and update the service. Because its can store data, analyse data and give result quickly. But before use digital system user should take proper training and also before implement any digital system or software it should be checked properly and find out the fault. Then digital system can be reliable and reduce the risks.

b) Minimize damages due to failure of digital system following countermeasure should take place:

Situation 1

§ At first we have to stop the financial transaction because of showing error.

§ As soon as possible we have to find out the solution of error.

§ Software should update and monitor regularly like routine check system.

§ Always keep the record manually and store data as a backup.

Situation 2

§ Ambulance service should keep backup software which will be automatically run if its shows any problem with main software. That means if main software make any problem than backup software will take over the main software.

§ Communication system should be updated for the ambulance service as per call capacity also monitor and check regularly its working smoothly.

Situation 3

§ Because it's new software so they should prepare about this kind of disaster.

§ They should arrange some way to give support the subscriber for the installation period which can be take from the other company or third party.

D. Interview

1. Personal Information:

Employee Name: Mr. Kobir Ahmed

Employer Name: Tesco Plc

Workplace Address: 94 Church Street, London


Work Telephone: 07511039004

Job Title: Manager

Number of year on current job: 11 Years

Years of computer experience: 15 Years

2. What kind of computer system(s) do you use?


§ Processor: Intel Pentium three and four

§ Mother/ main board: Intel

§ Sound card: Intel

§ AGP/ Graphics Card: Intel 32MB

§ Keyboard: Logitech

§ Mouse: Logitech

§ Hard drive/Storages : Tachguys

Software: I use tesco software which maintains sales information, profit and loss in business, stock level etc.

Printer: Hp LaserJet 1320 for prints all kind of document.

Network card: To connect with others computers and internet for share information.

3. What kind of training have you received in order to use the computer system effectively? Do you find the IT Technical Staff in your firm to be helpful and easy to work with?

I took 2 year training for hardware, software installation and how to use operating system like windows and also take training for Microsoft office.

Yes I found one of IT technical Staff in our firm, when I feel any difficulty he try to solve my problem which make my work easy.

4. What business process (operational) are supports by IT system in your workplace:

In my workplace whole business are supports by IT system such as ordering, take order from customer, keep record about sales and purchases, e-mal, analyse the profit and loss etc.

5. How does Management use the IT system to support their activities?

All business information stores in the computer and all branches can share all information including head office, so management get all information in same time. That's why can easily take their decision which only possible by IT system.

6. Is your system part of a network? If so, who is the network administrator? How do you interact with the administrator? What kinds of issues do you discuss with administrator?

§ Yes our system is a part of network.

§ Mr. Jonson is our network administrator.

§ Anytime we face any kinds of difficulty with our network like e-mailing, information sharing than we contact with him.

7. Are your computer system connected to your customers, supplier or partner? If so, describe how the system is used to connect to these entities.

Yes our computer is connected with customer, supplier or partner.

Customer: customer can access the particular area where they can find out the product information, price and the stock level.

Supplier: They also can access the particular area where supplier can justify our orders.

8. As your career has progressed, what changes in IT have you noticed and how have these changes in IT contributed to your performance.

Yes, my career has progressed by IT system. It's the easiest and quicker way to take any action and make a decision. And also its keep record for every work till we delete it. I can collect any kind of information of my organisation by a single click so it's very helpful to make a decision.

9. Has using the computer system at work influenced your life outside of work? If so, in what way?

Yes, using the computer it influences my life outside of my work.

Now I am use to by using computer, it can help me to get any kind of information from internet, I can send my e-mail and I can chat and share with my friends and with the others people.

10. What advice would you give to a new employee about the IT supported workplace?

For IT supported workplace my advice for the new employee, they should take proper training for the workplace.

11. How do you contact with head office or other branches?

We contract with our head office and other branches by e-mail, fax, telephone etc.

12. What's the payment system of your company?

Our payment system is two type, one by cash and other way pay by card.

13. How do you keep the records?

We keep our record both way like in IT system and manually.

14. Why do you keep the record manually?

We have to keep our record manually because is there any problem happen with IT system we can run our work smoothly.

15. What is the difference between IT system and manual system?

Manual system takes long time to finish every job but IT system can give you quick result if you use the right program for the job.


1. Athabasca University, Business plan 2004-2008, retrieved from

2. Anonymous, Singapore education market profile, 2007, Retrieved from

3. Bowvalley College, Business plan 2009 – 2013, Retrieved from





Download the 60-day trial version of the software by clicking here PowerOLAP Client Download

Please be aware that the free essay that you were just reading was not written by us. This essay, and all of the others available to view on the website, were provided to us by students in exchange for services that we offer. This relationship helps our students to get an even better deal while also contributing to the biggest free essay resource in the UK!