Practical File Format
Information Technology (Code 402) – Class X
Title
Practical Portfolio File
1. Cover Page
Include:
School Name
Subject: Information Technology (Code 402)
Practical File
Student Name
Class & Section
Roll Number
Session
Teacher’s Name
2. Certificate
Sample Certificate
This is to certify that __________ of Class X has successfully completed the Practical Portfolio for
Information Technology (Code 402) during the academic session __________ under the guidance of
the subject teacher.
Teacher’s Signature: __________
Examiner’s Signature: __________
3. Acknowledgement
Sample
I would like to express my sincere gratitude to my IT teacher for guidance and support in completing
this practical file. I also thank my school for providing necessary resources and facilities.
4. Index
[Link] Practical Name Software Page No
1 Letter Formatting Writer
2 Resume Creation Writer
3 Tables & Mail Merge Writer
4 Charts in Spreadsheet Calc
[Link] Practical Name Software Page No
5 Formula Calculations Calc
6 Student Database Base
etc.
SECTION A: LIBREOFFICE WRITER PRACTICALS
(Minimum 5)
Practical 1: Letter Formatting
Aim
To create and format a formal letter using LibreOffice Writer.
Features Used
Bold
Italic
Alignment
Font formatting
Output
(Attach printout)
Practical 2: Resume/Bio-Data
Aim
To prepare a professional resume.
Features Used
Bullets
Tables
Formatting
Header/Footer
Output
(Attach printout)
Practical 3: Tables in Writer
Aim
To create and format tables.
Features Used
Insert table
Merge cells
Border formatting
Output
(Attach printout)
Practical 4: Mail Merge
Aim
To generate invitation letters using mail merge.
Features Used
Data source
Mail merge fields
Multiple records
Output
(Attach printout)
Practical 5: Print Options & Page Formatting
Aim
To apply page setup and print settings.
Features Used
Orientation
Margins
Print preview
Output
(Attach printout)
SECTION B: LIBREOFFICE CALC PRACTICALS
(Minimum 5)
Practical 6: Student Marksheet
Aim
To prepare a marksheet using formulas.
Functions Used
SUM
AVERAGE
MAX
MIN
Output
(Attach printout)
Practical 7: Charts in Calc
Aim
To create charts from data.
Charts Used
Pie chart
Bar chart
Output
(Attach printout)
Practical 8: Cell References
Aim
To understand relative and absolute references.
Features Used
Formula copying
$ symbol
Output
(Attach printout)
Practical 9: Monthly Expense Sheet
Aim
To prepare a household expense sheet.
Features Used
Formatting
Formulas
Conditional calculations
Output
(Attach printout)
Practical 10: Attendance Sheet
Aim
To create attendance records using Calc.
Features Used
Percentage calculation
Formatting
AutoFill
Output
(Attach printout)
SECTION C: LIBREOFFICE BASE PRACTICALS
(Minimum 5)
Practical 11: Student Database
Aim
To create a student database in Base.
Features Used
Table creation
Data types
Primary key
Output
(Attach printout)
Practical 12: Library Management Table
Aim
To create a library record database.
Fields
Book ID
Book Name
Author
Issue Date
Output
(Attach printout)
Practical 13: Queries in Base
Aim
To retrieve records using queries.
Queries Used
SELECT
WHERE
Output
(Attach printout)
Practical 14: Forms in Base
Aim
To create data entry forms.
Features Used
Form controls
Data input
Output
(Attach printout)
Practical 15: Reports in Base
Aim
To generate summarized reports.
Features Used
Report wizard
Sorting
Formatting
Output
(Attach printout)
5. Teacher’s Remarks
6. Viva Questions Section
1. What is mail merge?
2. Difference between relative and absolute reference?
3. What is a primary key?
4. Why are reports used in Base?
5. What is the use of formulas in Calc?
Important Instructions for File Preparation
Attach printouts of all practicals
Use proper headings
Maintain neat formatting
Add screenshots wherever possible
Use ruled/file sheets as instructed by school
Recommended Order of Arrangement
1. Cover Page
2. Certificate
3. Acknowledgement
4. Index
5. Writer Practicals
6. Calc Practicals
7. Base Practicals
8. Viva Questions
9. Teacher Remarks