Your grandparents waited weeks for a letter from a relative working abroad. Today a family in Bhaktapur can see the face of a son in Qatar or a daughter in Australia on a phone screen, live, and talk for as long as they like. A student in a village school can download the same textbook as a student in Kathmandu, and a shopkeeper can add up a month of sales in a second.
All of this is information and communication technology, ICT for short. This unit shows you its tools and how to use them well: the internet, browsers and search engines, e-books, email, spreadsheets and photos. It also shows you how to keep yourself, and your computer, safe while you use them.
ICT in our lives
This is the age of science and technology. Inventions like the computer, the internet, the digital camera, CCTV (closed-circuit television: cameras that send their pictures only to a few screens, for security), the radio and the television have made our lives easier and simpler. Technology changes fast, and the field of information and communication has changed completely in a few years. Nepal has moved quickly too: with the internet, a computer or a mobile phone, we can talk to relatives inside and outside the country.
ICT is now used widely in teaching and learning. Lessons on the radio and the television, learning videos, e-books and online classes make learning more effective. So everyone needs the skill to use these tools well.
2.1 Tools of information and communication technology
Radios, televisions, newspapers, computers and projectors are all tools of information technology. Between them they create, display, store, transmit (send) and exchange information.
One-way and two-way communication
The tools in Activity 2.1 can be put into two groups:
- One-way means of communication: radio, television and newspapers. The information comes to you, but you can’t answer back through them, discuss or ask a question.
- Two-way means of communication: the telephone, the mobile phone and the computer. With these you can receive information and reply, talk and discuss.
Which of these is a two-way means of communication?
Pick an answer to see why.
What the words mean
- Information is the facts we get about any thing or event. Reading a newspaper, listening to the radio and watching television, we get information about the whole world.
- Communication is the exchange of information between two or more people or groups, by speaking, writing or any other means. In other words, expressing your feelings or experience to others, in speech, in writing or in any other way, is communication.
- Technology is the scientific way of working that is used to do a job or to invent things.
- ICT is the short form of Information and Communication Technology.
The devices used for the different jobs of ICT are called the tools (means) of information and communication technology. Some of them:
| Older tools | Newer tools |
|---|---|
| radio | computer, laptop |
| television | scanner, printer |
| newspaper | electronic book (e-book) reader |
| book | smartphone |
| telephone | digital camera |
The internet has made all these tools far more useful. On a phone or computer with internet access, you can find learning materials online, study them and do many other things.
2.2 Internet, email and browser
To search for information on a computer, you need the internet. The internet is a network that joins together billions of computers and other devices all over the world. It is because of the internet that the information stored in computers anywhere in the world can be shared. A computer can join the internet with a wire (a cable) or without a wire (wireless, by Wi-Fi or a mobile network).
Sometimes a computer is connected but the internet still doesn’t work, because of a technical problem. The small network icon near the clock on a computer shows whether it has internet access.
The internet is one of the important needs of today’s world. It connects the tools of ICT to each other. With its help we learn about events anywhere in the world almost at once, read news online, and get knowledge and information from social networks. Because of the internet, the whole world has become like one small village, a global village.
Browser
Having internet access is not enough to look at things online. The computer also needs an app (application) that opens web pages. Such apps are called browsers. Chrome, Mozilla Firefox, Safari and Microsoft Edge are widely used browsers.
Different computers and phones run different main software (Windows, Linux, macOS, Android, iOS), and the browser may differ with it: an iPhone comes with Safari, an Android phone usually with Chrome.
Website
A website is a collection of information kept on the internet, as text, photos, videos and documents, under one address. Schools, offices, companies and other organizations keep their information on their own websites. Many website addresses begin with www, which stands for World Wide Web.
No two websites in the world can have the same address, so every website has its own exact address, its web address, also called its URL (Uniform Resource Locator).
Search engine
To find something on the internet, we use a search engine: a website that searches millions of web pages for the words you type and lists the pages that match. Google, Bing and Yahoo are search engines. When a browser is installed, one search engine is already chosen as its default (the one it uses unless you change it). You can change the default in the browser’s settings.
For example, in Google Chrome:
- Open Chrome on your computer or phone.
- Click the menu, the three dots ⋮ at the top right.
- Click Settings, and then Search engine in the list on the left.
- At “Search engine used in the address bar”, choose Google, Bing or Yahoo.
- Now type any word in the address bar and press Enter: the results come from the search engine you chose.
The Google search engine is used most widely. You don’t need to know a website’s address to find it: type a few key words about what you want in the search engine. But if you do know the address (of a school, a university, a ministry, a government or non-government organization), you can type it straight into the address bar and go to its main page.
Bimala wants to read about the snow leopard but doesn’t know any website about it. What should she use?
Pick an answer to see why.
E-book
An e-book (electronic book) is a book in digital form. It can be read on a computer, a smartphone or an e-book reader. Many e-books are PDF files (Portable Document Format), which need a PDF reader app, such as Adobe Reader, or a browser, to open. You can find and download e-books on almost any subject with a search engine. An e-book takes up very little space, so one computer, or even one phone, can hold thousands of books.
Email (electronic mail) is a way of sending and exchanging messages electronically. It has made sending letters by post much rarer. With email, words, pictures, sound and videos reach another place almost at once. To use email you need a computer or phone, the internet and an email service. Companies offer free email services: Gmail, Outlook (Hotmail), Yahoo Mail and others. With such a service, you can send messages to anyone who has an email address.
Opening an email account
You can open a new email account with any email service: Gmail, Outlook, Yahoo Mail and others. You need an email account not only to send email, but also to use many services on an Android smartphone (the app store, for example).
Sending an email and reading one you got
Email can be sent from Gmail, Outlook, Yahoo Mail and other services. Here is how to do it in Gmail:
- Type www.gmail.com in the address bar and press Enter.
- Type your email address and password (or your parent’s) and click Sign in. Your mailbox opens.
- Click Compose (the + sign or the pencil) at the top left.
- In the To row, type the email address of the person you are writing to. To send the same email to several people, type their addresses one after another. You can also put addresses in Cc and Bcc to send copies.
- In Subject, write a short title, so the person knows at once what the email is about.
- Write your message. To send a file, a photo or a video with it, click the attach icon (the paper clip) at the bottom, choose the file, and it is attached.
- Click Send. The email reaches the other person’s inbox within seconds.
| Row | What it means | Who sees the addresses |
|---|---|---|
| To | the main person (or people) the email is for | everyone who gets the email |
| Cc (carbon copy) | others who should get a copy, to know about it | everyone who gets the email |
| Bcc (blind carbon copy) | others who get a copy secretly | only the sender; the others can’t see Bcc addresses |
To read the emails you have received, click Inbox. Open an email to read it. If a file is attached, you will see it below the message: click download to save it, and open it whenever you need it.
Advantages and disadvantages of email
Email is used more every day. It is easy, quick and useful for many things, but it can cause serious problems if we are careless.
| Advantages | Disadvantages |
|---|---|
| It is fast: a message arrives in seconds. | The receiver needs the internet too; where there is none, it doesn’t work. |
| It can be sent and received at any time. | Viruses can come with email and damage the computer’s data and files. |
| Besides text, it can carry sound, video, photos, files and links. | If the receiver doesn’t check the email, the message isn’t passed on. |
| It works on any computer or mobile with internet access. | Unwanted spam mail is annoying, and an important email can be lost among it. |
| Apart from the cost of the internet, it is free. | A forgotten password that can’t be recovered can mean losing the account for ever. |
| One email can be sent to many people at once. | Fake emails can trick people into giving away passwords or money. |
The password of an email account must be kept secret and changed from time to time. To be able to recover the account if you forget the password, give your mobile number or another email address when you make the account. With care and safety, email is very useful in today’s world.
Which of these is a disadvantage of email?
Pick an answer to see why.
2.3 Spreadsheet
A spreadsheet is a computer program used mainly for calculating and for making graphs and charts. It can do a large calculation quickly with a single command. People use spreadsheets more and more, for their own accounts, in business and in offices. Microsoft Excel (part of Microsoft Office) is the most common; LibreOffice Calc and Google Sheets are free ones that work the same way.
In a spreadsheet you can:
- enter data;
- arrange data in alphabetical order, or in ascending or descending order;
- add, subtract, multiply and divide;
- present the data as a table or a chart.
Rows, columns and cells
A spreadsheet is a big grid. The columns go up and down and are named by letters: A, B, C… The rows go across and are numbered: 1, 2, 3… Each box where a column and a row meet is a cell, and it is named by its column letter and its row number: its cell address. The cell in column C and row 2 is C2.
Adding numbers in a spreadsheet
Here is a bill for vegetables. Open a blank spreadsheet (search for “Excel” on the computer and open a blank workbook), and type it in like this:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name of the vegetable | Quantity (kg) | Rate (Rs/kg) | Price (Rs) |
| 2 | Tomato | 2 | 70 | |
| 3 | Potato | 5 | 35 | |
| 4 | Onion | 1 | 50 | |
| 5 | Cabbage | 3 | 30 | |
| 6 | Cucumber | 1 | 90 | |
| 7 | Mushroom | 0.5 | 250 | |
| 8 |
Every number has its own cell. The rate of tomatoes, Rs 70, is in column C and row 2, so its cell is C2. The 0.5 kg of mushrooms is in B7.
- To add all the quantities: click cell B2 (the 2 kg of tomatoes) and drag down to B7 (the 0.5 kg of mushrooms). To drag means to press, hold and move: all the cells from B2 to B7 are now selected.
- Click Σ AutoSum (on the Home tab). The total of the quantities, 12.5, appears in the cell just below, B8. AutoSum has written a formula in B8: =SUM(B2:B7), which means “add all the cells from B2 to B7”.
- To add only some numbers, click the cell where the answer should go and type a formula that begins with =. For example, once the prices are in column D (below), the price of tomatoes (D2, Rs 140) plus the price of mushrooms (D7, Rs 125) is =D2+D7: press Enter and the cell shows 265.
- In the same way, use − to subtract, * to multiply and / to divide. To take the price of onions from the price of potatoes, type =D3-D4 in the answer cell and press Enter (175 − 50 = 125). To divide the rate of mushrooms by the rate of tomatoes, type =C7/C2 (250 ÷ 70 = about 3.57).
Multiplying in a spreadsheet
The price of the tomatoes is their quantity times their rate.
- Click cell D2.
- Type =B2*C2 and press Enter. D2 shows 140 (2 × 70).
- Now the other vegetables, all at once: click D2 again, put the mouse on the small square at the cell’s bottom right corner (the fill handle), and drag it down to D7. The formula is copied into every cell, and each copy uses its own row: D3 gets =B3*C3, D4 gets =B4*C4, and so on. Each vegetable’s price appears in its row.
- To find the total cost, select D2 to D7 and click Σ AutoSum, as before: D8 shows 670.
- The average price per kilogram of all the vegetables is the total price divided by the total quantity: in any empty cell type =D8/B8, which gives 670 ÷ 12.5 = Rs 53.60 per kg.
So a spreadsheet can easily add, subtract, multiply, divide and find averages.
Cell B4 holds 6 and cell C4 holds 25. What does the cell with =B4*C4 show?
Pick an answer to see why.
Making a graph or chart in a spreadsheet
A spreadsheet can also show data as a graph or a chart: a line graph, a pie chart or a bar (column) diagram. A chart is more attractive than a table of numbers and makes the data easier to understand: one look shows what the numbers are saying.
- First, type the data into the spreadsheet. As an example, here are the numbers of people who died in road accidents in an area, month by month, from Shrawan to Poush 2077 BS:
| A | B | |
|---|---|---|
| 1 | Month | Deaths |
| 2 | Shrawan | 10 |
| 3 | Bhadra | 5 |
| 4 | Aswin | 14 |
| 5 | Kartik | 21 |
| 6 | Mangsir | 18 |
| 7 | Poush | 21 |
- Select all the data (A1 to B7) and click Insert.
- Among the kinds of charts shown, choose a suitable one.
- The chart appears on the spreadsheet page.
- Click the + sign at the top right of the chart to add things to it: tick (✓) what you want (a chart title, data labels, gridlines), and untick what you don’t.
- Click Axis Titles to give the x-axis and the y-axis their names (“Month”, “Number of deaths”).
2.4 Photo
What do you do when you visit a new place? You take photos, of course, to remember it. We take photos at birthdays, weddings, bratabandha and pasni (annaprasan, a baby’s first rice), and many other occasions. A digital photo can be sent from one place to another quickly and easily through the tools of ICT, and photos and messages can be sent and received at once with different apps.
Phones now have good cameras, so taking high-quality photos is easy. Apps on the phone or computer can edit photos to make them more attractive, and make them bigger or smaller.
Copying photos from a phone or camera to a computer
- Switch on the phone or camera and connect it to the computer with its data cable (USB).
- A message on the screen (or on the phone) asks what the connected device should do.
- Choose File transfer, because you want to move photos (files).
- On the computer, open This PC → Devices and drives. It shows the computer’s drives and the connected phone or camera, by name.
- Click the phone’s name to go inside.
- Open the DCIM → Camera folder (or Pictures). The photos are now shown on the computer.
- Select the photos to copy:
- i.for one photo, click it, right-click and choose Copy (or press Ctrl + C);
- ii.for several, click the first, then hold down Ctrl and click each of the others (or hold Shift and click the last, to pick all the photos between them), and copy them all at once;
- iii.for all the photos in a folder, select the folder itself, or open it and press Ctrl + A to select everything.
- Go to the folder or drive on the computer where you want them, right-click and choose Paste (or press Ctrl + V). The photos are now copied onto the computer.
Photo editing
Photo tools can make photos more attractive, and can make a digital photo smaller or bigger. Editing is also a useful skill for online applications: when you apply for a job or for admission to a school or college online, a photo or document often has to be of a fixed size, in a fixed file format (JPEG, PDF…). If it isn’t, the form won’t accept the upload. Here are some simple photo tools.
Crop
Sometimes a photo has more in it than you want. Keeping only the part you need and cutting off the rest is called cropping.
To crop a photo with the Photos app in Windows:
- Open the photo with a suitable photo program.
- Here we use the Photos app. (Right-click the photo and choose Open with; you can also choose which program opens photos by default.)
- When the photo is open, click the Crop tool at the top.
- A bright frame appears around the photo. Drag the frame so that only the part you want to keep is inside it.
- Dragging a corner of the frame changes two sides at once; to move just one side (left, right, top or bottom), drag the middle of that side.
- When the frame is right, click Done (or Crop and rotate).
- Click Save as copy, so that the original photo stays as it was.
- Choose the folder where the edited photo should be saved.
Light and color
- Open the photo in the Photos app, as above.
- Click Edit (or press Ctrl + E).
- Click Adjustments: options such as light, color, brightness and contrast appear.
- To make the photo lighter or darker, drag the slider for light (or brightness) left or right until the photo looks best.
- Adjust the color the same way, and the other adjustments if needed.
- With Spot fix, click on small spots or marks in the photo, again and again, to remove them.
- When everything is done, click Save as copy and save the photo on the computer.
So by adjusting the light, color and clarity, and fixing spots, we can make a photo look better.
Making a photo bigger or smaller
A digital photo is made of tiny colored squares called pixels (short for “picture elements”), arranged in rows and columns like the cells of a spreadsheet. A photo 4272 × 2848 pixels has 4272 pixels across and 2848 down: more than 12 million pixels. The more pixels, the more detail, and the bigger the file.
To change the size of a photo in MS Paint:
- Open MS Paint.
- Click File → Open at the top left and choose the photo (or press Ctrl + O).
- Zoom in or out so you can see the whole photo on the screen.
- Click Resize.
- Below the photo, Paint shows its size in pixels and its file size. In our example, the photo is 4272 × 2848 pixels and 3.3 MB.
- In the Resize box, choose Pixels. With Maintain aspect ratio ticked, changing the horizontal pixels changes the vertical ones by itself, so the photo isn’t stretched.
- To set both numbers yourself, untick Maintain aspect ratio (but the photo may then look squashed or stretched).
- To make the photo smaller, make the pixels fewer; to make it bigger, make them more.
- Click OK (or press Enter).
- In our example, making the photo 3000 × 2000 pixels brought its file size down to only 973 KB.
- Save the resized photo (Ctrl + S).
- Save it in an image format (such as JPEG), on the desktop or in a folder.
Note: with internet access, you can also resize photos on websites that come up when you search for “online image resize”.
PowerPoint presentation
To explain something so that others understand it easily, we make a PowerPoint presentation: a set of slides shown on a screen. Photos make a presentation attractive, so they must be fitted well onto the slides; they can be edited first, or right inside PowerPoint.
Cropping a photo in PowerPoint
- Save the photo on the desktop.
- Open PowerPoint and click Insert → Pictures → This Device, and choose the photo: it goes onto the slide.
- On the Home tab, click Layout and choose Blank, so the slide’s empty text boxes behind the photo go away.
- Click the photo, then the Picture Format tab (Picture Tools).
- Click Crop.
- Black handles appear at the four corners and the middle of each side of the photo.
- Drag the handles until they surround only the part you want.
- The part that stays looks brighter than the part to be cut. Click Crop again (or click outside the photo).
- Only the part you wanted is left on the slide.
Brightness, contrast, sharpness
- Click the photo on the slide, then Picture Format → Corrections.
- Point the mouse at the small pictures under Sharpen/Soften and Brightness/Contrast: the photo shows how each would look. Click the one that looks clearest.
- For more control, click Picture Corrections Options and set the values you need.
- You can make other changes too, with the buttons for color and artistic effects next to Corrections.
- To write a caption under a photo, add a text box (Insert → Text Box) and type in it.
- You can put more than one photo on a slide. So that the photos and their captions don’t shift apart when you move them, group them.
- To group: press Ctrl + A to select everything on the slide, or click one photo and hold Shift while clicking the others.
- With them selected, right-click on the edge of one of them.
- From the menu, choose Group.
- Now the photo and the caption under it move together as one picture. That is why a picture and its caption should always be grouped.
Rina’s online admission form says: “Photo: JPEG, up to 200 KB.” Her photo is a 3 MB JPEG. What should she do?
Pick an answer to see why.
2.5 Computer virus
A computer virus is a kind of computer program that gets into a computer, often without the user knowing, and harms how it works. It can close programs, show the same message again and again, or even shut the computer down by itself. Like a virus that makes people ill, it spreads from one computer to another.
You may suspect a virus if:
- problems keep coming back while you work, or the computer switches itself on or off;
- files get damaged and won’t open, or can’t be deleted;
- strange new folders appear on the computer or on a pen drive or memory card;
- the same unwanted message keeps popping up while you do something else;
- the computer becomes very slow, or programs stop working properly.
A virus damages files and programs and gives the computer wrong instructions.
How viruses spread
- The internet is the main way. If a file on a website, or a file attached to an email, carries a virus, it can get straight into the computer that opens it (the host computer).
- Storage devices: pen drives, memory cards, CDs, hard disks (and, on old computers, floppy disks). Files copied from a computer that has a virus carry it to the next computer.
- Installing programs: some viruses install themselves through autorun when a program or a device is opened, and some are installed by users without their knowing, hidden inside a program they wanted.
Preventing computer viruses
Just as for an illness, prevention is better than cure. Some ways to keep viruses out:
- Files downloaded from the internet can bring viruses, so don’t visit unnecessary or unknown websites, and download only from websites you trust.
- Don’t open emails from unknown addresses (spam), or the files attached to them, without checking who sent them and why.
- Keep the computer’s firewall switched on all the time.
- Don’t use easy passwords that others can guess. A strong password mixes letters (a–z, A–Z), numbers (0–9) and special characters (!, @, #, $).
- Don’t download programs from unknown websites, especially “free” copies of programs that are normally paid for (“cracked” software): they very often hide viruses. Get software from its maker’s own website or the official app store.
- Install good antivirus software, which protects the computer from viruses.
- Keep the antivirus updated, and scan the drives, folders and portable media (pen drives, memory cards, hard disks) from time to time.
Removing a computer virus
Even with care, a virus sometimes gets in. If the computer becomes much slower than usual, or its programs don’t work properly, it may have a virus. To find and delete it, you need antivirus software:
- Install a suitable antivirus program on the computer.
- Update it (its database update), so it knows the newest viruses.
- From its Scan options, choose Full scan (the whole computer, slow) or Quick scan (the places viruses usually hide, fast).
- When the scan ends, it shows a notification listing any viruses or other problems found.
- Choose Delete (or Quarantine, which locks the file away) from the action options next to each item in the list.
- If the scan causes problems because of a wrong setting, change the setting as the antivirus program’s instructions say.
Which of these is the best way to keep viruses off a school computer?
Pick an answer to see why.
2.6 Software
An instruction, or set of instructions, that tells a computer how to do a job is a program (programme). A set of programs is called software. Software gives the computer its directions: it controls the computer and solves the user’s problems. Without software, a computer is a box of parts that can do nothing. The physical parts you can touch (the screen, the keyboard, the processor) are the hardware.
Many kinds of software are available: older ones such as MS-DOS (Microsoft Disk Operating System) and Windows XP, and the newer Windows 11, Paint, Excel, Word and many more. Some software is free: it can be downloaded from the internet and installed easily (some free software is also open, its instructions open for anyone to read and improve). Other software must be bought before it can be used.
Software is sorted into three kinds.
System software
System software runs and controls the computer system itself. It is made to run the computer’s hardware, and it is the most important software of a computer: nothing else can run without it. The main system software is the operating system (OS). Windows, macOS, Android and Linux are operating systems.
Application software
Application software is software made for the jobs a user wants to do. It is designed for the user’s needs: writing, calculating, drawing, browsing, playing. MS Office (Word, Excel, PowerPoint), Photoshop and PDF readers are application software. On a phone, application software is called an app.
Utility software
Utility software helps the software and the hardware work well together, so the computer runs fast, reliably and properly. Antivirus programs, disk cleaners and disk defragmenters are utility software.
Which of these is utility software?
Pick an answer to see why.
2.7 Code of conduct for using computer and internet
Computers have made many jobs easy, and the internet lets us share information instantly. But if we don’t know how to use them properly, we can get into trouble. On social media we may make virtual friends, people we know only online, trust them, and share private information that can cause big problems in our lives, and even loss of money. News of digital theft and cheating comes up often. So we must know the precautions to take.
The rules to follow when using computers and the internet are called the code of conduct (terms and conditions, or internet ethics) for computer and internet use. Some of them:
- Don’t give your personal details (full name, date of birth, age, mobile number, address, school) to people you don’t know.
- Don’t give anyone’s personal details to others without their permission. If you must, with permission, make sure they won’t be misused.
- Never share your password.
- Don’t let a computer save your password automatically if others use it too, as in a school or an office.
- Don’t share anyone’s photo, or a group photo, without the permission of the people in it.
- Never make a social media account in someone else’s name.
- If your account is stolen or hacked, or someone you don’t know threatens you or causes you trouble, report it to the Cyber Bureau of Nepal Police, or to another proper authority.
- If a stranger online tries to get close to you, asks to meet, or keeps sending unwanted messages, tell your parents or teacher at once.
- Don’t open an email without knowing who sent it. If it is from a stranger, open it only after making sure it is for a proper purpose.
- Don’t open or reply to unwanted spam emails, and don’t forward them to others.
- Hackers send emails and social media messages saying you have won a prize or a great chance, to steal your personal details. Don’t be tempted by them.
- Don’t post photos that show where you are while you are traveling or away from home where strangers can see them. Someone could use that information to steal from your home, or harm you.
Exercise
1. Fill in the blanks
Use these words: software, browser, connect, ICT, program.
Computers, smartphones and digital cameras are tools of ……… .
Answer
ICT (information and communication technology)
The internet ……… the tools of information technology with each other.
Answer
connects
We can search the internet for the information we need with the help of a ……… .
Answer
browser (with a search engine in it)
A series of instructions given to a computer is called a computer ……… .
Answer
programme (program)
A spreadsheet is ……… used on a computer to prepare charts and graphs.
Answer
software
2. Write ✓ for a correct statement and ✗ for an incorrect one
Because of the internet, computer devices all over the world are used to exchange information.
Answer
✓ Correct.
The receiver of an email does not need internet service to read it.
Answer
✗ Incorrect. The receiver needs the internet to receive and read the email.
A photo can be made more attractive by photo editing.
Answer
✓ Correct.
The size of a photo can be increased or decreased using MS Paint.
Answer
✓ Correct (with its Resize tool).
The set of instructions used to operate a computer is called a program.
Answer
✓ Correct.
3. Choose the correct option
a. What type of software is Windows?
Pick an answer to see why.
b. What does Cc in an email stand for?
Pick an answer to see why.
c. Which of these is a disadvantage of email?
Pick an answer to see why.
d. What does drag mean in a spreadsheet?
Pick an answer to see why.
e. What does gov in www.moecdc.gov.np show?
Pick an answer to see why.
4. Differentiate between
System software and application software
Answer
| System software | Application software |
|---|---|
| Runs and controls the computer and its hardware. | Does the particular jobs a user wants done. |
| The computer can’t work at all without it. | Is installed and used according to the user’s needs. |
| Runs all the time the computer is on. | Runs only when the user opens it. |
| e.g. Windows, Android, Linux, macOS | e.g. MS Word, Excel, Photoshop, a PDF reader |
A letter (post) and an email
Answer
| Letter (post) | |
|---|---|
| Written on paper and carried by post. | Typed and sent electronically through the internet. |
| Takes days or weeks to arrive. | Arrives within seconds. |
| Needs a stamp for each letter. | Free, apart from the cost of the internet. |
| Can carry only paper (and small things). | Can carry text, photos, sound, video and files. |
| One letter goes to one address. | One email can go to many people at once. |
| Needs no internet or electricity. | Needs a device and the internet at both ends. |
5. Answer the following questions
What is information and communication technology?
Answer
Information and communication technology (ICT) is the use of tools and technology, such as computers, mobile phones, the internet, radio and television, to create, store, display, send and exchange information and to communicate with others. “Information” is the facts we get about things and events; “communication” is the exchange of information between people; “technology” is the scientific way of working used to do jobs and make things.
How have the tools of information and communication technology changed the way people live? Explain.
Answer
- Communication: we can talk, see and send messages to relatives in Nepal or abroad at once, by mobile phone, video call and email, instead of waiting weeks for letters.
- Information: news from anywhere in the world reaches us almost at once through television, radio and the internet.
- Learning: students learn from e-books, online videos, virtual classes and radio and TV lessons, even at home.
- Work and money: offices keep records and accounts on computers; people pay bills, bank and shop online; forms are filled online.
- Health, travel and safety: doctors share reports online, tickets are booked online, and CCTV helps security.
- Entertainment: music, films and games on demand.
But there are new problems too: cybercrime, fraud, misuse of personal details, and spending too much time on screens.
What is the internet? Make a list of the tasks that have become possible because of it.
Answer
The internet is a worldwide network that joins billions of computers and other devices, by wire and without wires, so that information can be shared and exchanged between them.
Tasks made possible by the internet:
- searching for information on any subject with a search engine;
- sending and receiving email, and messages with photos and videos;
- video calls with people anywhere in the world;
- reading news and e-books, and downloading textbooks;
- online classes and learning videos;
- online shopping, banking and paying bills;
- filling in forms and applications online (admissions, jobs, passports);
- social networking, sharing photos and keeping in touch with friends.
How can we use an e-book? Write any two advantages of using e-books.
Answer
An e-book is a book in digital form, often a PDF file. We download it from a website (for example, Nepal’s textbooks from the CDC website, www.moecdc.gov.np), or find it with a search engine, and read it on a computer, a smartphone or an e-book reader with a reader app.
Advantages (any two):
- It takes very little space: thousands of e-books fit on one computer or phone.
- It is cheap or free, and can be downloaded at once from anywhere with the internet.
- It doesn’t tear, fade or get lost, and saves paper.
- Words can be searched and the text made bigger to read easily.
Write any two advantages and two disadvantages of email.
Answer
Advantages:
- It is very fast: a message arrives in seconds.
- Text, photos, sound, video and files can be sent, to many people at once, almost free.
Disadvantages:
- Both the sender and the receiver need the internet.
- Viruses and fake (spam) emails can come with it and harm the computer or trick the user.
What is a spreadsheet program? Make a list of the tasks that can be done with it.
Answer
A spreadsheet program is computer software used mainly for calculating and for making graphs and charts. Its data are kept in cells, arranged in columns (A, B, C…) and rows (1, 2, 3…). Microsoft Excel is an example.
Tasks:
- entering and storing data in a table;
- arranging data in alphabetical, ascending or descending order;
- adding, subtracting, multiplying and dividing with formulas;
- finding totals (SUM) and averages quickly;
- making charts and graphs (bar, line, pie) from the data;
- keeping accounts, marks, bills and records, which update themselves when a number changes.
What is a computer virus? What can be done to stop computers being infected with viruses?
Answer
A computer virus is a harmful computer program that gets into a computer, usually without the user knowing, spreads to other computers, and damages files and programs or stops the computer working properly.
Ways to prevent it:
- Install a good antivirus program and keep it updated.
- Scan pen drives, memory cards and other portable media before opening them.
- Keep the firewall switched on.
- Don’t open emails or attachments from unknown senders, or spam.
- Don’t visit unknown websites or download pirated software; get software from its maker or the official app store.
- Use strong passwords.
Why is it necessary to follow a code of conduct when using the internet on a computer?
Answer
- To keep our personal details, passwords and photos safe from people who could misuse them.
- To protect ourselves from cheating, theft, threats and strangers who mean harm.
- To respect other people’s privacy: not sharing their details or photos without permission, not making fake accounts in their names.
- To keep computers safe from viruses and hackers (not opening spam, not saving passwords on shared computers).
- Because breaking these rules can be a crime under the law, and can harm others.
If everyone follows the code of conduct, the internet stays safe and useful for all.
What are the tools of information and communication technology?
Answer
The devices used to create, store, display, send and exchange information are the tools of ICT. Examples: radio, television, newspaper, book, telephone, mobile phone (smartphone), computer and laptop, the internet, digital camera, scanner, printer, projector, CCTV and e-book readers. Radio, television and newspapers are one-way tools; telephones, mobiles and computers are two-way tools.
How has the development of information and communication technology made human life easier?
Answer
- We can talk to and see anyone, anywhere, at once, by phone, video call and email.
- Information on any subject is found in seconds with a search engine.
- Students can learn at home with e-books, online classes and educational videos.
- Many jobs are done quickly and correctly by computer: accounts with spreadsheets, letters and reports, photo editing and presentations.
- Services come home: online banking, bill payment, shopping, ticket booking and filling in forms, without traveling or queuing.
- News, weather warnings and health information reach people quickly, which saves time and even lives.
6. Use a spreadsheet
Type this data into a spreadsheet. Taking 100 as the full marks of each subject, work out the total marks and the percentage of each student.
| S.N. | Name | English | Nepali | Maths | Science | Social | Total | Percentage |
|---|---|---|---|---|---|---|---|---|
| 1 | Aarati | 55 | 45 | 70 | 56 | 72 | ? | ? |
| 2 | Dolma | 53 | 54 | 43 | 62 | 45 | ? | ? |
| 3 | Lakpa | 64 | 67 | 56 | 34 | 53 | ? | ? |
| 4 | Meena | 53 | 75 | 76 | 45 | 76 | ? | ? |
| 5 | Raman | 65 | 52 | 65 | 32 | 32 | ? | ? |
Hint
Put the headings in row 1, so S.N. is in column A, Name in B, English to Social in C to G, Total in H and Percentage in I. Aarati is in row 2. Five subjects of 100 marks make 500 full marks.
Answer
In H2 type =SUM(C2:G2), and in I2 type =H2/500*100. Then select H2 and I2 together and drag the fill handle down to row 6.
| Name | Total | Percentage |
|---|---|---|
| Aarati | 298 | 59.6 % |
| Dolma | 257 | 51.4 % |
| Lakpa | 274 | 54.8 % |
| Meena | 325 | 65 % |
| Raman | 246 | 49.2 % |
Check one by hand: Aarati, 55 + 45 + 70 + 56 + 72 = 298, and 298 ÷ 500 × 100 = 59.6 %.
Practice every question in the book, and keep track of the ones you miss →
