Question

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

Answer 1

To create a drop-down list in Excel. we shall first open excel and save the same at location you want and name it.

Step : 1 :

• At first step enter the value of data diagram.
• we shall start entering the same from A1 Cell.
• 
  Home Insert Page Layout Formulas Data Review Vi Calibri 11 Α Α΄ * Cut E) Copy Paste Format Painter Clipboard B I U C3 Font Aligr fx start entering data from this cell с D А B 1 2 3 start entering data from this cell 4 5 6 7 8 9 10 11 12
  
• lets fill the whole data.....
• 
  Page Layout Calibri Home Insert * Cut Eg Copy Paste Format Painter Clipboard C7 B I U Font fx B А 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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
  

Step : 2 : creating list

• at next we will creat the list of shaps
• as instructed in the question list will be entered from cell A20
• so lets enter shape name from A20 cell...
• 
  de Home Insert Page Layout Calibri * Cut Eg Copy Paste Format Painter Clipboard B I U F G12 fx А B 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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 17 18 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines
  

Step : 3 : use of data validation tool to creat Drop-down list

• At first place your pointer at B2 Cell
• 
  20092020 Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator Calibri 11 Α Α΄ Wrap Text General * Cut Ea Copy Paste Format Painter Clipboard BIU Merge & Center % Font Alignment Num B1 fac B С D E F A 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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 17 18 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines
  
• now go to DATA TAB > DATA TOOLS > Data Validation > Data Validation...
• 
  20092020 - Microsoft Excel Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator connections 21 4 A ET TO HT RE ? Solver ) 13 show Detail Show Detail Hide Detail From Access From Web From From Other Text Sources Get External Data Existing Connections Properties Refresh All- G Edit Links Connections A Sort Clear Reapply Filter Y Advanced Sort & Filter ER Text to Remove Data Consolidate What If Group Ungroup Subtotal Columns Duplicates Validation Analysis Outline E Data Validation... & Circle Invalid Data Prevent invalid data from being Clear Validation Circl entered into a cell. Analysis B1 fic А. B C D E F N O F For example, you could reject invalid dates or numbers greater than 1000 You can also force input to be chosen from a dropdown list of values you specify. Press F1 for more help. Buy Supplies eClass Registration Employee Employee Database Employee Pay data Issue capital Stock - Pay Employee 3 Purchase Order Register for classes 0 Shareholder 1 Shareholder Database 2 Shareholder Information 3 Student 4 Student Database 5 Vendor 6 Vendor Database 7 8 9 0 Circle 1 Line 2 Rectangle 3 Set of Parallel Lines
  
• and selecting data validation following dialogue box will appear
• 
  20092020 - Microsoft Excel Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator * Clear From Access From Web From From Other Text Sources Existing Connections E Connections Properties Refresh All- Edit Links Connections At Sort Reapply Filter Y Advanced Sort & Filter Text to Remove Data Со Columns Duplicates Validation Data Tools Get External Data B1 B D E F G H I Data Validation ? X Error Alert А 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 5 Issue capital Stock 7 Pay Employee 3 Purchase Order Register for classes o Shareholder 1 Shareholder Database 2 Shareholder Information 3 Student 4 Student Database 5 Vendor 6 Vendor Database Settings Input Message Validation criteria Allow: Any value Data: between Ignore blank Apply these changes to all other cells with the same settings Clear All OK Cancel -7 -8 9 0 Circle -1 Line -2 Rectangle 3 Set of Parallel Lines -4
  
• in validation criteria set : Alllow as : List
• 
  20092020 - Microsoft Excel Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator * Clear From Access From Web From From Other Text Sources Get External Data Existing Connections Connections Properties Refresh G Edit Links Connections At Sort Reapply Filter Y Advanced Sort & Filter Text to Remove Data Con Columns Duplicates Validation Data Tools B1 B D E F G H Data Validation ? X Settings Input Message Error Alert Validation criteria Allow: List Ignore blank V In-cell dropdown Data: А 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 5 Issue capital Stock 7 Pay Employee 3 Purchase Order Register for classes o Shareholder 1 Shareholder Database 2 Shareholder Information 3 Student 4 Student Database 5 Vendor 6 Vendor Database between Source: Apply these changes to all other cells with the same settings Clear All OK Cancel -7 8 9 20 Circle 1 Line -2 Rectangle 3 Set of Parallel Lines
  
• now in source : give refrence to list of shapes we have entered .
• 
  20092020 - Microsoft Excel Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator 21 21 From Access From Web From From Other Text Sources Get External Data Existing Connections Connections Properties Refresh All Edit Links Connections At Sort Clear Reapply Filter Y Advanced Sort & Filter Text to Remove Data Columns Duplicates Validatio Data T A19 A B D E F G H ? X Data Validation =$A$19:$A$231 C 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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 17 18 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines 24
  
• 
  20092020 - Microsoft E Home Insert Page Layout Formulas Data Review View PDF Architect 6 Creator E Connections 2+ 2 A Properties Clear Reapply Advanced Refresh From Access Filter From Web at Sort Existing Connections From From Other Text Sources Get External Data Edit Links Text to Remove Columns Duplicate Connections Sort & Filter A19 B D E F Data Validation ? х Settings Input Message Error Alert Validation criteria Allow: List Ignore blank In-cell dropdown Data: A 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 8 Purchase Order 9 Register for classes LO Shareholder 11 Shareholder Database 12 Shareholder Information 13 Student 14 Student Database 15 Vendor 16 Vendor Database 17 between Source: =$A$19:$A$23 Apply these changes to all other cells with the same settings Clear All OK Cancel 18 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines 4
  
• and hit ok..
• drop-down menu is created in B2 Cell
• 
  = Home Insert Page Layout Formulas Data Conne From Access From Web From From Other Text Sources Get External Data Existing Connections Propel Refresh All G Edit Li Connections B1 foc B С Circle Line Rectangle Set of Parallel Lil A 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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 17 18 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines
  
• Select the appropreiate shape in B2 cell

Step : 4

• Drag Cell B2 till B16 to apply drop-down list in entire data
• 
  Home Insert Page Layout Formulas Data El Col From From Access Web From From Other Text Sources Get External Data Existing Connections Pro Refresh All So Edi Connecti B1 fox B C A 1 Buy Supplies 2 Class Registration 3 Employee 4 Employee Database 5 Employee Pay data 6 Issue capital Stock 7 Pay Employee 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 17 H. 18 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines 24
  
• choose appropriate shap....
• 
  Home Insert Page Layout Formulas Data El Co From From Access Web From From Other Text Sources Get External Data Existing Connections Pro Refresh All Sa Ed Connect B16 fx Circle A B 1 Buy Supplies Circle 2 Class Registration Line 3 Employee Circle 4 Employee Database Circle 5 Employee Pay data Line 6 Issue capital Stock Circle 7 Pay Employee Rectangle 8 Purchase Order Circle 9 Register for classes Rectangle 10 Shareholder Line 11 Shareholder Database Circle 12 Shareholder Information Circle 13 Student Set of Parallel Lines 14 Student Database Circle 15 Vendor Line 16 Vendor Database Circle 17 19 20 Circle 21 Line 22 Rectangle 23 Set of Parallel Lines
  

hence this is how drop-down list is create by data validation tool