Notes/ solved exercises with questions KEYBOARD COMPUTER-7 SECOND ED OXFORD OUP

Notes/ solved exercises with questions KEYBOARD COMPUTER-7 SECOND ED OXFORD OUP

Contents

  1. Formulas in MS Excel
  2. Advanced Features of MS Excel
  3. Creating Charts in MS Excel
  4. Computer Viruses
  5. QBasic Looping Statements
  6. Introduction to Visual Basic
  7. Communication on the Internet
  8. More Tools in Flash
  9. Animation in Flash
  10. Introduction to HTML
  11. Basic HTML Commands
  12. Assessment 1
  13. Assessment 2
  14. Comprehensive Assessment 1
  15. Assessment 3
  16. Assessment 4
  17. Comprehensive Assessment 2
  18. Cyber Olympiad Questions
  19. Revision Questions

 

CH 1: Formulas in MS Excel P:1-17

Exercises

1-FILL IN THE BLANKS WITH THE CORRECT WORDS.

Enter – equals – Formula – Functions – Name

  1. A formula in Microsoft Excel starts with an …………….. .. sign.
  2. …………….. are pre-defined formulas that perform specific calculations.
  3. you select a cell, the cell reference appears in the …………….. .. Box.
  4. Press …………….. .. to view the formula result.
  5. you enter a formula in a cell, it also appears in the ………. .. Bar.
  6. a. equal
  7. Functions
  8. Name
  9. Enter
  10. Formula

2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)

 

  1. Microsoft Excel formulas can start with a ’+’ sign.
  2. The only way to enter a formula in Microsoft Excel is to type it in a cell.

c-  you click on a cell writing a formula, the cell reference appears in the formula.

  1. A3-E3 is the cell reference of a range. …………. ..
  2. The Count Numbers function counts the cells in a range that contain numeric data. ………………..
  3. a. F; A Microsoft Excel formula always starts with an equals (=) sign.
  4. F; A formula can be entered in the cell or in the Formula Bar.
  5. T
  6. F; A3:E3 is the cell reference of a range.
  7. T

 

  1. NAME THE FOLLOWING
  2. The action displayed in the Status bar while pointing …………………. ..

b-These change the order of evaluation of a Microsoft Excel formula. …………………. ..

c-To copy a formula in Microsoft Excel, you select the cell and drag this symbol that appears in the lower-right corner of the cell. …………………. ..

d- The process of joining a series of text values …………………. ..

e- The Excel function that tells you the highest common factor for a set of numbers …………………. ..

 

  1. a. Point
  2. Precedence
  3. +
  4. Concatenation
  5. GCD

 

  1. ANSWER THE FOLLOWING.
 QUESTION  a: What are the two ways of entering a formula in Microsoft Excel?
ANSWER a. The two ways of entering a formula in Microsoft Excel are to enter the formula in the cell or in the Formula Bar.
QUESTION b: What do you do to view the result of a formula?
ANSWER b. To view the result of a formula, we press Enter.
QUESTION  c: What is pointing?
ANSWER c. Pointing is a method of adding a cell reference to a formula by clicking on the cell instead of typing the cell address.
QUESTION d: In which two places is the AutoSum button located?
ANSWER d. The AutoSum button is located in two places on the Ribbon:

• In the Editing group on the Home tab

• In the Function Library group on the Formulas tab.

QUESTION e:aHow would you copy a formula entered in cell G2 to G3:G7?
ANSWER e. The AutoFill feature can be used to copy a formula for a range of cells. Select cell G2. Point the cursor to the fill handle (the small black square in the lower-right corner) of cell G2. It will change to a small black cross. Keeping the left mouse button pressed, drag the fill handle to cell
QUESTION f: What is the order of evaluation of arithmetical operators (+, – , /, * , /\) in a Microsoft Excel formula.
ANSWER f. The order of evaluation is:

1. ^ (Exponent)

2. * (Multiplication) / (Division)

3. + (Addition) – (Subtraction)

 QUESTION g: When does a formula give you an error result?
ANSWER g. A formula gives an error result the formula has a problem and Excel cannot evaluate it.
 QUESTION h: How are the different error values that a formula can display?
ANSWER h. The different error values that a formula can display are #DIV/0! , #N/A, and #VALUE!

 

  1. CIRCLE THE CORRECT OPTION
  2. symbol do Microsoft Excel formulas start with?
  3. * ii. +  iii. =    iv. /

 

  1. How do you write the cell reference for the range of cells in columns B to D and rows 4 to 6?
  2. B4:D6 ii. B4:B6 iii. D4:D6 iv. B6:D4

 

  1. Where can you enter a Microsoft Excel formula?
  2. Name Box i ii. Formula Bar iii. cell iv. either ii or m

 

  1. will be the result you enter : “Hello” & “Hi” in a cell?
  2. Hell0Hi ii. HELLOHI iii. Hello Hi iv. Error

 

  1. will you see if the column is not wide enough to display the result of a formula in a cell?
  2. a series of * characters iii. a series of # characters
  3. a series of & characters ‘ iv. a series of @ characters

 

  1. Which of these operators has the highest precedence in Microsoft Excel?
  2. + ii. – iii. * iv. ^

 

g-Which of the following is not available in the AutoSum menu?

  1. Sum ii. Add iii. Average iv. Min

 

 

  1. a. iii
  2. i
  3. iv
  4. i
  5. iii
  6. iv
  7. ii

 

 

 

CH 2: Advanced Features of MS Excel P:18-34

Exercises

1, Fill in the blanks with the correct W0Td$-

Conditional – Data – Filter – Home – sort

a-To display the Sort dialog box you click on sort in the Sort & filter group on the  ………… .. tab.

  1. The ………… command arranges data in ascending or descending order.
  2. The …………….. .. command displays data that the user wants to see .
  3. …………….formatting sets a cell’s format according to conditions specified by the user.
  4. The Conditional Formatting button is located on the …………… ..tab.
  5. a. Data
  6. Sort
  7. Filter
  8. Conditional
  9. Home

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F THE FALSE STATEMENT (S)TH FALSE ONES.
  2. The Sort & Filter button is located In the Editing group on the HOME tab.
  3. Data can only be sorted In ascending order.
  4. if you select a cell in a table and click on the filter button, a drop-down.

menu arrow appears next to the Column.

  1. you bring the mouse pointer over a filter, the filter criteria are displayed in a Screen Tip.
  2. The button shows that filtering has been applied.
  3. a. T
  4. F; Data can be sorted in both ascending and descending order.
  5. T
  6. T
  7. T

 

3, NAME THE FOLLOWING

  1. The command in the Sort & Filter group that opens a dialog box where more than one sort column can be defined.
  2. Temporarily hiding rows that do not meet specified criteria ……………..
  3. The button used to remove a filter.———————–
  4. The button used to apply the filter criteria again——————————
  5. The command in the Conditional Formatting drop-down menu that removes conditional formatting ———————————
  6. a. Sort
  7. Filtering
  8. Clear
  9. Reapply
  10. Clear Rules

4- ANSWER THE FOLLOWING

QUESTION a. What is meant by sorting data?

ANSWER a. Sorting data means rearranging the data in cells in a specified order. b. Yes, Excel data can be sorted by more than one column.

QUESTION b. Can you sort Excel data by more than one column? If so, which command would you use?

ANSWER b. This can be done by selecting Sort in the Sort and Filter group on the Data tab.

QUESTION c. What is meant by filtering data?

ANSWER c. Filtering data means selectively blocking data that the user does not want to see.

QUESTION d.  What are the different ways to remove filter criteria?

ANSWER d. To remove the filter, any one of the following can be used:                                                                         • Click on Clear in the Sort and Filter group on the Data tab.                                                                     • Click on the arrow next to the column heading and select Clear Filter From “column heading” or Select All in the drop-down menu.

QUESTION e.  What is conditional formatting?

ANSWER e. Conditional formatting is a feature that allows you to set a cell’s format according to the conditions that you specify.

QUESTION f. List three conditional formatting criteria.

ANSWER f. The three conditional formatting criteria are Greater Than, Less Than, and Equal To.

QUESTION g. Name the tool you can use to copy conditional formatting.

ANSWER g. The Format Painter tool is used to copy conditional formatting.

 

  1. CIRCLE THE CORRECT OPTION.
  2. type of data can Microsoft Excel sort?
  3. numeric ii. text iii. alphanumeric iv. all of these

 

  1. How does thee! button sort data?
  2. in ascending order ii. in descending order iii. both i and ii iv. none of these

 

  1. How does the button sort data?
  2. in ascending order ii. descending order iii. both i and ii iv. none of these

 

  1. does a next to a column heading signify?
  2. filtering applied ii. filtering enabled iii. filtering not applied iv. none of these

 

  1. you enable filtering, where do you see drop-down menu arrows?
  2. on each column heading ii. in each selected cell iii. both i and ii iv. none of these
  3. Which of the following is a type of filter?
  4. by list values ii. by criteria iii. by a format iv. all of these

 

  1. Which option in Clear Rules would you use to remove conditional formatting from a table.
  2. Clear Rules from Selected Cells iii. Clear Rules from table
  3. Clear Rules from Selected Rows iv. all of these

 

  1. will the output be if you apply the filter criterion Begins With “A” to a field containing data values Bilal, Anum, Junaid, and Vaqar?
  2. Bilal, Anum, Vaqar ii. Anum iii. Bilal, Vaqar iv. Junaid

 

  1. a. iv
  2. i
  3. ii
  4. iv
  5. i
  6. iv
  7. i
  8. ii

 

CH 3: Creating Charts in MS Excel P:35-50

Exercises

FILL IN THE BLANKS WITH THE CORRECT WORDS.

chart –  category – labels- line -plot

  1. A ……………….. .. is a pictorial representation of data.
  2. A ……………….. .. chart shows changes over time intervals.
  3. The ……………….. .. axis is usually the horizontal axis of a chart.
  4. The ……………….. .. area is the rectangular area bounded by two axes.
  5. Data ……………….. .. provide additional information about data markers.
  6. a. chart
  7. line
  8. category
  9. plot
  10. labels

2-WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)

  1. If you change data in a worksheet, it is automatically reflected in any chart based on that data.
  2. Pie charts are generally used to show trends over time.
  3. A chart has to be on the same worksheet as the data.
  4. You cannot modify a chart. *
  5. Each object in a chart can be individually selected and then formatted or edited.
  6. a. T
  7. F; Line charts are generally used to show trends over time.
  8. F; A chart can be on the same worksheet as the data or on a new worksheet.
  9. F; You can modify a chart using the tabs under Chart Tools.
  10. T

 

 

3-NAME THE FOLLOWING.

  1. A chart that shows the relationship between two sets of numbers ………….. ..
  2. The area within which all the charts components are found ………….. ..
  3. The many data entries from which a chart is derived ………….. ..
  4. U Lines that run across the plot area from each category on the x-axis or L each value on the y-axis ……………
  5. lt identifies each data series in a chart. ………………
  6. a. Scatter
  7. Chart area
  8. Data Series
  9. Gridlines
  10. Legend

 

4-ANSWER THE FOLLOWING.

 

QUESTION a. What  is a chart?

ANSWER a. A chart is a pictorial representation of data.

QUESTION b. What is the difference between a column chart and a bar chart?

ANSWER b. A column chart shows changes in data over a period of time or illustrates comparisons between items, whereas a bar chart illustrates comparisons among individual items.

QUESTION c.What  is the similarity between a pie chart and a doughnut chart?

ANSWER c. A doughnut chart and a pie chart show the relationship of parts to the whole.

QUESTION d. How is a scatter chart different from a line chart?

ANSWER d. A line chart shows change over time intervals, whereas a scatter chart shows the relationships between numeric values or plots points between x and y values.

QUESTION e. Which  tab has the commands to insert charts in Microsoft Excel?

ANSWER e. The Insert tab in the Charts group has the commands to insert charts in Microsoft Excel.

QUESTION f. List the names and write the definitions of four Excel chart components.

ANSWER f. The following are the four chart components:

  • Axis Title – This is the title given to an axis.
  • Plot area – This is the rectangular area bounded by the two axes.
  • Legend – This identifies the data series.
  • Y- Axis – This is the vertical axis of the chart and is also known as value axis.

QUESTION g. How would you move a chart to a new worksheet?

ANSWER g. To move a chart to a new worksheet, the steps are as follows:

  1. Click Move Chart in the Location group on the Design tab. The Move Chart dialog box appears.
  2. Click New sheet and type a name for the new sheet.

QUESTION h. Name the three Chart Tools tabs that appear  a chart is selected.

ANSWER h. The three Chart Tools tabs are Design, Layout, and Format.

 

5- CIRCLE THE CORRECT OPTION.

  1. Which chart type displays data as slices of a circle and shows the relationship of each

value in a data series to the series as a whole?

i, line chart ii. bar chart iii. column chart iv. pie chart

 

b.Which chart type often looks at data trends over a period of time?

i, line chart ii. pie chart iii. area chart iv. scatter chart

 

  1. Which tabs do we get with Chart Tools?

i_ Design, Layout, Format iii. Design, Format, Type

  1. Design, Style, Layout ’ iv. Design, Shape, Style

 

  1. Which chart element shows all the data values and categories?

i, Data Marker ii. Data Table iii. Data Label iv Data Point

 

e,  do we mean by the floor of a 3~D chart?

i, x-axis ii. Y-axis iii. xy-plane iv. plot area

 

  1. do you see you move a mouse over a chart object?
  2. Chart Tip ii. Mouse Tip iii. Screen Tip iv Keyboard Tip
  3. On which tab would you find ready-made chart styles?

i, Data g ii. Design iii. Format iv Insert

  1. On which tab would you find the Axis Titles button?
  2. Insert ii. Design iii. Layout iv. Format
  3. a. iv
  4. i
  5. i
  6. iii
  7. iii
  8. iii
  9. ii
  10. iii

 

 

 

 

CH 4: Computer Viruses P:51-62

Exercises

1-FILL IN THE BLANKS WITH THE CORRECT WORDS.

email  . antivirus . definitions  .worm . macro

  1. Computer viruses can spread from one computer to another infected files are W

attached to …………………….

  1. Microsoft Office documents are vulnerable to ……………………. .. viruses.
  2. A ……………………. .. can propagate itself without any user action.
  3. You can prevent most virus infections by using a good ……………………. .. prograiii.
  4. Virus ……………………. .. should be updated regularly so that the antivirus software can

recognize new viruses.

  1. a. email
  2. macro
  3. worm
  4. antivirus
  5. definitions

 

2-WRITE T FOR THE TRUE STATEMENTS AND FFOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).

  1. A virus can affect both software and hardware.
  2. A computer virus cannot infect files on write-protected discs such as CD-ROMs.
  3. You should scan perl‘ drives for viruses before using theiii.
  4. Spyware can steal and pass on confidential information stored on your computer.
  5. Spaiii.is a type of virus.
  6. a. F; A virus can only affect software.
  7. T
  8. T
  9. T
  10. F; Spam refers to unsolicited, unwanted email.

 

3-NAME THE FOLLOWING.

  1. The type of virus that infects files with extensions such as .com and .e><e. ……….. ..
  2. The type of virus that infects data files ……….. ..
  3. Beast is an example of this type of prograiii. ……….. ..
  4. Any dangerous software ……….. ..
  5. The database of viruses that antivirus software scans for ………..
  6. a. Program virus
  7. Macro virus
  8. Trojan horse
  9. Malware
  10. Virus definitions

4-ANSWER THE FOLLOWING.

QUESTION a. What is a computer virus?

ANSWER a. A software program that has the ability to make copies of itself, and that can attach itself to other applications or files is known as a computer virus.

QUESTION b.  What can a computer virus do to your computer?

ANSWER b. • A computer virus can infect executable program files such as word processors, spreadsheets, and operating systems.

  • It can infect disks by attaching itself to special programs called boot records on the hard disk.
  • It can infect files that are attached to email messages or copied to discs and pen drives. In this

manner it can spread from one computer to another.

QUESTION c. Name the three types of viruses based on target Give one example of each type?

ANSWER c. The three types of viruses based on target are program virus, boot virus, and macro virus. The examples of each are:

Program virus – Acid Rain

Boot virus – Disk killer

Macro virus – Melissa

QUESTION d. Differentiate between program viruses and boot viruses.

ANSWER d. Program viruses infect program files that have extensions such as .com, .exe, .sys, .dll, .ovl, and .scr, whereas boot viruses infect the boot records of hard disks.

QUESTION e. How does a computer virus spread from one computer to another?

ANSWER e. Computer viruses spread from one computer to another by the transfer of infected data through email, pen drives, or other sources.

QUESTION f. List four precautions for protecting your computer from virus infections.

ANSWER f. Four precautions for protecting your computer from virus infections are:

  • Restrict access to your system, both offline and online.
  • Install and use antivirus software and keep it updated.
  • Scan files that you download from the Internet.
  • Never click on a link or attachment in an email, unless the email is from a trusted source.

QUESTION g. List five different types of malware.

  1. Five different types of malware are computer viruses, worms, Trojan horses, spyware, and spaiii.

QUESTION h.  are virus definitions and why is it necessary to update them?

  1. Virus definitions are the database of viruses for which antivirus software scans. It is necessary to update the definitions regularly so that the antivirus software can detect new viruses.

 

5- CIRCLE THE CORRECT OPTION.

  1. Program viruses infect program files with extensions such as
  2. .com ii. .exe iii. .sys iv. all of these

 

  1. Which of the following statements about computer viruses is false?
  2. It can infect executable program files.
  3. lt can infect the computer monitor.

iii. lt can spread from one computer to another.

  1. lt can infect boot records.

 

  1. Which of the following statements is false?
  2. Viruses can infect files and corrupt data.

 

  1. Virus definitions should be updated regularly.

iii. All viruses try to delete your data.

  1. Antivirus software tries to detect and remove viruses.

 

  1. Which of these can infect Excel documents?
  2. program viruses ii. boot viruses iii. i. restricting access to your system macro viruses iv. all of these
  3. Which of the following helps to prevent a virus infection?
  4. scanning pen drives with antivirus program before using them iii. installing a firewall
  5. all of these
  6. Which of these is an antivirus software?
  7. Norton Antivirus iii. both i and ii
  8. Quick Heal Total Security iv. none of the above
  9. Which of these can replicate itself?
  10. Trojan horse ii. worm iii. Spam iv. none of these

 

  1. Which of the following is available for free?
  2. Kaspersky antivirus iii. Microsoft Security Essentials
  3. Quick Heal Total Security iv. Norton antivirus
  4. a. iv
  5. ii
  6. iii
  7. iii
  8. iv
  9. iii
  10. ii
  11. iii

 

CH 5: QBasic Looping Statements P:63- 71

Exercises

1.- FILL IN THE BLANKS WITH THE CORRECT WORDS.

false  -loop – once – step  -true

  1. The set of statements between WHILE and WEND is called the …………….. .. body
  2. DO UNTlL…LOOP executes the loop the condition is …………….. ..
  3. DO WHlLE…LOOP executes the loop the condition is …………….. ..
  4. The …………….. .. clause in FOR…NEXT is optional.
  5. The DO…LOOP UNTlL executes the loop at least …………….. ..
  6. a. loop
  7. false
  8. true
  9. STEP
  10. once
  11. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
  12. The WHlLE…WEND loop is executed as long as the condition is false.
  13. Any condition evaluates to either true, false, or unknown.
  14. The statements between DO and LOOP are together called the loop body.
  15. You can place WHlLE and UNTIL at the end of a DO…LOOP.
  16. STEP in a FOR…NEXT statement must be followed by a positive integer.
  17. a. F; The WHILE…WEND loop is executed as long as the condition is true.
  18. F; Any condition evaluates to either true or false.
  19. T
  20. T
  21. F; STEP in a FOR…NEXT statement must be followed by a positive or a negative integer.

 

 

  1. NAME THE FOLLOWING.
  2. The number of looping statements in QBasic
  3. This loop executes the condition is false.
  4. This loop is used the number of repetitions is known
  5. The default STEP value in FOR…l\lEXT
  6. The statement used to stop a FOR loop prematurely
  7. a. Three
  8. DO UNTIL…..LOOP
  9. FOR….NEXT
  10. One
  11. EXIT FOR

4- ANSWER THE FOLLOWING

QUESTION a.  What is a loop in a program?

ANSWER a. In computer programming, a loop is used to repeat a block of statements a number of times.

QUESTION b.  What are the looping statements in QBasic?

ANSWER b. There are three looping statements in QBasic: WHILE…WEND, DO…LOOP, and FOR….NEXT.

QUESTION c. What is the difference between DO WHlLE…LOOP and DO UNTlL…LOOP?

ANSWER c. DO WHILE…Loop is executed as long as the condition is true; DO UNTIL…LOOP is executed

as long as the condition is false.

QUESTION d. What  is the difference between the DO WHlLE…LOOP and DO…LOOP WHlLE forms of

the DO…LOOP?

ANSWER d. The DO WHILE…LOOP is executed as long as the condition is true; DO…LOOP WHILE is executed at least once before the condition is checked. Also, the condition in the DO   WHILE…    LOOP appears before the loop starts, whereas in DO…LOOP WHILE the condition appears at the end of the loop.

QUESTION e. How many times is the loop executed in DO…LOOP WHILE if the condition starts off as

false?

ANSWER e. In DO…LOOP WHILE the loop will execute at least once even if the condition starts off as false.

QUESTION f. Which looping statement is preferred if you know the number of repetitions?

ANSWER f. The FOR…NEXT looping statement is preferred if we know the number of repetitions.

QUESTION g.  is the default STEP value in a FOR NEXT statement?

ANSWER g. The default STEP value in a FOR…NEXT statement is one.

QUESTION h. Can you have a negative value in STEP? lf yes,  would be true about the start and end

values in the statement?

ANSWER h. Yes, we can have a negative value in STEP. In this case, the starting value is greater than the ending value.

 

5- CIRCLE THE CORRECT OPTION.

  1. do the statements inside a DO…LOOP form?
  2. compound statement ii. loop body iii. multiple statements iv. none of these

 

  1. Which of these is true if you have a negative number in a STEP value? W 1
  2. Start value is greater than end value. iii. either i or ii .
  3. End value is greater than start value. iv. none of these

 

  1. Which is the loop that is executed the condition is false?

FOR…l\lEXT ii. DO WHlLE…LOOP iii. DO…LOOP WHILE iv. DO UNTlL…LOOP

 

  1. is the default value of STEP in FOR…NEXT?

i -1 ll 0 iii.1    iv. 2

 

  1. will be the output if the following code is executed?

FoRN=10To5sTEP-2″

PRINT N;

NEXT 1 ‘

i- 0864 ii. 1086 iii. Error iv. l0 8

 

  1. How many times is the given loop executed?

X=8

DO

PRlNT X

X=X- l

LOOP UNTlL X < 5

  1. 1 ii. 2 iii. 3 G, iv. 4

 

  1. will be the output if the given code is executed?

N =1

S=0

WHILE N<=5

S=S+N

N:N+1

WEND

PRINTS

  1. 10 ii. 11 iii. 12 iv. 15
  2. How many times is the following loop executed?

FOR N = 8 TO 3 STEP -2

PRINT N

NEXT N

  1. 1 ii. 2 iii. 3 iv. O
  2. a. ii
  3. i
  4. iv
  5. iii
  6. ii
  7. iv
  8. iv
  9. iii

 

 

CH 6: Introduction to Visual Basic P:72-88

Exercises

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Controls – Debug -double-click  -graphical- IDE

  1. GUl stands for ……………………. .. user interface.
  2. The ……………………. .. integrates many functions such as designing, editing, compiling,

and debugging in a single window.

  1. The Visual Basic Toolbox contains many ……………………. ..
  2. To get the code window in Visual Basic, you ……………………. .. on a control.
  3. Select the Start Debugging option of the ……………………. .. menu to run the Visual Basic application.
  4. a. graphical
  5. IDE
  6. controls
  7. double-click
  8. Debug

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
  2. Visual Basic is a language for event-driven programming.
  3. The extension of a form file is .vb.
  4. The Code window appears you click on a control.
  5. A variable name in Visual Basic can be up to 254 characters long.

e‘. Press F6 to run the Visual Basic application.

  1. a. T
  2. T
  3. F; The code window appears you double-click a control.
  4. T
  5. F; Press F5 to run the application.

 

3-NAME THE FOLLOWING.

  1. The collection of files that make up an application—————-
  2. A named attribute of a control—————

c.. Actions that can be performed on a control—————–

  1. Actions such as click, double-click, and mouse over———————
  2. The key that you press to run the application in Visual Basic————————
  3. a. Project b. Property c. Method d. Event e. F5
  4. ANSWER THE FOLLOWING.

 

QUESTION a-  is meant by GUI?

ANSWER a. GUI is an interface that enables the user to interact with the application by using controls like icons, buttons, menus, dialog boxes, and windows.

QUESTION b-  is event-driven programming?

ANSWER b. Event-driven programming is one in which the program responds to events, which are actions

performed by the user.

QUESTION c- Write clown the steps in the development of a Visual Basic application

ANSWER c. The steps to develop a Visual Basic application are:

  1. Create a foriii.
  2. Place controls on the foriii.

iii. Set properties for the controls.

  1. Add code to the controls to handle the events.

QUESTION d-  are the file extensions of a form file and a project file?

ANSWER d. The extension of a form file is .vb and the extension of a project file is .vbproj.

QUESTION e-  are the two ways to place a control on a form?

ANSWER e. The two ways to place a control on the form are:

  • Double-click on the control in the Toolbox.
  • Click on the control in the Toolbox and drag it onto the foriii.

QUESTION f- Name any four controls in the Toolbox.

ANSWER f. Four controls in the Toolbox are Label, Button, Combo Box, and ListBox.

QUESTION g-Name any two properties of Text Box and Label.

ANSWER g. Two properties of Text Box and Label are Font and Text.

QUESTION h- Write down two ways to run a Visual Basic application.

ANSWER h. Two ways to run a Visual Basic application are:

  • Press F5.
  • Click Debug Start Debugging.

 

  1. CIRCLE THE CORRECT OPTION.
  2. Which of these is an event-driven programming language?
  3. QBasic ii. Basic iii. Visual Basic iv. all of these

 

  1. does IDE stand for?
  2. independent development enterprise iii. integrated development environment
  3. independent decided event iv. integrated development event

 

  1. do we call icons, buttons, menus, dialog boxes, and windows?
  2. events ii. controls iii. methods iv. variables i

 

  1. Which of these is not a part of the Visual Basic IDE?
  2. Toolbox ii. Properties window iii. Code window iv. General window

 

  1. ln which part of the Visual Basic environment are various controls available?
  2. Code window = ii. Toolbox iii. Properties window iv. Menu bar

 

  1. Where would you find the application name in Visual Basic?
  2. Tools box ii. Title bar iii. Toolbar iv. Properties window

 

  1. is the extension of Visual Basic project files?
  2. .vbp ii. .vbproj iii. .vb iv. .vbn

 

  1. Which of these is a valid variable name in Visual Basic?
  2. lst_rank ii. father.name iii. cost price g iv. from_1_to_l0
  3. a. iii
  4. iii
  5. ii
  6. iv
  7. ii
  8. ii
  9. ii
  10. iv

 

 

CH 7: Communication on the Internet P:89-100

Exercises

FILL IN THE BLANKS WITH THE CORRECT WORDS.

blog web social text Twitter

  1. Chat programs let you communicate instantaneously with other users through

————————–messages.

b, On a ……………… .., articles are posted regularly and displayed in reverse sequential order.

  1. A ………………….. .. feed is a publishing format that provides readers with updated content from a website.
  2. ……………………. .. is a social networking and micro-blogging service.
  3. A ………………….. …. network connects people who share common interests.

 

  1. a. text
  2. blog
  3. web
  4. Twitter
  5. social

2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).

  1. We now have websites that allow audio and video chatting.—————–
  2. Blogs can have reading material but they cannot have images, audio, or videos.—————-
  3. Tweets can be up to 1000 characters long.——————-
  4. Online telephony is unpopular because it is very expensive.—————–
  5. The cloud is a space on the Internet that can be used for file storage and online sharing——–

 

  1. a. T
  2. F; Blogs can have text, hypertext, images, video, audio, etc.
  3. F; Tweets can be up to 140 characters long.
  4. F; Calls made on the Internet are much cheaper than phone calls.
  5. T

 

3- NAME THE FOLLOWING.

  1. The first social network …… ..
  2. A popular social network created at Harvard University in the USA …… ..
  3. Games that thousands of people play at the same time over the Internet …… ..
  4. A software program that helps you organize and view photos that are already on your computer …… ..
  5. The term used to refer to services such as Think Free Online, Google Apps, and

Microsoft Office 365 ……. ..

 

  1. a. Six Degrees
  2. Facebook
  3. MMORPG
  4. Picasa
  5. Cloud computing

 

 

  1. ANSWER THE FOLLOWING.

QUESTION a. What is a chat room?

ANSWER a. A chat room is a service where multiple users talk to each other in real time by posting messages.

QUESTION b. How does online chat differ from instant messaging?

ANSWER b. Instant messaging is like a private chat room and has known users; online chat can be conducted between unknown users.

 

QUESTION c. Name any two online chat services.

ANSWER c. Two online chat services are Yahoo! Messenger and Google Talk.

 

QUESTION d. How are newsgroups different from email?

ANSWER d. In a newsgroup, messages are posted on a bulletin board where any member can read and respond to them, unlike email that is sent to somebody’s private mailbox.

 

QUESTION e. List any three official newsgroup categories.

ANSWER e. Three official newsgroup categories are Alt(alternate), Biz(business, commerce), and Soc(social).

 

QUESTION f. Why are feed readers useful?

ANSWER f. Feed readers are useful because they allow you to keep up-to-date with new content from websites and you can easily subscribe to the website.

 

QUESTIONg. What is online file sharing? List two websites that allow online sharing.

ANSWER g. An online file-sharing service provides a way to store and access information in the ‘cloud’ rather than locally on a hard drive. The two websites that allow online file sharing are Picasa and YouTube.

 

QUESTION h. What are the benefits of using Picasa Web Albums?

ANSWER h. The benefits of using Picasa Web Albums are that it allows easy photo sharing and storing, and also provides online backup.

 

QUESTION i. What s cloud computing?

ANSWER i. Cloud computing is a technology that uses the Internet and central remote servers to store data and applications.

 

  1. CIRCLE THE CORRECT OPTION.
  2. Which of these is not a social networking website?
  3. Twitter ii. Facebook iii. MySpace iv. Hotmail

 

  1. A message on Twitter has a limit of ……………. .. characters.

i- 100 ii.130 iv. 140

 

  1. Which of these is not an online game?
  2. Counter Strike ii. Age of Empire iii. Solitaire iv. Halo

 

  1. Which of these allows only online photo sharing?
  2. Picasa ii. Drop box iii. FTP iv. Windows Live SkyDrive

 

e.——————————– is the founder of Facebook?

  1. Markjohn ii. Mark Smith iii. Mark Schildt iv. Mark Zuckerberg

 

  1. Which of these is the odd one out?
  2. Picasa ii. Google Reader iii. Windows Live SkyDrive iv. YouTube

 

  1. Which of these cannot be used for online chat?
  2. Windows Live Messenger ii. Google Talk iii. Tomb Raider iv. Yahoo! Messenger

 

  1. benefits do we get from cloud computing?
  2. easy storage and sharing of data iii. automatic backup and data protection
  3. reliable, password-protected security iv. all of these

 

 

  1. a. iv
  2. iii
  3. iii
  4. i
  5. iv
  6. ii
  7. iii
  8. iv

 

CH 8: More Tools in Flash P:101-113

Exercises

 

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Free Transform symbol “Gradient Transform Timeline Effects side

  1. The ………………… .. tool is used to change the properties of a gradient fill.
  2. To scale an object horizontally, drag one of the ………………… .. handles.
  3. The ………………… .. tool is used to move an object.
  4. A ……. ………… .. is a graphic image, an animation, or a button that is stored with a movie
  5. …………….. .. provide a simple method of adding animation toe Flash movie.

 

1 a. Gradient Transform

  1. side
  2. Free Transform
  3. symbol
  4. Timeline Effects
  5. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
  6. The Pen tool is used to draw a precise path in Flash.
  7. The Eyedropper tool is used in combination with the Brush tool in Flash.
  8. You can change the transparency of an instance of a Flash symbol.
  9. You cannot change the font of text added to a Flash document
  10. You can convert text into a drawing object in Flash.

 

  1. a. T
  2. F; The Eyedropper tool is linked with the Paint Bucket tool.
  3. T
  4. F; You can change the font of text added to a Flash document.
  5. T

 

 

3- NAME THE FOLLOWING.

  1. The tool used to apply colours and styles that have been picked with the Eyedropper tool
  2. The tool that is used to rotate objects in Flash
  3. The two types of gradient fill in Flash
  4. The folder where symbols are stored in a Flash document
  5. The panel used to set text attributes in Flash

 

  1. a. Paint Bucket tool
  2. Free Transform tool
  3. Linear and Radial
  4. Library
  5. Property Inspector

 

  1. ANSWER THE FOLLOWING.

 

QUESTION a. What is the Eyedropper tool used for?

ANSWER a. The Eyedropper tool is used acquire colours and styles from existing lines, brush strokes, and fills, and applying these to other objects.

QUESTION b. List three things you can do with the Free Transform tool in Flash.

ANSWER b. The Free Transform tool is used to move, rotate, or scale an object.

 

QUESTION c. What are symbols and instances in Flash?

ANSWER c. A symbol is a graphic image, animation, or button that is stored with a Flash movie; an instance is an occurrence of a symbol in a Flash movie.

 

QUESTION d. Write down the steps to change the transparency of an instance in Flash

ANSWER d. The steps to change the transparency of an instance in Flash are as follows:

 

QUESTION e. Why do we group the shape and fill of a Flash object?

  1. Use the Selection tool to select an instance of the symbol.
  2. To change the transparency, in the Property Inspector window, click the drop-down menu

arrow for Color, choose Alpha, and change the percentage.

ANSWER e. We group the shape and fill of a Flash object so that it can become a single object.

 

QUESTION f. How would you group and ungroup objects in Flash?

ANSWER f. The steps to group objects in Flash are as follows:

  1. Using the Arrow tool, select both the outline and the fill.
  2. Select Modify Group.

The steps to ungroup objects in Flash are as follows:

  1. Using the Arrow tool, select both the outline and the fill.
  2. Select Modify Break Apart.

 

QUESTION g. How would you change the orientation of text in Flash?

ANSWER g. To change the orientation of the text, select the text block and use the Property Inspector to change the text orientation from horizontal to vertical or vice-versa.

 

 QUESTION h. Write down the steps to convert text into basic Flash shapes.

ANSWER h. The steps to convert text into basic Flash shapes are as follows:

  1. Select the text.
  2. Select Modify Break Apart.

iii. Select Modify Break Apart one more time. The characters can now be converted into

shapes.

  1. Click outside the converted text to deselect the shapes.

 

 

  1. CIRCLE THE CORRECT OPTION
  2. Which tool is the Eyedropper tool used with?
  3. Paint Bucket ii. Pen iii. Free Transform iv. none of these

 

  1. do you drag to scale a Flash object both horizontally and vertically?
  2. side handle ii. corner handle iii. both i and ii iv. none of these

 

  1. What do libraries in a Flash document store?
  2. symbols ii. instances iii. folders iv. none of these

 

  1. When you add an occurrence of a symbol to the stage in Flash, is it called?
  2. object ii. instance iii. drawing iv. none of these

 

  1. Which option from the Color drop-down menu in the Property Inspector is used to

change the transparency of an instance?

  1. Tint ii. Alpha iii. Color iv. none of these

 

  1. is the shortcut key to group objects in Flash?
  2. F5 ii. Alt+G iii. Ctrl+G , iv. none of these

 

  1. Which menu do you use to convert text into basic shapes in Flash?
  2. Edit ii. File iii. Modify iv. none of these

 

  1. Which tool can you use to resnape characters in Flash?
  2. Selection ii. Brush iii. Paint Bucket iv. none of these
  3. a. i
  4. ii
  5. i d. ii
  6. ii f. iii
  7. iii
  8. i

CH 9: Animation in Flash P:114-124

Exercises

  1. FILL IN THE BLANKS WITH THE CORRECT WORDS.

Layers frame Timeline mask one

  1. A ………………… .. is the basic unit of a flash movie.
  2. The ………………… .. helps you organize the contents of a Flash document.
  3. ………………… .. are like transparent sheets stacked one on top of the other.
  4. By default, the number of layers in a movie is …………………. ..
  5. A ………………… .. layer hides the lower layer except for the part visible through a particular

object.

 

  1. a. frame
  2. Timeline
  3. Layers
  4. one
  5. mask

 

 

 

  1. WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
  2. You can use the Insert menu to insert a layer in a Flash document.
  3. You cannot delete a Flash layer.
  4. To rename a layer, you double-click on the layer name.
  5. You can press Enter to play a Flash_movie.
  6. The mask layer should be the uppermost layer.
  7. a. T
  8. F; You can delete a Flash layer using the Delete Layer icon.
  9. T
  10. T
  11. T

 

  1. NAME THE FOLLOWING.
  2. The colour of the dot on key frames ……………………. ..
  3. The red rectangle with a vertical line in the Timeline ……………………. ..
  4. The white rectangular area for working with the contents of a Flash movie ……………………. ..
  5. The Flash feature that shows the relative position of an object over ‘V

several frames ……………………. ..

  1. The built-in visual effects for text in Flash ……………………. ..
  2. a. Black
  3. Play head
  4. Stage
  5. Onion Skin
  6. Filter

 

  1. ANSWER THE FOLLOWING.

QUESTION a. What are the two ways of inserting a layer?

ANSWER: a. The two ways to insert a layer are:

  • Select Insert „ Timeline „ Layer.
  • Click Insert Layer at the bottom of the Timeline.

 

QUESTION b. How do you rename a layer?

ANSWER: b. To rename a layer, double-click the layer name and type the new name.

 

QUESTION c. How do you change the order of layers?

ANSWER: c. To change the order of layers, click the name of the layer you want to move and drag it to the required position.

 

QUESTION d. How does motion tweening differ from shape tweening?

ANSWER: d. In motion tweening, we specify only the position of the first and last keyframes. Flash automatically fills in the frames between the two; in shape tweening one shape appears to change into another shape.

 

QUESTION e. How can you control the number of frames displayed with the Onion Skin feature?

ANSWER: e. We can control the number of frames by dragging the Start Onion Skin and End Onion Skin markers in the Timeline.

 

QUESTION f.  What is meant by a motion guide?

ANSWER: f. Motion guide is the path along which the object moves.

 

QUESTION g. Write down the steps to convert a layer into a mask layer.

ANSWER: g. To convert the layer into a Flash mask layer, right-click the layer name and select the Mask option in the shortcut menu.

 

QUESTION h. Name three filters in Flash.

ANSWER: h. The three filters in Flash are Bevel, Glow, and Shadow.

 

 

 

5- CIRCLE THE CORRECT OPTION.

  1. What helps to organize the contents of a Flash document?
  2. Timeline ii. scene iii. movie iv. none of these

 

b- What do we call the number of frames a Flash movie displays per second?

Playhead ii. keyframe iii. frame rate iv. none of these

 

c.- What is the default name of the layer in a new Flash document?

Layer 1 ii. Layer iii. New layer iv. none of these

 

d- Where is the Insert layer button on the Timeline.

bottom ii. top iii. left iv. right

e- Which menu has the command to convert an object or objects into a group?

Insert ii. Modify iii. Edit iv. none of these

 

f- Which of the following buttons is available in the Timeline window?

Insert ii. Lock iii. Delete iv. all of these

 

g- What key do you press to insert a key frame?

i.F6  ii. F7 iii. Ctrl+F iv. none of these

 

h- What is the shortcut key to convert an object into a symbol?

  1. F6 ii.F 7 ii. F8 iv. none of these

 

  1. a. i
  2. iii
  3. i
  4. i
  5. ii
  6. iv
  7. i
  8. iii

 

CH 10: Introduction to HTML P:125-137

Exercises

1-FILL IN THE BLANKS WITH THE CORRECT WORDS.

web browser Attributes <BR> home page Notepad

  1. The …………………. .. is the first page of a website.
  2. …………………. .. is a text editor that can be used for creating HTML documents.
  3. A …………………. .. is used to view HTML documents.
  4. …………………. .. are extra bits of information that appear inside tags.
  5. A …………………. .. tag is used to skip a line.

 

  1. a. home page
  2. Notepad
  3. web browser
  4. Attributes
  5. BR

 

2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).

  1. We create HTML documents with Notepad, we save them with a .txt extension.

b- Ah OFF tag looks the same as an ON tag except that it has a forward slash before the

Command.

  1. Spaces or paragraphs between the opening and closing tags do not affect the browser displays.

d- HTML elements that do not require an OFF tag are called container elements.

e- The title element of a web page is included in the body element.

  1. a. F; we create HTML documents with Notepad, we save them with a .htm or .html extension.
  2. T
  3. T
  4. F; HTML elements that do not require an off tag are called empty elements.
  5. F; The TITLE element of the web page is included in the Head element.

 

3- NAME THE FOLLOWING.

a- The HTML element that contains text and images that are displayed in the browser

b- The HTML element that contains information about the document

c- The element that contains the whole HTML document

d- BGCOLOR is an attribute of this element.

e- The attribute that specifies the colour of text on a web page

 

  1. a. Body
  2. Head
  3. HTML
  4. Body
  5. Text

 

 

4- ANSWER THE FOLLOWING.

QUESTION a-  What are the three different parts of a website?

ANSWER a. A website is composed of three main sections: the home page, the main sections, and subsections.

QUESTION b-Name two types of HTML editors.

ANSWER b. The two main types of HTML editors are WYSIWYG editors and text editors.

 

QUESTION c- Write down two advantages of WYSlWYG HTML editors.

ANSWER c. The two main advantages of WYSIWYG HTML editors are:

  • Websites can be created quickly.
  • No knowledge of HTML tags or commands is required.

 

QUESTION d- What  are the two distinct parts of an HTML document?

ANSWER d. The two distinct parts of an HTML document are Head and Body.

 

QUESTION e- Differentiate between container elements and empty elements.

ANSWER e. HTML elements that include both on and off tags are called container elements; HTML elements that do not require an off tag are called empty elements.

 

QUESTION f- What is the body tag used for?

ANSWER f. The Body tag contains all the text and images that make up the page. It also contains other elements that help you control and format the page.

 

QUESTION g- Write down any three attributes of the body tag. Give their uses.

ANSWER g. The three attributes of the Body tag and their uses are as follows:

  • BGCOLOR: Used to set the background colour of the document.
  • TEXT: Used to set text colour in the document.
  • LEFTMARGIN: Used to set the left margin. It is a numeric value and the unit is pixels.

 

QUESTION h- Are element names case sensitive?

ANSWER h. No, element names are not case sensitive.

 

5- CIRCLE THE CORRECT OPTION.

a- Which of the following is a text editor?

i- Notepad ii. Dreamweaver iii. Internet Explorer iv. none of these

 

b-  are the components that make up an HTML code? F

i- tags ii. elements iii. attributes iv. all of these

 

c- Which is the correct way of writing an element name?

i- <html> ii. <HTML> iii. either i or ii U iv. none of these

 

d-  do we call HTML elements that have both ON and OFF tags?

i- empty elements ii. container elements iii. elements iv. none of these

 

e-Which element has identification and supplementary information about a web document?

  1. head ii. hr iii. body iv. none of these

 

f- Which is the tag that we use to insert at line break?

  1. <BREAK> ii. <LlNE> iii. <BR> iv. none of these

 

g- Which of the following is not a container tag?

  1. <FONT> ii. <HR> iii. <BODY> iv.<TITLE>

 

h- Which attribute of the body tag is used to set the left margin?

  1. MARGlN ii. LEFTMARGIN iii. LMARGlN iv. none of these

 

  1. a. i
  2. iv
  3. iii
  4. ii
  5. i
  6. iii
  7. ii
  8. ii

 

 

CH 11: Basic HTML Commands P:138-147

 

1- FILL IN THE BLANKS WITH THE CORRECT WORDS.

<center> L 6 face <p> <b>

  1. The ……………….. .. element defines a paragraph. “
  2. HTML defines ……………….. .. levels of headings.
  3. The ……………….. .. tag is used to make text bold.
  4. The tag used to centre-align content between the left and right margins is
  5. The ……………….. .. attribute of the <f0nt> tag is used to change the font style

 

  1. a. <p>
  2. 6
  3. <b>
  4. <center>
  5. face

 

 

2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).

  1. <hr> is an empty element,
  2. You Cahhetlehahge the colour of a horizontal line.
  3. HTML deflheS Seven levels of headings.

d, Any text placed between the <!– and ~-> tags will be ignored by a browser.

  1. Font is a container element
  2. a. T
  3. F; The colour of the horizontal line can be changed using the COLOR attribute.
  4. F; HTML defines six levels of headings.
  5. T
  6. T

 

 

3- NAME THE FOLLOWING.

  1. The tag used to underline text ……………………. ..

t>- The attl’thUte Qt the <hr> tag that sets the length of the line ……………………. ..

  1. The kind Of elements <hl>, <h2>, etc. are ……………………. ..
  2. The attribute of the <font> tag used to change the font ……………………. ..

e- T8135 that ate Oh the way to being discontinued ……………………. ..

  1. a. <u>
  2. WIDTH
  3. heading elements
  4. Face e. deprecated

 

 

4- ANSWER THE FOLLOWING.

QUESTION a. What is the <p> tag used for?

ANSWER a. The <p> tag is used to define a paragraph in HTML.

 

QUESTION b- What are the tags for adding comments to an HTML document?

ANSWER b. The tags for adding a comment to an HTML document are <!– and –>.

 

QUESTION c- Write el0Wh the expansion of the <hr>, <b>, and <u> tags.

ANSWER c. The expansions of the given tags are as follows:

<hr> stands for horizontal line.

<b> stands for bold.

<u> stands for underline.

 

QUESTION d- What  the function of the noshade attribute of the <hr> tag?

ANSWER d. The NOSHADE attribute of the <hr> tag displays a solid line without shading.

 

QUESTION e-What can be the different values of align attribute of the <hr> tag?

ANSWER e. The different values of the ALIGN attribute of the HR tag are LEFT, CEnter , and RIGHT.

 

QUESTION f- Give examples of the two different ways of specifying the length of a horizontal line.

ANSWER f. Two examples of specifying the length of a horizontal line are:

<hr width=“150”> or <hr width=“70%”>

 

QUESTION g- Identify the error in the following and then write the correct code.

<hr thickness=”45” COLOR=”red”>

ANSWER g. The correct code is as follows:

<hr size= “45” COLOR = “red”>

 

QUESTION h- Write the Code to display Hello, World bold-faced and underlined,_ in the centre of the page, and in size 8.

ANSWER h. The correct code is as follows:

<center>

<font size= “8”>

<b><u>Hello, World </u></b>

</font></center>

 

 

5- CIRCLE THE CORRECT OPTI0N

a- How many heading levels does HTML have?

it 5 ii. 6 iii. 7 iv. None of these

 

  1. Which of the following is not an attribute of the <hr> tag?

l- atlgn ii. width iii. bgcolor iv. size

 

  1. Which attribute of the <hr> tag is used to define the horizontal width of the line?

 

1- 5lZet ii. width iii. thickness iv. none of these

  1. Which tag is used to insert a line break?

t- <bt> ii. <linebr> iii. <break> iv. none of these

 

  1. Text after Which of the following tags is ignored by web browsers?

l- <t” ii. <hr> iii. <hn>  iv. none of these

 

f- Which of the following is a container element?

l- bold ii. italics iii. underline iv. all of these

 

g- Which tag makes text bold?

  1. <b0Id> ii. <b> V iii. <textb> iv_ none Of these

 

h- Which tag would you use to underline text?

  1. <u> ii. <underline> iii. <b> iv, none of these

 

 

  1. a. ii
  2. iii
  3. ii
  4. i
  5. i
  6. iv
  7. ii
  8. i

 

Assessment 1

 

  1. a. The two functions found under AutoSum are Sum and Average.
  2. Sorting means rearranging the data in cells in a specified order; filtering means selectively blocking data that the user does not want to see.
  3. The Home tab of MS Excel has the Conditional Formatting command and it is defined as setting cell format according to the conditions specified by the user.
  4. a. Pie chart b. Bar chart c. Doughnut chart
  5. Line chart e. Column chart
  6. a. 1200
  7. 300
  8. =AVERAGE(A2:C2)
  9. Always Smile
  10. 18 and 12 (The comma in the question represents the individual cell values and not the range. Thus the formula finds the minimum value between those in the cells A2 and C2.)

Assessment 2

  1. a. i. IDE integrates many different functions such as designing, editing, compiling, and debugging in a single window.
  2. Visual Basic is referred to as integrated development environment (IDE) software.
  3. i. Loops are used in programs to execute a group of statements repeatedly.
  4. There are three ways to execute loops in QBasic: WHILE…WEND, DO…LOOP, and FOR…

NEXT.

  1. i. A computer virus is a software program that can make copies of itself.
  2. A computer virus attaches itself to other programs or files.
  3. a. .vb b. 1 c. Computer virus d. Spyware e. Trojan horses
  4. a. The two controls on the form are Button and Label.
  5. To display the title on the form, click the box to the right of Text in the Properties window of the form and type ‘Square of Number’.
  6. Select the label ‘Enter Number’ by clicking it. In the Properties window, click the box to the right of Font, and then make the specified changes.
  7. Double-click the button control and type the code given below:

Public Class Form1

Private Sub Button1_Click (ByVal sender As Systeiii.Object, ByVal e As Systeiii. EventArgs)

Handles Button1.Click

Dim a, b As Integer

a = Val (TextBox1.Text)

b = a*a

TextBox2.Text = Str(b)

End Sub

End Class

  1. The function key F5 is used to run the prograiii.
  2. a. The output of the program is 1, 3, 5.
  3. The loop is executed three times.
  4. The value of X is 7.

52 1

Comprehensive Assessment 1

  1. a. (i), i.e. A to Z
  2. Begins With
  3. Next to the column headings
  4. Home tab
  5. GCD and LCM are two functions in MS Excel.
  6. We can use a good antivirus software to protect our computer from computer viruses.
  7. The tabs that appear are Design, Layout, and Format.
  8. IDE stands for integrated development environment.
  9. The Exit command is used to exit a FOR or a DO loop prematurely.
  10. Yes, we can have a negative value in the STEP clause.
  11. a. Sorting should be done on the column Total Marks in descending order.
  12. To remove the filter, do one of the following:
  • Click Clear in the Sort and Filter group on the Data tab.
  • Click the arrow next to Total and select Clear Filter From “Total” or Select All in the

drop-down menu.

  1. i. 8.
  2. F1 will become 10.
  3. Four controls in the Toolbox of Visual Basic are Label, Button, ComboBox, and ListBox.
  4. Spam is unsolicited, unwanted email. Two ways of avoiding spam are:
  • using the spam filter of the email program
  • deleting spam mail without reading it.
  1. a. virus b. antivirus c. updated d. Home e. label
  2. a. =Sum(C3:D3) b. =Average(E3:E6)
  3. a. Chart title b. Gridline c. Legend d. Category axis
  4. Value axis f. Data label
  5. The code is as follows:

Public Class Form1

Private Sub Button1_Click(ByVal sender As Systeiii.Object,ByVal e As Systeiii. EventArgs) Handles

Button1.Click

Dim a, b, c As Integer

a = Val(TextBox1.Text)

b = Val(TextBox2.Text)

c = a * b

TextBox3.Text = Str(c)

End Sub

End Class

  1. a. i b. ii c. iv d. iii e. iv
  2. iv g. ii h. ii i. ii j. iii

53

Assessment 3

  1. a. Google Talk b. Blog post c. Ctrl+G
  2. Web feed e. File transfer protocol (FTP)
  3. a. TWITTER b. CLOUD COMPUTING
  4. EYEDROPPER d. LIBRARIES
  5. a. iii b. v c. iv d. vi e. ii f. i
  6. a. To convert the text into shape, select Modify Break Apart.
  7. Two times.
  8. Yes, shape tween can be applied to the object.
  9. a. Layer 2: Circle and Layer 1: Rectangle
  10. Circle
  11. 12.0 fps
  12. 25

54

Assessment 4

  1. a. Paragraph b. Italic c. Horizontal Rule
  2. Bold e. Underline f. Line break
  3. a. Home page b. HTML c. Attribute
  4. Head e. Body
  5. a. <hr> is used to draw the horizontal line.
  6. The attributes used to change the thickness and color of the line are SIZE and COLOR.
  7. <hn> headingtext </hn> is used to write the heading, where n stands for heading level 1-6.
  8. The <font> tag and COLOR attribute are used to change the appearance of the timings text:

<font color= “green”> Timings: 4pm to 7pm</font>

  1. <html>

<head>

<title>

Healthy Food

</title>

</head>

<body bgcolor= “yellow” text = “green”>

<font face= “Arial”>

Always eat healthy food and a<b> balanced diet. </b></font>

</body>

</html>

  1. <html>

<head>

<title>

Learning

</title>

</head>

<body>

<font face= “Times New Roman” size= “6” color= “red”>

I am learning HTML.</font>

</body>

</html>

 

Comprehensive Assessment 2

  1. a. Six Degrees b. www.123greetings.com c. blogger
  2. FTP e. cloud computing service f. Free Transform tool
  3. Gradient Transform h. <i> i. <hr> is an empty element. j. ALIGN
  4. a. In newsgroups messages are not posted to somebody’s mailbox, as in email, but on a bulletin board where any member can read and respond to theiii.
  5. Sharing files online and saving files online are two benefits of cloud computing.
  6. Xbox and Playstation are two gaming control devices used for online gaming.
  7. To insert a layer in the Timeline window, select Insert Timeline Layer.
  8. Two benefits of Internet telephony are that calls made over the Internet are cheaper and we can see the other person.
  9. a. Chat b. Eyedropper c. WYSIWYG, text d. empty elements
  10. a. True b. True c. False d. True e. True
  11. <html>

<head>

<title>

My Favourite Stories

</title>

</head>

<body bgcolor= “blue”>‑

<h2><center> My Favourite Stories </center></h2>

<hr size= “4” color = “white”>

<font face= “Arial” color = “yellow”>

  1. The Railway Children<br>
  2. The Swiss Family Robinson<br>
  3. Robinson Crusoe<br>
  4. Kidnapped<br>
  5. The Wind in the Willows<br>

</font>

</body>

</html>

  1. a. i b. iii c. iv d. iii e. i
  2. iv g. iii h. iv i. iii j. i

56

Cyber Olympiad Questions

  1. b 21. d
  2. b 22. b
  3. d 23. c
  4. c 24. d
  5. d 25. a
  6. a 26. b
  7. a 27. c
  8. b 28. a
  9. a 29. b
  10. c 30. b
  11. b 31. b
  12. c 32. c
  13. d 33. a
  14. b 34. a
  15. c 35. a
  16. c 36. c.
  17. c 37. b
  18. d 38. b
  19. d 39. d
  20. b 40. c

57

Revision Questions

  1. We will refer to the range of cells as F5:F30.
  2. The error ‘#VALUE!’ appears in a cell the formula contains invalid data.
  3. The GCD function is used to calculate the greatest common divisor of two or more integers.
  4. The MAX function in MS Excel is used to calculate the maximum value among the given values and the MIN function is used to calculate the minimum value.
  5. Concatenation is the process of joining text values in a series.
  6. Functions are pre-defined formulas that perform specific calculations. Two functions in MS Excel are AutoSum and LCIII.
  7. The Sort command of Excel is found on the Data tab.
  8. Yes, we can sort the data in more than one column in MS Excel.
  9. Filtering in MS Excel is used for selectively blocking data that the user does not want to see.
  10. Conditional formatting is used to set cell format according to the conditions specified by the user.
  11. Charts are created in MS Excel to make large quantities of data more easily understandable through pictorial representation.
  12. Two types of charts that can be created in MS Excel are line charts and bar charts.
  13. A pie chart is used to plot data for a single data series.
  14. The horizontal axis of a chart is known as the category axis and the vertical axis is known as the value axis.
  15. A computer virus is a software program that can make copies of itself and attach itself to other programs or files.
  16. No, computer viruses cannot infect computer hardware.
  17. Three common signs of virus attack are as follows
  • The computer runs more slowly than normal.
  • Unusual error messages appear on screen.
  • The computer restarts on its own.
  1. Program viruses infect program files that have extensions like .com, .exe, .sys, etc. Two examples of program viruses are Acid Rain and Alien.298.
  2. A Trojan horse is a program that appears useful but is actually programmed to pass the user’s data to someone else.
  3. Malware refers to any program that infiltrates and harms a computer without the user’s consent; spyware refers to computer programs that secretly gather information about the user and relay it to advertisers.
  4. Spam is unsolicited, unwanted email. Two ways of avoiding spam are as follows:
  • Do not give your email address to unknown people.
  • Use the spam filter of your email prograiii.
  1. Three basic rules to avoid virus infections are:
  • Restrict access to your system, both offline and online.
  • Install and use antivirus software and keep it updated.
  • Scan files that you download from the Internet.
  1. The following are necessary for an antivirus program to be effective:
  • It should run in the background at all times.
  • It should be kept updated so that it recognizes new versions of malicious programs.
  • The user should run full disk scans periodically.
  1. Two antivirus software are Norton Antivirus and McAfee Virus Scan.
  2. By virus definitions we mean the database of viruses for which antivirus software scans.
  3. The two looping statements in QBasic are DO…LOOP and FOR…NEXT.
  4. The output is: 3 6 9.
  5. A social networking website provides a virtual community for people to keep in touch with friends or share common interests.
  6. The default extension of Visual Basic project file is .vbproj.
  7. To change the background colour of a Visual Basic form, click the box to the right of Backcolor.
  8. A Web feed facility informs us a website has new content.
  9. The MOD operator returns the remainder dividing two values.
  10. Three rules for naming variables in Visual Basic 2010 Express are:
  • A variable name must be fewer than 255 characters.
  • A variable name should not contain spaces or full stop (.) signs.
  • A variable name must not begin with a digit.
  1. The three benefits of online telephony are:
  • It allows users to make telephone calls over the Internet.
  • Calls made are much cheaper than international phone calls.
  • We can see the person we are talking to.
  1. The Pen tool in Flash is used for drawing precise paths such as straight lines and smooth curves.
  2. HTML elements that include both on and off tags are called container elements.
  3. An example of a container element is <b> and an example of an empty element is <br>.
  4. The <hr> tag is used to draw a horizontal line across the page. The two attributes used with the <hr> tag are SIZE and COLOR.
  5. a. SIZE b. <p> c. empty d. Paint Bucket e. one
  6. a. True b. False c. True d. True e. False

——————–End——————

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.