- Information
- AI Chat
IT 402 Class 10 Practical File Questions
Computetr science
Preview text
Information Technology (402) - Class X
Practical Records File
Session 2022-
S Practical Activity Marks
1
Practical Examination - Writer Question – 5 - Spreadsheet Questions – 5 - Database – 10
20
2 Project work in OO Base 10 3 Practical File 10 4 Viva Voce 10 Total 50
OO Writer problems for IT 402 Practical file
The practical concepts included for OO writer problems are as following:
- Create and apply styles in the digital document
- Insert and use images in the digital document
- Create and Use templates
- Create and customize the table of contents
- Implement the mail merge
Create and apply styles in the digital document
[1] Type a paragraph with at least 100 words and create below given styles as instructed:
- Headings : Font name: Font name: Times New Roman, Size: 24 , Color: Red. Give the style name: DreamHeading (Use create style from selection command to create style)
- Paragraph: Apply Style Text Body from the Style Gallary
- Quote: Font Name:Broadway, Size:16, Colour: Blue, Alignment: Center. Give the style name: DreamQuot
More questions on Create and apply styles
Insert and use images in the digital document
[2] Prepare a document in OO writer and do the following:
- Create a new document in OO Writer and Type a paragraph.
- Insert a picture of your choice.
- Adjust the picture at top left to the paragraph.
- Insert some shapes and write additional text into the shapes.
The output should be something like this.
More questions Insert and Use Images
Create and Use Template
[3] Create a document in OO writer and do as directed below:
- Prepare a template for the leave application writing format. Apply formatting as required.
- Set this template as a default template.
- Change the default template to custom template. Change the formatting as you wish.
Analyse data using scenarios and goal seek
[1] Prepare worksheet as given below and do as directed:
- Create a new file in spreadsheet software and enter data for 10 salesmen.
- Add two worksheets in the file and modify the data for all 3 quarters.
- Rename all worksheets like sheet1 - 2018, sheet2 - 2019 and sheet3 -
- Now add one more worksheet at the end and rename as consolidated sheet.
- Now type the serial no and names as displayed, use sum function to add data for 2018, 2019 and 2020 in respective cells using consolidation.
[2] Prepare a worksheet as :
Creating Subtotals
Link data and Spreadsheet
- Create a new file in spreadsheet software.
- Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth, Father Name, Mother Name.
- Enter records for at least 15 students.
- Rename this worksheet as "Student Profile".
- Insert 3 new worksheets and rename as " Periodic Test I ", " Periodic Test II " and " Periodic Test III " respectively.
- In the Periodic Test I worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the keyboard.
- In the Periodic Test II worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the mouse.
- In the Periodic Test III worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile as you wish.
- Apply sheet tab color as follows: o Profile - Red o Periodic Test I - Green o Periodic Test II - Blue o Periodic Test III - Yellow
- Now enter the marks for different subjects in the worksheets.
- Delete the Worksheet Perdioc Text III.
OO Base problems for IT 402 Practical file
The practical concepts are as following: 1. Create and Edit tables using wizard and SQL commands 2. Perform operations on Table 3. Retrieve Data using query 4. Create forms and reports using wizard
Create Table
Instructions: 1. Create table 1,2,3 using design view. 2. Insert records using datasheet view. 3. Create table 4 and 5 using SQL command. 4. Insert records using SQL command. Attach the screenshot of each and every command along with output screens. Attach the outputs and datasheet separately for each question. Write steps wherever applicable. Create following tables in OO base for Database Management System 10. [1] Students
Field Name Data Type Size RollNo Integer 3 Name Text 15 Gender Text 6 City Text 20 DOB Date 8 Blood_Group Text 5 Remark Text 10
Assign RollNo as primary key.
[2] Employee Table
Field Name Data Type Size Constraint EmpNo Integer 5 Primary Key EmpName Text 15 Designation Text 10 Address Text 50 City Text 10 MobileNo Text 10 Salary Decimal 9, Gender Text 6
[3] PhoneDiary
Field Name Data Type Size Cust_ID int 5 CName Text 15 CustomerAddress Text 20 City Text 10 PhoneNo_Res Text 10 PhoneNo_Off Text 10 MobileNo Text 10 Email_Id Text 20
Primary Key - Cust_ID
Queries
In the Marksheet table Add these Fields: (Total: Datatype- Number 3 digits, Percentage: Datatype - Number 3 digits with 2 decimal places, Grade: Datatype- Char with 2 letters)
Insert more 3 records in MARKSHEET using SQL mode.
Update the values for newly added columns i. Total, Percentage, Grade table using UPDATE command. (Grades should be A1 to E2 as per CBSE exam pattern)
Display all records of the marksheet table, write SQL command.
Display name, rollno, marks of 3 subjects, total and percentage using design view.
Write SQL command to display name, rollno, grades from the marksheet table.
Display the maximum and minimum marks for Sub101 using design.
Display the sum of marks for Sub102 using SQL command.
Display the rollno, student name and percentage whose name starts with A using SQL command.
Display the rollno, student name and percentage whose name second letter is i using SQL command.
Display all the records from the marksheet table whose name ends with 'N' using SQL command.
Display the rollno, name and percentage whose percentage are more than 70.
Display the records who secured the grade A1 and A2.
Display all the record in ascending order of names using SQL view.
Display the rollno, name, and grades whose percentage are in between 70 to 100.
Display the rollno, name, sub101, sub102,sub103 with an increment of 5 marks in each subject.
Display all the students record who failed in sub102. (Marks less than 33)
Display all the students records who needs improvement in Sub103. (Marks less than 33 and Greater than 30)
Display all the records in descending order of percentage.
Delete the records from table who is failed in any of the subject. (You can use any mode)
Complete these queries and write SQL commands wherever applicable, write steps for design view queries wherever applicable.
Creating Forms
- Create forms by selecting all the fields for the tables - Students, Employee and Marksheet
- Add 3 new records into Students table using navigation toolbar.
- Change the label backgrounds and fonts formatting as per your choice.
- Search records by from form of students for the boys.
Write steps to complete these tasks. Attach the appropriate screenshots with that.
Creating Reports
Create report for the all the tables. Use your own choice of layouts. Save your reports with your title.
IT 402 Class 10 Practical File Questions
Subject: Computetr science
School: St. Xavier High School, Junagadh
- Discover more from:Computetr scienceSt. Xavier High School, Junagadh237 Documents
- More from:Computetr scienceSt. Xavier High School, Junagadh237 Documents
