L-4 More on Tux Paint / Class-3 Computer

Computer Science

Class –III

Lesson 4 More on Tux Paint

A. Fill in the blanks

{ hints : paint, fill color, mascot, Undo, thumbnail }

1. Fill color  tool is used fill color in an object.

2. Tux paint has a drawing mascot  that helps us to know about Tux paint.

3. The most commonly used free hand drawing tool is the  paint  tool

4. Tux paint saves every file in the form of a thumbnail.

5. Ctrl +Z is used to perform  undo  command.

 

B. State true or false-

1. The grass tool is used to create flowers on the canvas.                                            False

2. Clicking on open will erase your current file.                                                                 False

3. The working of line tool and paint tool is exactly the same.                                    False

4. Using Magic tool, we can apply beautiful effects to our drawing.                         True

5. Tux paint is free software.                                                                                                    True

 

B. Multiple choice questions:

1. Which option allows you to save you drawing

a) Save                                                 b) Open                                               c) Quit

 

2. Which tool is used to draw and give amazing effects to a picture?

a) Paint                                                 b) Line                                                  c) Magic

 

3. Name the sub-tool using with which you can fill bricks in the picture.

a) Haze                                                 b) Grass                                              c) Bricks

 

4. Which tool is used to select by default, when we open Tux paint?

a) Paint                                                b) Line                                                 c) Stamp

 

5. Which sub-tool is used to give rain effects?

a) Text tool                                         b) Rain tool                                        c) Quit

 

A. Name the tools

1. To start a new drawing                                                        New Tool

2. To repeat cancelled action                                                   Undo Tool

3. To close the Tux paint                                                          Quit Tool

4. To apply Magical effect                                                         Magic Tool

5. To draw straight line.                                                            Line Tool

 

A. Answer in one word-

1. Tool used to save a drawing is. Save Tool

2. Tool used to write text is. Text Tool

3. Sub tool used to fill effect is. Sub Tool

4. Tool used to draw shapes is.  Shapes Tool

5. Command used to repeat last cancelled  action is  Redo Tool

 

 

Label the tools and sub tools used to make this drawing.

Ans:  Tools  and subtools used to make this drawings are :

 Rain

Flower

Grass

Rail

Bricks

Shapes

 

 Name tool used in below drawing

 Ans Grass

Bricks

Metal

Flower

 

L-4 Ms Access / Class-8 Computer

 

Computer Science

Class –VIII

Lesson 4 Ms Access

A. Fill in the blanks:-

1. Ms Access is a database  Management System

2. Hyperlink  Stores up to 1GB of data.

3. The Primary key is a unique Key.

4. The fields with this data type (text)  can have maximum of   255   characters.

5. The maximum size of a number field can be  16  bytes.

B. Write a note:-

1. OLE

Ans: This is used to embed an object created in another application, such as Microsoft word document Excel spreadsheet, or Power Point Presentation into the Access table. Stores up to 2 GB of data.

 2. Hyperlink

Ans: The Hyperlink data type can store links to web pages, web sites, files on an intranet or LAN on you computer. It stores up to 1GB of data.

 

 3. Attachment

Ans: This data type allows you to attach images, spreadsheet files, documents, charts and other types of supported files to the records in your database, much similar to the manner you attach files to emails.

 

 4. Table

Ans: It is defined as a group of related data organized in columns and rows in a datasheet. The columns contain a number of headings (such as personal number, first name, lat name, address, city, pin code, telephone numbers etc.) and are known as Fields. A set of fields comprise a record and finally, a set of similar records make a table.

 

C. Short Answer question

1. What is Database Management System.

Ans: Ms Access is a database Management package which is a part of Ms office. It provides handy tools to work with data fields that help operate, maintain and manipulate various records effectively.

 

2. State the difference between OLE and Hyperlink

Ans:

OLE	Hyperlink
This is used to embed an object created in  another application, such as Microsoft word document Excel spreadsheet, or Power Point Presentation into the Access table. Stores up to 2 GB of data.	The Hyperlink data type can store links to web pages, web sites, files on an intranet or LAN on you computer. It stores up to 1GB of data.

 

 

3. What do you mean by data types?

Ans: Data types are used to declare the fields of a table. A data type determines the type of data. A particular field can accept. Once the data type is defined, we cannot enter different type of data in it. If we try to do so, an error message will be displayed.

 

4. Explain the use of Primary key in a table

Ans: Primary key is a standard feature of every database management system. A Primary key is a short of check on the table that uniquely identifies each record in a table. It does not contain any duplicate data. A table can have only one Primary key. The value in the Primary key field is different for every record and thus helps in uniquely identifying the record.

 

5. What are the features of Ms Access.

Ans: Commonly used features in Ms Access. The frequently used of the features of Ms Access are explained below:

Table : It is defined as a group of related data organized in columns and rows in a datasheet. The columns contain a number of headings (such as personal number, first name, last name, address, city, pin code, telephone numbers etc.) and are known as Fields. A set of fields comprise a record and finally, a set of similar records make a table.

Primary key : Primary key is a unique field by which records are identified in a table. For e.&. in a table of student's record, the 'Registration Number' can be called the primary key.

Query : Query helps you retrieve information from a table as and when required. So the basis of extracting information from a database is known as 'Query'. Forms : When a query is made, the system retrieves the information from the table and makes it available to us the user. Thus, the format of displaying the information from a particular table is called 'form'.

Report : The end product of data manipulation in DBMS as per the user's choice is known as 'Report'. You may get the report as a hard copy or a soft copy. The reports are generally created after making queries on the database.

 

L 6 Mail Merge in Ms Word / Class -7

 

Computer Science

Class-VII

Lesson 6 Mail Merge in Ms Word

 

A. Fill in the blanks

task Filter Create

1. Mail Merge is an important feature of MS Word which enables us to combine files.

2. There are three documents involved in Mail Merge.

3. Task  pane appears on the right side of a screen.

4. To type a new list we can click on create .

5. Filter  option is used to sort your list according to ascending and descending

order.

B. True or False.

1. Mail Merge is the useful feature of MS Power Point                                   False

2. We can start Mail Merge by choosing Mailing tab.                                        True

3. We can insert any number of fields as per our need.                                  True

4. Preview option is used to preview our recipient list.                                   True

5. We can take print out of our document using finish and merge section. True

C. Short answer

1. Name three documents involved in mail merge.

Ans: There are three documents involved in mail merge:

1. Main document

2. Data source

3. Merged document Starting of Mail Merge

 

2. In which tab mail merge option is available.

Ans: In mailing tab mail merge option is available .

 

3. Name the types of document we are working in mail merge.(e.g. Letters)

Ans: 1) Letter

2) E-mail message

 3) Envelope

4) Label

5) Directory

 

D. Long answers

1. What is the use of Mail Merge?

Ans: Mail merge is an important feature of MS Word which enables you to combine a document with a data file. By using mail merge feature you can send the same letter to a number of persons without retyping the matter of letter again and again.

 

2. Write the steps to open mail merge.(step - 3)

Ans: Choose Mailing Tab click start Mail Merge and click Step by Step Mail

Merge wizard.

 

3. Write the steps to print your mail merge document.

Ans: Print a Merged Document

Steps to print a merged document

Step1. Choose Mailing tab and Click on Finish and Merge button. Drop down box

will appear.

Step2. Choose Print documents. A box will appear.

Step 3. Select the desired option. Click ok button and get the hard copy of your

document.

 

4. Write the steps to preview your document.(step-11)

Ans: Now click on Preview Result on Mailing Tab to preview your recipient list. To

see more recipients click on GO TO Record Navigation Bar as shown in

figure.

L1 Computer fundamental test / Class 4th

 

Class 4^th

Subject : Computer

Lesson 1 Computer Fundamental 

Revision Test

Fill in the blanks

1) Full form of OMR is _______________

2) __________________ output device allows you to hear sound.

3) Inkjet and laser are the types of _______________

4) A set of programs that enables the hardware to work in a desired manner is called _______________.

5) Mouse and light pen are called ____________ devices.

6) CPU is the _______________ device.

7) The physical parts of a computer which can be touched and seen are called _____________.

8) A _________________ is an electronic data processing device used to work on data as per instruction.

9) The printed copy of output is called the ______________.

10) _______________ is an input device, which works more like a photocopy machine.

L 2 software and its type / Class 5 Computer

 

Class 5

Class Test

Lesson 2

Fill in the blanks

1. There are two broad categories of software _____________and _____________.

2. Software is a set of ________ .

3. A set of instructions given to the computer to perform a particular task is called a computer __________.

 4. A ____________program lets you create documents such as letters and reports.

5. A collection of computer programs are called  ___________________.

6. MS Windows is example of  _________  system.

7. An ____________ system (OS) is system software. It is an interface  between the

user and the hardware and enables them to work together.

8. _________ software is the software which help you in keeping the computer parts in proper working condition.  

9. ____________software is used to create multimedia presentation.

10. A _____________ is very important software as it translates or converts a

program written in a computer language into the machine language form so that it

can be understood by a computer.

 

 

L3 Advance Features of Ms Excel / Class 7th Computer

 

Class 7^th
Subject : Computer
Lesson 3 : Advance features of Microsoft Excel

Paste and label component of Ms Excel Window

 

LearnwithMotivation

A. Fill in the blanks

Cell Chart Three Print 16384

1. There are 16384  columns in a worksheet.

2. The intersection of row and column is known as cell .

3. Chart  is a graphical representation of data.

4. There are three (3) types of referencing in MS Excel.

5. Print option is used to print a worksheet.

 

 

 

B. True or False

1. Wrap text is used to move your text in multiple lines.              True

2. In absolute referencing & symbol is used.                                False

3. Bar and columns are two types of charts.                                True

4. The cell with highlighted boundary is known as Active cell.   True

5. In relative referencing value is copied instead of formula.      False

C. Short answer type questions.

1. Write any four components of MS Excel.

Ans: 

Components of Ms-Excel are :

1. Worksheet : A worksheet is made up of rows and columns. By default, work book

has three worksheets. You can add any number of worksheets in a workbook.

2. Row Heading : Each row in excel represent a specific number and it is present

on the left side of a worksheet. There are 1,048,576 rows in a worksheet.

3. Column Heading : Each column in excel represent column heading and it is present on the top of a worksheet. There are 16,384 columns in a worksheet.

4. Cell : It is a intersection of row and column. Each cell has its unique address. Example of cell address is A1, F5 or T7. It contains letter and number.

5. Active Cell : The cell with highlighted boundary is known as active cell.

6. Name Box : It displays the location of the cell pointer.

7. Formula Bar : It shows the character or formulas that you enter in active cell

 LearnwithMotivation

2. Name three types of referencing

Ans: REFERENCING : The cell address in a formula is known as the cell referencing. By using it you can use the data in different parts of a worksheet. There are three types of referencing.

1. Relative Referencing

2. Absolute Referencing

3. Mixed Referencing

 

3. List various types of charts you use in MS Excel

Ans: There are various types of chart available in MS Excel

1. Bar chart

2. Column chart

3. Line chart

4. Area chart

5. XY Scatter chart

 6. PIE chart

7. Doughnut chart

 8. Radar chart

9. Bubble chart

 

D. Long answer type questions.

1. What is the use of Excel?

Ans: MS Excel is a powerful spread sheet component which allows us to calculate, manipulate our data. It consists of rows and columns to make our work easier.

 LearnwithMotivation

2. Differentiate between ROW heading and COLUMN heading.

Ans: Row Heading : Each row in excel represent a specific number and it is present on the left side of a worksheet. There are 1,048,576 rows in a worksheet.

Column Heading : Each column in excel represent column heading and it is present on the top of a worksheet. There are 16,384 columns in a worksheet.

 

3. Write the steps to apply WRAP TEXT?

Ans: Steps to apply Text Wrap

Step 1. Click on the cell in which you want to move the text in next line.

Step 2. Select HOME button choose WRAP TEXT on Alignment group. Now your text will represent in multiple lines.

 

4. What is chart? Also draw diagram of any two types of charts after seeing in your computer.

Ans: CHARTS : Charts are the graphical representation of your worksheet data. It make it easy to represent our data in comparison manner or to show it in relational manner.

 LearnwithMotivation

 

 

 

L-3 Advance feature in Ms Word/ Class-5 Computer

 

Class -5^th

Subject computer

L- 3 Advance feature in Ms Word

A. Fill in the blanks:

clip art, word art, file, text formatting, arrows, add text, callouts

1. Pictures can be imported into Word document from File  from

Clip art or from other software.

2. Word Art is a set of predefined text formatting.

3. If you want to write in the Auto shape object, right-click inside the shape and select the option add text .

4. Word art allows you to create text effects that are not available through font formatting.

5. The auto shapes menu contains many categories of  arrows,

flowchart elements, stars and callouts .

B. Write the steps to insert the following:

1. Word Art

Ans: To insert the WordArt:

Step 1 : Click on Insert tab.

Step 2 : Click on WordArt under text group.

Step 3 : Select a style and click on it.

Step 4 : The “Edit WordArt Text” dialog box

appear, type the text you want to insert in the

document.

Step 5 : Click on OK.

 

2. A picture from file :

Ans: To Insert A Picture From File:

Step 1 : Place your insertion point where  you want the image to appear.

Step 2 : Select the Insert tab.

Step 3 : Click the Picture command.

Step 4 : Select the image file on your computer.

Step 5 : Click on Insert and it will appear in your document.

 

3. Clip Art

Ans: To Insert Picture from Clip Art:

Step 1 : Place your insertion point where you

want the image to appear

Step 2 : Click on the Clip Art command from

Insert tab.

Step 3 : The clip art option appears in the task

pane on the right

Step 4 : Enter keywords in the Search for: field

that is related to the image you want to

insert.

Step 5 : View the various Clip Art images using vertical scroll bar and click on the

desired Clip Art image to insert.

 

4. A shape

Ans: To insert a shape in document:

Step 1 : Click on the Insert tab.

Step 2 : Click on the Shapes Option.

Step 3 : Click a shape from the menu. Your

cursor is now on cross shape.

Step 4 : Click your mouse and while holding

it down, drag your mouse until the

shape is the desired size.

Step 5 : Release the mouse button.

 

C. State True or False:

1. The intersection of a column and row is called table. True

2. The Word Art button is available in Home tab. False

3. You can copy a symbol only for once. False

4. You cannot write text in shapes.  False

5. The Clip Art folder contains readymade pictures or graphics. True

 

 

 

A. Answer in one word:

1. Which option allows you to visually communicate information rather than  simply using text?

Ans: Smart Art

 

2. Name the gallery of text styles used for adding special text  effects.

Ans: Word Art

 

3. Which tab contains Clip art option.

Ans: Insert Tab

 

4. Write two methods of inserting pictures in a document.

Ans: a) From File , b) From Clip art

 

B. Answer the following Question:

1. What is Word Art?

Ans: Word Art is a set of predefined text formatting.

 

2. What is Smart Art?

Ans: Smart Art allows you to visually communicate information rather than simply using text.

 

3. Write the steps to fill color in shapes.

Ans: To Insert A Table :

Step 1: Click on Insert tab.

Step 2 : Click on Table from tables group.

Step 3 : Click on Insert table option.

Step 4 : Enter the number of columns and rows you want to insert in your table  from the insert table dialog box.

Step 5 : Click on OK button.

 

4. Write the steps to insert a Table in document.

Ans: To fill color in Shapes:

Step 1 : Select the shape. A new Format tab  appears with Drawing Tools.

Step 2 : Click the Shape Fill command to  display a drop-down list.

Step 3 : Select a color from the list, choose No  Fill, or choose one of the other  options.

 

5. How can you give 3D effect to a shape?

Ans: To change 3D effects :

You cannot add a 3D effect to all shapes.

Step 1 : Select the Format tab.

Step 2 : Click the 3-D Effects command.

Step 3 : Click an option to select the 3D effect.