Notes/ solved exercises with questions KEYBOARD COMPUTER-7 SECOND ED OXFORD OUP
Contents
Formulas in MS Excel
Advanced Features of MS Excel
Creating Charts in MS Excel
Computer Viruses
QBasic Looping Statements
Introduction to Visual Basic
Communication on the Internet
More Tools in Flash
Animation in Flash
Introduction to HTML
Basic HTML Commands
Assessment 1
Assessment 2
Comprehensive Assessment 1
Assessment 3
Assessment 4
Comprehensive Assessment 2
Cyber Olympiad Questions
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
A formula in Microsoft Excel starts with an …………….. .. sign.
…………….. are pre-defined formulas that perform specific calculations.
you select a cell, the cell reference appears in the …………….. .. Box.
Press …………….. .. to view the formula result.
you enter a formula in a cell, it also appears in the ………. .. Bar.
a. equal
Functions
Name
Enter
Formula
2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
Microsoft Excel formulas can start with a ’+’ sign.
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.
A3-E3 is the cell reference of a range. …………. ..
The Count Numbers function counts the cells in a range that contain numeric data. ………………..
a. F; A Microsoft Excel formula always starts with an equals (=) sign.
F; A formula can be entered in the cell or in the Formula Bar.
T
F; A3:E3 is the cell reference of a range.
T
NAME THE FOLLOWING
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 …………………. ..
a. Point
Precedence
+
Concatenation
GCD
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!
CIRCLE THE CORRECT OPTION
symbol do Microsoft Excel formulas start with?
* ii. + iii. = iv. /
How do you write the cell reference for the range of cells in columns B to D and rows 4 to 6?
B4:D6 ii. B4:B6 iii. D4:D6 iv. B6:D4
Where can you enter a Microsoft Excel formula?
Name Box i ii. Formula Bar iii. cell iv. either ii or m
will be the result you enter : “Hello” & “Hi” in a cell?
Hell0Hi ii. HELLOHI iii. Hello Hi iv. Error
will you see if the column is not wide enough to display the result of a formula in a cell?
a series of * characters iii. a series of # characters
a series of & characters ‘ iv. a series of @ characters
Which of these operators has the highest precedence in Microsoft Excel?
+ ii. – iii. * iv. ^
g-Which of the following is not available in the AutoSum menu?
Sum ii. Add iii. Average iv. Min
a. iii
i
iv
i
iii
iv
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.
The ………… command arranges data in ascending or descending order.
The …………….. .. command displays data that the user wants to see .
…………….formatting sets a cell’s format according to conditions specified by the user.
The Conditional Formatting button is located on the …………… ..tab.
a. Data
Sort
Filter
Conditional
Home
WRITE T FOR THE TRUE STATEMENTS AND F THE FALSE STATEMENT (S)TH FALSE ONES.
The Sort & Filter button is located In the Editing group on the HOME tab.
Data can only be sorted In ascending order.
if you select a cell in a table and click on the filter button, a drop-down.
menu arrow appears next to the Column.
you bring the mouse pointer over a filter, the filter criteria are displayed in a Screen Tip.
The button shows that filtering has been applied.
a. T
F; Data can be sorted in both ascending and descending order.
T
T
T
3, NAME THE FOLLOWING
The command in the Sort & Filter group that opens a dialog box where more than one sort column can be defined.
Temporarily hiding rows that do not meet specified criteria ……………..
The button used to remove a filter.———————–
The button used to apply the filter criteria again——————————
The command in the Conditional Formatting drop-down menu that removes conditional formatting ———————————
a. Sort
Filtering
Clear
Reapply
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.
CIRCLE THE CORRECT OPTION.
type of data can Microsoft Excel sort?
numeric ii. text iii. alphanumeric iv. all of these
How does thee! button sort data?
in ascending order ii. in descending order iii. both i and ii iv. none of these
How does the button sort data?
in ascending order ii. descending order iii. both i and ii iv. none of these
does a next to a column heading signify?
filtering applied ii. filtering enabled iii. filtering not applied iv. none of these
you enable filtering, where do you see drop-down menu arrows?
on each column heading ii. in each selected cell iii. both i and ii iv. none of these
Which of the following is a type of filter?
by list values ii. by criteria iii. by a format iv. all of these
Which option in Clear Rules would you use to remove conditional formatting from a table.
Clear Rules from Selected Cells iii. Clear Rules from table
Clear Rules from Selected Rows iv. all of these
will the output be if you apply the filter criterion Begins With “A” to a field containing data values Bilal, Anum, Junaid, and Vaqar?
Bilal, Anum, Vaqar ii. Anum iii. Bilal, Vaqar iv. Junaid
a. iv
i
ii
iv
i
iv
i
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
A ……………….. .. is a pictorial representation of data.
A ……………….. .. chart shows changes over time intervals.
The ……………….. .. axis is usually the horizontal axis of a chart.
The ……………….. .. area is the rectangular area bounded by two axes.
Data ……………….. .. provide additional information about data markers.
a. chart
line
category
plot
labels
2-WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
If you change data in a worksheet, it is automatically reflected in any chart based on that data.
Pie charts are generally used to show trends over time.
A chart has to be on the same worksheet as the data.
You cannot modify a chart. *
Each object in a chart can be individually selected and then formatted or edited.
a. T
F; Line charts are generally used to show trends over time.
F; A chart can be on the same worksheet as the data or on a new worksheet.
F; You can modify a chart using the tabs under Chart Tools.
T
3-NAME THE FOLLOWING.
A chart that shows the relationship between two sets of numbers ………….. ..
The area within which all the charts components are found ………….. ..
The many data entries from which a chart is derived ………….. ..
U Lines that run across the plot area from each category on the x-axis or L each value on the y-axis ……………
lt identifies each data series in a chart. ………………
a. Scatter
Chart area
Data Series
Gridlines
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:
Click Move Chart in the Location group on the Design tab. The Move Chart dialog box appears.
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.
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
Which tabs do we get with Chart Tools?
i_ Design, Layout, Format iii. Design, Format, Type
Design, Style, Layout ’ iv. Design, Shape, Style
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
do you see you move a mouse over a chart object?
Chart Tip ii. Mouse Tip iii. Screen Tip iv Keyboard Tip
On which tab would you find ready-made chart styles?
i, Data g ii. Design iii. Format iv Insert
On which tab would you find the Axis Titles button?
Insert ii. Design iii. Layout iv. Format
a. iv
i
i
iii
iii
iii
ii
iii
CH 4: Computer Viruses P:51-62
Exercises
1-FILL IN THE BLANKS WITH THE CORRECT WORDS.
email . antivirus . definitions .worm . macro
Computer viruses can spread from one computer to another infected files are W
attached to …………………….
Microsoft Office documents are vulnerable to ……………………. .. viruses.
A ……………………. .. can propagate itself without any user action.
You can prevent most virus infections by using a good ……………………. .. prograiii.
Virus ……………………. .. should be updated regularly so that the antivirus software can
recognize new viruses.
a. email
macro
worm
antivirus
definitions
2-WRITE T FOR THE TRUE STATEMENTS AND FFOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
A virus can affect both software and hardware.
A computer virus cannot infect files on write-protected discs such as CD-ROMs.
You should scan perl‘ drives for viruses before using theiii.
Spyware can steal and pass on confidential information stored on your computer.
Spaiii.is a type of virus.
a. F; A virus can only affect software.
T
T
T
F; Spam refers to unsolicited, unwanted email.
3-NAME THE FOLLOWING.
The type of virus that infects files with extensions such as .com and .e><e. ……….. ..
The type of virus that infects data files ……….. ..
Beast is an example of this type of prograiii. ……….. ..
Any dangerous software ……….. ..
The database of viruses that antivirus software scans for ………..
a. Program virus
Macro virus
Trojan horse
Malware
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.
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?
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.
Program viruses infect program files with extensions such as
.com ii. .exe iii. .sys iv. all of these
Which of the following statements about computer viruses is false?
It can infect executable program files.
lt can infect the computer monitor.
iii. lt can spread from one computer to another.
lt can infect boot records.
Which of the following statements is false?
Viruses can infect files and corrupt data.
Virus definitions should be updated regularly.
iii. All viruses try to delete your data.
Antivirus software tries to detect and remove viruses.
Which of these can infect Excel documents?
program viruses ii. boot viruses iii. i. restricting access to your system macro viruses iv. all of these
Which of the following helps to prevent a virus infection?
scanning pen drives with antivirus program before using them iii. installing a firewall
all of these
Which of these is an antivirus software?
Norton Antivirus iii. both i and ii
Quick Heal Total Security iv. none of the above
Which of these can replicate itself?
Trojan horse ii. worm iii. Spam iv. none of these
Which of the following is available for free?
Kaspersky antivirus iii. Microsoft Security Essentials
Quick Heal Total Security iv. Norton antivirus
a. iv
ii
iii
iii
iv
iii
ii
iii
CH 5: QBasic Looping Statements P:63- 71
Exercises
1.- FILL IN THE BLANKS WITH THE CORRECT WORDS.
false -loop – once – step -true
The set of statements between WHILE and WEND is called the …………….. .. body
DO UNTlL…LOOP executes the loop the condition is …………….. ..
DO WHlLE…LOOP executes the loop the condition is …………….. ..
The …………….. .. clause in FOR…NEXT is optional.
The DO…LOOP UNTlL executes the loop at least …………….. ..
a. loop
false
true
STEP
once
WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
The WHlLE…WEND loop is executed as long as the condition is false.
Any condition evaluates to either true, false, or unknown.
The statements between DO and LOOP are together called the loop body.
You can place WHlLE and UNTIL at the end of a DO…LOOP.
STEP in a FOR…NEXT statement must be followed by a positive integer.
a. F; The WHILE…WEND loop is executed as long as the condition is true.
F; Any condition evaluates to either true or false.
T
T
F; STEP in a FOR…NEXT statement must be followed by a positive or a negative integer.
NAME THE FOLLOWING.
The number of looping statements in QBasic
This loop executes the condition is false.
This loop is used the number of repetitions is known
The default STEP value in FOR…l\lEXT
The statement used to stop a FOR loop prematurely
a. Three
DO UNTIL…..LOOP
FOR….NEXT
One
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.
do the statements inside a DO…LOOP form?
compound statement ii. loop body iii. multiple statements iv. none of these
Which of these is true if you have a negative number in a STEP value? W 1
Start value is greater than end value. iii. either i or ii .
End value is greater than start value. iv. none of these
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
is the default value of STEP in FOR…NEXT?
i -1 ll 0 iii.1 iv. 2
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
How many times is the given loop executed?
X=8
DO
PRlNT X
X=X- l
LOOP UNTlL X < 5
1 ii. 2 iii. 3 G, iv. 4
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
10 ii. 11 iii. 12 iv. 15
How many times is the following loop executed?
FOR N = 8 TO 3 STEP -2
PRINT N
NEXT N
1 ii. 2 iii. 3 iv. O
a. ii
i
iv
iii
ii
iv
iv
iii
CH 6: Introduction to Visual Basic P:72-88
Exercises
FILL IN THE BLANKS WITH THE CORRECT WORDS.
Controls – Debug -double-click -graphical- IDE
GUl stands for ……………………. .. user interface.
The ……………………. .. integrates many functions such as designing, editing, compiling,
and debugging in a single window.
The Visual Basic Toolbox contains many ……………………. ..
To get the code window in Visual Basic, you ……………………. .. on a control.
Select the Start Debugging option of the ……………………. .. menu to run the Visual Basic application.
a. graphical
IDE
controls
double-click
Debug
WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
Visual Basic is a language for event-driven programming.
The extension of a form file is .vb.
The Code window appears you click on a control.
A variable name in Visual Basic can be up to 254 characters long.
e‘. Press F6 to run the Visual Basic application.
a. T
T
F; The code window appears you double-click a control.
T
F; Press F5 to run the application.
3-NAME THE FOLLOWING.
The collection of files that make up an application—————-
A named attribute of a control—————
c.. Actions that can be performed on a control—————–
Actions such as click, double-click, and mouse over———————
The key that you press to run the application in Visual Basic————————
a. Project b. Property c. Method d. Event e. F5
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:
Create a foriii.
Place controls on the foriii.
iii. Set properties for the controls.
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.
CIRCLE THE CORRECT OPTION.
Which of these is an event-driven programming language?
QBasic ii. Basic iii. Visual Basic iv. all of these
does IDE stand for?
independent development enterprise iii. integrated development environment
independent decided event iv. integrated development event
do we call icons, buttons, menus, dialog boxes, and windows?
events ii. controls iii. methods iv. variables i
Which of these is not a part of the Visual Basic IDE?
Toolbox ii. Properties window iii. Code window iv. General window
ln which part of the Visual Basic environment are various controls available?
Code window = ii. Toolbox iii. Properties window iv. Menu bar
Where would you find the application name in Visual Basic?
Tools box ii. Title bar iii. Toolbar iv. Properties window
is the extension of Visual Basic project files?
.vbp ii. .vbproj iii. .vb iv. .vbn
Which of these is a valid variable name in Visual Basic?
lst_rank ii. father.name iii. cost price g iv. from_1_to_l0
a. iii
iii
ii
iv
ii
ii
ii
iv
CH 7: Communication on the Internet P:89-100
Exercises
FILL IN THE BLANKS WITH THE CORRECT WORDS.
blog web social text Twitter
Chat programs let you communicate instantaneously with other users through
————————–messages.
b, On a ……………… .., articles are posted regularly and displayed in reverse sequential order.
A ………………….. .. feed is a publishing format that provides readers with updated content from a website.
……………………. .. is a social networking and micro-blogging service.
A ………………….. …. network connects people who share common interests.
a. text
blog
web
Twitter
social
2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
We now have websites that allow audio and video chatting.—————–
Blogs can have reading material but they cannot have images, audio, or videos.—————-
Tweets can be up to 1000 characters long.——————-
Online telephony is unpopular because it is very expensive.—————–
The cloud is a space on the Internet that can be used for file storage and online sharing——–
a. T
F; Blogs can have text, hypertext, images, video, audio, etc.
F; Tweets can be up to 140 characters long.
F; Calls made on the Internet are much cheaper than phone calls.
T
3- NAME THE FOLLOWING.
The first social network …… ..
A popular social network created at Harvard University in the USA …… ..
Games that thousands of people play at the same time over the Internet …… ..
A software program that helps you organize and view photos that are already on your computer …… ..
The term used to refer to services such as Think Free Online, Google Apps, and
Microsoft Office 365 ……. ..
a. Six Degrees
Facebook
MMORPG
Picasa
Cloud computing
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.
CIRCLE THE CORRECT OPTION.
Which of these is not a social networking website?
Twitter ii. Facebook iii. MySpace iv. Hotmail
A message on Twitter has a limit of ……………. .. characters.
i- 100 ii.130 iv. 140
Which of these is not an online game?
Counter Strike ii. Age of Empire iii. Solitaire iv. Halo
Which of these allows only online photo sharing?
Picasa ii. Drop box iii. FTP iv. Windows Live SkyDrive
e.——————————– is the founder of Facebook?
Markjohn ii. Mark Smith iii. Mark Schildt iv. Mark Zuckerberg
Which of these is the odd one out?
Picasa ii. Google Reader iii. Windows Live SkyDrive iv. YouTube
Which of these cannot be used for online chat?
Windows Live Messenger ii. Google Talk iii. Tomb Raider iv. Yahoo! Messenger
benefits do we get from cloud computing?
easy storage and sharing of data iii. automatic backup and data protection
reliable, password-protected security iv. all of these
a. iv
iii
iii
i
iv
ii
iii
iv
CH 8: More Tools in Flash P:101-113
Exercises
FILL IN THE BLANKS WITH THE CORRECT WORDS.
Free Transform symbol “Gradient Transform Timeline Effects side
The ………………… .. tool is used to change the properties of a gradient fill.
To scale an object horizontally, drag one of the ………………… .. handles.
The ………………… .. tool is used to move an object.
A ……. ………… .. is a graphic image, an animation, or a button that is stored with a movie
…………….. .. provide a simple method of adding animation toe Flash movie.
1 a. Gradient Transform
side
Free Transform
symbol
Timeline Effects
WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S)
The Pen tool is used to draw a precise path in Flash.
The Eyedropper tool is used in combination with the Brush tool in Flash.
You can change the transparency of an instance of a Flash symbol.
You cannot change the font of text added to a Flash document
You can convert text into a drawing object in Flash.
a. T
F; The Eyedropper tool is linked with the Paint Bucket tool.
T
F; You can change the font of text added to a Flash document.
T
3- NAME THE FOLLOWING.
The tool used to apply colours and styles that have been picked with the Eyedropper tool
The tool that is used to rotate objects in Flash
The two types of gradient fill in Flash
The folder where symbols are stored in a Flash document
The panel used to set text attributes in Flash
a. Paint Bucket tool
Free Transform tool
Linear and Radial
Library
Property Inspector
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?
Use the Selection tool to select an instance of the symbol.
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:
Using the Arrow tool, select both the outline and the fill.
Select Modify „ Group.
The steps to ungroup objects in Flash are as follows:
Using the Arrow tool, select both the outline and the fill.
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:
Select the text.
Select Modify „ Break Apart.
iii. Select Modify „ Break Apart one more time. The characters can now be converted into
shapes.
Click outside the converted text to deselect the shapes.
CIRCLE THE CORRECT OPTION
Which tool is the Eyedropper tool used with?
Paint Bucket ii. Pen iii. Free Transform iv. none of these
do you drag to scale a Flash object both horizontally and vertically?
side handle ii. corner handle iii. both i and ii iv. none of these
What do libraries in a Flash document store?
symbols ii. instances iii. folders iv. none of these
When you add an occurrence of a symbol to the stage in Flash, is it called?
object ii. instance iii. drawing iv. none of these
Which option from the Color drop-down menu in the Property Inspector is used to
change the transparency of an instance?
Tint ii. Alpha iii. Color iv. none of these
is the shortcut key to group objects in Flash?
F5 ii. Alt+G iii. Ctrl+G , iv. none of these
Which menu do you use to convert text into basic shapes in Flash?
Edit ii. File iii. Modify iv. none of these
Which tool can you use to resnape characters in Flash?
Selection ii. Brush iii. Paint Bucket iv. none of these
a. i
ii
i d. ii
ii f. iii
iii
i
CH 9: Animation in Flash P:114-124
Exercises
FILL IN THE BLANKS WITH THE CORRECT WORDS.
Layers frame Timeline mask one
A ………………… .. is the basic unit of a flash movie.
The ………………… .. helps you organize the contents of a Flash document.
………………… .. are like transparent sheets stacked one on top of the other.
By default, the number of layers in a movie is …………………. ..
A ………………… .. layer hides the lower layer except for the part visible through a particular
object.
a. frame
Timeline
Layers
one
mask
WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
You can use the Insert menu to insert a layer in a Flash document.
You cannot delete a Flash layer.
To rename a layer, you double-click on the layer name.
You can press Enter to play a Flash_movie.
The mask layer should be the uppermost layer.
a. T
F; You can delete a Flash layer using the Delete Layer icon.
T
T
T
NAME THE FOLLOWING.
The colour of the dot on key frames ……………………. ..
The red rectangle with a vertical line in the Timeline ……………………. ..
The white rectangular area for working with the contents of a Flash movie ……………………. ..
The Flash feature that shows the relative position of an object over ‘V
several frames ……………………. ..
The built-in visual effects for text in Flash ……………………. ..
a. Black
Play head
Stage
Onion Skin
Filter
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.
What helps to organize the contents of a Flash document?
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?
F6 ii.F 7 ii. F8 iv. none of these
a. i
iii
i
i
ii
iv
i
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
The …………………. .. is the first page of a website.
…………………. .. is a text editor that can be used for creating HTML documents.
A …………………. .. is used to view HTML documents.
…………………. .. are extra bits of information that appear inside tags.
A …………………. .. tag is used to skip a line.
a. home page
Notepad
web browser
Attributes
BR
2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
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.
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.
a. F; we create HTML documents with Notepad, we save them with a .htm or .html extension.
T
T
F; HTML elements that do not require an off tag are called empty elements.
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
a. Body
Head
HTML
Body
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?
head ii. hr iii. body iv. none of these
f- Which is the tag that we use to insert at line break?
<BREAK> ii. <LlNE> iii. <BR> iv. none of these
g- Which of the following is not a container tag?
<FONT> ii. <HR> iii. <BODY> iv.<TITLE>
h- Which attribute of the body tag is used to set the left margin?
MARGlN ii. LEFTMARGIN iii. LMARGlN iv. none of these
a. i
iv
iii
ii
i
iii
ii
ii
CH 11: Basic HTML Commands P:138-147
1- FILL IN THE BLANKS WITH THE CORRECT WORDS.
<center> L 6 face <p> <b>
The ……………….. .. element defines a paragraph. “
HTML defines ……………….. .. levels of headings.
The ……………….. .. tag is used to make text bold.
The tag used to centre-align content between the left and right margins is
The ……………….. .. attribute of the <f0nt> tag is used to change the font style
a. <p>
6
<b>
<center>
face
2- WRITE T FOR THE TRUE STATEMENTS AND F FOR THE FALSE ONES. CORRECT THE FALSE STATEMENT(S).
<hr> is an empty element,
You Cahhetlehahge the colour of a horizontal line.
HTML deflheS Seven levels of headings.
d, Any text placed between the <!– and ~-> tags will be ignored by a browser.
Font is a container element
a. T
F; The colour of the horizontal line can be changed using the COLOR attribute.
F; HTML defines six levels of headings.
T
T
3- NAME THE FOLLOWING.
The tag used to underline text ……………………. ..
t>- The attl’thUte Qt the <hr> tag that sets the length of the line ……………………. ..
The kind Of elements <hl>, <h2>, etc. are ……………………. ..
The attribute of the <font> tag used to change the font ……………………. ..
e- T8135 that ate Oh the way to being discontinued ……………………. ..
a. <u>
WIDTH
heading elements
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 tag