Grade 5

TECH WIZARD Class 5 SYLLABUS Term – I 1. Brief History of Computers 2. MS PowerPoint: Graphics & Multimedia 3. MS Word Page Layout 4. MS Word: Working with Tables 5. Introduction to MS Excel Term – II 6. MS Excel: Working with Worksheet 7. Internet Searching & Surfing 8. Interactive Programming with Scratch 9. Kids Animation with TupiTube Exercises Chapter 1 – Brief History of Computers A. Choose the correct answer. 1. a 2. d 3. c 4. a 5. c B. Fill in the blanks. 1. Nanotechnology 2. First, second 3. 3D printing 4. Integrated circuits 5. VLSI C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. True (√) 3. False (×) 4. False (×) 5. True (√) D. Answer the following questions. 1. Napier’s bones is a device invented by John Napier in 1617. It consisted of 9 rods marked with numbers. For calculating mathematical numerals like multiplication, division, square roots, and cube roots. Pascaline is a device invented by Blaise Pascal for calculating addition and subtraction. This device had turn- table discs used to set the numbers for calculations after turning a handle. 2. a) First Generation Computers Second Generation Computers 1. Vacuum Tubes were used. 1. Transistors were used. 2. Big in size. 2. Small in size. 3. They were expensive. 3. Cheaper than first generation of computer E.g. UNIVAC, ENIAC E.g. IBM 1401, PDP- I Page | 20

TECH WIZARD b) Third Generation Computers Fourth Generation Computers 1. IC based. 1. VLSI Microprocessor based. 2. Smaller but not handheld. 2. Small in size, handheld also. 3. Single user OS. 3. Multi-user, GUI Operating system. E.g. IBM 360, 370 E.g. IBM PC, Apple Macintosh, Compaq PC 3. The term VLSI is an acronym for Very Large Scale Integration, which was used in 1970 for modern-age computers, where thousands of transistors were integrated into a single small chip. As a result, semiconductor and telecommunication technologies developed. 4. Artificial Intelligence is used in smart devices for facial recognition, object identification, interacting with natural human language, serves as the expert system in medical and other fields, performing useful predictions, detecting frauds, analyzing sentiments of people about products and public figures, autonomous vehicles, drones, robots, etc. E. Briefly list 2 key features of each type of computer classified on the basis of size. i. Super computer: 1. Very high storage capacity. 2. Data processing is ultra-fast. ii. Mainframe: 1. Smaller than super computers. 2. Large memory capacity. iii.Mini: 1. Expensive and larger than micros. 2. Mostly used as network servers. iv. Micro: 1. Portable and high speed. 2. Support different types of secondary memories. F. Match the following. 1. d 2. e 3. a 4. c 5. b Chapter 2 – MS PowerPoint: Graphics and Multimedia A. Choose the correct answer. 1. b 2. c 3. a 4. c 5. a B. Fill in the blanks. 1. Charts 2. Data sheet 3. Audio, video 4. Icons 5. Slide layout C. Tick (√) the correct statement and cross (×) out the wrong one. 1. False (×) 2. True (√) 3. False (×) 4. True (√) D. Define the following terms. a. Slide layout is the arrangements of all the objects on the slide. There are 9 slide layouts in MS PowerPoint. b. A table represents data in the form of rows and columns. It is very useful to organize and represent data. c. A chart is a pictorial or graphical form to represent data. It describes the relation between two or more sets of values in presentation. d. SmartArt graphic is a virtual representation of information to effectively communicate our messages or ideas. SmartArt graphic allows us to communicate through graphics instead of just text. Chapter 3 – MS Word Page Layout A. Choose the correct answer. 1. d 2. a 3. b 4. b 5. b B. Fill in the blanks. 1. Page 2. Hyperlink 3. Text box 4. Footer 5. Custom C. Answer the following questions. Page | 21

TECH WIZARD 1. A page margin is a blank with space between the text and edge of the page on all the sides. 2. Header and footer are the content which appear at the top and the bottom margin of every page in the document. It can be an image, text, page number, date, company name, etc. Header appears at the top margin of the page while footer appears at the bottom margin of the page. 3. Page orientation is the direction in which a document is displayed or printed. The two types of page orientation are portrait (vertical) and landscape (horizontal). School time table will best fit in Landscape orientation. 4. a. Put the cursor in the document after which you want to insert a blank page. b. On the Insert tab in, Pages group, click on the Blank Page button. 5. The steps to set the text in multi-columns are: 1. On the Layout tab, in Page Setup group, click on the drop-down arrow of Columns button. 2. Click on the desired number of columns from the list. The text on the document will be set in the selected number of columns. 6. The steps to create hyperlink to a text (to link other document or website) are: 1. Select the text you want to put as a hyperlink. 2. On the Insert tab, in Links group, click on the Link button. Or, right-click on the selected text and click on the Link option. The Insert Hyperlink dialog box appears . D. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. . True (√) 3. False (×) 4. True (√) 5. False (×) E. Write the steps of the following. 1. i) Select the text and click on drop-down arrow of Columns button in Page Setup group on Page Layout tab. ii) Select the Two option in the list. 2. i) Select the text that you want to put as a hyperlink. ii) Click on Hyperlink button in Links group on Insert tab and select the required options in the Insert Hyperlink dialog box. 3. Insert tab > Header & Footer section > Page Number> Bottom of Pages. 4. Insert tab > Symbol button > Symbol tab in the dialog box > Select desired Symbol > Insert button. Chapter 4 – MS Word Working with Tables A. Choose the correct answer. 1. a 2. a 3. d 4. d 5. a B. Match the following. 1. d 2. f 3. b 4. c 5. a 6. e C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. True (√) 3. False (×) 4. False (×) 5. True (√) D. Answer the following questions. 1. Time table, Calendar 2. Row is horizontal series of cell in a table. Column is the vertical series of cell in a table. Cell is the intersection of a row and column in a table. 3. Merging of cells is combining two or more cells into one cell whereas dividing a cell into two or more cells into one cell is splitting the cell. 4. Text alignment refers to the position of the text inside a table-cell. There are 9 such alignments. Page | 22

TECH WIZARD 5. Select the required cells and click on Merge Cells button in Merge group on Layout tab. 6. To delete unwanted rows and columns: i. Click in any cell (of the row or column that you want to delete). ii. Click on the Layout tab. iii. In Rows & Columns group, click on Delete button. A drop-down list appears. iv. Click on the Delete Columns option to delete the entire column, or, click on the Delete Rows option to delete the entire row. 7. The steps to apply a design on a table are: i. Click on a cell in the table. ii. Click on the Design tab. iii. Click on the drop-down arrow of Table Styles. A list of design tables appears. iv. Hover the mouse on the design to select the design. Click on the desired design. Chapter 5 – Introduction to MS Excel A. Choose the correct answer. 1. d 2. a 3. b 4. d 5. b B. Fill in the blanks. 1. Cell name box 2. Formula bar 3. Worksheet 4. Cell range 5. Shift + F11 C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. False (×) 3. False (×) 4. True (√) 5. True (√) D. Answer the following questions. 1. i) In Excel, numbers and calculations are managed efficiently. ii) In Excel, data can easily be created, analyzed and maintained. iii) In Excel all the data are stored in simple tabular format. 2. Components of MS Excel Window are: i. Quick Access Toolbar: It contains commands that are frequently used like Save, Undo, Redo, Print, etc. ii. Title Bar: It displays the name of the workbook and three control buttons - minimize, maximize, restore and close. iii. Ribbon: It contains two parts: eight tabs - File, Home, Insert, Page Layout, Formulas, Data, Review and View. Each tab contains commands in different groups. iv. Cell Name Box: It displays the name of the active cell or cell reference. The column letter and row number corresponding to the active cell is displayed in the cell name box. v. Formula Bar: It displays the data and formulas that you entered in an active cell. It can also be used for entering or editing data, labels and formulas. 3. Workbook: Each Excel file is known as a workbook. It can hold many worksheets. The default workbook is Book1. Worksheet: A worksheet is a collection of cells in the form of rows and columns. 4. a. Formula Bar: It displays the data and formulas that you entered in an active cell. It can also be used for entering or editing data, labels and formulas. b. Cell Range is a group of cells adjacent to each other and consist of cell address in the first cell colon and last cell address. c. Sheet Tab: It indicates the name of the worksheet and you can switch between the different sheets by clicking on it. 5. The steps to save the workbook are: Page | 23

TECH WIZARD i. In File tab, click on Save As option. The Save As pane appears on the right of the window. ii. Click on Browse button. iii. In the dialog box, locate the drive or folder Shortcut and enter the file name in File name text box. iv. Click on Save button. The workbook will be saved as .xlsx file. E. Match the following. 1. b 2. a 3. e 4. c 5. d Chapter 6 – MS Excel: Working with Worksheet A. Choose the correct answer. 1. b 2. a 3. a 4. b 5. c B. Fill in the blanks. 1. Entire row 2. Entire column 3. Copying 4. Quick Access Toolbar 5. 8.43 C. Tick (√) the correct statement and cross (×) out the wrong one. 1. False (×) 2. True (√) 3. False (×) 4. True (√) 5. False (×) D. Answer the following questions. 1. Copying refers to duplicating the data (text, numbers and formulae) while 'moving' refers to move the data from its original location to a new location. 2. The steps to adjust the row height are: i . Put mouse cursor on the border of the row (header), the cursor changes to +. ii. Now, click and drag the border of row header to increase or decrease the row height. iii. After getting the desired height release the mouse button. 3. Undo command reverses the last action while Redo command reverses the Undo command. 4. i. Insert a row / column: Ctrl + + ii. Select the cell, above/left to which you want to add a cell, and press Ctrl + + the Insert dialog box appears. 5. Autofill let us fill a predefined series of data in adjacent cells quickly instead of typing every entry manually. Chapter 7 – Internet Searching and Surfing A. Choose the correct answer. 1. d 2. c 3. d 4. d 5. b B. Fill in the blanks. 1. Google 2. Messages 3. Education 4. Enter 5. Distance learning C. Answer the following questions. 1. Sending and receiving messages using Internet is called mails. Chatting refers to the kind of communication done from sender to receiver with the help of the internet. 2. www,google.com, www..bing.com, www. yahoo.com 3. Internet is a massive network of computer networks. It connects millions of computers together globally, forming a network in which any computer can communicate with any other computer. While The World Wide Web is a way of accessing information over the medium of the Internet. It is an information-sharing model that is built on top of the Internet. 4. i. Open the search engine in a web browser. ii. Type the name of thevideo you are searching for in Search text box, and press Enter key. Page | 24

TECH WIZARD iii. Several options are displayed. Click on Videos option, you will get more related video links. D. Write a few words about the following. 1. News and Information: These are the facilities to get information about online news and other various topics such as science, technology, sports and education, etc. 2. Video Conferencing: This is the way to communicate with others on internet using web camera, microphone, speakers, etc. 3. Online Shopping: Using online shopping various products can be purchased. Chapter 8 – Interactive Programming with Scratch A. Choose the correct answer. 1. b 2. d 3. a 4. b B. Fill in the blanks. 1. Project 2. Sprites 3. Backdrop 4. Control C. Tick (√) the correct statement and cross (×) out the wrong one. 1. False (×) 2. False (×) 3. True (√) 4. True (√) 5. True (√) D. Answer the following questions briefly. 1. A script is a set of Scratch blocks arranged to define how an animation shall work. Scripts are created by drag-dropping various blocks in the script editor. Scripts are executed by clicking Execute script green flag button or through some event. 2. In Scratch, an event is something that occurs due to user action or sprite's action. For example, you may click on a sprite with mouse or press a key on the keyboard or a sprite may send message to other sprites. 3. Using sprite setting you can also hide/unhide the sprite. It also provides options to add sprite from the library, draw a new sprite in sprite editor or import an image as a new sprite and delete a sprite by clicking on the delete button over the sprite's icon. 4. Control block is used to keep those blocks which you need to run repeatedly (again and again) infinitely. Looks block is used to change the looks (costumes) one-by-one. Chapter 9 – Kids Animation with T u p i T u b e A. Choose the correct answer. 1. c 2. b 3. d 4. a 5. b B. Fill in the blanks. 1. Initial, Ending 2. Rotation 3. Stage 4. Motion 5. Multimedia C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. False (×) 3. False (×) 4. False (×) Page | 25