Cs Practical Class 10

Information
Technology Practical
File
-by A.DISHANT 10-YELLOW
UNIT-1
STYLE:
In Open Office Writer some text formatting like font size, font
alignment and font face are by default saved in the software. Those predefined
formatting are called style
STEPS TO CREATE A STYLE:

Steps to use Paragraph / Character Style:
1) Select a paragraph in a document.
2) 2) Open Style and Formatting Window (F11 shortcut key) and click on
Paragraph Style/Character Style.
There we see many options like

i) Heading 1 ii) Heading 2 iii) Heading 3
Steps to insert an Image:
1) Click on Insert tab in Open Office writer.

2) Select picture option and a sub menu open
up.
3) Select any option ‘From File’ or ‘Scan’.
4) ‘From File’ is used to access picture from computer.
5) ‘Scan’ is used to scan a picture.
Image Cropping
1. We make a new writer file, and insert the image.
2. Now we will crop the image by keeping scale. Right-click the
image → Click on Picture.
3. Under the crop tab, Click on Keep Scale radio button → Set other
specification → Click on OK.
Writer Template :
A template is a document type that creates a copy of itself

when we open it.
To save it as a template, the steps are: -
1. Go to the File Menu → Click on Save As option.
2.
2. Browse to the desired place to save it and write the desired name
for the file → Choose the file type as Template (.ott).
UNIT-2
SUBTOTAL:
The Subtotal option is used to automatically create groups and apply inbuilt
functions like Sum, Average, Count to summaries data in a sheet.
These are the steps to use Solver in Open Office:
1) Create a table in a sheet.
2) Go to the data tab for subtotal.
3) Select Subtotal option.
4) In Subtotals dialog box, select ‘Item’ in group by option.
5) In calculate subtotal for box select ‘Quantity’.
6) In use function select “Sum’. 7) Now press 'OK' button
Scenario:
In ‘What if scenario’ a set of values are changed to predict some results, which
spreadsheet save automatically with scenario names
These are the steps for ‘what if scenario’:

1) Create a table in a spreadsheet.
2) Select the table.
3) Go to ‘Tools’ tab.
4) Select ‘Scenarios’ option.
5) In ‘Create Scenarios box’ give scenarios name.
6) Now for other scenarios, change the Principal amount and repeat same steps
(2 - 5).
Goal Seek :
Goal Seek feature is an important part of What if analysis feature of
Spreadsheet. Goal seek is basically used when our output value if fixed and we have
to make a change in any one of the input values. Goal Seek is just reverse of
Scenario.
These are the steps for Goal Seek:

1) Create a table in a sheet,
2) Go to tools tab,
3) Select Goal Seek option,
4) In Goal Seek dialog box, enter values in formula cell, in target value, and in
variable cell,
5) Press OK button.
Solver :
Solver is a more descriptive form of Goal Seek. Solver can deal with
multiple variables as the Goal Seek is used to manipulate one variable cell
These are the steps to use Solver in Open Office:

1) Create a table,
2) Go to Tools tab,
3) Select Solver option,
4) In Solver dialogue box: Enter target value, optimize result to, and limiting
conditions,
5) Press OK button
STEPS TO ADD HYPERLINK:

Here, we will add a hyperlink to a website. Steps are: -
1. Go to Insert → Hyperlink.
2. Click on Internet → Click on Web radio button → Under Target
textbox, write the link of website.
3. Click on Apply. The link will be visible in the selected cell.
STPES TO RUN MACRO:
A typical method to run a macro is as follows:
1.Use Tools > Macros > Run Macro to open the Macro
Selector dialog).
2.Select the library and module in the Library list (left hand
side).
3.Select the macro in the Macro name list (right hand side).
4.Click Run to run the macro.
UNIT-3
HOW TO FORM TABLE:

To create a table in Open Office -
1.Launch Open Office.
2.Select database option from the window.
3.Open a database
4.Click on Table from Database and select Table in design view.
5.Specify the field name and the data type of the field.
6.Save the table by clicking on File>Save.
STEPS TO CREATE FORMS:

Step 1: Select fields
UnderTables or queries, select Table: People. Available field lists the fields for the People table.
1.Click the field FirstName and then on the right single arrow to move it to the Fields in the form list. Do the
same with LastName.Click Next . We do not put the PeopleID field on the form because it was defined as an
AutoValue field, and it will be populated automatically.
Step 2: Set up a subform
This form will not have a subform. Click Next and the dialog will jump to Step 5.
Step 5: Arrange controls
Step 6: Set data entry
This step allows limiting what can be done with the form, such as preventing data deletion or viewing existing
data. We will leave the defaults in place, but this could be an important step in securing data. Click Next .
Step 7: Apply styles
You can adjust the appearance of the form at this step with different colors and borders. We will leave the
default in place, but you might want to try different settings. Click Next .
Step 8: Set name
steps to create reports:

1)create a new report using wizard.
2Select the fields.

3Label the fields: answering the question How do you want to label the fields. ...
4Since we are grouping by the date, use the > button to move the Date
steps to create queries:

1)open queries,
2)click on create query in SQL view.

3)enter the formula Select*fromsdetails;
4)you will get your queries.

Cs Practical Class 10

Uploaded by

Copyright:

Available Formats

Cs Practical Class 10

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cs Practical Class 10

Uploaded by

Copyright:

Available Formats

Information

STEPS TO CREATE A STYLE:

There we see many options like

Steps to insert an Image:

1) Click on Insert tab in Open Office writer.

A template is a document type that creates a copy of itself

1. Go to the File Menu → Click on Save As option.

These are the steps for ‘what if scenario’:

These are the steps for Goal Seek:

These are the steps to use Solver in Open Office:

STEPS TO ADD HYPERLINK:

HOW TO FORM TABLE:

1.Launch Open Office.

2.Select database option from the window.

4.Click on Table from Database and select Table in design view.

STEPS TO CREATE FORMS:

Step 5: Arrange controls

Step 6: Set data entry

Step 8: Set name

steps to create reports:

2Select the fields.

steps to create queries:

2)click on create query in SQL view.

You might also like