Accounting Information Systems Chapter 7 Problem 12

a data flow diagram should be labeled with verb phrases to show the movement would lead to numbers like 2.1, 2.2, and so on. of data. 12. Excel application. In this problem, you'll be creating a drop-down list in Excel. a. Consider the following list of items you might find in a data flow diagram: 1 Buy supplies 2 Class registration 3 Employee 4 Employee database 5 Employee pay data 6 Issue capital stock 7 Pay employees 8 Purchase order 9 Register for classes 10 Shareholder 11 Shareholder database 12 Shareholder information 13 Student 14 Student database 15 Vendor 16 Vendor database Starting in Cell A1, enter the list of items in the first tab of a blank Excel spreadsheet. b. Consider this list of shapes found in a data flow diagram: 20 Circle 21 Line 22 Rectangle 23 Set of parallel lines Starting in Cell A20, enter the list of shapes in the same tab of the Excel spreadsheet. c. In Cell B1, use Excel's Data Validation tool to create a drop-down list of the four shapes. Copy the drop-down list for the remaining items from (a). d. Use the drop down list to indicate which symbol you would use to depict the indicated item in a data flow diagram. The first row should look like this: 1 buy supplies B rectangle