Page 3 :
GOVERNMENT OF KARNATAKA, , INFORMATION AND, COMMUNICATION TECHNOLOGY, (ICT), Workbook, , 8, EIGHTH STANDARD, , LEVEL III, , 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 II, , 01, , 02, , Classification of computer, , 03, , 03, , Computer Organization, , 06, , 04, , Introduction to Word Processor, , 10, , 05, , Formatting in Word Processor, , 12, , 06, , Introduction to Spreadsheet, , 15, , 07, , Formatting in Spreadsheet, , 18, , 08, , Projects, , 21
Page 5 :
8th Standard, , Chapter, , Chapter 1: Overview of Level II, , 1, , Overview of Level II, Worksheets, , I. Classify the following as Hardware and Software:, Speaker, , Tux Paint, , Windows, , CD, , Mouse, , Linux, , Baraha, , RAM, , Biometric, , Android, , Hardware, , Software, , II. Match the Following:, Sl No, , Generation, , Used Component, , 1., , First, , Transistor, , 2., , Second, , Microprocessor, , 3., , Third, , Vacuum Tubes, , 4., , Fourth, , VLSI, , 5., , Fifth, , Integrated Circuit, , III. Complete the crossword puzzle:, DOWN:, 1. The physical parts of a computer system called as ___________., 2. __________ are used to store data and information, songs, pictures etc., , Karnataka Residential Educational Institutions Society, , 1|Page
Page 6 :
8th Standard, , Chapter 1: Overview of Level 2, 3. __________ is a horizontal bar located at the bottom of the screen., 4. A Set or collection of programs is known as software., , 5. __________ is the raw information or basic facts that computer can process., 6. The main file management tool on Windows is __________., 7. ____________ is a GUI based operating system., 8. ___________ are the small pictures that represent a file, folder, or application., ACROSS:, 9. ___________ is the workspace that appears when the operating system is booted., 10. ___________ helps you to organize files on a computer., 11. The button with the Windows logo on the left corner of the taskbar is called ______., 12. _________ is a process of loading the operating system to the system’s main memory., 13. __________ is a command - line based operating system., 14. __________ is UNIX based operating System., 15. People who use the computer are called _______., 1, , D9, 15, 2, , F10, , 3, 4, , 12, , T, , 11, 5, , T, , 13, 14, 7, , 6, , O, , I, 8, , N, , (SOFTWARE, FOLDER, DOS, DATA, TASKBAR, START, ICON, WINDOWS,, BOOTING, LINUX, COMPUTER, HARDWARE, FILES, DESKTOP, USER), , Karnataka Residential Educational Institutions Society, , 2|Page
Page 7 :
8th Standard, , Chapter, , Chapter 2: Classification of Computer, , 2, , Classification of Computer, Worksheets, , I., , Fill in the blanks with suitable words:, 1. According to Purpose computers are classified into ___________________ and, ____________________., 2. Analog computer operates by _______________ rather than counting., 3. Digital computer converts the data into binary digits ______ and ______., 4., , ________________ was India’s first Supercomputer., , 5. The first PC was developed by _________________, , II., , Beside each of the following, write the data that is being measured or, counted. State whether the device is analog or digital. The first one, already done for you., Device, , Data, , Analog/Digital, , Weather Vane, , Wind Direction, , Analog, , Note Counting Machine, Mercury Thermometer, Calculator, , Karnataka Residential Educational Institutions Society, , 3|Page
Page 8 :
8th Standard, , Chapter 2: Classification of Computer, , III., , IV., , Match the following:, 1. Digital Alpha, , Super Computer, , _____________________, , 2. CDC 6600, , Micro Computer, , _____________________, , 3. PARAM, , Mini Computer, , _____________________, , 4. Laptop, , Main Frame, , _____________________, , Answer the following questions in one or two sentences each:, 1. List the types of Digital Computers., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 2. Write any two features of Mini Computers., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 3. Where the Hybrid Computers are used?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, V., , Answer the following questions in three or four sentences each:, 1. Write a note on Analog Computer., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, , Karnataka Residential Educational Institutions Society, , 4|Page
Page 9 :
8th Standard, , Chapter 2: Classification of Computer, 2. List any four features of Micro Computer., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 3. Why Super Computers are used in research filed?, , ___________________________________________________________, _______________________________________________________, ___________________________________________________________, ___________________________________________________________, 4. List the difference between Analog and Digital Computers, Analog Computer, , A C, , T, , Digital Computer, , I, , V, , I, , T, , Y, , 1. Collect the pictures of Microcomputers., 2. Gather the information about Indian supercomputers., 3. Group Activity: Make a list of everyday objects and, classify them based on a criterion., , Karnataka Residential Educational Institutions Society, , 5|Page
Page 10 :
8th Standard, , Chapter, , Chapter 3: Computer Organization, , 3, , Computer Organization, Worksheets, , I., , Fill in the blanks with suitable words:, 1. ___________ and ____________ are commonly used input devices., 2. ALU performs _______________________ and ________________ operations., 3. Storage capacity of computer is measured in ___________., 4. ___________ Memory is placed between CPU and main memory., 5. _____________ is an example for Volatile Memory., , II., , III., , Match the following:, 1. 1 Byte, , -, , 1024 MB, , _________, , 2. 1 KB, , -, , 1024 B, , _________, , 3. 1 MB, , -, , 1024 GB, , _________, , 4. 1 GB, , -, , 1024 KB, , _________, , 5. 1 TB, , -, , 8 Bits, , _________, , Expand the following:, 1. C.P.U -, , _____________________________________________, , 2. A.L.U -, , _____________________________________________, , 3. R.A.M -, , _____________________________________________, , Karnataka Residential Educational Institutions Society, , 6|Page
Page 12 :
8th Standard, , Chapter 3: Computer Organization, , V., , Answer the following questions in three or four sentences each:, 1. List the functions of Input unit?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 2. Draw a Block diagram of Computer and label it parts., , 3. Write a note on RAM., , ___________________________________________________________, _______________________________________________________, ___________________________________________________________, ___________________________________________________________, 4. Compare Primary Memory and Secondary Memory., Primary Memory, , Secondary Memory, , Karnataka Residential Educational Institutions Society, , 8|Page
Page 13 :
8th Standard, , Chapter 3: Computer Organization, , A C, , T, , I, , V, , I, , T, , Y, , 1. Make a chart of the block diagram of a computer, and display it in the computer lab., 2. Make a poster of secondary memory storage, devices. List out the tips for Care and handling of, removable media., 3. Learn how to use the removable storage devices., 4. Gather picture and information about the storage, capacity of the secondary storage devices., , Karnataka Residential Educational Institutions Society, , 9|Page
Page 14 :
8th Standard, , Chapter, , Chapter 4: Introduction to Word Processor, , Introduction to Word, Processor, , 4, , Worksheets, I., , Fill in the blanks with suitable words:, 1. ___________________ program allows you to create letters and reports., 2. ____________ button is located on upper-left corner of the window., 3. The _________ bar displays the name of the currently active document., 4. __________ and_______ are the two scroll bars present in the word window., 5. The ______ is the area in the document window where we type the text., 6. In word ________ option is used to preview the document., , II., , Identify following icons:, , 1.________, , III., , 2. ________, , 3. ________, , 4. _______, , 5._______, , Match the following:, 1. Ctrl + N, , Print, , ___________, , 2. Ctrl + S, , Close, , ___________, , 3. Ctrl + P, , Save, , ___________, , 4. Ctrl + O, , New, , ___________, , 5. Ctrl + W, , Open, , ___________, , Karnataka Residential Educational Institutions Society, , 10 | P a g e
Page 15 :
8th Standard, , Chapter 4: Introduction to Word Processor, , IV., , Answer the following questions in one or two sentences each:, 1., , What is Word processing?, , ___________________________________________________________, ___________________________________________________________, __________________________________________________________, 2., , List any two features of Word Processor., , ___________________________________________________________, ___________________________________________________________, __________________________________________________________, 3., , Write the steps to create a new Word document?, , ___________________________________________________________, ___________________________________________________________, __________________________________________________________, 4., , What is print preview?, , ___________________________________________________________, ___________________________________________________________, __________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Write an essay on Environmental pollution with a minimum of, 100 words and save with an appropriate name., 2. Write the passage about a famous personality in India, save it in, a specific location and print the same., , Karnataka Residential Educational Institutions Society, , 11 | P a g e
Page 16 :
8th Standard, , Chapter, , Chapter 5: Formatting in Word Processor, , Formatting in Word, Processor, , 5, , Worksheets, I., , Fill in the blanks with suitable words:, 1. The ____________ is a temporary holding area of information., 2. A ________ is the text that is added to the top margin of every page., 3. To find a particular word or piece of text, you can use the _______ command., 4. Proper arrangement of text and objects are called __________, 5. Default font face in Microsoft word 2007 is _____________., , II., , III., , Match the following:, 1. Ctrl + X, , Paste, , ___________, , 2. Ctrl + B, , Copy, , ___________, , 3. Ctrl + V, , Bold, , ___________, , 4. Ctrl + I, , Underline, , ___________, , 5. Ctrl + C, , Italic, , ___________, , 6. Ctrl + U, , Cut, , ___________, , Circle the correct options:, 1. The words which are in “Italic”., New, , Open, , Save, , Print, , Karnataka Residential Educational Institutions Society, , 12 | P a g e
Page 17 :
8th Standard, , Chapter 5: Formatting in Word Processor, 2. The words which are in “Bold”., Cut, , Copy, , Paste, , Undo, , 3. The words which are same in same “Font type and Font Size”., , Keyboard, Monitor, , IV., , Mouse, Printer, , Scanner, , Speaker, , Web camera, Plotter, , Answer the following questions in one or two sentences each:, 1. What is Clipboard?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 2. Briefly explain font face and font size., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 3. How you make text bold and italic?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 4. What are headers and footers? How do you insert it?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 5. Explain about line spacing., , ___________________________________________________________, , Karnataka Residential Educational Institutions Society, , 13 | P a g e
Page 18 :
8th Standard, , Chapter 5: Formatting in Word Processor, , ___________________________________________________________, ___________________________________________________________, 6. How you write CO2 in Word Processor?, , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Write a paragraph about human heart and perform the following operations:, a. Change the font face to Verdana and font size to 12, b. Find the word ‘blood’ using find option and change its, color to red., c. Save the document as ‘Heart’., d. Make use of Bold, Italic and Underline features in the, text to highlight the important words., 2. Observe the fonts in newspapers, magazines, story books, and everything that you read. Collect the articles with, fonts you like most., 3. Prepare a poster showing your house name, leaders, students and their classes. Print, and display it on your dormitory door., 4. Group Activity: Make a group of five students. Collect mathematical formulas and, chemical equations and prepare a list., 5. Group Activity: Make a group of five students prepares charts about cleanliness,, quotes, safety precautions, etc., display them in your classroom., , Karnataka Residential Educational Institutions Society, , 14 | P a g e
Page 19 :
Chapter, , Chapter 6: Introduction to Spreadsheet, , 6, , 8th Standard, , Introduction to Spreadsheet, Worksheets, , I., , Fill in the blanks with suitable words:, 1. A spreadsheet is a grid of _________ and __________, 2. In a new worksheet the address of the Active Cell is ______, 3. By default, the workbook contains _____ sheets, 4. Non-adjacent cells can be selected by holding ________ key and clicking., 5. Single clicking the column label will select _____________________, , II., , Study the following Spreadsheet and answer the following:, , 1. The data in Active Cell is ___________, 2. The value in cell K6 is __________, 3. Total marks scored by Anil is in cell _______, 4. ___________ scored highest marks in Kannada., 5. Cell E5 shows the marks scored by ___________ in __________ subject., , Karnataka Residential Educational Institutions Society, , 15 | P a g e
Page 20 :
Chapter 6: Introduction to Spreadsheet, , III., , 8th Standard, , Answer the following questions in one or two sentences each:, 1. Define cell., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 2. What is active cell?, , ___________________________________________________________, ___________________________________________________________, 3. What is the function of formula bar?, , ___________________________________________________________, ___________________________________________________________, 4. Write the steps to create a new workbook., , ___________________________________________________________, ___________________________________________________________, 5. What is cell merging?, , ___________________________________________________________, ___________________________________________________________, IV., , Answer the following questions in three or four sentences each:, 1. List any four features of Spreadsheet, , ___________________________________________________________, ___________________________________________________________, , Karnataka Residential Educational Institutions Society, , 16 | P a g e
Page 21 :
8th Standard, , Chapter 6: Introduction to Spreadsheet, 2. Write a short note on Auto Fill., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 3. Write the steps to rename a worksheet., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, 4. Write the steps to wrap text in a cell., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1., , Create a spreadsheet for attendance register of your class., , 2., , Create a spreadsheet with the details of the students in your, class. (Use Roll No. Name, Date of Birth, Address, and, Contact No. columns), , 3., , Create a spreadsheet for your class timetable., , Karnataka Residential Educational Institutions Society, , 17 | P a g e
Page 22 :
8th Standard, , Chapter, , Chapter 7: Formatting in Spreadsheet, , 7, , Formatting to Spreadsheet, Worksheets, , I., , Identify the following Icons:, , 1., _____________, , II., , III., , 2., _____________, , 3., ______________, , 4., _______________, , Match the following:, 1. COUNT(), , Unknown formula, , 2. SUM(), , Finds the least number in the range, , 3. AVERAGE(), , Counts the number of selected cells with data, , 4. MAXIMUM(), , Finds the sum of numbers, , 5. MIN(), , Finds the average of numbers., , Study the following spreadsheet and predict the result of the functions:, , Karnataka Residential Educational Institutions Society, , 18 | P a g e
Page 24 :
8th Standard, , Chapter 7: Formatting in Spreadsheet, , ___________________________________________________________, ___________________________________________________________, 6. Name the basic functions of Excel., , ___________________________________________________________, ___________________________________________________________, ___________________________________________________________, , A C, , T, , I, , V, , I, , T, , Y, , 1. Cost price and selling price of some fruits are given below:, , Fruit, , Cost Price, , Selling Price, , (Per KG), , (Per KG), , Apple, , 80, , 90, , Banana, , 25, , 45, , Mango, , 20, , 25, , Orange, , 25, , 30, , Profit, , Percentage, Profit, , Design a spreadsheet to calculate profit and percentage of profit for each fruit., (Hint: Profit=Selling price-Cost price, Percentage Profit =(Profit/Cost Price)*100), 2. Design a spreadsheet to calculate total and average marks scored in an exam of each, student in your class., 3. Use the same spreadsheet you have designed in the activity 2 and Find out the top, scorer in individual subjects and the whole class., (Hint: Use MAX( ) function), 4. Design a spreadsheet for multiplication table using auto fill., , Karnataka Residential Educational Institutions Society, , 20 | P a g e
Page 25 :
1. Design a model of Block diagram of a computer., 2. Collect the information and picture about Blu-ray Disc., 3. Determine and prepare a report about the configuration of a computer in, your lab., 4. Prepare your “Bio-Data” using the word processor., 5. You have to make an announcement for a picnic and put it up on the, school notice board. Use the different formatting options and prepare the, text., 6. Prepare a Salary Bill using a spreadsheet for below-mentioned data., Sl, , Designation, , Basic, , HRA, , DA, , MA, , 01, , Principal, , 22800.00, , 10%, , 32%, , 02, , Asst Teacher, , 17650.00, , 10%, , 03, , Warden, , 14550.00, , 04, , Staff Nurse, , 05, , Cook, , No, , Gross, , PT, , LIC, , -, , 200.00, , 1611.00, , 32%, , 100.00, , 200.00, , 617.00, , 10%, , 32%, , 100.00, , 200.00, , 500.00, , 16000.00, , 10%, , 32%, , 100.00, , 200.00, , 1200.00, , 8000.00, , -, , -, , -, , -, , -, , Total, , Net, , Ded, , Pay, , -, , Grand Total, , Note: HRA= Basic * 10%, DA= Basic * 32%, Gross = Basic + HRA+DA+MA, Total Deduction = PT+LIC, Net Pay= Gross – Total Deduction, , Karnataka Residential Educational Institutions Society, , 21 | P a g e