Tutorial Revision Multiple Choice Test V6 copy.docx

Instructions ============ ***Students are NOT to google to search for answers. The tests are closed Book, and this would defeat the purpose of the revision.*** ***Students to go through the notes for each topic and then answer each section without looking at the notes.*** ***Tutor will check your...

Instructions ============ ***Students are NOT to google to search for answers. The tests are closed Book, and this would defeat the purpose of the revision.*** ***Students to go through the notes for each topic and then answer each section without looking at the notes.*** ***Tutor will check your individual answers.\ If necessary, tutor will walkthrough after this.*** A. **Decision Making** i. Describe clearly the difference between structured and semi-structured and unstructured decisions. ii. What is the relationship between a TPS and DSS? TPS- transaction processing system is used to process day to day business transaction. All the data are stored in a TPS. DSS takes all the data in the TPS and analyses it to generate analytical reports which is dues by management to make decision. B. **Data and Business Intelligence** i. Contrast Data, Information, Knowledge and Business Intelligence ii. What are the characteristics of Information Integrity? The quality of the information- Accuracy, relevance, timeliness (up to date), consistent, completeness, unique iii. Contrast Database, Data Warehouse, Data Mart and Data mining Contrast database- is collection of data for specific area. Eg sales database would have customer table, product table and sales order table. Data warehouse is a consolidation of all internal and external data. Data mart is a subset of a data warehouse. Data mining- is the process of finding patterns and trends in data (BI) by analyzing the data warehouse of data mart. iv. What is Big Data and what role does it play in businesses today? v. Describe the 5 data mining techniques vi. What are the challenges of data mining? Data from cloud maybe inconsistent format Some data are not accurate Privacy infringement- legal, people do not like their personal information used Complex data that needs to be mined, it could be corrupted vii. What is data analytics? C. **Business Functions & Business Process** i. Business functions- a description of the work carried out to meet a business goal Business process- a standardized set of activities to accomplish a task such as planning a timetable for workers ii. HR, marketing, sales, accounting and finance, operations, logistics D. **Connectivity** i. Contrast Sustaining & Disrupting Technologies with an example for each ii. WEB 2.0 technology allow collaboration: Explain this statement? E. **E business & M business** 1. Explain what is meant by Long Tail in business and how www has helped in marketing products at all the sections of the Long Tail? The long tail refers to those products which are at the end of the sales curve A product which is at the end of the sales curve in a market can be marketed to consumers from other markets using the www. The gives opportunities to produces of products which are in the end of the sales F. **MS Excel Questions** i. What is a spreadsheet? ii. What does VLOOKUP, SUM, IF, etc. do? Vlookup to look in a table a lookup value and find the associated value of that lookup value. SUM- used to a different cell in a worksheet IF- if executes a calculation based on whether it meets a condition. iii. What is the difference between relative and absolute cell addressing? iv. What do managers use MS Excel for? Managers use excel to help them make effective decisions Record data of their employee- employee ID v. Contrast MS Access and DBMS - Is used for data entry and analysis - Limited query capabilities- eg. If statement has a criteria. - We can apply a password on the spreadsheet - We can use it to capture all customer data, but all the data is visible to everyone. - Database management systems software is used to create and update, query and report on data - Can create complex queries as table can be linked - DBMS can be used for a TPS. Each TPS usually has user id and password and access level controls - Using roles, you can restrict the availability and visibility of data in the DBMS