The MIS 370 exam 2 will cover chapters 5, 6, and 7 of the Stair and Reynolds text, Excel ss2 and ss3 material and any additional material presented in class. Sources for some questions include the end-of-chapter Self-Assessment Test, Review Questions, and Discussion Questions from the text as well as the Quick Check within the Tutorials.

The exam will be CLOSED BOOK and CLOSED NOTES.

Calculators are NOT allowed.

The exam may consist of 50 multiple choice questions.

A Trans-Optic Answer sheet No. 4521 must be brought by the student

You will need a number 2 pencil to mark your answer sheet form.

Any material in the chapters or presented in the lectures is fair game.

For each chapter you should know all of the terms that are listed in bold type in the text and/or indicated as key terms in the margins throughout the chapter.

It is always a good idea to answer the review questions at the end of each chapter. In the past I have been know to include some of these questions on the exam.

Some specific things that you should know from the readings and lecture are given below (This is not an all inclusive list).

Chapter 5 – e- and m-Commerce and Enterprise Systems

What is B2B, B2C, and C2C?

What are various e-commerce applications?

Name and desribe the various software used in Web-based e-commerce

Describe TPS in general

Descrive the difference between Batch processing and OLTP

Describe TPS activities such as data collection, editing, correction, manipulation, storage, and document production

What is ERP?

What is common among ERP systems?

What are the advantages and disadvantages of ERP systems?

Chapter 6 – Information and DSS

What are the stages and phases in the problem solving process?

What are programmed versus non-programmed decisions?

What are optimization, satisficing, and heuristics?

What is MIS? What is its primary output?

What is GIS?

What is DSS? Who and why are they used? How are they different from TPS and MIS?

What is GSS? Why are they used? What are their key capabilities?

What is ESS? Who uses them and why?

Chapter 7 – KM and Special ISs

What is the difference among data, information, and knowledge?

Compare explicit versus tacit knowledge?

What is data mining?

What is AI? What are the sub-fields of AI?

What is an Expert System? What are IF-THEN rules?

What is Virtual Reality? What is immersive VR?

Excel

Know the Excel functions we have used in the assignments including: MIN(), MAX(), AVERAGE(), COUNT(), COUNTIF(), IF(), SUM(), etc. What is a Macro? Know some of the Visual Basic for Applications keywords, operators, and object properties including: If-Then-Else, &, MsgBox, Range().Value, etc. Also, be able to explain how variables are used in VBA.