Ict Access Presentation Module
Construct : S12 Database Development
Aspect : LA6.S12.1 Develop A Database
Instrument : Practical Session
Tasks to be completed.
1. Refer Appendix C for project details
2. Refer Table Of Construct for assessment details
3. Develop a database according to requirements in TOC
4. Complete Report Form
5. Submit Report Form and softcopy of database that has been developed.
SITUATION 3
The form teachers of your school are required to submit a report on the monthly test results of each student to the school administration. As an ICT student, you are asked to develop a Test Marks Information System (TMIS) to assist the teachers in recording the subject marks obtained by each student. TIMS should generate a report to show the subject marks, total marks and average marks of the students from each class.
In the system, you are required to:
a) create a database that consist of two tables, namely table STUDENT and table CLASS. The database should store student ID, name, class, form teacher and marks for each subject taken. b) enter at least four classes into the CLASS table. c) enter at least two students’ data for each class. d) create a query that links the two tables. The query should be able to calculate the total marks and average marks for each student automatically. e) create a form for each table in (a). The form must show the title given and descriptive labels. f) create a report based on the query in (d). The report must show the subject marks, total marks and average marks of the students from each class.
Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the softcopy of the information system to your teacher at the end of the assessment session.
OVERVIEW OF DATABASE FOR SITUATION 3:
The fundamental elements in this assessment are 2 Tables, 1 Query, 2 Forms, and 1 Report as shown below:
|Database Name:
Aspect : LA6.S12.1 Develop A Database
Instrument : Practical Session
Tasks to be completed.
1. Refer Appendix C for project details
2. Refer Table Of Construct for assessment details
3. Develop a database according to requirements in TOC
4. Complete Report Form
5. Submit Report Form and softcopy of database that has been developed.
SITUATION 3
The form teachers of your school are required to submit a report on the monthly test results of each student to the school administration. As an ICT student, you are asked to develop a Test Marks Information System (TMIS) to assist the teachers in recording the subject marks obtained by each student. TIMS should generate a report to show the subject marks, total marks and average marks of the students from each class.
In the system, you are required to:
a) create a database that consist of two tables, namely table STUDENT and table CLASS. The database should store student ID, name, class, form teacher and marks for each subject taken. b) enter at least four classes into the CLASS table. c) enter at least two students’ data for each class. d) create a query that links the two tables. The query should be able to calculate the total marks and average marks for each student automatically. e) create a form for each table in (a). The form must show the title given and descriptive labels. f) create a report based on the query in (d). The report must show the subject marks, total marks and average marks of the students from each class.
Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the softcopy of the information system to your teacher at the end of the assessment session.
OVERVIEW OF DATABASE FOR SITUATION 3:
The fundamental elements in this assessment are 2 Tables, 1 Query, 2 Forms, and 1 Report as shown below:
|Database Name: