USA: +1(669)289-8683 
Sign in
just question and answer, to ans question 2, 5, 6, 7, 8, 10, and its sub units and exclude question 1, 3, 4, and 9 , but if you can help out with some sub units of the excluded questions please do. no word count, just a brief and straight to the point ans and easy to understand
SampleExam Questions
NOTE: THE STYLE OF QUESTIONS APEARING IN YOUR EXAMINATION
WILL BE SIMILAR TO THOSE GIVEN BELOW. THIS, HOWEVER, DOES NOT IMPLY
THAT THESE QUESTIONS ARE IN THE EXAMINATION.
1. Introduction to AIS
1.1 Define a management information system. (2)
1.2 Do you agree with the statement “Not every company needs an AIS system.”? Please explain. (2)
1.3 Why is it important for accounting students to gain knowledge about Accounting Information Systems? (2)
2. Enterprise Systems, Transaction Processing and Systems Documentation
2.1 Define enterprise resource planning (ERP) systems and give two examples of common ERP add-on modules. (3)
2.2 Describe five advantages of an enterprise system. (2.5)
i.
ii.
iii.
i
v.
v.
2.3 Lexington Company sells a broad range of fashion products to end users. The company is considering taking customer’s orders on their Web site. (6)
a) What information should Lexington collect from the customer during this process?
b) What information would need to come from Lexington’s system to complete the order?
3. System Documentation
3.1 Why should you develop both logical and physical DFDs for systems? What is the advantage of drawing a logical DFD before a physical DFD for a new information system? (4)
3.2 EspressoCoffee customers place an online order. EspressoCoffee processes the customer order by sending a request to the credit card company to verify the customer’s good credit standing. The items are verified for availability. The shipment is processed and sent to the warehouse. An invoice is generated from the sales information and emailed to the customers. The corresponding database tables are updated.
Draw the related logical level 0 DFD. (8)
4. General Ledger and Reporting System
4.1 “Defining the codes for a chart of accounts is no big deal –nothing is permanent –I can change it at any time in the future.” Why do you agree (or disagree) with this statement? (3)
4.2 Explain the functions of the general ledger and reporting system. (4)
5. Revenue cycle
5.1 Explain the logical sequence of data flows in the Sales Order Entry process (4)
5.2 Explain the purpose of a Customer Relationship Management system. (2)
6. Expenditure Cycle
6.1 Explain why ambiguities and conflicts exist among operations process goals of the purchase process. (4)
6.2 Explain two possible scenarios of fraudulent behaviour related to the Expenditure Cycle. (4)
7. Controls
7.1 If it were not for the potential of computer crime, the emphasis on controlling computer systems would decline significantly in importance. Do you agree? Discuss in detail. (2)
7.3 If input data are entered into the system completely and accurately, then the information system control goals of ensuring update completeness and of ensuring update accuracy will be automatically achieved. Discuss. (2)
7.4 In small companies with few employees, it is virtually impossible to implement the segregation of duties control plan. Do you agree or disagree with this statement? Discuss your answer. (2)
7.5 No matter how sophisticated a system of internal control is, its success ultimately requires that you place your trust in certain key personnel. Do you agree? Discuss in detail. (2)
5.1 Public Key Cryptography is an important facilitator of secure electronic commerce over the Internet. Describe, with the aid of a labelled diagram, how credit-card information is shared with an ecommerce vendor for payment of goods purchased over the Internet. (5)
Diagram (2)
Explanation (3)
8. SAP Concepts
(GL, AR, AP, Auditing)
8.1 Distinguish client, company code, chart of accounts and business area. (2)
8.2 What is the difference between a fiscal year variant and a posting period variant? How are they used? (2)
8.3 What are internal and external number ranges? Why is internal numbering preferred? (2)
8.4. Design a year-independent fiscal year variant for a business with quarterly reporting. The fiscal year runs from 16 May in year 0 to 15 May in year 1. (4)
9. Database Theory and SQL
9.1 A University uses a relational database. The ‘Course Table’ contains information about all courses the University provides, including the assigned convenor. The ‘Course Schedule Table’ lists the course timetable and the allocated lecture theatre. The ‘Theatre Table’ has information on theatre capacity (venue size) etc.
[Sample table data would be provided]
The University is planning to use the following SQL statements to query the tables mentioned above. What would be the expected outcome of the statement?
SELECT CourseName, Convenor, Venue
FROM [Course Table], [Course Schedule]
WHERE [Course Table].Course = [Course Schedule].Course ;
a. Enter your answer in the blank table. (2)
b. Write a SQL statement that lists the Course Number, CourseName, Convenor and Venue Size. The venue sizes should appear in ascending order. (2)
9.2 Given the following relations
Master (ProdNo, Location, Description, UnitCost, QOH, Reorder, Book, DeptID)
Dept (DepartmentID, DepartmentName)
Write a SQL Query to display all Department Names for all Products in MASTER
9.3 Why is normalization important for relational databases? Provide three arguments. (3)
i.
ii.
iii.
10. AIS Acquisition and Implementation
10.1 What is a Gantt chart and how can it support the implementation of an AIS? (2)
10.2 A vendor would never propose a system that would not meet an organiization’s needs. Therefore, external validation of vendor proposals is not really needed. Do you agree? Justify your answer. (2)
10.3 Explain the concept of a ‘direct conversion’ strategy. What are the risks of such an approach? (2)
10.4 List and describe four ways that an accountant may be involved in the AIS acquisition process? (4s)
|
ADDITIONAL REVIEW MATERIAL 1 Answer ALL SAP Self Study Questions |
