Excel Flowchart
Assignments: 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
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