Information Technology Project
By Shubham, Class X Sunflower
1. Explain the styles given in the Style and Formatting window for Writer and paste the screenshot o
In OpenOffice Writer, styles are predefined sets of formatting rules. They help maintain consistent formatting
throughout a document. Access the 'Styles and Formatting' window using F11 or through the Format menu. It
includes paragraph styles, character styles, frame styles, etc.
[Insert Screenshot/Image Here]
2. Write the steps to create new style in OpenOffice Writer.
1. Open OpenOffice Writer.
2. Press F11 to open the Styles and Formatting window.
3. Right-click on the desired style category (e.g., Paragraph Styles).
4. Click 'New'.
5. Name your style and set formatting options.
6. Click OK.
[Insert Screenshot/Image Here]
3. Write the steps to consolidate data of two sheets in OpenOffice Calc.
1. Open OpenOffice Calc with data in multiple sheets.
Information Technology Project
By Shubham, Class X Sunflower
2. Select the sheet where you want to consolidate data.
3. Click on Data > Consolidate.
4. Select the Function (e.g., SUM).
5. Use the 'Add' button to select data ranges.
6. Check 'Link to source data' if needed.
7. Click OK.
[Insert Screenshot/Image Here]
4. Write the steps to record macro in OpenOffice Calc.
1. Go to Tools > Macros > Record Macro.
2. Perform the actions you want to record.
3. Click 'Stop Recording'.
4. Save the macro with a suitable name and location.
5. To run the macro, go to Tools > Macros > Run Macro.
[Insert Screenshot/Image Here]
5. Write the steps to create table with minimum five fields on an entity 'Student' in Design View.
Information Technology Project
By Shubham, Class X Sunflower
1. Open OpenOffice Base.
2. Choose 'Create Table in Design View'.
3. Enter field names like StudentID, Name, Age, Class, Grade.
4. Set data types accordingly.
5. Set 'StudentID' as Primary Key.
6. Save the table as 'Student'.
[Insert Screenshot/Image Here]
6. Write the command for the following table: Student.
To create the Student table using SQL:
CREATE TABLE Student (
StudentID INT PRIMARY KEY,
Name VARCHAR(50),
Age INT,
Class VARCHAR(10),
Grade CHAR(1)
);
Information Technology Project
By Shubham, Class X Sunflower
[Insert Screenshot/Image Here]
7. Illustrate the use of various options under Computer Accessibility in Keyboard, Mouse, Display ta
Computer accessibility features help users with disabilities.
- **Keyboard Tab**: Sticky Keys, Filter Keys.
- **Mouse Tab**: Mouse Keys for keyboard control.
- **Display Tab**: High contrast themes, magnifier, screen reader.
[Insert Screenshot/Image Here]
8. Write the steps to create result sheet of your class using spreadsheet function in OpenOffice Spr
1. Open OpenOffice Calc.
2. Enter student names, marks in columns.
3. Use SUM() to calculate total.
4. Use AVERAGE() for average.
5. Use IF() to assign grades.
6. Format the sheet for clarity.
Information Technology Project
By Shubham, Class X Sunflower
[Insert Screenshot/Image Here]
9. Write the steps to create instant messaging account for Google Talk.
Note: Google Talk has been discontinued, but steps for creating accounts in similar services (e.g.,
Gmail/Google Chat):
1. Visit [Link].
2. Click 'Create Account'.
3. Fill in details (name, username, password).
4. Verify email/phone.
5. Log in to Gmail and use Google Chat.
[Insert Screenshot/Image Here]
10. Illustrate the various uses of ICT techniques in case of education and sports.
ICT in Education:
- Online learning platforms.
- Smart classes and e-books.
- Virtual labs and simulations.
Information Technology Project
By Shubham, Class X Sunflower
ICT in Sports:
- Video analysis of performance.
- Fitness and health monitoring.
- Live broadcasts and data tracking.
[Insert Screenshot/Image Here]