In this article, you will get a complete and comprehensive guide about project work class 10 IT 402 for the session 2021-22. This year CBSE has specified that the project work should be done in OO base and the documentation should be prepared in OO Writer. So here, I will provide you with the complete solution for the same. Let’s start!
Topics Covered
OO Base Project Work Class 10 IT 402
According to information technology code 402 class 10 term wise syllabus, students need to submit project work for the practical assessment. This project work carries 10 marks in the practical assessment.
The important point given by cbse in the curriculum are as following:
- Any Interdisciplinary Real World Case Study to be taken.
- Summarized data reports of same can be presented in base.
- Input should be taken using forms and output should be done using reports using base.
- Documentation of the case study should be presented using writer.
So here I will provide you with one sample of the OO Base project that should be done for your practical assessment of CBSE IT 402. Here we go!
How to start with OO Base Project Work Class 10 IT 402?
In this section of OO Base Project Work Class 10 IT 402 I will guide you through how to start with the project work. So decide the topic on which you want to submit the project for real-world case study.
Here, I have taken a case study for the school to maintain the staff details in an organized way. I have selected 2 tables to do this project work.
- Departments
- Staff
Concepts used in OO Base Project Work Class 10 IT 402
To prepare a summarized report for the case study you need to use the following concepts of OO base for the OO Base Project Work Class 10 CBSE IT 402.
- Create Table
- Insert data
- Operations tables
- Queries
- Forms
- Reports
Project reports for OO Base Project Work Class 10 IT 402
My OO Base Project Work Class 10 CBSE IT 402 includes the following reports:
- All staff members and department details
- Deparment location wise
- Staff according to department
- Staff according to designation
- Staff according to type of appointment (regular/probation/ad-hoc etc.)
- Staff report on the level of seniority
- Staff report subject wise
So now let’s start with how to prepare these all reports using OO base for OO Base Project Work Class 10 IT 402.
Watch the video for understanding:
Creating tables for OO Base Project Work Class 10 IT 402
The OO Base Project Work Class 10 IT 402 starts with creating required tables. Here I have taken two tables for my project as mentioned earlier. You need to prepare the list of fields for both of the tables and determine their data types for data used in the table.
Observe the structure of the following table which I have used for my OO Base Project Work Class 10 IT 402.
Structure of tables
The departments’ table has 3 main fields as follows:
| Field | Data Type | Constraint | Description |
| Dep_ID | Integer (Auto) | Primary Key | Holds a unique id for each department |
| DepName | Text | Store department name | |
| DepLoation | Text | Store the location of the department like senior setion, middle section etc. |
Another table used in this OO Base Project Work Class 10 IT 402 is the staff. the structure of the staff table is as follows:
| Field | Data Type | Constraint | Description |
| Staff_ID | Integer(Auto) | Primary Key | Holds unique if for each staff member |
| StaffName | Text | Holds the staff member name | |
| DateofJoining | Date | Holds the date of joining | |
| Status | Text | Holds the status out of regular, probation, contractual etc. | |
| Subject | Text | Holds the subject taught by a teacher | |
| Qualification | Text | Holds qualification of teacher | |
| Department_ID | Integer | Holds department id of the staff |
Create tables for Project Work Class 10 IT 402
Create the required table in any of the modes in the OO base. If you don’t know how to create a table, click here. After creating a table insert the required records into that. After creating a table, create forms for entry purposes.
Create forms and report for Project Work Class 10 IT 402
To insert new records or edit existing records forms are created. These forms contain fields required for the table. If you don’t know how to create the form, click here.
After creating forms create reports as discussed earlier for the Project Work Class 10 IT 402. If you don’t know how to create reports, click here.
Download the project file in OO writer.
I hope it will help you to create Project Work Class 10 IT 402.
