IT 402 Class 10.
The structure of practical assessment as follows:
S.No Practical Activity Marks
Practical Examination Writer Question –
1 20
5Spreadsheet Questions – 5Database – 10
2 Project work in OO Base 10
3 Practical File 10
4 Viva Voce 10
Total 50
The structure for the same is as follows:
S.NO Details Marks
Portfolio or practical file should contain printouts of the practical done using
1
Writer, Calc and Base with minimum 5 problems of each
The practical concepts included for OO writer problems are as following:
1. Create and apply styles in the digital document
2. Insert and use images in the digital document
3. Create and Use templates
4. Create and customize the table of contents
5. 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:
1. 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)
2. Paragraph: Apply Style Text Body from the Style Gallary
3. Quote: Font Name:Broadway, Size:16, Colour: Blue, Alignment: Center. Give the
style name: DreamQuot
Insert and use images in the digital document
[2] Prepare a document in OO writer and do the following:
1. Create a new document in OO Writer and Type a paragraph.
2. Insert a picture of your choice.
3. Adjust the picture at top left to the paragraph.
4. Insert some shapes and write additional text into the sahpes.
Create and Use Template
[3] Create a document in OO writer and do as directed below:
1. Prepare a template for the leave application writing format.
2. Apply formatting as required.
3. Set this template as a default template.
4. Change the default template to custom template. Change the formatting as you
wish.
Create and customize table of content
[4] Prepare a document with different headings and apply a table of contents to it.
Implement the mail merge
[5] Write a letter and use the concept of mail merge with 5 addresses.
OO Calc problems for IT 402 Practical file
Class 10 for 2022-23
The practicals from Electronic Spreadsheet (Advanced) are as following:
1. Analyse data using scenarios and goal seek
2. Link data and spreadsheets
3. Share and review a spreadsheet
4. Create and Use Macros in spreadsheet
Analyse data using scenarios and goal seek
[1] Prepare worksheet as given below and do as directed:
1. Create a new file in spreadsheet software and enter data for 10 salesmen.
2. Add two worksheets in the file and modify the data for all 3 quarters.
3. Rename all worksheets like sheet1 – 2018, sheet2 – 2019 and sheet3 – 2020.
4. Now add one more worksheet at the end and rename as consolidated sheet.
5. 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.
6. [2] Prepare a worksheet as:
7.
Creating Subtotals
Link data and Spreadsheet
1. Create a new file in spreadsheet software.
2. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth,
Father Name, Mother Name.
3. Enter records for at least 15 students.
4. Rename this worksheet as “Student Profile”.
5. Insert 3 new worksheets and rename as “Periodic Test I“, “Periodic Test II” and
“Periodic Test III” respectively.
6. 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.
7. 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.
8. In the Periodic Test III worksheet create a reference for Roll No, First Name,
and Last Name columns from Student Profile as you wish.
1. Apply sheet tab color as follows:
o Profile – Red
o Periodic Test I – Green
o Periodic Test II – Blue
o Periodic Test III – Yellow
2. Now enter the marks for different subjects in the worksheets.
3. Delete the Worksheet Perdioc Text III.
[3] Data Consolidation and Hyperlink
1. Insert a new worksheet and rename as “Consolidated Worksheet“.
2. Create different references from the Student Profile and Marks to consolidate the
result.
3. Move the worksheet to the end of the workbook sheet tab.
4. Insert a new worksheet at the beginning.
5. Create a hyperlink to move to a particular worksheet from the newly inserted
worksheet.
6. Delete hyperlink for the consolidated worksheet.
[4] Share and review a spreadsheet
1. Create a new worksheet, enter data as you wish.
2. Save your worksheet with your desired name.
3. Enable sharing for your worksheet.
[5] Multiple Operations
A student is planning her goals about the marks she should attain in the forthcoming
examinations in order to achieve a distinction (75%). Assuming that the examination of
each subject is for 100 marks, her marks for PT 1 and Term 1 are given as under.
English Maths Science
PT 1 72 63 54
Term 1 70 69 80
Find out how many marks should she obtain in term 2 to secure 75%.
OO Base problems for IT 402 Practical file
for 2022-23
OO base or Unit 3 Database Management System has 5 main sessions. 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 the query
4. Create forms and reports using a wizard
Practical Database Management System
10
Create database and give the name as practical.
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.
5. Create following tables in OO base for Database Management System 10.
6. [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
EmpNo Integer 5
EmpName Text 15
Designation Text 10
Address Text 50
City Text 10
MobileNo Text 10
Salary Decimal 9,2
Gender Text 6
Assign EmpNo as primary key
[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
[4] Marksheet
Field Name Data Type Size
Stud_No Integer 2
Name Text 15
RollNo Integer 3
Sub101 Decimal 3,2
Sub102 Decimal 3,2
Sub103 Decimal 3,2
Primary Key – Stud_No
[5] Player
Field Name Data Type Size
Player_ID integer 5
Player_Name Text 15
Age integer 2
Height Text 5
Weight Integer 3
BloogGroup Text 5
No_of_Matches Integer 5
Centuries Integer 3
Wickets Integer 3
Average_Run Decimal 5,2
Primary Key – Player_ID
Insert at least 10 records in every table.
