I need help with this homework. I will attach the assignment and 2 examples how to complete the homework.Thanks

INSTRUCTIONS:

Create one file in Excel with two worksheets (use a new, blank file).

Include your first and last name in the file name.

Name the first worksheet "Table" and create a Table of Entities and Activities.

Name the second worksheet "Flowchart" and create a Document Flowchart.

Fall 2016 SysDoc1 and SysDoc2 Assignment Data Conversion for ERP System NOTE: This is a simplified version of a process for the purpose of illustrating flowcharting techniques. NARRATIVE The Consultant sends a Proposal to the CEO. The CEO returns an Approved Proposal back to the Consultant. The Consultant prepares a Project Plan using the Microsoft Project Program which adds a new record to the Project Master file. The Database Administrator creates a project data environment using the ERP Program which retrieves data from the Database Master files and Database Transaction files. The Programmer downloads data from the current ERP system using the ERP Program, the Database Master files, and the Database Transaction files. The Programmer then massages the data to conform to the new ERP system using the Data Utilities Program which updates the Database Master files and the Database Transaction files. The Programmer prints two copies of the Data Exception Report using the ERP Program and Data Exception Transaction file. Copy 2 of the Data Exception Report is sent to the Consultant. After reviewing the Data Exception Report, the Consultant corrects the data errors using the ERP Program which updates the Database Transaction and Data Exception Transaction files. The Consultant then prints fours copies of the Data Status Report using the ERP Program and Database Transaction files. Copy 2 of the Data Status Report is sent to the CFO, Copy 3 is sent to the Database Administrator, and Copy 4 is sent to the Programmer. The Programmer files the Data Status Report and Data Exception Report in the Projects Completed file cabinet by client name then by date. The Database Administrator moves the project data to the production environment using the ERP Program which adds new records to the Database Master and Database Transaction files. The Database Administrator prints three copies of the Project Status Report using the ERP Program, Database Master, and Database Transaction files. Copy 2 of the Project Status Report is sent to the CFO and Copy 3 is sent to the CIO. Finally, the Database Administrator files the Data Status Report and Project Status Report in the Data Projects file cabinet by project number. After approving the Project Status Report, the CFO makes two photocopies of the approved report. The first Photocopied Project Status Report is sent to the CIO, and the second copy is sent to the Consultant. Finally, the CFO files the Data Status Report and Project Status Report in the Projects Approved file by date. The Consultant files the Approved Proposal, Project Plan, Data Exception Report, Data Status, and Project Status documents in the Completed Projects file cabinet by client name then by date. INSTRUCTIONS: Create one file in Excel with two worksheets (use a new, blank file). Include your first and last name in the file name. Name the first worksheet \"Table\" and create a Table of Entities and Activities. Name the second worksheet \"Flowchart\" and create a Document Flowchart. ACADEMIC INTEGRITY: This is not a group project. Do not show your SysDoc files to any other student. Students who turn in another student's file or a portion of another student's file, and students who share their file with any other student, may receive a zero on the assignment. Additional penalties for turning in another student's work as though it was your own, or for sharing your work with others, may include a grade of \"F\" in the course that cannot be removed by any forgiveness policy or by dropping the course, a notation on the student's transcript stating that the student violated the Code of Academic Integrity, and expulsion from the University or the School of Accounting. Please see the Academic Integrity sections of the syllabus for more information on this process. Page 1 of 1 Entities Academic Departments 1 2 3 4 5 6 7 Activities Sends a list of Suggested Courses to the Faculty Receives the list of Suggested Courses back from the Faculty with any comments Receives the latest Course Catalog from the Registrar Holds a meeting to discuss the Suggested Courses and the Course Catalog Prepares the Departmental Course Schedule Sends the Departmental Course Schedule to the Registrar Files the Suggested Courses lists and the Course Catalog in the Course Schedules file by date Registrar 1 2 3 4 5 6 Sends the latest Course Catalog to each Academic Department Receives the Departmental Course Schedule from each Academic Department Reviews and approves the Departmental Course Schedules Enters the course schedule information into the online registration system using the Registration Program which accesses the Course Catalog Master file and updates the Course Schedule Transaction file Makes the course schedule available electronically to all students by using the Registration Program and updating the Course Schedule Transaction file Stores the Departmental Course Schedules in the Departmental Course Schedules file by department then by date Student 1 2 3 4 5 6 7 Reviews the course schedule online using the Registration Program and the Course Schedule Transaction file Registers for the courses online using the Registration Program which accesses the Student Master file and enters data into the Registration Transaction file and the Student Transcript Transaction file Gets an error message that they cannot register for the auditing course because they have not completed the accounting information systems course Sends an electronic request for permission to register for the auditing course using the Registration Program and the Student Master file while adding the request to the Registration Issues Transaction file Receives a Registration Approval letter from the Academic Advisor Registers for the auditing course online using the Registration Program which accesses the Student Master file and updates the Registration Transaction and Student Transcript Transaction files Files the Registration Approval letter in their University Records file by date Academic Advisor 1 2 3 4 Reviews the electronic registration permission requests using the Student Advising Program, Student Master file, Student Transcript Transaction file, and Registration Issues Transaction file Reviews the university rules using the Course Catalog Program and the Course Catalog and University Regulations Master files Approves electronic registration permission requests in the Registration Program by updating both the Registration Issues and Registration Transaction files Sends a Registration Approval letter to the Student Academic Departments Registrar Course Catalog Suggested Courses Student Departmental Course Schedule Suggested Courses with Comments A Error Message: Cannot register for auditing course Departmental Course Schedule Holds a meeting to discuss the Suggested Courses and Course Catalog Course Catalog Master Enter course schedule information Registration Program Suggested Courses with Comments Course Catalog Make course schedule available to students Registration Program Departmental Course Schedule Send electronic request for permission to register for auditing course Registration Issues Transaction Approve electronic registration permission requests Student Master C Registration Program Registration Transaction Student Transcript Transaction D Course Catalog Program Registration Approval University Records D Course Catalog Master University Regulations Master Registration Approval B Course Schedules Review university rules C Register for auditing course online Student Transcription Transaction Registration Issues Transaction Registration Program Course Schedule Transaction Course Schedule Transaction Student Advising Program Student Master Departmental Course Schedules A/D Course Catalog + Review electronic registration permission requests Registration Transaction Student Transcript Transaction Registration Approval Prepare Departmental Course Schedule Suggested Courses with Comments Registration Program Register for courses online Student Master Course Schedule Transaction Student Master Review and Approve Departmental Course Schedules Course Catalog Departmental Course Schedule Registration Program Review course schedule online A Faculty Academic Advisor B Registration Program Registration Issues Transaction Registration Transaction