Database

Question 10 - An instructor has been keeping all his grade books in Excel for years. He has a separate spreadsheet for every course. In the spreadsheet, he tracks the scores for every assignment and test and then assigns term grades based on the overall averages. Whenever a former student contacts him requesting a letter of recommendation or whenever the administration requests information concerning a student in a previous term, he has to open and search several spreadsheets to get the student's information.

1. What are some of the advantages a database would have over the current system for this instructor?

The advantages that a database would give to him would be that it would allow him easier access to a student's info because you would not have to search through all the spreadsheets.

2. What would be some of the major topics for the database?

I think some of the major topics for his database should be: Students Name, Classes, and Year/Years they attended

3. Write a statement of work for the preceding database.

A database needs to be created to help keep track easier access to the instructor's records. It needs to have all the students listed according to the year they attend, what courses they took, and the grades they received. We need to be able to bring up records by way of a person's name, year attended, and/or courses they took.

Question 4 - Create a questionnaire for the users of the form in Practice 2 with 4 or 5 questions. Your goal should be to understand how and when they use the form.

1. When do you fill out the report form?

a. Every time you install a new computer.

b. When helping fix a problem computer.

c. For any type of job you do.

2. Who is required to complete the report form?

a. The Technician that does the work.

b. Office worker that files paperwork.

c. The assistant that assists in technical jobs.

3. How do you go about completing the form?

a. A hard copy that has to be filled out by hand at the job site.

b. Completed on computer after job is complete and you are back in the office.

c. You do not complete the form someone else does.

4. What is the purpose of the form?

a. To let the client know what is going on.

b. To keep accurate records of clients/technical