Podar International
School, Ambegaon
Information Technology
Class 10
Session : 2024 - 25
Student’s Details
Roll No.: 18
Name of student: Rati Yemul
Class : 10 Section: A
Certificate
Index
Sr.No. Assignment Date Signature
Unit 1 : Digital Documentation (Advanced)
1 Understanding styles categories in Libre Office Writer
2 Create & Update a new style from the selection
3 Creating templates in Libre Office Writer
4 Uploading styles from another File
5 Table Of Content
Unit 2 : Electronic Spreadsheet (Advanced)
6 Consolidating the data in Libre Office Calc
7 Creating links within spreadsheets in Libre Office Calc
8 Creating Subtotal in Libre office Calc
9 Implementing Goal Seek in Libre Office Calc
10 Creating Scenarios in Libre Office Calc
Unit 3 : Database Management System
11
12
13
14
15
Unit 1: Digital Documentation
(Advanced)
Learning Outcome- Create and apply styles in digital document
Assignment 1
Objective: Understanding style categories in Libre Office Writer.
Task: Start Libre Office Writer and open styles Window. Explain the different styles given in the Styles
Window for writer and paste the screen shot of the window also.
Ans. Libre Office supports the following types of styles:
1. Page styles
2. Paragraph styles
3. Character styles
4. Frame styles
5. List
6. Table
1. Page – all documents in Writer are based on pages, hence for formatting them, Page Style
is used. It defines basic page layout like page size, its margin, placement of header and
footer, footnote, borders and background. A document can have one or many page styles. If
a page style is not specified, Writer uses its built-in Default page style.
2. Paragraph – after deciding on a page format, next is the document content, which is
organised in paragraphs. A paragraph begins and ends by pressing Enter key. Paragraph
formatting includes tab stops, text alignment, line spacing and borders. Usually, it also
includes Character styling attributes.
3. Character – this styling is used to work on block of letters, i.e. word(s) in the paragraph
instead of the whole paragraph. By using character styles, you can change the appearance of
a part of a paragraph without affecting the other part. Character styles allow changing the
text colour, text size, highlighting text and emphasising it.
4. Frame – using frames, a document can be organised in sections, so that each section of
the page can have a different appearance. Frames are like containers, which can hold text,
graphics and lists. Therefore, applying Frame Styles allows to format a frame by specifying its
size, position, border and how the text is placed around the picture.
5. List – to style lists in a document, the Writer provides a separate category. It can be used
to style lists by putting numbering or bullets of a different kind or specify numeric format.
6. Table – using tables, a large amount of information can be organised and presented
effectively. Table Style category allows to format a table by adding borders, using different
text or border colour(s), aligning text inside the table, having different patterns or text colour
Assignment 2
Objective: Create & Update a new style from the selection in the Style gallery and apply
them in the document.
Task: Create new styles in Libre Office Writer with the following specifications and apply
them in a document.
**Attach your document as output
Learning Outcome - Create and use template
Assignment 3
Objective: Creating templates in OO Writer and saving for distribution.
Task: Create a document looks like a screenshot and save as a template. Follow
below-given instructions:
Instructions:
1. Apply page borders as displayed in the screenshot. Apply border colour as per your
choice.
2. Page orientation must be landscape.
3. Give your desired formatting for school name, school address, and text written in the
certificate.
4. Save your file as a template and give the name certificate template.
**For output attach your document.
This certificate is awarded to Mast. Soham Deshmukh of class 10 E in honor of his
securing the first position in the event of Javelin Throw conducted on 20 th July
2024.
Learning Outcome–Uploading styles from another File
Assignment 4
Objective: Uploading style from another File
Task: Make a style in a file named “File 1 and the load style in another file “ File 2”
Learning Outcome–Table Of Contents
Assignment 5
Objective:To know & understand about the “Working with Table Of
Contents in Libre Office Writer
Task:Create a document which content different level of heading and apply Table
Of Content
Unit 2: Electronic Spreadsheet
(Advanced)
Learning Outcome– Consolidation
Assignment 6
Objective: To know and understand consolidated tool
Task: Creating Consolidated sheet from sheet 1, sheet 2, sheet 3
and sheet 4 in sheet 5 using Consolidated Tool.
Learning Outcome– Link data and Spreadsheet
Assignment 7
Objective: Creating reference to other document by using keyboard and mouse.
Task: Create a new file in spreadsheet software. Follow these instructions.
1. 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.
2. Rename this worksheet as "Student Profile".
3. Insert 3 new worksheets and rename as "Periodic Test I", "Periodic Test II" and
"Periodic Test III" respectively.
4. 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.
5. 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.
6. In the Periodic Test III worksheet create a reference for Roll No, First Name, and Last
Name columns from Student Profile as you wish.
Learning Outcome– Share and review a spreadsheet
Assignment 8
Objective: Setting up a spreadsheet for sharing.
Task: Create a new file in spreadsheet software and enable sharing.
1. Create a new worksheet, enter data as you wish.
2. Save your worksheet with your desired name.
3. Enable sharing for your worksheet.
Learning Outcome- Create and apply subtotals in OO Calc
Objective: Applying subtotal in OO Calc
Learning Outcome- Create and apply goal seek in OO Calc
Objective: Goal seek Application
Task: 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 of PT 1 and Term 1 are given
as under.
Learning Outcome- Create Scenario in OO Calc
Objective: Scenario Application
Task: Anish is planning to buy a car he wants to check the features of 4 cars for
comparison. Create 4 Scenarios based on following features in Libre Office Calc.
