Assignment on QBASIC

Computer Assignment Class 7th 

Chapter THREE (More on QBASIC)

Read the Quick Ride, Key Terms and all the back exercise for Half Yearly Exam

Q1. Explain the following terms?

MOD Function
LEN function
LEFT$ Function
RIGHT$ function
SPACE$ Function
MID$ Function
SQR Function

Q2. Explain LINE command with example?

Q3. Explain CIRCLE command with example?

Q4. What is the EXIT command?

Q5. Write the program to add 3 numbers?

Q6. Write the program to print table of 2.

Q7. How many total color codes are there in QBASIC?

Q8. Write the name of screen modes.

Assignment on FLASH

Computer Assignment Class 7th 

Chapter FOUR (More on FLASH)

Read the Quick Ride, Key Terms and all the back exercise for Half Yearly Exam

Q1. Explain the following terms?

• Hand Tool
• Lasso Tool
• Pen Tool
• Gradient
• Selection Tool
• Zoom Tool
• Linear Gradient

Q2. What is Radial gradient?

Q3. Name the tool to create point-to-point selection of an object?

More on Flash

Chapter 4 More on Flash

Answer to back exercise

---

1. Thick the correct option.

a. (ii)
b. (iii)
c. (iii)
d. (i)
e. (iii)

---

2. Fill in the blanks.

a.   Selection
b.   Lasso
c.   Color
d.   double-click
e.    Linear

---

3. Write T if the given statement is true and F if it is false.

a.  F
b.  T
c.  T
d.  F
e.  T

---

4. Answer the Questions:

---

a. The Lasso Tool is used to create a point-to-point selection of an object.

---

b.  A gradient is a multicolour fill in which one colour gradually changes to another colour. Flash provides two types of gradients they are.
        (i) Linear gradient: In this gradient the colour changes either horizontally or vertically.
        (ii) Radial gradient: In this gradient the colour changes in an outward direction starting from a central point.

---

c.

Zoom Tool	Hand Tool
The zoom tool is used to zoom in (enlarge) and zoom out (reduce) the display.	When the stage is magnified, it may not be possible to view the entire stage at once. The Hand Tool allows to move the stage so that the objects can be viewed.

---

f.  To select multiple objects, click the selection tool on the Tools panel and drag a rectangle such that the objects to the desired angle.

More on QBASIC

Chapter 3

More on QBASIC

Answers to back Exercise

---

1. Tick the correct option

A. iii

b. i

c. ii

d. ii

e. i

f. iii

---

2. Fill in the Blanks

a. exit
b. string
c. Resolution
d. FOR ... NEXT
e. text mode, graphics mode

f. 16

---

3. Write T if the given statement is true and F if it is false

a. F

b. T

c. F

d. T

e. T

f. F

---

4. Answer the questions.

---

a. The working of the following iterative commands is as follows:
(i) WHILE...WEND: This loop is used when you want to execute a set of instructions as long as the given condition is true.
(ii) DO...LOOP UNTIL: This loop executes a block of instructions repeatedly until the specified condition becomes true.
(iii) FOR...NEXT: This loop is used to repeatedly execute a statement or a block of statements for the specified number of times. This loop is a Fixed Loop.

---

b. The String functions available in QBASIC are given below.

• LEN: This function finds the number of characters in a string.
• LEFT$: This function extracts the specified number of characters from the left side of the string.
• RIGHT$: This function extracts the specified number of characters from the right side of the string.
• MID$: This function extracts the specified number of characters from anywhere in between the string.
• SPACE$: This function is used to insert a blank space between the given strings.

---

c. The screen modes enable the user to adjust the screen resolution according to the requirement. the 2 basic types of screen modes are available in QBASIC. they are the Text mode and the Graphics mode.

---

d. The LINE command is used to draw a line between two given coordinates. the syntax of LINe command is as follows:
LINE (50,50)-(200,200), 13

The CIRCLE command is used to draw a circle or an ellipse. This command requires to specify the coordinates of the centre, the radius of the circle and the colour. The syntax of the CIRCLE command is as follows:
CIRCLE (175,150),100,14

---

e. The exit command is used to terminate any loop before it execute the expected number of times.

---

f. QBASIC allows to use one loop inside another loop. This is known as nesting of loops and such loops are called nested loops.

More on Microsoft Excel

Chapter  Two

More on Excel

Answer the Questions

Q1. What are the two different ways in which you can sort data in excel?

Ans: The following are the two ways to sort data in excel

1.       Using Sort and Filter button present in the Editing group

2.       Using Sort Dialog box.

Q2. Write the steps to sort the data in descending order.

 Ans:  Step1: Select the desired range of cells

           Step 2: Click the sort and filter button.

           Step 3: Click Sort Z to A option from the list displayed.

Q3. What do you mean by custom filtering?

Ans: Custom filtering allows you to specify your own criteria for filtering the data in a worksheet.

Q4. Write the steps to filter the data in Excel.

 Ans:    Step 1: Click any cell within the range of data to be filtered in the worksheet.

            Step 2: Click the sort and filter button.

            Step 3: Click Filter option from the list displayed

            Step 4: Click the drop-down control of any column to filter the data of that particular column.

            Step 5: Click the Select All check box in the list. All the options will be deselected.

Step 6: Click the check box for the option 28000 or any amount.

Step 7: Click Ok

Q5. What are the different ways in which you can apply conditional formatting?

 Ans: The different ways in which we can apply conditional formatting are as follows:

1.       Highlight Cells Rules.

2.       Top/Bottom Rules.

3.       Data Bars.

4.       Color Scales

5.       Icon Sets.

Q6. Write the steps needed to perform conditional formatting using any one of the options.

 Ans:   Step 1: Select the desired range of cells.

Step 2: Click the conditional formatting button present in the styles group on the home tab, point to Highlight Cells Rules option and the click Greater Than option.

            Step 3: Enter the values for which the criterion is to be displayed.

            Step 4: Click the arrow next to the with drop-down list box and select the desired format.

            Step 5: Click OK.

Q7. What is a chart? List various components of a chart.

Ans: A chart is a graphical representation of data used to compare a series of data over different time spans. Components of a chart are Axis, Axis Title, Data Series, Chart Title, Chart area, Plot Area, Legend, Gridlines, Data Labels, Data Table.

Q8.  List different types of charts that can be created in excel. Write the steps needed to create a chart of any type.

Ans: Different types of charts that can be created in excel are Column chart, Line chart, Pie chart, Bar chart, Area chart, Scatter chart, Surface chart, Doughnut chart, Radar Chart.

Steps to create a chart:

Step 1: Select the desired range of cells.

Step 2: Click the Insert tab. The charts group on this tab contains different types of chart buttons.

Step 3: Click on any of the chart buttons. A List of chart subtypes is displayed.

Step 4: Select the desired chart subtype.

Q9. Write the steps to change the style of the chart.

Ans:    Step 1: Select the desired chart.

           Step 2: Click the design tab and then click the more button in the chart styles group.

           Step 3: Select the desired chart style from the list.

URL and its components

Components of Email Address

Class 10 Chaper 1 Internet

Very Short Answer Questions

Expand the Following abbreviations

1. ARPANET   -   Advance Research Projects Agency Network
2. DARPA        -   Department of Defense Advance Research Projects Agency
3. TCP/IP         -   Transmission Control Protocol and Internet Protocol
4. WWW          -   World wild Web
5. HTTP           -    Hyper Text Transfer Protocol
6. FTP              -    File Transfer Protocol
7. LAN             -    Local Area Network
8. URL             -    Uniform Resource Locator
9. HTML         -     Hyper Text Markup Language
10. SGML         -     standard Generalised Markup Language

Long Answer Questions


Q1. Read the following paragraph. Find five network and communication related abbreviations and give their expanded forms along with a one-line definition for each of them:

RBI is planning to expand its connectivity with all major banks of India. The plan includes providing TCP connectivity through HTTP for easy access points and seeking help from some ISPs to join hands in this venture. Also, there is a plan to setup IIS and SMTP servers. Some banks will go for DSL line, while others will use leased line connectivity to access these services. RBI is also taking the help of IIT professors in this venture.

Ans: Different communication terms are as follows:

TCP: The full form of TCP is Transmission Control Protocol. TCP is responsible for the formation of packets and delivery of the packets to destination computer.

HTTP: Hyper Text Transfer Protocol is standard set of rules that is used to access web pages found in the web server.

IIS: Internet Information Server is a web server provide by Microsoft.

SMTP: Simple Mail Transfer Protocol is used to send and receive mail form client to server and vice- versa.

DSL: Digital Subscriber Line is a technology for bringing high bandwidth information over ordinary copper telephone lines.


Q2. Shravan Joshi is a student of Political Science and is a keen researcher of Political issues related to various countries and states. He wants to share his research and his opinions on these issues on a day-to-day basis with everyone on World Wide Web. He is also interested in collecting views of others to enhance his research and knowledge related to his area of interest. He belongs to a middle class family and cannot afford his own website. Being a non-technical person, he cannot create a dynamic website to deal with day-to-day inputs either.

(a) Suggest an easy way for Shravan to achieve his goals.
(b) Name the two popularly used (and free) services that can help Shravan.

Ans:
A) Shravan should develop a blog, because it’s free and there is no technical knowledge require to create it.
B) Twitter and Blogger from Google.

Q3. As life gets busier, it becomes difficult to stay in touch with school and college friends, old neighbours and favourite teachers. It is important to keep in touch with all your near and dear ones. Sometimes, people sitting miles away doing a similar activity or solving similar kind of problems can help you achieve your goals faster by sharing their experiences. Similarly, people belonging to different socio-economic backgrounds can change your perspective and enhance your understanding of various cultures.

a) Suggest the real time toots that are suitable for the above mentioned activities
b) What is the generic name used for such tools?
Ans:
a) Facebook and Twitter
b) Social Networking

Q4. Laleema Chkradhar wants a broadband connection to access mails and stay updates with the latest happenings in the field of Biotechnology. Can you suggest two internet Service Providers that can be approached for the same?

Ans: Airtel and VSNL

Q5. Identify domain names(s) and URL(s) from the following list:

a) yoga@yoga.com
b) doYogaEveryday.com
c) www.doyogaeverydau.com/old/index.html
d) www.performingarts_schools.org/backlink.htm
e) 192.287.3.5
f) http://cbse.nic.in

Ans:

a) Email Address

b) Domain Name

c) URL

d) URL

e) IP Address

f) Domain Name

Q6. Anila works in a multinational company and needs to work online from home also. She therefore requires a fast Internet connection. Which type of Internet connection would be best suited for her? Apart from browsing, she would also need to upload and download files to/from remote sites. Which protocol will help her perform this activity?

Ans: Type of Internet connection she would uses are Broadband or ADSL line

The protocol used for uploading and downloading file from remote sites is FTP (File Transfer Protocol).

Q7. Explain the terms URL and ISP in brief. Give one example for each.

Ans:

1. URL is a web address. Uniform resource Locator is the global address of documents or web pages.

2. ISP -> Internet service Provider is any company that provides Internet services, including personal and business access to the Internet.

Chapter One Class VII

Chapter  One

Computer Networks

Answer the Questions

Q1. Define a computer network. List its three advantages and disadvantages.

Ans: It is an interconnected system of two or more computers and other hardware devices by some communication channel.

Three advantages of computer network are:

•             Speed
•             Information sharing
•             Cost effective

Three disadvantages of computer network are:

•             Security issues
•             Dependency on server
•             Rapid spread of computer viruses

Q2. How is the Internet different from the intranet?

Internet It is the largest network that connects millions of computers worldwide to share information and services.

Intranet It is a private computer network owned by a company or an organization and is accessible only to its employees.

Q3. Explain different types of computer networks.

Ans: Four different types of computer networks are PAN, LAN, MAN, WAN.

•       PAN (Personal Area Network) is the smallest possible network intended for one person.
•        LAN (Local Area Network) is a network that covers a relatively small area such as residence, a building or a campus.
•        MAN (Metropolitan Area Network) is a network that is formed by connecting multiple LANs.
•        WAN (Wide Area Network) is a network that spans a large geographical area such as several cities or even countries.

Q4. What is meant by data transmission media? Differentiate between guided and unguided media.

Ans: Data transmission media refers to the medium used for transmitting data among the devices connected in a network. It can be guided or unguided.

Difference between guided and unguided media is

Guided Media A guided media is also called wired media provides a physical path between the communicating devise in a network Examples are: Twisted pair cable, Coaxial Cable, Fibre optic cable

Unguided Media An unguided media is also called wireless media is a type of transmission media that sends or receives the data through air or space. Examples are: Radio Waves, Microwaves, Infrared, Bluetooth, Wi-Fi

Q5. Define the network topology? Briefly describe the different types of topologies.

Ans: Network topology refers to the way in which the network components (cables, computers and other peripheral devices) are connected together in a network.

Different topologies are Bus, Star and Ring.

•        Bus topology: In this topology the computers and other devices are connected to a single cable called the bus or backbone.
•        Star topology: In this topology the workstations are not directly connected to each other, rather they are connected to a centralized network device known as hub or switch.
•        Ring topology: In this topology the computers and other devices are connected to each other in such a way that they form a closed loop or ring.

Q6. Write short notes on the following.

Modem, Hub, NIC

Ans:

Modem:  A modem (an acronym of modulator/demodulator) is a device that enables a computer to transmit data over telephone line. The job of a modem is to convert data from digital to analog format and vice versa.

Hub: A hub is a small rectangular device that connects multiple devices on a network so that they can communicate with one another.

NIC: The Network Interface Card, commonly referred to as Ethernet card, is a hardware device that enables a computer to connect to a network.