I attached an assignment I have due by 7pm tonight. I failed to turn in SysDoc assignment #1, and this is SysDoc assignment #2. It says that assignment #2 builds from assignment #1. Any help would be greatly appreciated. I look forward to hearing back, hopefully before 7 pm!

SYSTEMS DOCUMENTATION ASSIGNMENT Customer Orders NARRATIVE - SysDoc #2 The salesperson receives a hardcopy customer order from the customer. The salesperson enters the customer order into the salesperson's mobile device using the Sales Order Program which retrieves information from the Customer Master file, enters data into the Sales Order Transaction file, and updates the information in the Customer Master file. The salesperson forwards the hardcopy of the customer order to the sales manager. The sales manager receives the hardcopy of the customer order from the salesperson. The sales manager views the salesperson's order entered into the Sales Order Program by retrieving data from the Customer Master File and the Sales Order Transaction file. The sales manager then manually compares the hardcopy of the customer order with the sales order on the computer screen and approves the hardcopy with a signature. The sales manager then files the signed hardcopy in the Approved Customer Orders file cabinet by customer number. The sales manager prints a picking ticket for each sales order by using the Sales Order Program and retrieving information from the Sales Order Transaction file. The sales manager sends the picking ticket to the warehouse clerk. The warehouse clerk receives the picking ticket from the sales manager. The warehouse clerk manually gathers the items listed on the picking ticket (NOTE: use the input/output parallelogram symbol to represent the items). The warehouse clerk enters the items picked into a mobile device using the Order Processing Program which retrieves information from the Customer Master file and the Sales Order Transaction file and enters data into the Orders Processed Transaction file. The warehouse clerk brings the picking ticket and items to the shipping clerk. The shipping clerk receives the picking ticket and items from the warehouse clerk. The shipping clerk enters the items received into a mobile device using the Shipping Program which retrieves information from the Customer Master file and the Sales Order Transaction file and enters data into the Shipments Transaction file. The shipping clerk files the picking ticket in the Completed Picking Tickets file by date. The shipping clerk prints a packing slip using the Shipping Program which retrieves data from the Customer Master file, Sales Order Transaction file, and Shipments Transaction file. The shipping clerk sends the packing slip and items to the customer. Instructions: Create one file in Excel with two worksheets (use a new, blank file). Create a Table of Entities and Activities on the first worksheet. Create a Document Flowchart on the second worksheet. This same file will be turned in for SysDoc #1 and SysDoc #2. SysDoc Assignment #2 builds from SysDoc Assignment #1. For SysDoc Assignment #1 - the Narrative represents the 1 st half of the process. For SysDoc Assignment #2 - the Narrative includes the 1 st and 2nd halves of the process. The grade for SysDoc #2 will include the Table and Flowchart from SysDoc #1. CAUTION: Flowchart styles can vary. Complete this assignment using the styles provided in class for this semester. Students who share their Table or Flowchart with another student will receive a zero on the assignment. Students who turn in another student's Table or Flowchart or a portion of another student's Table or Flowchart will receive a zero on the assignment. Page 1 of 1 Flowcharting with Microsoft Excel Finding the standard flowcharting symbols NOTE: The \"name\" of the symbol may be different in Excel, but just focus on the shape of the symbol Formatting Shapes Right-Click on symbol to edit such things as: - Symbol color (Fill) - Line Color - Line Style - Text Box Formatting Shapes Change to this option to make text fit neatly within a symbol Uncheck this option to give more flexibility with text fitting neatly Setting as Default Shape After Making Edits HELP !!!..........You can also use the Help feature within Excel, just click on the Question Mark near the top right Systems Documentatio n Tips ACG 4401 Some Flowcharting Rules Label processes with action verbs (enter, print, compare, etc.). List all entity, document, and file names the same way they are shown in the narrative (do not abbreviate) Do not label symbols with the name of the entity performing the process - their location within a column identifies the entity performing the process When showing a document moving from one entity to another (from one column to another), show the document in both columns. Do not use a manual processing symbol to show the sending or receiving of a document. Flowchart lines should flow from top-to-bottom and left-to-right, except for lines involving storage symbols. Flow lines should not cross each other. When using on-page connectors, start with the letter \"A\" and have only one match for \"A\" (two \"A\" connectors total). The next time you need an on-page connector, use the letter \"B\" then \"C\" etc. Table of Entities and Activities Find all the entities mentioned in the narrative Decide which entities will perform processing: they transform something, not just send/receive something - - If an entity processes, they get their own column If they do not process, they get a terminal symbol Include as entites in the Table ONLY those that perform processing (they will get a column in the flowchart) Next to each processing entity, list each separate activity they perform as described in the narrative (include any documents or files used when the activity is performed) SAMPLE: Table of Entities and Activities Include only the entities that perform processing (will get a column in the flowchart) Begin each activity with capitalized action verb Numbering for each entity starts with "1" List all entity, document, and file names the same way as they appear in the narrative (no abbreviations) Send/Receive Documents SEND RECEIVE To entity with NO column in flowchart From entity with NO column in flowchart To entity WITH column in flowchart From entity WITH column in flowchart Filing Documents Into File Cabinet Out of File Cabinet (storage symbols are best (storage symbols are best NOTE: There is no manual process symbol used when filingthe side) shown off to documents. shown off to the side) Approved Customer Orders N Include inside the file cabinet: Name of file cabinet How filed A = alpha D = date N = number Manual Process 3 steps Input(s) Processing (describe the activity) Output(s) 3 steps Computer Process 3 steps Input (Command) Print Sales Order Processing Storage (Computer Program) (Computer File(s)) Sales Order Program Sales Order Transactio n File There may be more than one file used in each computer process. See the next slide. Computer Files When more than one computer file is used for a process: Use a separate symbol for each computer file Update data (FROM and Do not draw flow lines from computer file symbols previously TO) Customer used Master File Be sure to use the correct flow Order between the processing Sales lines Enter Sales symbol Enter data TO file Program Order (computer program) and the storage symbol (computer file) Sales Show line vertically to next step Line from online keying symbol to computer processing symbol is always left to right Print Sales Order Sales Order Program Order Transactio n File Retrieve data FROM file Sales Order Transactio n File