Question

1. Create a detail report that will display all SCR courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in group footer. 2.

2. Create a switchboard design with control buttons that lead to students, instructors, courses, course schedules, and course rosters. Allow a user to add, update, or delete records in each area. Jesse wants to see storyboards that show the proposed screens.

3. Suggest data validation checks for data entry screens.

4. Create a source document for an SCR mail-in registration form. Also need a design for a Web-based course registration form.

Answer 1

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****

1. Create a detail report that will display all SCR courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in group footer.

2. Create a switchboard design with control buttons that lead to students, instructors, courses, course schedules, and course rosters. Allow a user to add, update, or delete records in each area. Jesse wants to see storyboards that show the proposed screens.

Same screen will be used for courses with fields as :

List of courses offered

Academic session:

For courses schedule:

Academic session:

Course name or number

For Class Roster:

Student ID:

Academic session:

Course number

Instructor name:

3. Suggest data validation checks for data entry screens.

Sequence check - This should be used for data that has to be entered in an established sequence otherwise an error can occur.

Existence check - This should be used for mandatory data items. A record will not save until a proper value has been entered.

Data type check - This should be used to ensure that the data is of the right required type; such as the numeric field must only contain numbers and alphabetic fields can only consist of characters A - Z.

Range check - This should be used to test and verify that the data falls between a specific minimum and maximum value.

Reasonableness check - This should be used if the value entered seems unusual. The system must then use this to verify the problem.

Validity check - This should be used when data items must have certain values.

Combination check - This should be used on two or more fields to ensure that they are compatible or reasonable.

Batch controls - This should be used for calculating. This checks for missing records and also checks for correct totals.

4. Create a source document for an SCR mail-in registration form. Also need a design for a Web-based course registration form.