KEMBAR78
Computer Language | PDF | Microsoft Excel | Assembly Language
0% found this document useful (0 votes)
27 views29 pages

Computer Language

The document provides an overview of computer languages, categorizing them into Machine Language, Assembly Language, High-Level Language, and Fourth Generation Language, along with their features. It includes fill-in-the-blank exercises, true/false statements, multiple-choice questions, and application-based questions related to the use of Windows 7 and Microsoft PowerPoint 2010. Additionally, it covers concepts such as mail merge, data sources, and the functionality of various software tools.

Uploaded by

Juhi Jaiswal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
27 views29 pages

Computer Language

The document provides an overview of computer languages, categorizing them into Machine Language, Assembly Language, High-Level Language, and Fourth Generation Language, along with their features. It includes fill-in-the-blank exercises, true/false statements, multiple-choice questions, and application-based questions related to the use of Windows 7 and Microsoft PowerPoint 2010. Additionally, it covers concepts such as mail merge, data sources, and the functionality of various software tools.

Uploaded by

Juhi Jaiswal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 29

Kumar (Computer Teacher)

Computer Language

Feature of Computer Language

Name of Language Feature of Language

· Uses binary codes to depict operators and data

Machine Language · Machine – Dependent

· Only language directly understood by a computer

· Mnemonic codes or symbols instead of binary Numbers.

· Machine- Dependent
Assembly Language
· Has to be converted into Machine language by translator
programs (Assemblers)

· Uses English words and mathematical operators.

· Machine- Independent.
High Level Language
· Has to be converted into Machine language by Translator
programs (Interpreters and Compilers)

· Machine Independent.

4GL · Minimal user skills required to obtain results

· Application development tool

1. Fill In the Blanks:


2. A Program is a set of instruction which tells the computer what to do.
3. The development of computer languages can be classified into four categories.
4. Machinelanguage consists of seat of binary numbersi.e.0 and 1.
5. spacewar wasthe first interactive computer games.
6. 5. HLL uses simple English words and mathematical operators.
7. Assemblylanguage uses mnemonic codes or symbols.
8. LISP was the first computer language for writing artificial intelligence programs.
9. In binary language, 0 means OFF and 1 means ON state.

State True and False:

1. Machine language is the only language which a computer understands. (True)


2. machine language uses mnemonic codes (False)
3. Each programming language has its own specific rules. (True)
4. Compiler converts a high level language program into machine language , line by line. (False)
5. High level language program has to be converted into machine language by translator
programs. (True)
6. Fortran language was designed for business users. (False)
7. Programming is the process of writing specific instructions in a computer language. (True)
8. Machine language uses mnemonic codes. (False)

Multiple Choice Questions:-

1. A program written in the assembly language is called _____________ .


2. A) Assembler b) Source Program c) Object Program [b]
3. An _________ converts a high leavel language program in to machine language , line by line,
4. A) Assembler B) Complier C) Interpreter [C]
5. The program converted into machine language by the translator is called________.
6. a) Source program b) Object Program c) Assembler [C]
7. The term software was first used by ____________ .
8. a) John Mc Carthy b) John W. Tukey C) John von Neumann [B]

Application based Question.

1. 1. Kapil’s aunt was a computer program during the third generated of computer language.
Which kind of language did she use them?

Answer:- HLL (High Level Language)

Q.2. Sumit is trying his hand in java programming , but he does not know which type of
language it is. Help him to solve his Query.

Answer:- HLL (High Level Language)

Answer the following :-

Q.1. What do you mean by Machine Language?

Answer> Machine language that can be directly understood and obeyed by a machine
(Computer) Without conversion (Translation).

Q.2. How is Assembly language different from Machine language?

Answer:-
Machine Language Assembly Language

An assembly language program is


The language provides a way of entering
translated machine language by
instruction in to computer
assembler .

Q.3. What are the feature of High Laver Language.

Answer

 Uses English words and mathematical operators.


 Machine- Independent.
 Has to be converted into Machine language by Translator programs (Interpreters and Compilers)

Q.4. Differentiate between an interpreter and a compiler.

Answer:-

Interpreter Compiler

An interpreter translates line by line, Compiler is a translator used to


executes the instruction and then repeats convert a high level language program
the procedure for remaining instructions. in to machine language.

Q.5. List any three characteristics of the Fourth Generation language.

Answer:-

 Highly user friendly and independent of any operating system.


 Very high speed of execution. Designed to recue level of programming efforts.
 Minimum efforts from the user to obtain any information.

Lesson:- 2

More on Windows 7

Fill in the blanks:

1. Microsoft Windows Media Player is used to run and organize digital media files on a
computer.
2. Ripping refers to Copying songs from a CD to a computer.
3. Windows 8 is the latest version of Windows.
4. Windows Mobile software empowers advanced devices that allow the users
to Send and receive e-mail and browse the internet.
5. In Pictures folder, you can store digital photos images and graphic files.
State True or False:

1. Windows 8.2 is the forthcoming version of Microsoft’s Windows Operating system. False
2. Disk Cleanup is used to remove the unnecessary files from a computer hard disk. True
3. Sound recorder facility is available in Windows Media Player folder. False
4. Windows 7 allows the users to display two windows side by side. True
5. Burning a CD and ripping a CD is one and the same thing. False

Multiple Choice Questions:-

1. To free up disk space and help your computer to run faster, use_________ .

(a)Windows Media Player (b)Disk Cleanup (c) Windows Media Center


[B]

2. The ________ feature allows you to turn the open windows transparent and makes desktop
screen visible.

(a) Aero Peek (b)Jump Lists (c) Windows Media Center [A]

3. _________ is a new feature in windows 7 which takes you right to the documents, Pictures
web site that you use frequently.

(a) Peek (b)Rip (c)Jump List [C]

Application Based Question:-

Qus. 1. Satita want to record her voice into the computer. Which device will you suggest her to
use to perform the operation

Answer:- Suggest for Sound Recorder system.

Qus.2. Kritika has made her computer project. She has saved it on her computer, but forgot the
location where she had saved it. Suggest her best way to search her project.

Answer. Click on Start Button. Go to Run and type the name of project and press enter
key.

Answer the following :-

Q.1. What do you understand by Windows Media Player?

Answer:-Windows Media Player (WMP) is a software application from Microsoft used to play,
store and organize digital audio, images and video. While earlier editions of WMP were released
for PC s running a variety of operating system operating systems, including Windows Mobile.

Q.2. Differentiate between ripping and burning features.


Answer:- “Ripping” refers to extracting audio files off a CD and copying them to your hard
drive. After ripping the audio, you can then convert the files to the more compressed MP3 format
if you want.

“Burning” refers to the process of writing data onto a CD. You can burn both audio and data
CDs, as well as DVDs, provided your computer has a CD/DVD burner.

Q.3. What is the utility of windows media Center.

Answer:- It can play and record live television, and organize and play digital images, music and
video. Media Center can play slideshows, videos and music from local hard drives, optical drives
and network locations.

Q.4. How will you display two application windows side by side?

Answer:-Click and Drag on the top title bar of the first window so your mouse pointer hits either
the left or right side of your screen. Let go of the window when you see the outline of the
window re-size to ½ of the screen.

Then choose the other window you want to view on the side of the first window. Click and Drag
the 2nd window to the opposite side of the screen until the mouse pointer hits the side of the
screen and resizes to the other ½ of the screen.

Q.5. What is meant by the term disk cleanup?

Answer:-Aside from removing unnecessary files, users also have the option of compressing files
that have not been accessed over a set period of time. This option provides a systematic
compression scheme.

Lesson 3.

Using Mail Merge

Fill in the Blanks:

1. Main document contains the text that we send to all the recipients.
2. Tab key helps us to move between fields while typing the data.
3. The data is organized in tabular form along with the Field name.
4. A Tick mark gives an indication that a record is selected.

State True or False:-

1. Data sources the text that we wish to send to all the recipients. [True]
2. Field is a column in a data source that contains one type of information. [True]
3. Merge field is the feature that is used to combine a recipients list with a main document.
[ False]
4. Preview Results option on Mailings tab displays the first record from the data source. [True]
5. The two main components required during a mail Merge process are the main documents
and merge field. [ True]

Multiple Choice Questions:-

1. _______________ is a row on data sheet, which consists of a number of fields.


2. A) Field b) Record c) Database [B]
3. ______________ is the data item, which instructs Microsoft word where to insert the data
source information in the main document?
4. a) Data Source b)Merge Field c) Main Document [C]
5. To create a new Recipients list, Select ___________ radio button under select recipients
section.
6. a) Using an existing list b) Select from contact c) Type a new list [C]

Application Based Question:-

Q.1. Radhika has purchased a brand new luxury car. She wants to celebrate her happiness with
her friends and relatives. She wants to extend personal invitation to each one of them without
typing their name and address time and again. Which method could she use to fulfill the
requirement?

Answer:- Mail merge Method

Q.2. Suchitra is an office assistant and handles all the correspondence work of the company. This
month her company has made five new clients. Where will she add the contact details of these
new clients while using the mail merge feature?

Answer:- Insert Merge Field.

Answer in one word or one sentence.

Q.1. IN Mail Mergewhere do we organize data in tabular form along with the field names?

Answer: Data Source

Q.2. which tab do you select to execute Mail Merge option?

Answer: Maligns tab

Q.3. Name the button that is used to further select the option for printing a document.

Answer:- Print Document.

Q.4. Where do you enter the records that are to be associated with the main document.

Answer:- Data Source.

Answer the following:


1. 1. What do you understand by the term Mail Merge?

Answer: Mail Merge feature is used to combine a data source with the main document.It saves
our time and energy to send letters at multiple addresses

Q.2. Name the documents that are combined while using Mail Merge Feature.

Answer:- You use mail merge when you want to create a set of Main Documents, such as a form
letter that is sent to many customers. Each document has the same kind of information, yet some
of the content is unique. For example, in letters to your customers, you can personalize each
letter to address each customer by name. The unique information in each letter comes from
entries in a data source.

3. 3. Define the Term Data Source.

Answer:Data source consists of mailing list. For example, Name, address, City, Pin, Tele.
Number, etc

Q.4. what is main document?

Answer:- It contains the text that we wish to send to all the recipients.

Q.5. How Will you create a recipient list for the main document?

Answer:- It contains the text that we wish to send to all the recipients.

Lesson 4.

Microsoft PowerPoint 2010

Fill in the Blanks:

1. We specify number of rows and columns in the Inset Table dialog Box.
2. Insert above option is present on the _Layout tab under table tools tab.
3. The Draw Borders tools is used to apply different background colours in a table.
4. The Plot Area is a window within the Chart Area that contains the actual chart itself.
5. Data series are the bars that show the data value.
6. The pen Weight tool in present in the SHADING group.

State True or false:

1. To insert a table in a presentation we should use title slide layout. False


2. Text can be entered in a table by clicking on the desired cell. True
3. Multiple rows can be added in a table. True
4. The border of a table can’t be modified. False
5. When we insert a chart, the data is also displayed in a special window called datasheet. True
6. We can’t delete the entire data of a datasheet. False
7. The text is aligned to the top of a cell by default. False
Multiple Choice Questions:

1. Intersection of a row and a column is called a ____________ ..


2. A) Cell Border b) Table c) Cell [C]
3. ________ depicts the pattern, color or the symbols, which are assigned to the data series.
4. a) Chart area b)Legend c) Plot Area [B]
5. ………………. Refers to the positioning of text in a table cell.
6. A) Alignment b) Formatting c) table Style [A ]
7. After inserting a table in PowerPoint 2010, the _________ tab appears automatically.
8. A) Table b)Table Tool d)Table Style [ B ]
9. In Microsoft PowerPoint 2010, Chart button is present on the _________ tab.
10. a) Home b)Design c)Insert [ C ]
11. There are _________ alignment buttons on the layout tab.
12. a) Four b) Six c) Three [B ]

Application Based Question:-

1. Rajiv has created a presentation of 5 slides in Microsoft Power Point. In all the five slides he
has used only text . He wants to add one more slide, in which he would insert chart and
clipart. Suggest him as to which type of slide layout should he use for the same.

Answer:- Title and Content

2. Sumit is working in Microsoft PowerPoint 2010. He has created a table of 4 row and 5
columns. But later on he realized that he needs one more row in the same table . Help him by
suggesting the correct option to perform this task.

Answer:- Right Click on table, Go to Insert Option, Click on insert row Above/Blow.

Answer the Following:

1. Explain any two methods to insert a table in presentation.

Answer:- Method 1.

1. A) To insert a table, click on the new slide drop down arrow on the Home tab. Select the Title
and Content layout.
2. B) Click on the Insert Table icon present on the slide the insert table dialog box will appear.
3. C) Define the Number of columns and rows. Click OK

Method 2.

Click on the Insert table and select Table option to draw a table.

2. Describe the method to add rows in a tables


Answer:- To add row in a tables.

 Place the insertion point in a cell.


 Click the right mouse button.
 Select the insert option, and click either on the Insert Rows above or Insert rows below sub-
option. You can also select any of the option from the a layout tab.

3. How can you apply border to a table and change its color.

Answer. Select cells, rows, columns you want to modify. Click on the Border button in the table
styles group on the design tab. Select the all borders option from the drop down menu. Border
will be applied on the selected cells rows columns.

4. Name all the six alignment buttons present on the layout tab.

Answer:- 1. Align Text left, 2. Center, 3. Align text Right,

4.Aligh left Top 5. Center Vertically 6. Align Right Bottom.

5. Differentiate between Category Axis and Value Axis.

Answer:-

Axis Value Axis

Axis or X-axis is the horizontal axis. The


Value axis or Y- axis is the vertical axis that
matter that is compared and presented
is used to plot the values.
in the chart comes under

6. Define the term Chart. Name the components of a chart.

Answer:- Chart is and effective way to display data in a graphical and pictorial form. Charts
make it easier to show comparisons and growth, relationship among the values and trend in data.

7. How will you delete the default data of a datasheet?

Answer:- You can replace the default data with your own data. To delete all the data from the
datasheet, move the mouse pointer to the Blank Button (Upper left corner of the column
indicators). The Mouse Pointer changes into a large plus sign

8. Explain the Method to Change a Chart type.

Answer:-Change the chart type as needed

o Select the Chart. Click on the design tab under Chart Tool.
o Click on the Change chart type button in the type group. Change chart type dialog box will
appear select any chart type and click OK. The chart will change accordingly.

Lesson 5

Animation text and object

Fill in the Blanks:

1. Transition are the special effects. you see when one slide changes to another in slide show
view.
2. Animation effects can be applied on both Text and Objects on a slide.
3. Action Button is a readymade button for defining hyperlink on a slide.
4. It is essential to connect a Microphone to the computer while recording your sound.
5. Play button is present on the start slide show group.
6. Click on the From Beginning button to start the sound.

State True or False:-

1. Action Button can be used to link any other application to the current slide. True
2. We can ass sound to text or graphics in a presentation. True
3. Video clips can be added to a slide by selecting the Home tab. False
4. We can choose transitional sound effects from the transition sound drop down arrow. True
5. Transition effects give motion to the text and pictures. False
6. Media group is present on the insert tab. True
7. The speaker icon in a slide can’t be moved or resized. False

Multiple Choice Questions:-

1. Transition effects can be seen in ________ view.


2. Slide Sorter b. Notes Pages c. Slide Show [ C ]
3. __________ effects can be added to objects on a slide.
4. Animation b. Transition c. Sound [ A ]
5. The recorded sound files are assigned the extension____________.
6. .midi b. .wma c. .wav [ C ]
7. The animation pane button is available on the tab.
8. Slide Show b. review c. Animations [ C ]

Application Based Questions:-

1. The teacher has asked kabir to open a blank slide and write a paragraph on the ‘Save
Environment’. He is also being given instructions not to use any text placeholder in it. Suggest
him as to how he can enter the text on a blank slide

Answer:- Insert Text Box


2. Priya has made a project on “Child labour-A Curse” With 20 slides in it. She wants to import
data from Microsoft Word file. Suggest her option using which she can fulfill the task.

Answer:- Outline in document view group in MS word

Answer the following

1. What do you understand by Animation? How is it helpful in a presentation?

Answer:- The ability to move objects like text, Graphics, logos, charts etc, in any direction of the
slide is called animation.

Animation is quite beneficial when you wish to focus on important points , it also controls the
order of flow of information and helps in increasing the interest of audience.

2. What is meant by Transition?

Answer:- Transition effect appear when one slide changes to other during slide show view. You
can apply transition effects to a single slide as well as to all the slides.

3. How will you insert your own sound in presentations?

Answer :- Sound file can be added from the files stored on your computer.

 Select the slide where you want to add sound


 Select the insert tab, click on Audio drop down arrow in the media group. Choose the Audio
from file option from the menu. The insert audio dialog box will appear. select the location,
click on audio file then apply and ok

4. What is an action Button? Why do we use it in a slide

Answer:- Action buttons are built in button shapes the that you can add to a presentation and set
to link to another slide play a sound or perform some other action.

Lesson 6

Microsoft Excel 2010

Fill in the Blank.

1. By default, a workbook contains three worksheets.


2. Merge & Center button places the contents in the centre of the cells across a number of
columns/ rows.
3. Formula bar shows the data and formulas entered in an active cell.
4. A worksheet becomes active by clicking on the Sheet tab
5. Name box is present above the column heading.
6. The Tab scrolling buttons to the left of sheet tabs let you move through the worksheet
quickly.
7. Pressing the F12 key opens the Save as dialog box

Statement True or False:

1. Microsoft excel is the most suited program for documentation. True


2. A workbook can contain any number of worksheets according to a user’s need. True
3. Letters A to Z , AA to AZ are the row heading. True
4. Status bar includes the name of the currently selected command or current activity. True
5. Data can’t be entered in an active cell. False
6. Arrow buttons present on the worksheet tab allow the user to switch between
worksheets. True

Multiple Choice Questions:

1. In Microsoft Excel, ________ button is used to perform addition of a ranges in a cell.


2. Sum b. AutoSum c. Addition [ B ]
3. By default the text data is _______ aligned in a cell.
4. a. Left Center c. Right [ A ]
5. In a worksheet there are rows.
6. 16384 b. 104850 c. 1048576 [ C ]
7. _________ box shows the address of an active cell
8. Cell b. Name c. Formula [ B ]
9. A formula starts with ________ sign.
10. Equal to(=) b. Plus(+) c. Minus(-) [ A ]
11. We can enter……..type to data in a worksheet.
12. Two b. Three c. Four [ B ]

Application based Question:-

1. The Class teacher has asked Pallavi to create a worksheet displaying the time table of the
class. She has also asked he to save it with the name of her choice e and further rename the
worksheet by specifying the name “ Time Table” Suggest her the method to rename the
worksheet.

Answer:- Right Click on sheet1, and Rename

2. Rohit,s father has given him Rs. 500 for his pocket expense. He has asked him to maintain the
expenses in an excel sheet and show it at the end of the month. Suggest him the method to
calculated the total expensed and find the amount left with him.

Answer:- Auto sum

Answer the following:


1. What do you understand by Microsoft Excel?

Answer:- Microsoft excel is one of the Most Popular spreadsheet software. It is widely used to
perform mathematical calculation.

2. Differentiate between a workbook and a worksheet.

Answer:-Workbook:- the excel window that appears on the screen is called a workbook.

Worksheet:- A worksheet is a grid like area made up of rows and columns where you can enter
and work with data by default and excel workbook display 3 worksheet at the bottom, with the
name Sheet1, Sheet2 and Sheet3 .

3. What is cell? How many characters can a cell contain?

Answer:- A cell is an intersection of a column and row in a worksheet. Each cell is denoted with
a cell address. A cell can contain up to 32767 Characters.

4. What is a formula Bar? How is it different from the Name Box?

Answer:-Formula Bar:- the Formula bar is located to the right of the name box. This bar shows
the data and formal as that you enter in an active cell.

Name Box:- Name box is located just above the column heading on the left side on the window.
This area displays the location the cell pointer.

5. How many types of data can be entered in an excel sheet? Explain each type briefly.

Answer:- There are three type of entered in Microsoft excel sheet.

1. Number:- Numbers are values that consist of numerals from 0 to 9 and the characters
like+,-,,,,!.@.$.%,^,& etc are included in numeric data.
2. Text:- Text data can contain alphabets Numbers, spaces and special characters. Text data is
not used in calculations.
3. Formulae :- A Formulae is a mathematical equation involving number values operator and cell
addresses used for performing calculation on a worksheet. Formulae begin with and equal to
(=) sign.
4. How can you rename a worksheet? Explain.

Answer:- Reaming a worksheet.

1. To rename a worksheet double click the sheet tab you want to rename. It will be highlighted.
2. Type a new name and press enter key.

Lesson 7

EDITING A WORKSHEET
Fill in the blanks:

1. The appearance of date and time on the worksheet depends on the Format applied to the
cell.
2. To repeat most commands or actions, press F4 function key.
3. To go to a specific cell, press F5 function key.
4. Enter and cancel buttons appear on the Formula Bar.
5. When you use F2 key for modification, the insertion point appears at the end of cell entry.
6. To enter date and time together, separate them with space.

State True or False

1. Copying refers to placing data from one place to another. True


2. Ctrl + A key combination is used to select a row. False
3. Auto Fill is a feature to copy data simply by dragging the fill handle to the cells to be filled
in. True
4. To turn on Overtype mode, press the inset key from the keyboard. True
5. Copy, Cut and Paste button on the Insert tab. False
6. To insert a new column in Excel sheet, select Add button on the Insert tab. False
7. You can edit the contents of a cell in the Formula Bar. True

Multiple Choice Question:

1. ………………. Function key is used to repeat most command or actions.


2. F5 b. F4 c. F2 [ B ]
3. Ctrl + V key combination is used to …………..the cell contents.
4. Undo b. Paste c. Cut [ B ]
5. When you finish editing within a cell, Excel returns to ……….. mode.
6. Edit b. finish c. Ready [ A ]
7. To select a range, hold down the …………….. key and click on adjacent cells.
8. Shift b. Ctrl c. Alt [ B ]
9. ………………. Is the shortcut key to undo the last action.
10. Ctrl + Z b. Ctrl + Y c. Ctrl + X [ A ]
11. To enter the digits as text, you have to begin the entry with an …………. Marks.
12. Question b. Apostrophe c. Exclamation [ C ]

Application Based Question:-

1. Ritu has created progress reports on the students of her class in Microsoft Excel 2010. But she
has forgotten to add and important column in the table. Suggest the option that will help her
to insert a new column without disturbing the existing table settings.
Answer:- Home – insert sheet column option.

2. Surabhi wants to reduce her weight. her dietician has suggested her to maintain a weekly diet
chart. What method should she follow to fill week days automatically in the table?

Answer:- Auto fill method

Answer in one word one sentence:

1. What is the function of clear button in editing group?

Answer:- Clear all.

2. Which function key is used to edit the cell contents?

Answer:- F2

3. How can you enter data and time together in a cell?

Answer:- Formatting cell

Answer the following:-

1. How will you make modification in cell contents using edit mode?

Answer:-Change the cell contents by pressing F2 key after selecting the cell. The cursor will
blink at the end of the cell contents.

o Select the cell . double click inside the cell. The data is also displayed n the formula Bar.

o Note that the edit mode in indicated on the left side of the Stratus bar.

o Position the pointe at the desired place and change the contents.

2. Explain the method to insert multiple columns in a worksheet.

Answer:-To insert a blank cell/column/ row , fight click on the cell and select the Insert option
from the pop-up menu and select the desired option from the insert dialog box.

3. What is the function of undo and redo commands?

Answer: The shortcut keys Ctrl +Z for Undo and Ctrl + Y for Redo actions.

o Some action can’t be undone , such a click in any command on the file tab menu. If you can’t
undo and action, the Undo button changes into can’t Undo.
o Some action, such as using a function in a cell can’t be replaced. If you can’t repeat the last
action, the Redo button changes into can’t repeat.

4. How will you select a range and non-adjacent cells in a worksheet?

Answer:-To insert non adjacent columns, hold down the Ctrl key while you select non adjacent
column.

5. How will you move data in a worksheet using dragging method?

Answer:- Select a cell or a range of cells. Position the mouse pointer at the edge of the selected
cell. Notice that the pointer change from a white cross symbol to move pointer symbol. Drag the
selected cell or a range of cells to a new destination, and release the mouse button. the data will
be moved to a new location.

or

select data (Moving data) go to top right of select data. Your pointer make + point drag your
mouse and move your data.

6. Explain any two methods for copying data.

Answer:- Methods 1. Select the cell range. Click on Copy button in the clipboard group. Click on
cell and click on paste button.

Methods 2. Select the cell. Press Ctrl + C, and go to Past location, press Ctrl + V,

7. What is Auto Fill? How can be applied?

Answer:- Auto Fill is the easiest method to fill data in class automatically.

o Type January in cell ……

o Position the pointer at the lower right corner of the cell.

o The Mouse pointer at Changes in to think blank “+” cross.

o Hold down the left mouse button and drag the fill handle up to cell……. . (up to fill) . release
the button.
Term II

Lesson 8

LOG ON TO FLASH CS3

FLASH:- Flash is an animation software package. Flash provides a versatile and easy way to
create animation. We can make any object in Flash with animation and make movies with sound
and action.
Qus:- 1 What is Flash? What are the main parts of Flash working environments?

Ans:- Flash is an animation software package. Flash provides a versatile and easy way to create
animation. We can make any object in Flash with animation and make movies with sound and
action.

Main parts of Flash:- Stage, Menu bar, Tools Panel, Time Line and Properties Panel.

Qus 2 :- What are the Difference between Stroke and fill Color?

Ans:- Stroke color:- This color is used in drawing pencil, brush or in line. It is an out liner color.

Fill color:- it is used to fill the color in any shape or figure and solid shape .

Qus.3. What are the three modes of pencil tool? Explain any one.

Ans:- Straighten:– the default option is straighten. Straighten mode automatically straighten the
line drawn by the pencil tool .

Smooth:- Smooth mode smoothens the jerks on the edges.

Ink:- Ink Mode helps in freehand drawing with no modification applied.

Qus. 4. What are the options of the eraser Mode Modifier? Explain any two briefly.

Ans: – The different Mode Modifier.

Erase Normal= eraser all line and fills wherever the erasers is moved.

Eraser fills= Eraser only the fill colors while lines are unaffected.

Eraser lines= it is used to eraser the strokes only.

Eraser selected fills= Help in erasing a selected part of an object.


Eraser in side= Erases the inner part of an object

Qus No 5. What is keyframes?

Answer:- Key frames are special types of frames where we can define change in the object for an
animation, like position, Color, shape, etc.
Fill in the blanks.

1. Stage is the area where we create our drawing.


2. Timeline is the area where graphics and elements are assembled in sequence.
3. Polystar tool is used to draw a star with five sides.
4. Control > Test Movie option is used to preview the animation.
5. Straighten is the default mode of the Pencil tool when it is selected.

State True or False:-

1. The Rectangle tool is used to draw polygon and star figures. True
2. Text tool is used to type text on the stage. True
3. To change the color style of lines, select stroke style option in the Property
Inspector. True
4. The Fill color tool is used to fill object with colour . True
5. The Shortcut key for Pencil Tool is P. False

Application Based Question:-

1. Sumit has to make a greeting card. He wants to draw flowers. Which tool will you suggest him
to use?

Answer:- Pencil Tool.

2. Kartik has drawn a Beautiful scenery. He wants to group the objects but he does not know
how to do it. Suggest him the right option to fulfill the task.

Answer:- Select the part of Objects.

Multiple Choice Question:-

1. Ctrl+G key combination is used to group the selected object.


2. F6 Function key is used to insert a keyframe.
3. Pencil Tool is used to draw precise Paths as straight lines or smooth flowing curves.
4. Ctrl+B Key combination is used to break apart the stroke and fill color.

Lesson 9:- Working with Flash CS3


Fill in the Blanks:-

1. A Symbol is a reusable graphics of static image.


2. There are three type of symbols.
3. Morphing refers to special effects in animation that change one shape into another shape.
4. The shortcut to convert any object into symbol is F8.
5. There are two type of tweened animation.

State True or False:

1. Flash stores symbols in the library. [True]


2. Motion Tweening works on symbols. [True]
3. Shape Tween works if the object in convert into symbol. [True]
4. The property Inspector in Flash displays all the information regarding the object which is
selected. [True]
5. We cannot Edit the properties of graphic symbol. [True]

Multiple Choice Question :

1. Ctrl + L is the shortcut key to open the library dialog box.


2. Ctrl +M b. Ctrl+ L c. Ctrl+ D [B]
3. To preview the animation effect, press Ctrl + Enter key combination.
4. Ctrl + Shift b. Ctrl + Enter c. Ctrl + Alt [B]
5. Motion Guide Layer defines the path of the movement of and object.
6. Motion tween b. Shape Tween c. Motion Guide Layer [C]
7. Library is the store house of symbols.
8. Property b. Library c. Timelines [B]
9. Movie Clip option is selected by default in the Convert to symbol dialog box.
10. Movie Clip b. Graphic c. Button [A]

Qus.1. What is symbols? Name the type of symbols.

Answer. Symbols is a reusable object for static images or animation . They are either created
with the help of drawing tools or imported from other sources.

Quss. 2. What do you understand by instance?

Answer:- Instance is a copy of the original symbol. The size, color, shape and position can be
altered without affecting the original symbol.

Qus. 3. What do you understand by the term animation?

Answer:- When a series of images appear in a fixed interval of time, then it appears to show
some movement this can be termed as animation.

Qus.4. Why do we use motion guide layer?


Answer:- Motion guide layer are used to draw a path which is being followed by the object
while in motion.

Qus. 5. How do you convert an object into a symbol? Explain briefy.

Answer:- When you change the shape of one object in to another. Shape tween does not work if
the object is converted into symbol. You can create a wonderful morphing effect by using Shape
Tween. Say , we have a box and want to make it appear to changing in to a circle. In this case ,
we need. Two shapes . namely a square and circle to be drawn in different frames at a different
point of time.

Qus. 6. What is Tweening ? What are the different types of Tweening ?

Answer:- Animations can be created in flash with the help of tweening which means “ in
between”.

There are two type of tweened animation (1) Motion tween (2) Shape tween.

Main difference of tween


(1) Motion tween :- Motion tweening work on symbols.

(2)Shape tween:- Shape tween is used with objects that are not symbols and are ungrouped.

Lesson 11:- Introduction to QBasic

Fill in the Blanks:-

1. The value which does not change during the execution of the program is called CONSTANT.
2. A CHARACTER SET is a set of symbols which are used in a programming language.
3. The hierarchy in which the operators are executed in Basic expression is called BEDMAS.
4. Numeric constants contain only NUMERIC VALUE.
5. String constants must be enclosed within DOUBLE QUOTES.

State True or False:-

1. A string variables is represented by an alphabet followed by dollar ($) sign. [True]


2. Variables are of three type. {False]
3. Constants are memory locations to store data in it. [ False]
4. Numeric constants include all the positive and negative numbers. [True]
5. The variable name must begin with a number.[False]
6. X = 1.3 is a valid statement. [ True ]
7. 22.4.43.6 are examples of whole numbers. [False]
8. Addition and subtraction operations come first in basic hierarchy. [False]

Multiple Choice Question:-

1. ____________ sign is added at the end of a String variable. A. ($)


2. Which is the correct numeric expression? B. [A1$ = 52]
3. ___________ key is used to switch from one mode to other in QBasic. B. (F5)
4. The extension of a QBasic program file is ___________ . C. (.bas)
5. QB64 was developed by __________. B (Galleon)

6 To hide the welcome dialog box , press ___________ key. B. (esc)

Answer the following in a sentence:

What is Full form of BASIC

Beginners All Purpose Symbolic Instruction Code.

What are the different type of Constants?

There are two type of Constants

(1)Numeric Constants

(2)Alphanumeric or String Constants

Given Two examples of both numerical and alphanumeric constants.

Numerical (1)224, (2)+12

Alphanumerical (1) “AGAM” (2) “SUM = Rs84”

Which operator is used to represent ‘less than or equal to’ condition

Relational Operators.

Which statement is used to display the output on the screen?

Print Statements.

What are the type of operators in QB64?

There are three type of operator

Who developed BASIC language?

Professor John G. Kemeny and Thomas E. Kurtz.

Answer the following

Q.1.Define QB64 language.

Ans. BASIC is a programming language use for beginner. It is very easy and simple to
understand.
Q.2. Write the different ways to run a QB64 program.

Ans. 1. By pressing F5 key.

2. By selecting Run menu and clicking on the Start option.

Q.3. Define Variables. Name the types of variables.

Ans. A variable is a location in the memory, which has been assigned a name, and is used to
store data temporarily. It continues to hold the value until another value is assigned to it.

Two type of variables; 1. Numeric variables 2. Alphanumeric or String Variables.

Q.4. Differentiate between Numeric and Alphanumeric Constant.

Numeric Constant Alphanumeric Constant

Alphanumeric constant consists of a sequence of


These constants are used for calculations and
characters and certain special symbols enclosed in
should not include any special character.
double quotes.

Q.5. Define the term Hierarchy of operation. Write the hierarchical order of the arithmetic
operators in QB64.

Ans. Hierarchy define the order in which the operators are executed in any QBASIC expression.
We use BEDMAS for the hierarchy of operation.

B Brackets ()

E Exponentiation ^

D Division /

M Multiplication *

A Addition +

S Subtraction –

Lesson 12. QB64 statements.

Fill in the Blanks:-


1. By using SEMICOLON in a print statement, the items are printed without any spaces between
them.
2. TAB statement prints TABULAR type of results.
3. INPUT statement instructs the computer to wait for some data to be entered.
4. CLS command clears all the contents of the screen.
5. The INPUT statement displays a Question mark on the screen.
6. The INPUT program can be given with both numeric and Alphanumeric variables.
7. IF- THEN statement is used for making DECISIONS as well as COMPRISONS.
8. If the condition specified after if is true the then instruction after THEN is executed.
9. IF THEN ELSE is conditional decision making statement.
10. CONTROL statement helps to control the flow of a program.

State True or False:-

1. The print statement provides variations to print the output on the screen. [True]
2. When comma is used with print statement the items get closed to each other leaving no
space.[False]
3. the “redo from start” message is displayed if the value of a defined variable is incorrect.
[True]
4. While using INPUT statement , the punctuation between the message and the variable is a
colon [True]
5. The INPUT statement is used to assign values to variables. [True]
6. When INPUT statement is executed the “?” symbol is display . [True]
7. You can have only one INPUT statement in a program. [False]
8. The condition in IF THEN ELSE statement is given by the logical operators. [False]

Multiple Choice Question:-

1. ___________ command helps to insert comments that enable us to understand what the
program is all about. B. [REM]
2. The ___________ statement in QBasic is used to accept the data item from the user.
B[INPUT]
3. __________________ statement can be used in controlling column location. C. [PRINT TAB]
4. In basic, whenever any item is enclosed in the ________________ it means it is
optional. C[SQUARE BRACKETS]
5. …………. Statement stops further the execution of the program. B [ input]
6. ___________________ statement is used to transfer the program control from one
statement to another. C. [GOTO]
7. Statement is used when we want more choice in the IF…THEN statement. C. [IF…THEN …
ELSE]

Answer the following.

Q.1. What is the use of INPUT statement? What does a computer do when a computer do when
we use INPUT statement?
Ans:- The input statement is used to accept a data item from the user and store it in a variable.
This statement asks the user to enter data by displaying a question mark(?). The program
execution is suspended till the user enters the required values and presses the enter key.

Q.2. What is the use of PRINT statement using TAB function?

Ans. The TAB function is used to move the print position to the column indicated in its
argument. This statement is quite suitable for printing tabular type of results.

Q.3. Differentiate between the use of PRINT statement with comma and semicolon by suing
examples.

Ans:- Print with comma, It is used to display the values one after another with plenty of spaces
(normally 14) in between. Only five values can be printed in one line. In case of more than five
values, the remaining values will be printed on the next line.

Print with semicolon= PRINT with semicolon is used to display the values one after another,
without any space in between.

Q.4. What is the use of assignment statement?

Answer. The LET statement or Assignment statement is used to assign or given a value to a
variable. The use of the word LET is optional.

Q.5. When does the “redo from start” message get displayed on the screen?

Ans. If the value entered during execution of a program does not match with the type of variable
given in the program, then the “redo from start” message is displayed on the graphic screen. It
means the you have to re-enter all the values.

Lesson 13:- Internet. Service

Fill in the blanks.

1. A NETWORK is an interconnection between two or more computers.


2. WWW is a collection of a number of web pages.
3. A CHAT is an online conversation over the internet.
4. VIDEO CONFERENCING is mainly used for virtual meeting.
5. E-mail is the fastest way of sending mails.

State True or False:-

1. Bill gates is the founder of world wide web. False


2. Skype is one of the popular chat software. True
3. Attachment can be sent through e-mail. True
4. Pay Pal is one of the most popular E-Learning software.
5. Reliance is not a private internet service provider.False
6. Modem is a device that connects a computer with telephone line. True

Multiple Choice Question:-

1. In India, internet services started on _________. A (15 Aug 1995)


2. Niklash Zennstrom and his Danish partner Janus Friis are the founder of _________ . B(Skype)
3. The first page of any website is called___________ . C(Home Page)
4. A ________is automatically inserted at the bottom of every mail you send. A. (Signature)
5. _______________ is a social networking site. B(Facebook)

Abbreviation (Full Form)

1 FD Fixed Deposit

2 WWW World Wide Web

3 URL Uniform Resource Locators

4 ARPANET Advanced Research Project Agency Network

5 INTERNET International Network

6 ISP Internet service Providers

7 DRAM Dynamic Random Access Memory

8 SRAM Static Random Access Memory

9 MTNL Mahanagar Telephone Nigam Limited

10 GUI Graphical User Interface

11 UPS Uninterrupted Power Supply

12 BMP Bitmap

13 BIOS Basic Input Output System

Answer in one sentence

Q.1. Name some popular Internet services

Ans. BSNL, Tata, Airtel, Reliance, Idea, etc.

Q.2. What are chat room?

Ans. A chat is an online conversation over the Internet. Some of the popular chat software are
Google Talk, Skype, and Window live Messenger.
Q.3. What is signature in an e-mail?

Ans. A signature is a bit of personalized text that is automatically inserted at the bottom of every
sent e-mail.

Q.4.Give some examples of E-Learning website?

Ans.:- www.abcya.com/ , www.webtools4u2use.wikispaces.com and www.w3c.com

Q.5. What do you understand by Online shopping?

Ans.:- The Process of selling and buying products over the internet is called online shopping.

Answer the following

Q.1. Briefly explain the term Internet.

Ans.:-

Q.2. What do you mean by the term e-commerce?

Ans.:-

Q.3. Define the term WWW. Who is the founder of WWW?

Ans.:-

Q.4. What do you Understand by the term E-Banking?

Ans.:-

Q.5. Explain the concept of Chatting.

Ans.:-

Q.6. Write a short note on Internet Free calls.

Class 6th Important Question:-

Abbreviation (Full form)

BASIC :- Beginners All Purpose Symbolic Instruction Code.

BEDMAS:- Brackets Exponentiation Division Multiplication Addition Subtraction .

COBOL :- Common Business Oriented Language.


SCSI:- Small Computer Scale Interface.

SRAM:- Static Random Access Memory.

POST:- Power on self-Test.

BSNL:- Bharat Sanchar Nigam Limited.

PROM:- Programmable Read Only Memory.

CAL :- Computer Aided Learning

E-MAIL :- Electronic Mail.

Short Note:-

Program:- This set of instructions is called a program.

Programmers or Coders:- It can only follow the instructions specified in the programs and
perform the function accordingly. The persons who create these programs are known as
programmers or coders.

Programming language:-The language used by the programmers to write computer programs is


called programming language .

Statement:-Every command or instruction in basic is called a statement.

Syntax:- Statements should be written according to the specific set of rules of the language,
which are called Syntax.

Qus.1. what is Flash? What is the main part of Flash Working environment?

Answer:- Flash is an animation software package. Flash provides a versatile and easy way to
create animation. We can make any object in Flash with animation and make movies with sound
and action.

Main part of Flash Working:-A. The stage B. Menu bar. C. Time line

1. The tool panel. E. Properties Panel

Qus . 2. What are the option of the Eraser Mode Modifier? Explain any two briefly.

Answer:- Option of the Eraser Mode Modifier:- This tool helps you to erase lines and fills of an
object. 1. Select Eraser Tool > click on Eraser Mode modifier > select the eraser mode .

There are different eraser Mode modifiers:-

1. Eraser Normal :-Erases all lines and fills wherever the eraser in moved.
2. Eraser Files:- Erases only the fill colors while line are unaffected.
3. Eraser Line:- It is used to eraser the strokes only
4. Eraser selected fills:- Help in erasing a selected part of an object.
5. Erase inside:-Erases the inner part of an object.

Qus. 2. What do you understand by


instance? Answer:- Instance is a
copy of the original symbol. The size, color, shape and positon cab be altered without affecting
the original symbol.

Qus. 3. Define variable. Name the types of


variables. Answer:- A variable is a location in
memory to which any value can be assigned. It continues to hold the value unit another value is
assigned to it. Two type of variables.

1. Numeric variable.
2. Alphanumeric or String Variable.

Qus.4. Define constants. Name the type of


constants. Answer:- The value which does
not change during the execution of the program is called constants. Two type of Constants.

1. Numeric Constants.
2. Alphanumeric Or String Constants.

Qus. 5. What is the use of


inputement? Answer:- The INPUT
statement in QBasic is used to accept the data item from the user and store it in a variable. This
statement asks the user to make data entry by displaying a question mark (?) during the execution
of program.

Qus. 6. Define the WWW. Who is the founder of www?

Answer:- The world Wide Web is a large computer network where by using a browser such as
Netscape. Internet Explorer, you can surf and get information. Founder of www is Tim Berners-
Lee.

Qus. 7. How many type of Operator in QBasic? Define any two operators.

Answer: – There are three type of Operator.

1. Arithmetic operators:- A computer performs many arithmetic operator. and calculation with
the help of arithmetic operator.
2. Relational Operators:- They are used to compare two values using any of the iven relational
operators from a relational expression.
3. Logical operators:- Logical operators are used to perform logical operations on numerical
values. Logical operators are used to combine two or more relational expressions and return
a single value as true or false in a decision.
Qus. 8. Describe the term Video Conferencing.

Answer:- It involves the use of video cameras connected to two or more computers. Images and
sounds are then sent through the Internet where users not only hear each other but can also have
a face to face conversation. This technology is mainly used for virtual meeting among a group of
people to discuss political , business , medical or social affairs.

Qus. 9. Define the conditional statement. IF- THEN – ELSE.

Answer:- IF – THEN – ELSE is a conditional decision making statement. If the condition given
after if is true statement(s)specified after then is excuted . But it the condition is False , ELSE
statement will be processed.

Qus. 10. What do we understand by the animation?

Answer:- a symbol is a reusable object for static images or animation. They are either created
with the help of drawing tools or imported from other sources

You might also like