Page 3 :
GOVERNMENT OF KARNATAKA, , INFORMATION AND, COMMUNICATION TECHNOLOGY, (ICT), Workbook, , 9, NINETH STANDARD, , LEVEL IV, , Karnataka Residential Educational Institutions Society, No -8, M.S.B -1, 6th and 7th Floor, Cunningham Road,, Bengaluru – 560 052, .
Page 4 :
Karnataka Residential Educational Institutions Society, , 6th Standard, , CONTENTS, SL.NO, , NAME OF THE LESSON, , PAGE NO, , 01, , Overview of Level III, , 01, , 02, , More on Word Processor, , 02, , 03, , More on Spreadsheet, , 04, , 04, , Introduction to Presentation, , 07, , 05, , Introduction to Internet, , 09, , 06, , Electronic-Mail, , 12, , 07, , Online Services, , 14, , 08, , Computer Networks, , 17, , 09, , HTML, , 22, , 10, , Projects, , 25
Page 5 :
9th Standard, , Chapter, , Chapter 1: Overview of Level III, , 1, , Overview of Level III, Worksheets, , I. Complete the crossword puzzle for shortcut keys:, Down:, , Across:, 6. Ctrl + V, , 1. Ctrl + V, , 7. Ctrl + S, , 2. Ctrl + U, , 8. Ctrl + I, , 3. Ctrl + X, , 9. Ctrl + C, , 4. Ctrl + B, , 10. Ctrl + N, , 5. Ctrl + O, , 5, 3, , C9, , 2, 1, , 10, , P6, , 4, , 8, , I, , 7, , ( CUT, COPY, PASTE, BOLD, ITALIC, UNDERLINE, NEW, OPEN, SAVE ), , Karnataka Residential Educational Institutions Society, , 1|Page
Page 6 :
Chapter, , Chapter 2: More on Word Processor, , 2, , 9th Standard, , More on Word Processor, Worksheets, , I. Fill in the blanks with suitable words:, 1. A combination of rows and column is called a ____________., 2. ____________ option is used to combine two or more cells into one cell., 3. The ________________ feature helps to create artistic text., 4. ________________ is the text that is added to the top margin of every page., 5. ____________ group consists of margins, orientation, size and columns options., 6. ____________ and _______________ are two types of page orientations., , II. Write the steps to insert:, 1. Table, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, 2. Clipart, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, , Karnataka Residential Educational Institutions Society, , 2|Page
Page 7 :
9th Standard, , Chapter 2: More on Word Processor, 3. Word Art, , _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, 4. Watermark, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Using Clipart create a document about “Save the Tiger”., 2. Create a document on effects of using tobacco and using alcoholic drinks., 3. Using Shapes, Prepare a document on Polygons., 4. Insert the following text using Word Art., a. INDIA, , 2. KARNATAKA, , 3. COMPUTER, , 4. MONITOR, , 5. Group Activity:, a. Prepare a class timetable of your class on the computer. Use, table properties and Take a printout of time table and display it, in your class., b. Prepare a directory of your class on the computer. List the, names of students along with their addresses and telephone, numbers. Now arrange this in alphabetic order. Choose a name, for your directory and add this as the title., Sl No, , Student Name, , Address, , Contact No, , c. Prepare a School day invitation card. Use page margin, page border, page color., And invite your friends to that program., , Karnataka Residential Educational Institutions Society, , 3|Page
Page 8 :
9th Standard, , Chapter, , Chapter 3: More on Spreadsheet, , 3, , More on Spreadsheet, Worksheets, , I. Fill in the blanks with suitable words:, 1. _________ means arranging the data in a given order., 2. The _______ command is used to filter unwanted data., 3. _______chart compares values across categories by using vertical bars., 4. The TODAY() is returns ___________ date., 5. ___________function returns the factorial of a given number., 6. The logical condition limit of IF,OR and AND functions is__________, , II. Match the following:, 1. NOW(), , To get remainder, , __________________, , 2. UPPER(), , Find square root, , __________________, , 3. MOD(), , Convert to capital letter, , __________________, , 4. PRODUCT(), , Date and time, , __________________, , 5. SQRT(), , To get product., , __________________, , III., , Write the syntax of the following functions., , 1. PRODUCT() ________________________________________________, 2. SQRT(), , ________________________________________________, , Karnataka Residential Educational Institutions Society, , 4|Page
Page 10 :
9th Standard, , Chapter 3: More on Spreadsheet, , A C, , T, , I, , V, , I, , T, , Y, , 1. Create the Bar chart for marks of your class, 2. Create the Pi chart for the strength of your school., 3. Generate all perfect square numbers between 1 and 100, 4. Generate following series in a spreadsheet., a. Natural number, b. Even number, c. Odd number, 5. Generate all perfect cube numbers between 1 and 100, 6. Design a spreadsheet to the following problem., The number of goals scored by a hockey team in 20 matches is given here, 4,6,3,2,2,4,1,5,3,0,4,4,5,4,5,4,0,4,4,3,6,4. Find the Mean., 7. Design a spreadsheet to the following problem., The cost of a motorbike is 90000; the company offers it in 3 months of equal, installments at 10% of interest. Find the equated monthly interest., 8. Create a spreadsheet to find the compound interest on 12,000 for 2 years at 4% per, annual., 9. Create a spreadsheet for marks register of your class and perform following, operations., a. Sort the Name field in an ascending order., b. Sort the Name field then by Total field, c. Save the file as Mark., 10. The population of different continents as in 2013 is given in below table., Continent, Population, Asia, 4,29,87,23,000, Africa, 1,11,06,35,000, Europe, 74,24,52,000, North America, 56,52,65,000, South America, 40,67,40,000, Australia, 3,83,04,000, Antarctica, 4,490, Create following charts in a spreadsheet., (a) Bar Chart (b) Pie Chart, (c) Line Chart (d) Area Chart, , Karnataka Residential Educational Institutions Society, , 6|Page
Page 11 :
Chapter, , Chapter 4: Introduction to Presentation, , 4, , 9th Standard, , Introduction to Presentation, Worksheets, , I., , Fill in the blanks with suitable words:, 1. A presentation is made up of _____________., 2. _______________ are boxes with dotted borders that are part of all slide layouts., 3. ______________ are the basic slide elements necessary for creating a presentation., 4. A small image of each slide is displayed in _________________ view., 5. Keyboard shortcut used to start a slide show is ________., 6. ___________ is OpenOffice.org presentations component., , II., , Answer the following questions in one or two sentences each:, 1. What is a slide?, ____________________________________________________________________, ____________________________________________________________________, 2. Write the steps to open a presentation., ____________________________________________________________________, ____________________________________________________________________, 3. Write steps to delete a slide., ____________________________________________________________________, ____________________________________________________________________, 4. List the working areas of Normal view., ____________________________________________________________________, ____________________________________________________________________, Karnataka Residential Educational Institutions Society, , 7|Page
Page 12 :
9th Standard, , Chapter 4: Introduction to Presentation, 5. What are animations?, , ____________________________________________________________________, ____________________________________________________________________, , III., , Answer the following questions in three or four sentences each:, 1. What is a presentation program? Give any two examples., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, 2. Write the steps for inserting additional text boxes., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, 3. Write the steps for applying transition to slides., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Create a presentation on the following the topics., a. Solar System, b. Cell Division, c. Memory devices, d. Communication gadgets, e. National parks in India., , Karnataka Residential Educational Institutions Society, , 8|Page
Page 15 :
9th Standard, , Chapter 5: Introduction to Internet, , A C, , T, , I, , V, , I, , T, , Y, , 1. List out the government website address., 2. List out five important websites for browsing, the information., 3. Collect the pictures and information on, different types of browser., 4. Collect the pictures and information on, different types of search engines., 5. Collect the information and make a poster of, Human Respiratory system., , Karnataka Residential Educational Institutional Society, , 11 | P a g e
Page 16 : 9th Standard, , Chapter, , Chapter 6: Electronic-Mail, , 6, , Electronic-Mail, Worksheets, , I. Circle the words that belong to e-mail application interface:, Post, , Inbox, , Delete, , Like, , Receive, , Send, , Erase, , Forward, , Poke, , Compose, , Comment, , Attachment, , II. Answer the following questions in one or two sentences each:, 1. What is e-mail?, ____________________________________________________________________, ____________________________________________________________________, 2. Who invented e-mail?, ____________________________________________________________________, ____________________________________________________________________, 3. List any two e-mail service providers., ____________________________________________________________________, ____________________________________________________________________, 4. Identify the user and domain for
[email protected]., ____________________________________________________________________, ____________________________________________________________________, , Karnataka Residential Educational Institutions Society, , 12 | P a g e
Page 17 :
9th Standard, , Chapter 6: Electronic-Mail, , III. Answer the following questions in three or four sentences each:, 1. Write any two differences between post and e-mail., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, 2. How to send an e-mail? Explain steps., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, 3. List out the any two do’s and don’ts of e-mail., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. List the three ways we use to communicate with friends or anyone., 2. Create your own e-mail account in any one e-mail service, providers., 3. Prepare a birthday card and send it to your friend’s e-mail, address., 4. Invite your friends to your School’s Annual Day using e-mail., , Karnataka Residential Educational Institutions Society, , 13 | P a g e
Page 18 :
9th Standard, , Chapter, , Chapter 7: Online Services, , 7, , Online Services, Worksheets, , I. Fill up the blanks with suitable words:, 1. __________________a group of people responsible for the administration and control, of a Country/State., 2. The electronic sharing of ______________and _______________ between, government agencies, departments or organizations., 3. ______________ is Online Delivery of Land Records in Karnataka., 4. E-Commerce is commonly known as____________________., 5. ____________ is defined as commerce between companies and the public sector., , II. Answer the following questions in one or two sentences each:, 1. What is E-Governance?, ____________________________________________________________________, ____________________________________________________________________, 2. What is E-Commerce?, ____________________________________________________________________, ____________________________________________________________________, 3. List types of E-Commerce, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, , Karnataka Residential Educational Institutions Society, , 14 | P a g e
Page 21 :
9th Standard, , Chapter, , Chapter 8: Computer Networks, , 8, , Computer Networks, Worksheets, , I. Fill up the blanks with suitable words:, 1. Communication model is used to exchange __________between two parties., 2. The data is exchanged in the form of ____________ and _____________., 3. __________________is the person who is sending the message., 4. Protocol is some set of _________ which govern data communication., 5. MESH Topology is a __________ connection to other nodes or devices., 6. A firewall protects a network from ____________access and communication., 7. ___________ code or the algorithm used in the encryption and decryption of data., , II. Identify the following network components:, , 1. ___________________, , 2. ___________________ 3. ___________________, , 4. ___________________, , 5. ___________________ 6. ___________________, , Karnataka Residential Educational Institutions Society, , 17 | P a g e
Page 22 :
9th Standard, , Chapter 8: Computer Networks, , III. Expand the following:, 1. LAN, , ______________________________________, , 2. MAN, , ______________________________________, , 3. WAN, , ______________________________________, , 4. WLAN, , ______________________________________, , IV. Complete the following Network Topologies by:, A. Drawing the missing connections., B. Labelling the hardware., C. Making appropriate connections., 1., , 2., , 3., , 4., , ., , ., , Karnataka Residential Educational Institutions Society, , 18 | P a g e
Page 23 :
9th Standard, , Chapter 8: Computer Networks, , V. Solve the following coding and decoding:, 1. In a certain language, MADRAS is coded as NBESBT, how is BOMBAY coded in, that code?, A. CPNCBX, , B. CPNCBZ, , C. CPOCBZ, , D. CQOCBZ, , 2. In a certain code, TRIPPLE is written as SQHOOKD. How is DISPOSE written in, that code?, A. CHRONRD, , B. DSOESPI, , C. ESJTPTF, , D. ESOPSID, , 3. If in a code language, COULD is written as BNTKC and MARGIN is written as, LZQFHM, how will MOULDING be written in that code?, A. CHMFINTK, , B. LNKTCHMF, , C. LNTKCHMF, , D. NITKHCMF, , VI. Answer the following questions in one or two sentences each:, 1. What is computer network?, _____________________________________________________________________, _____________________________________________________________________, 2. List different network topologies., _____________________________________________________________________, _____________________________________________________________________, 3. What is server?, _____________________________________________________________________, _____________________________________________________________________, 4. What is modem?, _____________________________________________________________________, _____________________________________________________________________, 5. List the two types of Firewall., _____________________________________________________________________, _____________________________________________________________________, , Karnataka Residential Educational Institutions Society, , 19 | P a g e
Page 25 :
9th Standard, , Chapter 8: Computer Networks, 5. List and explain advantages of computer network., , _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, _____________________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Collect the information about Client/ Server Architecture., 2. Gather pictures and information about different types of Modem., 3. A cipher with an example is given below. Study these and do the following:, A. Encrypt your state name using the given cipher., B. Decrypt using the given cipher: 22 11 33 11 52 11 45 11 33 44 32 11, Cipher, 1, 2, 3, 4, 5, 1 A B C D E, F G H I/J K, 2, L M N O P, 3, 4 Q R S T U, 5 V W X Y Z, Example, Plaintext: KREIS, Ciphertext: 52 24 51 42 34, , a. ______________________________________, b. ______________________________________, , 4. Build a cipher of your own., a. Encrypt your name using the cipher. Show this to your friends., b. Write a message using your cipher. Ask your friends to decrypt the message., a. NAME:__________________________________________, CIPHER:_________________________________________, b. NAME:__________________________________________, CIPHER:_________________________________________, , Karnataka Residential Educational Institutions Society, , 21 | P a g e
Page 26 :
9th Standard, , Chapter, , Chapter 9: HTML, , 9, , HTML, Worksheets, , I., , Fill in the blanks with suitable words:, 1. HTML stands for _________________________________________., 2. HTML file is saved with _________ or _________extension., 3. HTML tags are enclosed with ______________., 4. _________is used to visually break up sections of a document., 5. _________element is used to display in italic., , II. Match the following:, 1. <h3>, , Bold, , ________________, , 2. <p>, , Table row, , ________________, , 3. <b>, , Unordered List, , ________________, , 4. <hr>, , Paragraph, , ________________, , 5. <tr>, , Heading, , ________________, , 6. <ul>, , Horizontal line, , ________________, , III. Answer the following questions in one or two sentences each:, 1. What is HTML?, ____________________________________________________________________, ____________________________________________________________________, 2. What is a DOCTYPE?, ____________________________________________________________________, ____________________________________________________________________, , Karnataka Residential Educational Institutions Society, , 22 | P a g e
Page 27 :
Chapter 9: HTML, , 9th Standard, , 3. List any four HTML formatting tags., ____________________________________________________________________, 4. Write the syntax for inserting images into Webpage., ____________________________________________________________________, ____________________________________________________________________, 5. What is Hyperlink?, ____________________________________________________________________, ____________________________________________________________________, 6. Which ar the tools used for creating HTML files?, ____________________________________________________________________, ____________________________________________________________________, , IV. Answer the following questions in three or four sentences each:, 1. Write the structure of HTML document structure?, , 2. Write a simple HTML program for inserting table., , Karnataka Residential Educational Institutions Society, , 23 | P a g e
Page 28 :
9th Standard, , Chapter 9: HTML, 3. List the type attributes for ordered list tag., , ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, 4. Explain the attributes of Anchor tag., ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, ____________________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Create a basic web page using HTML basic tags., 2. Create a web page using HTML for a table with marks list., 3. Design a HTML web page to demonstrate href tag., 4. HTML Tags Quiz: Provide a list of HTML tags and ask students, to identify what the tags do (Example: “the tag used to italic, text”)., 5. HTML Errors Quiz: Provide students with the source code for, an actual website but introduce a number of errors into the code., Students will then be marked on whether they identify and correct the error., , Karnataka Residential Educational Institutions Society, , 24 | P a g e
Page 29 :
1. Create a table and list of the National parks in India., Sl No, , Name of, , State where, , Animals found, , National Park, , located, , in National Park, , 2. Create a word processor document related to Bank Transactions., 3. Prepare a document on important identities of Mathematics and display it, in your Mathematics laboratory., 4. Prepare a Presentation on E-Commerce and give a seminar., 5. Design a network for your school. The computers are located in, Computer Labs, Staff room, and Office., Details of computers to be included:, 5 computer in Computer Lab, 1 Computer in Staff room, 1 Computer, in office, One server., Guidelines for drawing the layout:, Draw the network layout in each of the computer laboratory, Staff, room, and office., Interconnect the lab, staff room, and office networks., 6. Design a simple School Website using HTML tags., , Karnataka Residential Educational Institutions Society, , 25 | P a g e