Management Info Systems
Carrying out managerial functions to achieve a common goal
Functions of Management:
Data: Facts about objects and events (color, weight, size, length, ect) measured by our senses or instruments.
Information: Processed data:
Methods of data processing:
1) Simple operations such as counting, sorting, categorizing, ect 2) Math/ Stat operations such as averages, sums, Std Dev, formulas, ect. 3) Visualizing operations such as charts, graphs, tables, ect.
Knowledge: Information combined with experiences and expertise Systems: Parts working and interacting together to achieve a common goal
Heating system: boiler, pipes, water
Organization: accounting, marketing, finance, operations
Information Systems: A system to process data to get useful and meaningful information.
Information system components:
Management Information Systems:
An information system to help managers do their daily business and make better decisions to achieve business goals
Process: A set of activities carried out to convert inputs into outputs. Insurance Claims Processing activities
1) Take the next claim,
2) Validate ID
3) Validate amounts claimed
4) Validate bills with service provider
5) Approve the claim if all validations are good. Otherwise, reject.
Input: Claim Forms Claim processing activities Output: claim form with approve or reject decision
Business process should be provided with the right information to the right person at the right time, so that it can run smoothly. Databases are used to store and get data in an organized fashion for business processes.
Flow chart: only arrow box diamond and circle
Introduction to Microsoft Access:
It is a Database Management System (DBMS)
Database: Organized collection of data
There are different types of databases but the most common is called a “relational database” where the database is consisted of “tables” linked by a common “field”.
Table is data organized in terms of “fields” and “records”, very similar structure to Excel. -Fields
-If you intent to multiply, add, subtract, ect., then it is a numberical field -If not then it is a text field
-Byte- small numbers, up to 128 #-integer must be a whole number
In Access there are 4 objects we need to know:
1) Table: where we store our data
2) Form: How we show, browse, modify data on the screen on rec at at time 3) Report: How we list the records on the screen or paper
4) Query: To filter the data based on a user defined criteria
Management Information Systems are needed usually for 3 reasons: 1) To do daily business and transactions,
2) To make decision making,
3) For strategic purposes
a. What are the general and specific strategic initiatives?
b. How IS/IT can support those initiatives?
EIS+ MIS + TSP= ERP
ERP= Enterprise Resource Planning or Enterprise Systems
One single, big information system for all departments and employees Example: SAP, PeopleSoft, Oracle
Strategic Management and Information Systems
Strategy: consistent moves or steps to reach a goal
Information systems (IS) and Information Technology
1) strengths, weaknesses, opportunities, and threats SWOT
1) avoid redundancies, keeping two or more databases about the same object in multiple places 2) Keep consistent data
StudentID FirstName LastName CalssesTaken
101 John Smith Mgt info sys, oper mgt, finan acc, euro
Entity-relationship diagrams (E-R Diagram)
Most databases are used as relational databases
It means creating links (relationships) between tables (Entities) using common data fields you can integrate and access all the related information distribution in multiple tables...
Please join StudyMode to read the full document