Edit this essay
only $12.90/page

Excel Flowchart Essay Sample

Excel Flowchart Pages
Pages: Word count: Rewriting Possibility: % ()

1. INDIVIDUALLY, prepare an Excel flowchart for the narrative posted on D2L. Submit your Excel file of your flowchart before the deadline posted on the D2L drop box. Identify the appropriate individuals, departments, or computer processing involved within the business process. Label the columns with these items. Identify the steps, procedures, and documents used in the process. Use the appropriate symbols to depict who does the steps and procedures, how documents originate, how you record the data, and what happens to the documents. Also, indicate any reports distributed. (5 points)

2. During class, you will form groups of 2-3 students and compare your individual flowcharts. You must submit you individual flowchart before the start of class so you can work within a group. Within your group, decide how to best depict the business process within a flowchart. Prepare a “group” flowchart and submit the Excel file to D2L. The due date for this assignment is posted on the D2L drop box. (15 points)

3. Prepare a control matrix using the form posted on D2L. This form will identify operating goals appropriate for the business process. Submit your individual control matrix before the deadline posted on the D2L drop box. (5 points)

4. During class, you will form groups of 2-3 students and compare your individual control matrix. You must submit you individual matrix by the deadline before you can work within a group. Within your group, decide how to best depict the analysis of internal controls within a control matrix. Also, your group will annotate your flowchart. Submit the control matrix and your group’s annotated flowchart to the D2L drop box. The due date for this assignment is posted on the D2L drop box. (10 points for control matrix and annotated flowchart)

5. INDIVIDUALLY, prepare a data flow diagram (DFD) within Excel for the same narrative posted on D2L. Submit your DFD before the deadline posted on the D2L drop box. Use the appropriate symbols to depict the business process. (5 points)

6. During class, you will form groups of 2-3 students and compare your individual DFD. You must submit you individual DFD by the deadline before you can work within a group. Prepare a “group” DFD and submit one copy of the Excel file to D2L. (15 points)

7. INDIVIDUALLY, prepare a REA diagram within Excel for the same narrative posted on D2L. Submit your REA diagram before the deadline posted on the D2L drop box. Use the appropriate symbols to depict the events, resources, and agents within the business process posted on D2L. Think about the data required within the tables used for the resources, events, and agents. Remember that the main objective of REA diagramming depicts the tables and data accumulated within each table. Indicate that you have considered the needed data but you may not capture all required data. Keep it simple in designing a potential database! (5 points)

8. During class, you will form groups of 2-3 students and compare your individual REA diagrams. You must submit you individual REA diagram by the deadline before you can work within a group. Prepare a “group” REA diagram and submit one copy of the Excel file to D2L. (10 points)

Search For The related topics

  • diagram