Torrens University (TU) currently uses a paper-based manual process for managing applications for special consideration (SC),...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Torrens University (TU) currently uses a paper-based manual process for managing applications for special consideration (SC), the process for students to request special consideration of an assessment deadline, or arrangement of alternative assessments. The university is planning to automate the process, and as a database designer, you are going to design the back-end database for the system. The current process is detailed below: To apply for special consideration (SC) of an assessment, students download the special consideration form from the TU Website and then fill out the sections allocated for the student, which are then sent to the Learning Facilitator (LF) along with the supporting documents via email. There are 6 sections allocated for the student, they are: • Section 1: Personal details • • Section 2: Modified assessment arrangement requested Section 3: Reason for application • Section 4: Supporting documentation • Section 5: Assessment or examination affected Section 6: Declaration Sections 2 and 4 have a number of options for the students to tick depending on their circumstances. Likewise, there is also a section that is required to be filled by the LF, and alternatively in some cases to be filled by the Program Director. To get a good understanding of the data requirements, please check the SC form currently used by the university: https://www.torrens.edu.au/policies-forms. However, you should note that the form is not a full reflection of the data requirements of the new system the university is planning to implement. SC form acceptance works by the following process: when the LF receives the SC form, they are responsible for checking the form for completeness and deciding if the student is eligible for an SC. If the student is eligible for SC, the LF approves the form by filling in the details allocated to the LF, which includes the new submission date with signature. If declined, the LF would add reasons. The form is then sent to the Academic Services Officer (ASO) team who is dedicated to processing these applications in a timely manner. They work on different campuses, and there is at least one dedicated ASO for each campus. Final processing of the form, which includes checking the form for completeness and supporting documents is carried out by the ASO, who then notifies the outcome to the student and LF via email. Finally, a request is sent to the Blackboard (BB) team to adjust the due date of the assignment accordingly in BB for that student. Typically, the form is processed on the same day, and the student is informed of the outcome within 1-2 days if all the supporting documents are available. The LF is responsible for ensuring that the application is complete with supporting documents before sending them to the ASO team. If not, the ASOS would not be able to process the application. Forms with extension periods longer than 10 days would require the Program Director's (PD)/Course Coordinator's approval in addition to the LF's approval. The data in the forms are recorded in an Excel spreadsheet shared on a network drive. When the new system is designed, the university also wishes to make the application process more flexible to allow multiple SC requests to be submitted at the same t in one form, instead of the current process where the student is required to fill out separate applications for each subject. Likewise, students can also apply for SC for multiple assignments of the same subject in a single application. For example, in some circumstances, a student may want to apply for an SC for all the assessments of one or more subjects. To implement this new feature, instead of one authorized person (LFs/PD) approving the application, one or more approvers may require approving the requests. For example, if the student applied for SC for assignments of two different subjects, then each request would be approved by the relevant LF delivering that subject. The SC approval process is one of the processes that get periodically audited by the quality assurance. team. At any time, the team could request to provide reports of the SC approval process. The reports include, but is not limited to, the following statistics: • • The number of applications received each semester, by course and vertical. The total number of applications that do not conform to the SC policy, and the LF who approved them. The number of SC forms approved come after a particular assessment due date. The total number of students by gender, campus, and mode (F2F/online). The total number of forms rejected, and likewise, the total number accepted. The average number of days taken to process the form. Torrens University (TU) currently uses a paper-based manual process for managing applications for special consideration (SC), the process for students to request special consideration of an assessment deadline, or arrangement of alternative assessments. The university is planning to automate the process, and as a database designer, you are going to design the back-end database for the system. The current process is detailed below: To apply for special consideration (SC) of an assessment, students download the special consideration form from the TU Website and then fill out the sections allocated for the student, which are then sent to the Learning Facilitator (LF) along with the supporting documents via email. There are 6 sections allocated for the student, they are: • Section 1: Personal details • • Section 2: Modified assessment arrangement requested Section 3: Reason for application • Section 4: Supporting documentation • Section 5: Assessment or examination affected Section 6: Declaration Sections 2 and 4 have a number of options for the students to tick depending on their circumstances. Likewise, there is also a section that is required to be filled by the LF, and alternatively in some cases to be filled by the Program Director. To get a good understanding of the data requirements, please check the SC form currently used by the university: https://www.torrens.edu.au/policies-forms. However, you should note that the form is not a full reflection of the data requirements of the new system the university is planning to implement. SC form acceptance works by the following process: when the LF receives the SC form, they are responsible for checking the form for completeness and deciding if the student is eligible for an SC. If the student is eligible for SC, the LF approves the form by filling in the details allocated to the LF, which includes the new submission date with signature. If declined, the LF would add reasons. The form is then sent to the Academic Services Officer (ASO) team who is dedicated to processing these applications in a timely manner. They work on different campuses, and there is at least one dedicated ASO for each campus. Final processing of the form, which includes checking the form for completeness and supporting documents is carried out by the ASO, who then notifies the outcome to the student and LF via email. Finally, a request is sent to the Blackboard (BB) team to adjust the due date of the assignment accordingly in BB for that student. Typically, the form is processed on the same day, and the student is informed of the outcome within 1-2 days if all the supporting documents are available. The LF is responsible for ensuring that the application is complete with supporting documents before sending them to the ASO team. If not, the ASOS would not be able to process the application. Forms with extension periods longer than 10 days would require the Program Director's (PD)/Course Coordinator's approval in addition to the LF's approval. The data in the forms are recorded in an Excel spreadsheet shared on a network drive. When the new system is designed, the university also wishes to make the application process more flexible to allow multiple SC requests to be submitted at the same t in one form, instead of the current process where the student is required to fill out separate applications for each subject. Likewise, students can also apply for SC for multiple assignments of the same subject in a single application. For example, in some circumstances, a student may want to apply for an SC for all the assessments of one or more subjects. To implement this new feature, instead of one authorized person (LFs/PD) approving the application, one or more approvers may require approving the requests. For example, if the student applied for SC for assignments of two different subjects, then each request would be approved by the relevant LF delivering that subject. The SC approval process is one of the processes that get periodically audited by the quality assurance. team. At any time, the team could request to provide reports of the SC approval process. The reports include, but is not limited to, the following statistics: • • The number of applications received each semester, by course and vertical. The total number of applications that do not conform to the SC policy, and the LF who approved them. The number of SC forms approved come after a particular assessment due date. The total number of students by gender, campus, and mode (F2F/online). The total number of forms rejected, and likewise, the total number accepted. The average number of days taken to process the form.
Expert Answer:
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
1. Consider the linear system Ax = b (all integer values) with the notation shown below, 1 -3 -1 -2 - H 5 7 - 2261x11 X2 -4 3 9 16x3 615 LX4- = A X b The element a24 = a has been lost. Assume,...
-
Write the use case description for the QUERY TRAINING CLASSES use case. Use the use case diagram to define the header information. The steps involve entering information on the Web form, validating...
-
Koehler (see Exercise E19-15 and Exercise E19-16) makes handheld calculators in two modelsbasic and professionaland wants to further refine its costing system by allocating overhead using...
-
Mackay Industries sales for the year ended December 31, 2010, were \($1,287,000\) and cost of goods sold amounted to \($707,000.\) Beginning inventory was \($58,000\) and ending inventory was...
-
A machine shop has two machines, A and B. Four jobs need to be processed through machine A first and B second. Job 1 will take one hour on machine A and three hours on machine B. Job 2 will take...
-
Anania is an apprentice with H&M Constructions and has been working under the supervision of Mari, the Principal Contractor, for about four weeks on a construction project for Muhammad Ali's first...
-
Redwood Inc, which owned a parcel of land that contained dense forests, entered into a contract with Bunyon Corp. Bunyon was required to cut and remove the trees from a 40-hectare area. In exchange,...
-
Suppose the labour force of an economy is equal to 1,000 and the unemployment on December 2010 is 0. Then, suppose that in January 2011 and every month that follows, 66 workers become unemployed for...
-
The motor of your "dune buggy" is fueled by a gas line with a radius of4.2010 -3 mand the fuel pump is rated at 7.2510 -2 kg/s.If the density of the gas you are using is730 kg/m 3 ,determine the...
-
Fogerty Company makes two products-titanium Hubs and Sprockets. Data regarding the two products follow: Direct Labor-Hours per Hubs Sprockets Unit 0.50 0.10 Annual Production 22,000 units 50,000...
-
A computer disk drive with a radius of 0.065 m starts rotating from rest with a constant angular acceleration. It takes 2 minutes and 50 seconds to complete ten revolutions. How long does it take to...
-
Assume an hypothetical firm of your choice and describe the four (4) perspectives of the balanced scorecard that the firm may put in use. (11 Marks) b) Explain how waste/spoilage/defective units...
-
A Company reports the following contribution margin income statement for this year. Contribution Margin Income Statement For Year Ended December 31 Sales (10,200 units at $36 each) Variable costs...
-
Which of the following is NOT an available firewall type? O Domain Level Firewall O Stateful Inspection Firewall O Application Level Gateway Firewall O Packet Filtering Firewall
-
The National Collegiate Athletic Association (NCAA) and the National Federation of State High School Associations (NFHS) set a new standard for non-wood baseball bats. Their goal was to ensure that...
-
Holcomb Candles, Inc., manufactures decorative candles and has contracted with a national retailer to supply a set of special holiday candles to its 8,500 stores. These include large jars, small...
-
A supermarket has been experiencing long lines during peak periods of the day. The problem is notice-ably worse on certain days of the week, and the peak periods sometimes differ according to the day...
-
The Excel file Unions and Labor Law Data reports the percent of public and private sector employees in unions in 1982 for each state, along with indicators whether the states had a bargaining law...
-
Following is a probability density curve with the area between 0 and 1 and the area between 1 and 2 indicated. a. What proportion of the population is between 0 and 1? b. What is the probability that...
-
Use Table A.2 to find the area between z = 1.13 and z = 2.02. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 -0.8 -0.7 .2119 .2090 .2420 2389 -0.6 .2743 .2709 .2676 .2061 .2033 2358 .2327 .2643...
-
Use Table A.2 to find the area to the left of z = 0.25. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 -0.8 -0.7 .2119 .2090 .2420 2389 -0.6 .2743 .2709 .2676 .2061 .2033 2358 .2327 .2643 .2005...
Study smarter with the SolutionInn App