Share
Explore BrainMass

Flowchart and Table of Entities

The Academic Departments send a list of Suggested Courses to the Faculty. The Academic Departments receive the list of Suggested Courses back from the Faculty with any comments. The Academic Departments hold a meeting to discuss the Suggested Courses and the latest Course Catalog received from the Registrar. The Academic Departments then prepare the Departmental Course Schedule and send it to the Registrar. The Academic Departments file the Suggested Courses lists and the Course Catalog in the Course Schedules file by date.

The Registrar reviews and approves the Departmental Course Schedules. The Registrar 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. The Registrar makes the course schedule available electronically to all students by using the Registration Program and updating the Course Schedule Transaction file. The Registrar stores the Departmental Course Schedules in the Departmental Course Schedules file by department then by date.

The Student reviews the course schedule online using the Registration Program and the Course Schedule Transaction file. The Student 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. While registering, the student gets an error message that they cannot register for the auditing course because they have not completed the accounting information systems course. The Student 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.

The Academic Advisor reviews the electronic registration permission requests using the Student Advising Program, Student Master file, Student Transcript Transaction file, and Registration Issues Transaction file. The Academic Advisor then reviews the university rules using the Course Catalog Program and the Course Catalog and University Regulations Master files. The Academic Advisor approves electronic registration permission requests in the Registration Program by updating both the Registration Issues and Registration Transaction files. The Student receives a Registration Approval letter from the Academic Advisor. The Student 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. The Student files the Registration Approval letter in their University Records file by date.

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.

Solution Summary

Table of entities and activities, and a flowchart for a course auditing process is attached in Excel.

$2.19