CLASS 10 ASSIGNMENTS FOR INFORMATION TECHNOLOGY (402) (WRITER, CALC, DATABASE)

(WRITER, CALC, DATABASE)

Note: Please Paste Outputs (PICTURES) at the Left side (Blank page) of your Practical Copy AND write steps on ruled page.

UNIT-1

Digital documentation (Advanced)

....................................................................................................................................................

Assignment 1: Create a Paragraph style namely 'specific' with these settings.

Font name: Verdana; Font size: 10; Font color: Blue; First Line Indent: 0.04

Line spacing: 1.5 lines; before and after paragraph spacing: 006

Objectives: To know and understand about the "Creating new style".

Hardware & Software required: Computer system, Windows 7 or more (operating system), Open Office Writer.

Procedure:

Steps:-

1. Go to format Menu. Select styles and Formatting option or clicking on styles and formatting button on Formatting toolbar or Press F11 key.

2. Right click over Styles and formatting window and select New option.

3. Enter the name of style "Specific".

4. Set Font name "Verdana" & Font size "10" from Font Tab.

5. Set Font color "Blue" from Font Effects Tab.

6. Set First line Indent "0.04", Line Spacing "1.5 lines", Before and after Paragraph "0.06" from Indents & Spacing Tab.

7. At Last Click on OK option. Paragraph Style ("Specific") will be saved".

Conclusion: I have understand to create a New Paragraph Style.

....................................................................................................................................................................

Assignment 2:

Open a Formatted document. create a new style from the formatted heading of this document.

Objectives: To know and understand about the "Creating new style" from the formatted heading of this document.

Hardware & Software required: Computer system, Windows 7 or more (operating system), Open Office Writer.

Procedure:

Steps:-

1. Open a formatted document. Some formatting (Bold,underline,font soze,font color etc...) was done with the heading "SOCIAL MEDIA".

2. Select heading and drag and drop inside the Styles and Formatting window or select New Styles for Selection option.

3. Enter the Style name "My Style" and click on ok button.

4. Now Style "My Style" is ready.

.......................................................................................................................................................

Assignment 3:

In a blank document, load a clipart or an image of your choice.

Objectives:- To know and understand about the "How to insert an image in Writer document".

Hardware & Software required:- Computer system, Windows 7 or more (operating system), Open Office Writer.

Procedure:-

Steps:-

Method:-1 (Inserting an object/shape)

1. Open a blank document.

2. From the Drawing toolbar, select an object (smiley). Drag over the page. This image will be inserted.

Method 2:- (Inserting Image)

1. Open a blank document.

2. Go to Tools menu. select Gallery option.

3. Select an image from Gallery, Drag it to document.

Method 3:- (Insert image from PC)

1. Open a blank document.

2. Go to Insert menu. Select Picture, then from file option.

3. Select picture from your PC.

................................................................................................................................................

Assignment 4-

Create a template for a formal letter to some government authority.

Procedure (Steps)-

1. Type a letter in writer which you want to be a template.

58/109, Sreevatsa Residency

G N Mills Road

Coimbatore – 641025

12/12/2021

The Inspector of Police

D 1 Police Station

K V Palayam

Coimbatore – 641021

Subject: Request for registering an FIR regarding my stolen mobile phone

Sir/Ma’am,

I am Aarathy Santhosh, a resident of G N Mills Road, Coimbatore. I am writing this letter to report to you about the loss of my phone. My phone was stolen when I was travelling by bus (Bus No. 32 A) from Gandhipuram to Thudiyalur today, at around 8:30 am. My phone is a Vivo V15 Pro phone with a removable blue matte back case. My mobile number is xxxxxxxxxx, and the IMEI number of my phone is 155612459875612. The phone is worth forty thousand rupees.

I request you to kindly register the complaint and look into this matter as soon as possible. I have already sent in an application to block my mobile number so that whoever took my mobile would not be able to make any inappropriate use of it. Please do the needful.

You can contact me on xxxxxxxxxx or via email (email id:name.123@email.com). Please feel free to get in touch with me whenever required.

Looking forward to a positive response from you soon.

Thank you for your time and consideration.

Yours sincerely,

Signature of the sender

xyz

2. Go to File Menu and select Templates, then select Save option.

3. Type the name of Template "FIR" Using My Template option. Then click on OK. This letter template will be used to type letter for Police station.

4. To use this template, go to FILE menu, select NEW option, then select Templates and Documents option.

5. Select Templates , then select My templates, then select FIR. Then click on Open option. and use it,

...................................................................................

Assignment 6-

Create a TOC (Table of Content) for your current document.

Procedure (Steps)-

1. Create a document using different types of headings. Format all headings using Heading 1, heading 2, heading 3 etc.

2. Go to Insert Menu, select Index and Tables.

3. Click on OK button.

4. Now TOC is ready.

5. Now add on more heading in the document. Format it with Heading 3.

6. Now TOC will not change automatically. This heading will not be added ain TOC automatically. we have to use Update ooption.

So go to TOC and make write click on TOC, then select Update Index/Table option.

7. Now you can see this updated TOC.

--------------------------------------------------------------

UNIT-2

(ELECTRONIC SPREADSHEET) ADVANCED

Assignment - 1 (DATA CONSOLIDATION)

Tahhya Company has offices in four zones of India: North, South, East and Central Zones. The company maintains quarterly report of Revenue, Expanses and profits as shown below.

Considering that four sheets store data for four quarters of the company. Prepare a consolidated data sheet that shows the summery report for the Tahya Company.

Procedure (Steps)

1. Create four sheets (Sheet 1, Sheet 2, Sheet 3 and Sheet 4) containing the following data.

2. Create one more Sheet 4 for consolidation process. So copy the format in Sheet 4. Leave space for Data. Then go to Data Menu and select Consolidation option.

3. Select SUM Function. To select first source data range, click on shrink.

4. Select first source data range from sheet 1. Then click on add.

5. Similarly select other three more source data range from sheet2, sheet3 and sheet 4. And select the Target range also from sheet 5. At last click on OK button.

6. Now you can see the consolidated data at sheet 5.

-----------------------------------------------------------------------------------------------------------------------------

Assignment 2 - (SUBTOTALS)

There are three Cities Amritsar, Gajraula and Moradabad. In the spreadsheet, Sales of different products is given. Find

(i) Zone wise sales subtotals.

(ii) Product wise Sales subtotals.

Objectives: To know and understand about the "Subtotals" in Calc.

Hardware & Software required: Computer system, Windows 7 or more (operating system), Open Office Calc.

Procedure:

Steps:-

Step 1- Create the following spreadsheet contains three columns City, Product and sales.

Step 2- Select range of cells. Go to Data menu, then select Subtotals option.

Step 3- It will open Subtotals dialog box, Select Group by-City, and Select the value sales. Use function SUM. click on ok.

Step 4- Now Calc will calculate the subtotals as City wise Sales Subtotals.

Step 5- Now again follow Step 3 again. Group by Product and select the value Sales. Use function SUM. click on ok.

Step 6- Step 4- Now Calc will calculate the subtotals as Product wise Sales Subtotals.

See this video to know more....

ASSIGNMENT 3- Scenarios

Manish is planning to take loan from Punjab National Bank. He want to check what-if he go for Rs. 5000 or Rs. 1000. In both cases, which interest will be easy for him to payback to bank.

Objectives: To know and understand about the "Scenarios" in Calc.

Hardware & Software required: Computer system, Windows 7 or more (operating system), Open Office Calc.

Procedure:

Steps:-

Step 1- Enter Principal, Rate and Time and keeping the formula

S.I = P x R x T/100

Find out the Simple Interest.

Step 2- Select data, go to Tool menu and select Scenarios option.

Step 3- Type the name of Scenario name. Select the border color. Then Ok.

Step 4- First Scenarios is ready.

Step 5- Now change the value of P as RS. 1000. Then select the data. Again go to Tool option, select Scenarios option. Type the name of Scenarios and border color. Then OK.

Step 6- Now Bothe Scenarios are ready with different colors. Click on arrow and see both scenarios.

See this video to learn more.

ASSIGNMENT 4- Goal Seek

See the following spreadsheet. We are using the values of Principal, Rate and Time as input and finding the output simple interest using formula.

Now if we want simple interest as Rs. 500, the what will be the Time?

Objectives: To know and understand about the "Goal Seek" in Calc.

Hardware & Software required: Computer system, Windows 7 or more (operating system), Open Office Calc.

Procedure:

Steps:-

Step 1- Type the above data and find simple interest using formula. Select the data and go to Tools and select Goal Seek option.

Step 2- Enter Cell address of formula cell in Formula cell box. Fill Target Rs. 500 as interest. Enter Cell address of Time. Then Ok.

Now as were given output Rs. 500 (simple interest), now we got input as 2 (Time).

Conclusion:-

So, if simple interest as Rs. 500, then the value of Time will be 2 years.

See this video to learn more.

ASSIGNMENT 5-

..................................................................................

UNIT - 3

DATABASE MANAGEMENT SYSTEM

ASSIGNMENT 1

Create a table "Customer" using Table Wizard.

Objectives- To aware the students about the steps to create table with Table Wizard method.

Procedure-

Step 1- Open OO Base.

Step 2- Select "Create a new database" option to create a new database. Then Next.

Step 3- Select 'do not register' then Finish.

Step 4- Type the Database name 'CUSTOMER', select location Desktop and save.

Step 5- Select "Use Wizard to create table" option.

Step 6- Select the Fields for the Table. Then Next.

Step 7- Set the Fields information (Properties). Then Next.

Step 8- Select the Primary key "CustomerID". Then Next.

Step 9- Select 'Insert data immediately' Then Finish.

Step 10- Enter data in table. Save it and close it.

Result - Now table " Customers" is ready.

......................................................................................................................................................................

ASSIGNMENT 2

Create a table "Employee" using Design view.

Objectives- To aware the students about the steps to create table with Design view method.

Procedure-

Step 1- Open OO Base.

Step 2- Select "Create table in Design View" option.

Step 3- Enter fields name and Field Type. Set the properties of each field if required.

Step -4 Right click on TeacherID field and make it Primary key.

Step 5- Save the table with name "Employee". Save and close.

Result- Now you can see table "Employee" is ready. OPEN IT AND ENTER THE DATA.

..............................................................................................................................................

ASSIGNMENT 3

Create a query using Query wizard.

Create a query (Firstname and phone number from Employee table)

Objectives- To aware the students about the steps to create a query using Query wizard.

Procedure-

Step 1- Open Existing database.

Step 2- Click on query option. Then select "Use wizard to create Query" option.

Step 3- Select the Table "Employee". Select the required fields from this table. Then Next.

Step 4- Select the field for Sort by Ascending order. Then Next.

Step 5- Then Next.

Step 6- then Next.

Step 7- Type the name of Query. Then Finish.

Result - NOW QUERY IS READY. OPEN IT. YOU CAN SEE NAMES IN ASCENDING ORDER WITH PHONE NUMBER.

..............................................................................................................................................................

ASSIGNMENT-4

Create a query using DESIGN VIEW.

Create a query (Firstname and phone number from Employee table)

Objectives- To aware the students about the steps to create a query using Design view.

Procedure-

Step 1- Open Existing database.

Step 2- Click on query option. Then select "Create query with design view" option.

Step 3- Select Table "Employee" then click on Add option. Now table is added. close add Table window.

Step 4- Do the following settings.

Step 5- Click on Save option then type the name of Query.Click on OK. and close it.

Result- Now query is ready. Open it and see.

................................................................................................................................................................

ASSIGNMENT 5-

Create a Form Using Wizard.

Create a Form from Employee table.

Objectives- To aware the students about the steps to create a Form.

Procedure-

Step 1- Select forms. Then select Wizard option.

Step 2- Select the table "Employee". Select all Fields. Then click on Next option.

Step 3- Click on Next.

Step 4- Select the arrangements. Then Next.

Step 5- Select any one of these. If you select first option, then only new data or record will be entered. Old data of the table "Employee" will not be displayed.

If second option will be selected, then old data will be displayed and you can enter new data also.

Here we will select second option. Then Next.

Step 6- Select Style and Field Border. Then Next.

Step 7- Type the name of Form. then Finish.

Result - Open form and you can see already entered four records are available. you can add new Records also. These will be displayed in Table "Employee".