DIGITAL DOCUMENTATION (ADVANCED)
Assignment 1 :
Objective: Using various commands to create customer styles and apply
predefined styles in Libre Office Writer.
Task: Type a paragraph with at least 100 words and create below given styles as
instructed:
1. Title
a. Font Name: Kristen ITC, Size:28, Colour: Magenta
b. Give Style Name: Title AI (Use create styles using drag and drop)
2. Headings
a. Font name: Times New Roman, Size: 24 , Colour: Red.
b. Give the style name: My Heading (Use create style from selection
command)
3. Paragraph and Headings - My heading styles to all headings using Fill
Format
4. Load Styles in New Document and Save the document
Solution:
Preparing document
1. Click on Start > All Apps > LibreOffice > LibreOffice Writer.
2. Type required text.
Creating styles
Title (Using Drag and Drop)
1. Select the title “Generative Artificial Intelligence”.
2. Apply the desired formatting.
3. Now click on Styles > Manage Styles option.
4. Select the title “Generative Artificial Intelligence” and drag over the
Styles pane present on the screen.
5. New Style From Selection dialog box will appear with a prompt
to enter New Style Name. Type name as “Title AI”.
6. Click on OK button.
1
Assignment 2 :
Objective : Creating templates in LibreOffice Writer and saving for distribution.
Task:
• Prepare a template for the class time table.
• Apply formatting as required.
• Set this template as a default template.
• Reset the default template as usual.
Solution:
1. Create a new document in LibreOffice Writer.
2. Click on Format > Page Style option.
3. A page style dialog box will appear.
4. Select Area > Image > Add/Import option.
5. Apply desired options for background and click on OK button.
6. Insert table for time table and format it as per your choice.
Saving file as template
1. Click on File > Templates > Save as Template option.
2. A Save As Template dialog box will appear.
3. “Time Table ” as Template Name in Enter Template Name dialog box.
4. Select Template Category as MyTemplate.
5. Click on Set as default template option.
6. Click on Save button.
Reset default template
1. Click on File > Templates > Manage Templates option.
2. A manage template dialog box will appear.
3. Click on Manage > Reset Default Text Document option.
4. Click on Close button.
2
Assignment 3 :
Objective: Create and Customize Table of Contents
Task: Prepare a document with different headings and apply a table of contents
to it.
Solution:
1. Type the contents.
2. Apply appropriate level of headings from the Styles window.
3. Place the cursor at the beginning of document to insert Table of Content.
4. Click on Insert → Table of contents and index → Table of contents,
index or Bibliography option. The Table of contents, index or
Bibliography will appear.
5. Select and apply the styles for the Table of Contents.
6. Click on OK.
ELECTRONIC SPREADSHEET ADVANCED
Assignment 4 :
Objective : Applying Data Consolidation in LibreOffice Calc
Task: Prepare 3 worksheets for products sales and consolidate them
Solution:
Preparing sheets for Data Consolidation
1. Create a new file in spreadsheet software and enter data for 5 products.
2. Add two worksheets in the file and modify the data for all. Click on Sheet tab
and + icon there,
3. Rename all worksheets like sheet1 - Ahmedabad, sheet2 - Surat and sheet3
- Rajkot. Select the sheets respectively and do right click on Sheet tab >
Rename Sheet option, Type the sheet name and Click on OK button.
4. Now add one more worksheet at the end and rename as Consolidated as
similar as step 2 and 3.
Perform Data Consolidation
1. Place the cursor in cell B2 in Consolidated sheet.
2. Click on Data > Consolidate option.
3. The Consolidate dialog box will appear.
4. Choose the Sum function.
5. Select Data Source ranges respectively and click on Add button.
6. Click on OK button.
3
Assignment 5 :
Objective: To change the mark of Mathematics to get the percentage from 87 to
93 percentage. The marks are given below:
Task: Create the above mark list and change the mark of Mathematics using Goal
Seek.
Solution:
1. Enter the values in the worksheet.
2. Write the formula in the cell (B9) to get the sum( =sum(B2:B7) )
3. Write the formula in the cell (B10) to get the percentage ( =B9/600*100 )
4. Place the cursor in the formula cell (B10), choose Tools > Goal Seek
5. The Goal seek dialog window will appear, the Formula cell box will have
the cell address.
6. Enter the desired result (i.e, 93) in the Target value box.
7. Place the cursor on the Variable cell box and click on the cell (B6) that
contains the value to be changed
8. Click on OK button
Assignment 6 :
Objective: Create a macro named multiplyby3 to multiply a set of numbers by 3
Task: Record a macro named multiplyby3.
Solution:
1. Open Libre office calc and type 3 in the cell A1, then copy it by pressing
ctrl+c.
4
2. Choose Tools > Macros > Record Macro.
(If the Record Macro is not available , then go to Tools->Options-
>Advanced->tick the check box ‘Enable macro recording’)
3. Click Edit->Paste Special. Then Paste special window will be displayed.
Click on Multiply and ok button.
4. Click Stop Recording to stop the Macro Recorder
5. The Basic Macro dialog appears. A Standard library is present by default
when a spread sheet is created.
6. Enter the macro name as ‘MultiplyBy3’ in Macro Name box.
7. Press Save button.
8. Create a new sheet and enter some numbers .
9. Select all the numbers and click on Tools->Macros->Run Macro option.
10.Now Macro Selector window appears, choose My Macros->Standard-
>Module1-> MultiplyBy3->Run option.
Assignment 7 :
Objective: To create a hyperlink in a spread sheet.
Task: Prepare 3 worksheets to create hyperlink.
Solution:
1. Create two spread sheet documents named IPL 2023 and IPL 2024 that
stores the statistics of a cricket player.
2. Create a new spread sheet named Rohit Sharma. Then click on Insert->
Hyperlink. A Hyperlink dialog box will open.
3. Click on the Document option on the left pan of dialog box, then choose
path from Document section. Locate the file named IPL 2023.
4. Choose Button from Form and type IPL 2023 in the Text box.
5. Click on Apply and Close button to exit the Target Document window
6. Repeat step 2 to 5 to insert the spread sheet IPL 2024.
7. Now go to View->Toolbars->Form Design and click on Design Mode to
activate the hyperlink buttons.
8. Now click on the buttons to jump to the locations.
5
DATABASE MANAGEMENT SYSTEM
Assignment 8 :
Objective: Steps to create a table using table wizard
Task: Create a table using wizard and insert data.
Solution:
1. Click on Start → All Programs → LibreOffice → LibreOffice Base
2. Click on Create a new database option.
3. Click on Next button.
4. Select the database Register option either Yes, or No.
5. Check on Open database for editing.
6. Click on Finish button.
7. It will prompt to save the database.
8. Type the desired name and save it. I have given db1.
9. Now click on Tables button from Left pane and choose the option - Use
Wizard to Create Table… from the tasks window.
10. The Table Wizard will open. Follow wizard steps to create a table.
11. In first step of wizard select the Category either Business or Personal,
12. Now choose a table from list of table. As I have selected Employees table.
13.Click on Next and select field types and all if you want to change it.
Click on Next. I have selected EmployeeID, Firstname, Lastname,
Salary, Datehired.
14.Set a primary key for your table in this step. Click on Use an existing
field as a Primary Key. I have selected EmployeeID as Primary key.
Click on Next.
15.If you wish to change the table name then type new name for the table and
click on Insert.
Assignment 9 :
Objective: Create a table named Employee and display the details of employees
who are getting salary more than 65000 using query design mode. Use the
6
following table
EMPID EMPNAME DEPARTMENT SALARY
1001 John Doe IT 70000
1002 Jane Smith HR 60000
1003 Michael Brown Finance 80000
1004 Emily White Marketing 65000
1005 Daniel Green Sales 55000
Task: : Create Employee table and generate a query to display the details of
employees who are getting salary more than 65000.
Solution:
1. Open LibreOffice Base and create a database named School.
2. Create a table named Employee in LibreOffice Base.
3. Click on Queries object and Choose ‘Create Query in Design View’.
4. Choose the table Employee from Add Table/Query dialog box and click on
Add button.
5. Press Close button.
6. Select all the fields from the list box of field row.
7. Visible check box of all the fields should be selected.
8. Type >65000 in the criterion grid of Salary field.
9. Run the query by pressing F5 key.
10.Save the query.
