Vocational IT Practical File
SUBMITTED BY :
DEVANSH KHERA
CLASS : X-C
ROLL NO : 11
Libre Office Base
Topic 1:- Creating Database
The creation of a database and operation of the Database Wizard
are discussed in detail in Chapter 2, Creating a Database. For now,
the following steps are followed to create
the Example_Sport.odb database:
1) Launch the Database Wizard using one of the following methods:
a) From the LibreOffice Start Center, click on the Base
Database option in the Create area.
b) In any LibreOffice component, select File > New > Database on
the Menu bar or click the arrow at the right of the New icon on the
Standard toolbar and select the Database option from the drop-down
menu.
c) In Base, click on the New icon in the Standard toolbar or
press Ctrl+N.
2) At step 1 of the Database Wizard, select the Create a new
database option and select HSQLDB Embedded in the Embedded
database menu.
3) Click on the Next > button.
4) At step 2 of the Database Wizard, select the No, do not register
the database option, select the Open the database for editing option,
and make sure that the Create tables using the table wizard option is
not selected.
5) Click the Finish button. Base displays the Save As dialog.
6) Navigate to the folder where the new database is to be stored.
7) Enter the text “Example_Sport.odb” in the File name field.
8) Click the Save button to save the new database and close the
Save As dialog.
Topic 2 :- Creating A Data Entry
Form
To use the Form Wizard to create a form, carry out the
following steps.
1) On the main Base window, click Forms in
the Database area.
2) In the Tasks area, click Use Wizard to Create Form.
3) Base opens the Database Form window and the
Form Wizard dialog in readiness for you to start
creating the form. The Form Wizard opens at step 1 of
8. You can view components of the form building up
on the underlying Database Form window as you
complete the steps of the Form Wizard.
4) Select the entry for the tblEntrants table in
the Tables or queries drop-down menu.
The tblEntrants table data should be written in the
main form. Data from the tblSports table is loaded
directly with the few necessary sports and will be
rarely updated.
5) Use the right arrow buttons to move all entries
except ID in the Available fields area to the Fields in
the form area (Figure 37). All fields except the primary
key field (ID) are needed from the tblEntrants table.
The primary key field is filled automatically with a
unique value.
6) Click the Next > button. Base displays step 2 of the
Form Wizard.
7) Select Add Subform and Subform based on existing
relation. A subform should be set up where a sport can
be assigned to an entrant.
8) Select the tblRel_entrant_sport entry adjacent to
the Which relation do you want to add? label (Figure
38). This confirms the previously defined relationship.
9) Click the Next > button. Base displays step 3 of the
Form Wizard.
10) Use the right arrow buttons to move
the ID_sport field from the Available fields area to
the Fields in the form area (Figure 39). The primary
key in the tblEntrants table provides the value for
the ID_entrant field for the current record by the
connection of the main form to the subform.
11) Click the Next > button. Base displays step 5 of
the Form Wizard. Step 4 (Get joined fields) is inactive
because the linkage is already in place.
12) Click the second icon of the four under the
label Arrangement of the main form. This arrangement
is called Columnar – Labels on Top. How the items in
the main form and subform are arranged is not of
great importance for this example. However, the
layout should always be clear and user-friendly to
assist inexperienced users.
13) Click the third icon of the four under the
label Arrangement of the subform (Figure 40). This
arrangement is called As Data Sheet. The fields in the
subform will later show all sports of the entrants, so
the subform arrangement is best left at its default
setting.
14) Click the Next > button. Base displays step 6 of
the Form Wizard. Make sure that the default
option The form is to display all data is Selected
(Figure 41). This means that new entries can be made
and existing entries can be modified.
15) Click the Next > button. Base displays step 7 of
the Form Wizard (Figure 42). Applying styles is a
matter of taste. Just beware: some styles involve
unexpectedly low-contrast images, especially in table
control fields. In such cases, the font color of the data
sheet fields may need to be readjusted.
16) Click the Next > button. Base displays step 8 of
the Form Wizard.
17) Type the text “frmEntrant” into the Name of the
form field.
18) Select the Modify the form option (Figure 43).
19) Click the Finish button to close the Form Wizard.
Topic 3:- Creating A Query
In a query, the contents of various tables can be
grouped together. In this section, a simple query is
created that displays each of the entrants together
with a list of the sports that they have entered.
1) Click Queries in the Database area of the main
Base window.
2) Click Create Query in Design View in
the Tasks area of the main Base window.
3) Base displays the Query Design window and opens
the Add Table or Query dialog (Figure 47).
4) Select the tblEntrants table and click
the Add button.
5) Select the tblRel_entrant_sport table and click
the Add button.
6) Select the tblSports table and click the Add button.
7) Click the Close button to remove the Add Table or
Query dialog from the display.
8) Note that the three tables, and the relationships
between them, are represented in the upper area of
the Query Design window (Figure 62).
9) Double-click the first_name, last_name, birth_date,
and gender fields in the tblEntrants table and verify
that these fields are added to the columns of the
query in the lower part of the Query Design window.
Double-clicking is perhaps the simplest method to add
a field to a query.
10) In the lower part of the Query Design window,
click in the blank Field entry located to the right
of gender and then click the down arrow to access a
drop-down list of fields that are available for inclusion
in the query. The list consists of the field names and
their corresponding table names indexed by table
name. In order to match the fields of the tables
correctly to their tables, they are labeled "table
name"."field name" in queries. If "*" is used instead of
the field name, it means that all the fields of the
corresponding table are displayed. Select
the tblSports.sport_name entry in the list—this
provides an alternative to the method of double-
clicking described in the previous step (Figure 63). The
query is complete and it is advisable to execute it before
saving to see if it produces the desired results
Topic 4:- Sorting Tables
The A > Z and Z > A buttons allow for quick sorting.
First, select a field. Then, click on the button
corresponding to ascending or descending sort, and
the data is sorted by that column. Figure 15 shows a
descending sort by the Title field.
Quick sort will only sort by one column. To sort by
several columns simultaneously, a more advanced sort
function is provided to the left of the quick sort
buttons:
The field name of the column and the current sort
order are selected. If a previous quick sort has been
carried out, the first row will already contain the
corresponding field name and sort order.
Topic 5 :- Creating A Report
A report will be created showing a list of entrants,
sorted by sport, gender, and age group.
1) On the main Base window, click Reports in
the Database area.
2) In the Tasks area, click Create Report in Design
View.
3) Base displays the Report Builder window, with the
Add field dialog in the foreground.
4) On the right side of the Report Builder window,
there should be an area to view and edit properties of
the currently active object. If this area is not visible,
select View > Properties on the Menu bar. (Figure 75).
The initial configuration of the Properties area for
the Example_Sport.odb database is for the Data tab to
be visible; the Content type field to be set to Table;
and the Content field to be set to tblEntrants (the
name of the first table alphabetically). These default
settings define the initial content of the Add field
dialog.
5) On the Data tab of the Properties area, for
the Content type field select Query.
The qryRegistration query is used as the basis for the
new report.
6) On the Data tab of the Properties area, for
the Content field select qryRegistration.
7) Base updates the content of the Add field dialog to
list the fields of the selected query in alphanumeric
order (Figure 76).
8) Click the Sorting and Grouping icon on the
Standard toolbar of the Report Builder window (Figure
77).
9) Base displays the Sorting and Grouping dialog (Figure
78).
10) In the Sorting and Grouping dialog, click in the first
area below the Field/Expression label and
select sport_name from the drop-down menu. Note that
a sport_name Header area is added to the underlying
window. Use the default settings in the Properties area
of the Sorting and Grouping dialog.
11) Repeat step but select gender from the drop-
down menu in the next free area below
the Field/Expression label.
12) Repeat step but select age_group from the drop-
down menu in the next free area below
the Field/Expression label.
13) Close the Sorting and Grouping dialog.
14) On the Report Builder window, select
the sport_name Header group section. Base highlights
the selected area with a white border.
15) If the Add field dialog is not displayed, click
the Add Field icon on the Standard toolbar of the
Report Builder window (Figure 79).
16) Base re-displays the Add Field dialog (Figure 76).
17) On the Add field dialog, select
the sport_name entry and then click the Insert icon.
18) Base inserts a label field and a text field to display
the contents of the sport_name field of
the qryRegistration query in the highlighted area of
the underlying report.
19) On the Report Builder window, select the gender
Header group section. Base highlights the selected
area with a white border.
20) On the Add field dialog, select the gender entry
and then click the Insert icon.
21) Base inserts a label field and a text field to display
the contents of the gender field of
the qryRegistration query in the highlighted area of
the underlying report.
22) On the Report Builder window, select
the age_group Header group area. Base highlights the
selected area with a white border.
23) On the Add field dialog, select
the age_group entry and then click the Insert icon.
24) Base inserts a label field and a text field to display
the contents of the age_group field of
the qryRegistration query in the highlighted area of
the underlying report.
25) On the Report Builder window, select the
Detail group area. Base highlights the selected area
with a white border.26) On the Add field dialog, select
the first_name entry and then click the Insert icon.
27) On the Add field dialog, select
the last_name entry and then click the Insert icon.
28) On the Add field dialog, select the birthday entry
and then click the Insert icon.
29) On the Add field dialog, select the sport_age entry
and then click the Insert icon.
30) Base inserts pairs of label fields and text fields to
display the contents of
the first_name, last_name, birth_date,
and sport_age fields of the qryRegistration query in
the highlighted area of the underlying report.
31) Close the Add field dialog.
32) The draft report should now look similar to that
shown in Figure 80.
33) Save the report with the name rptList_of_entrants.
34) Save the database (otherwise, the report is stored
only temporarily).
z
LibreOffice Writer
Topic 1 :- Inserting Images From the
Gallery
The Gallery (Figure 3) provides a convenient way to
group reusable objects such as graphics and sounds
that you can insert into your documents. The Gallery is
available in the Writer, Calc, Impress, and Draw
components of LibreOffice. See “Managing the
LibreOffice Gallery” below. You can copy or link an
object from the Gallery into a document.
Topic 2 :- Creating A Template From
a Document
To create a template from a document:
1)Open a new or existing text (Writer) document.
2)Add any content that you want to appear in any
document you create from the new template, for
example company logo or a copyright statement.
3)Create or modify any styles that you want to use in
the new template.
4)On the Menu bar, choose File > Templates > Save
as Template. The Save as Template dialog (Figure 3)
opens, displaying the existing categories and a box for
the name for the new template.
5)Select a category, for example My
Templates or Business Correspondence. You can also
set this template as a default template at this time.
Click Save.
Topic 3:- Creating Drawing Objects
Right 1
1 Select 7 Rectangle 13 Flowchart
Triangle 9
Rectangle, Basic 2
2 Insert Line 8 14 Callouts
Rounded Shapes 0
Lines and Symbol 2 Insert Text
3 9 Square 15
Arrows Shapes 1 Box
Insert
Curves and 1 Block 2
4 Ellipse 16 Fontwork
Polygons 0 Arrows 2 Text
1 Stars & 2
5 Curve Circle 17 Points
1 Banners 3
1 Isosceles Callout 2 Toggle
6 Polygon 18
2 Triangle Shapes 4 Extrusion
To use a drawing tool:
1) Click in the document where you want the drawing
to be anchored. You can change the anchor later, if
necessary.
2) Choose the tool on the Drawing toolbar (Figure 8).
The mouse pointer changes to a drawing-functions
pointer and the normal Formatting toolbar changes to
Drawing Object Properties toolbar (Figure 9).
3) Move the cross-hair pointer to the place in the
document where you want the graphic to appear and
then click and drag to create the drawing object.
Release the mouse button. The selected drawing
function remains active, so that you can draw another
object of the same type.
4) To cancel the selected drawing function, press
the Esc key or click on the Select icon (the arrow at
the left-hand end of the Drawing toolbar).
5) You can now change the properties (fill color, line
type and weight, anchoring, and others) of the
drawing object using either the Drawing Object
Properties toolbar (Figure 9) or the choices and dialogs
reached by right-clicking on the drawing object.
Topic 4 :- Applying Styles using the
Styles and Formatting Window
Steps :-
The Styles and Formatting window includes the most
complete set of tools for styles. To use it for applying
styles:
1. 1)Select View > Styles and Formatting or
Styles > Styles and Formatting from the Menu bar,
or press F11 (⌘+T on a Mac), or click the Styles
and Formatting tab in the Sidebar (View > Sidebar
to open it).
The Styles and Formatting window shows previews
of the styles available. Figure 1 shows the window
for Writer, with Paragraph Styles visible.
1. 2)Select one of the buttons at the top left of
the Styles and Formatting window to display a list
of styles in that category.
1.3) To apply an existing style, position the
insertion point in the paragraph, frame, page, or
word, and then double-click the name of the style
in one of these lists. To apply a character style to
more than one word, select the characters first.
Topic 5 :- Customizing A Table Of
Content
Start by clicking in the document where you want the
table of contents to appear and chooseInsert > Table
of Contents and Index > Table of Contents, Index or
Bibliography to open the Table of Contents, Index or
Bibliography dialog shown in Figure 1.
You can also access this dialog at any time by right-
clicking anywhere in an existing table of contents and
choosing Edit Index in the context menu.
The Table of Contents, Index or Bibliography dialog
has five tabs. Each tab covers a different aspect of the
TOC structure and appearance:
1)Use the Type tab to set the attributes of the TOC.
2)Use the Entries and Styles tabs to format the entries
in the TOC.
3)Use the Columns tab to put the TOC into more than
one column.
4)Use the Background tab to add color or an image to
the background of the TOC.
LibreOffice Calc
Topic 1 :- Consolidating data
The Consolidate tool allows you to combine and
aggregate data spread across one or more sheets.
This tool is useful if you need to quickly summarize a
large, scattered set of data for review. For example,
you could use it to consolidate multiple department
budgets from different sheets into a single company-
wide budget contained in a master sheet.
To consolidate data:
1) Open the document containing the cell ranges to
be consolidated.
2) Select Data > Consolidate on the Menu bar to open
the Consolidate dialog (Figure 1).
3) Click on the Source data ranges field, then type a
reference to a source data range, a named range, or
select it with the mouse. Use the associated Shrink /
Expand button if you need to minimize the dialog
while you select the range. Alternatively, select a
named range from the drop-down list to the left of the
field.
4) Click Add. The selected range is added to
the Consolidation ranges list.
5) Repeat steps and to add additional source ranges.
6) To delete an entry in the Consolidation ranges list,
select it and click Delete. The deletion is carried out
without further confirmation.
7) Click on the Copy results to field, then type a
reference to the first cell of the target range or select
it with your mouse. You can also select a named range
in the drop-down list to the left of the field.
8) Select a function to aggregate your data in
the Function drop-down list. The default is Sum. Other
available functions are Count, Average, Max, Min,
Product, Count (numbers only), StdDev (sample),
StDevP (population), Var (sample), and VarP
(population).
9) Click OK to consolidate the ranges. Calc runs the
function from step on your source data ranges and
populates the target range with the results.
Topic 2:- Creating Scenarios
To create a new scenario:
1) Select the cells that contain the values that will
change between scenarios. To select multiple ranges,
hold down the Ctrl key as you click. You must select at
least two cells.
2) Choose Tools > Scenarios on the Menu bar to open
the Create Scenario dialog (Figure 12).
3) Enter a name for the new scenario in the Name of
Scenario field.
Topic 3:- Renaming Sheets
Sheets can be renamed at any time. To give a sheet a
more meaningful name:
• Enter the name in the Name box when you create
the sheet.
• Double-click on the relevant sheet tab and replace
the existing name through the Rename Sheet dialog.
• Right-click on the relevant sheet tab,
select Rename Sheet in the context menu, and
replace the existing name through the Rename Sheet
dialog.
• Left-click on the relevant sheet tab, select Sheet >
Rename Sheet on the Menu bar, and replace the
existing name through the Rename Sheet dialog.
A sheet name cannot be empty and must not be a
duplicate of an existing name.
Topic 4 :- Saving A Shared
Spreadsheet
When you save a shared spreadsheet, and if it has not
been modified and saved by another user since you
opened it, it is saved as usual.
If the spreadsheet has been modified and saved by
another user since you opened it, one of the following
will occur:
• If the changes do not conflict, the document is
saved, the message “Your spreadsheet has been
updated with changes saved by other users”
appears, and any cells modified by the other user
are shown with a red border.
• If the changes conflict, the Resolve Conflicts
dialog (Figure 2) is shown. You must decide for
each conflict which version to keep, yours or the
other person’s. When all conflicts are resolved,
the document is saved. While you are resolving
the conflicts, no other user can save the shared
document.
• If another user is trying to save the shared
spreadsheet and resolve conflicts, they see a
message that the file is locked due to a merge in
progress. They can cancel the Save command and
retry saving later.
When you successfully save a shared spreadsheet, the
document shows the latest version of all changes
saved by all users.
Topic 5:- Recording Changes
To record changes, open the spreadsheet and make
sure that the Edit > Track Changes > Record menu
item has a check mark next to it, indicating that
change recording is active.
Caution
After making some changes, do not turn off
change recording. Turning off change recording
in Calc causes all the recorded changes to be
accepted and no longer shown as changes. A
message box will warn if you try to do this.
When changes are made in a cell, a colored border
with a dot in the upper left-hand corner appears
around the cell (Figure 3). A deleted column or row is
marked by a heavy colored bar.
To see the changed information, hover the mouse
pointer over the changed cell. See Figure 4.