Final Exam Review & Recap

1. Final Exam Review &Recap CSIS-114

2. Reading • Chapter 1 pp 3-30 • Chapter 2 pp 39-58 • Chapter 5 pp 67-91 • Chapter 7 pp 99-124 • Chapter 8 pp 133-161 • Chapter 10 pp 169-209 The final exam is cumulative so review early reading But, Concentrate on these pages

3. Basic Types Operation Support TPS PCS ECS Management Support MIS DSS EIS Enterprise Types ERP SCM CRM Special Types Expert Systems Core Types DBMS System Types

4. Information Technologies- major highlight Database Technology (Chapter 5) • Relational model reduces redundancy and dependence by providing a centralized data framework Data Mining (Chapter 10) • Innovative techniques used to discover patterns and correlations hidden in massive data sets. OLAP: Online Analytical Processing (Chapter 10) • Technologies allow large amounts of data to be processed and analyzedinteractively instead of with pre-developed reports. Artificial Intelligence (Chapter 10) • Category of technologies that simulate human-like ability to solve problems, learn, and “think.”

5. Information Technologies- examples from lab Database Technology • Lab 4: Databases vs. Spreadsheets • Lab 5: Tables, Records, Relationships, Queries, etc. Data Mining • Lab 9: Using advanced queries to discover the best transaction (Decision Support). Best transactions were difficult to find with basic reports and graphs. OLAP: Online Analytical Processing • Lab 10: Pivot Charts let us slice and dice the data to develop an expert system that would predict when Dr. B will play.

6. Information Technologies- student presentation examples Data Mining • Dan Haemmerle talked about advanced Scout; data mining in basketball, and other applications like casinos.” Artificial Intelligence • Chris Allen, Travis Smith & Guillaume Dufau talked about the Lexus that could parallel park itself (Human-like ability)

7. Systems for Functional Areas- examples from class Accounting Systems • Frank Leone and Robyn Freeman talked about Quickbooks an out-of-the-box, inexpensive system perfect for small businesses. • Be sure to read pp 121-122 While functional systems are still around, systems that integrate different functional areas are more valuable. Why?

8. Systems for Functional Areas- examples from class Marketing Systems • Tara Maloney and Todd Crounse talk about the major components: (1) Managing Customers, (2) Targeted Marketing, (3) Automating the Sales Force • Be sure to read pp 111- 116 • Mathias Besse and Bryan Li talked about a CRM system (SalesForce?), a CRM is really an Enterprise Marketing System that integrates other functional areas. • Be sure to read pp 135-142

9. Enterprise Systems- Functional Areas CRM: Customer Relationship Management • Marketing • Accounting, Finance, HR, Operations ERP: Enterprise Resource Planning • All functional areas are equally represented SCM: Supply Chain Management System • Accounting, Operations • Finance, HR, Marketing

10. Enterprise Systems- Types or Categories CRM: Customer Relationship Management • MIS, TPS, DSS, ECS ERP: Enterprise Resource Planning • EIS, DSS, MIS • TPS SCM: Supply Chain Management System • TPS, DSS, PCS • MIS

11. Components and Goals- read all of Chapter 8 CRM: Customer Relationship Management • Contact Management • Marketing • Customer Service • Retention & Loyalty Programs • Sales Management Goals: • Acquire More Customers • Enhance Sales • Retain Customer Loyalty

12. Components and Goals- read all of Chapter 8 ERP: Enterprise Resource Planning • Production Planning (DSS, PCS play roles) • Sales Distribution and Order Management (TPS) • Logistics Integration (TPS) • Human Resource Planning (DSS, MIS) • Accounting and Finance (MIS) By integrating all the components into a single portal, an ERP can also fit into the EIS category. Goals: • Increase Efficiency • Decrease Production Costs • Increase Enterprise Agility

13. Components and Goals- read all of Chapter 8 SCM: Supply Chain Management System • Forecast and Demand Planning • Customer Order Fulfillment • Distribution Network and Warehouse Operations • Transportation and Shipment Management • Strategic Sourcing and Procument Goals (similar to ERP but more specific): • Increase Efficiency (Rapid Demand Fulfillment) • Decrease Inventory Costs (Just-in-time Inventory) • Improve Collaboration with Parters Unique system because it could integrate multiple enterprises.

14. Key Concepts- Role of IS’s • Competitive Advantage • Companies use IS’s to leverage advantages • Force competition to invest in IS’s or sink • Strategic Advantage • IS’s transform data into valuable information that help companies make better “big” decisions. • Misconcept: IS’s only help make “small” operational decisions.

15. Key Concepts- Role of IS’s • Business Improvement vs. Business Process Re-engineering • Better information lead to incremental continuous improvement in each functional area. This is why functional systems are still valuable. • Integrating system and information allows companies to completely re-engineer at the highest levels (BPR). This is why Enterprise systems are so valuable.

16. Key Concepts- Role of IS’s • Business/Enterprise Intelligence • In large businesses, no single person could process all the available information to make intelligent decisions. • IS’s all a large group of people to get the right information so that the company has a collective intelligence that is great than the sum of its parts. • Enterprise Agility • IS’s allow information to move faster from the operational level to the strategic level and vice versa enabling companies to move faster.