Grade 6

TECH WIZARD Class 6 SYLLABUS Term – I 1. Working with Data in MS Excel 2. MS Excel: Charts 3. MS Excel: Formatting, Formulas and Function 4. Mail Merge using MS Word 5. Animation and Transition in MS PowerPoint Term - II 6. Communication on Internet 7. Algorithm & Flowchart 8. Scratch Game Creation 9. Image Processing with GIMP 10. Programming Logic and Techniques Page | 26

TECH WIZARD Exercises Chapter 1 – Working with Data in MS Excel A. Choose the correct answer. 1. d 2. a 3. c 4. c 5. c B. Fill in the blanks. 1. Excel 2. First 3. Absolute 4. Sorting 5. Conditional C. Answer the following questions. 1. Cell reference is the way to identify the location of a cell in a group of cells in the worksheet. These cell addresses are used in formulas and functions. 2. In absolute cell referencing if you move or copy the formula to another cell, the cell referred to in the formula will not change. Whereas in relative cell referencing if you move or copy the formula to another cell, the cell referred to in the formula will change accordingly. 3. Sorting data is rearranging the data. It can be done for alphabets, numbers, date and time, cell color, font color or icon set. Filtering data displays the data in the rows that meet the criteria and hides the rows that do not meet the criteria. 4. Steps to format the stable using Table style are: i. Select the table (data range) ii. On Home tab, 1n Styles group, click on Format as Table and select the required table style. iii. The Format As table drop-down appears. Click on OK button. iv. Required design is applied to the table. Small arrows are added to each filed name to filter data. D. Tick (√) the correct statement and cross (×) out the wrong one. 1. False (×) 2. True (√) 3. True (√) 4. True (√) Chapter 2 – MS Excel: Charts A. Choose the correct answer. 1. b 2. a 3. d 4. c 5. a B. Fill in the blanks. 1. Goal seek 2. Bar Chart 3. Line 4. Chart 5. Funnel C.Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. False (×) 3. True (√) 4. True (√) 5. False (×) D.Answer the following questions. 1. A chart is a pictorial representation of the data i.e. it allows us to illustrate the data graphically. 2. The various components of a chart are, i. The chart area is the entire chart and all its elements. ii. X-axis or category axis is the horizontal axis of a chart. It shows the names. iii. Y-axis or value axis is the vertical axis of a chart. It shows the values/data series. Page | 27

TECH WIZARD iv. Axis titles are labels/titles of X-axis and Y-axis. v. The plot area is the area of the chart bounded by the axis. 3. Line Chart: In this type of chart, data is plotted in a form of line with connecting dots. It displays categories along the horizontal axis and values along the vertical axis. Pie Chart: In this type of chart, data is displayed in the form of circles that shows the size of items in one data series, proportional to the sum of the items. Area Chart: In this type of chart, data is displayed in the form of an area. It is used to show the magnitude of change over time. 4. The steps to change the chart style are: i. Select the chart on the worksheet. The Design and Format tabs appear on Ribbon. ii. Click on Design tab. iii. Click on the drop-down button of Chart Styles and select the required style from the menu. 5. The steps to change the chart style are: i. Select the chart on the worksheet. The Design and Format tabs appear on Ribbon. ii. Click on Design tab. iii. Click on the drop-down button of Chart Styles and select the required style from the menu. 6. Goal Seek is a tool to get the desired result in a cell by changing a value in another cell. The steps to use Goal Seek are: i. Create a worksheet and enter data. ii. On Data tab, in Forecast group, click on What-If-Analysis. (MS Excel 2016: On Data tab, in Data Tool group, click on What-If-Analysis .) iii. Select Goal Seek in the drop-down. The Goal Seek dialog box appears. iv. In Set cell text box, define the cell address for which the Goal Seek goal seek is to be applied. Here, refer the cell that contains the formula. v. In To value text box, type the new value. vi. Now, click on the cell, whose value you want to change to get the desired result. vii. Click on OK button. The Goal Seek Status dialog box app ears displaying the Target value and current value. viii. Click on OK button. Chapter 3 – MS Excel: Formatting, Formulas and Functions A. Choose the correct answer. 1. c 2. b 3. b 4. d 5. d B. Fill in the blanks. 1. Arithmetic 2. Compound 3. Font Tab 4. Average() 5. #REF! C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. False (×) 3. True (√) 4. True (√) 5. True (√) D. Answer the following questions. 1. A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas for addition, subtraction, multiplication and division. Page | 28

TECH WIZARD 2. A Function in Excel is a predefined formula that perform calculations by using specified values called arguments in a particular order or structure. Sum : Returns the sum of the given values. Syntax: =SUM (value1, value2, etc.) or = SUM(range of cells) Example =SUM (15, 25, 65) Output= 105 Average : Returns the average of the given values. Syntax: =AVERAGE (value1, value2, etc.) Example =AVERAGE (10, 20, 30) Output=20 3. - Alignment tab is used to position text and numbers in the cells, change the orientation and specify text control in cells. - Font tab is used to set the font face, font size, font style, font color and other effects. 4. Steps to apply a colorful border to a cell are: i. On the Format Cells dialog box, click on Border tab. ii. Now, click on Color drop-down list box and select the desired colour. 5. Logical functions check one or more conditions. Logical functions are generally used with other functions like IF to perform decision making. For example, a person is allowed to vote if he or she is at least 18 years old and his or her address is verified. Both of these conditions need to be satisfied for a person to cast his or her vote. 6. To compare two values, comparison operators are used. The result is always a logical value i.e. either True or False. For example, = (Equal to), > (Greater than), < (Less than), > = (Greater than or Equal to), < = (Less than or Equal to) and < > (Not Equal to). examples i. Select the cell where the answer will appear. ii. Type the equal sign = with the formula that you want Excel to calculate and press Enter key. For example, = 5 + 5. 7. The steps to format the text (in a cell) using the tools available on Home tab are: 1. Select the cell where you want to format the text. 2. Click on required tool available in Font or Alignment group. Chapter 4 – Mail Merge using MS Word A. Choose the correct answer. 1. c 2. c 3. a 4. a 5. a B. Fill in the blanks. 3. Main document 4. Sender 5. Mail merge 1. Envelope option 2.Merge Field C. Answer the following questions. 1. Data Source: This is like an address book that contains recipients' details in tabular form that is to be merged with the main document. Merged document: This is the final document, which is obtained after merging of fields from data source with the main document. 2. i. Main Document: - It is a document which has the common data that needs to be sent to multiple Page | 29

TECH WIZARD recipients. ii. Data Source: - It contains recipients’ details that is to be merged with the main document. iii. Merge Field: - It is the data item which is to be merged with the document from a data source. iv. Merge Document: - This is the final document, which is obtained after merging of fields from data source. 3. The process of merging the recipients' data with the main document to generated multiple merged documents is called mail merge. It helps the user to create a document for multiple recipients more easily by just selecting recipient names and choosing the document. 4. Steps to merge all the data in a single document are: i. On the Mailings tab, in Finish section, click on Finish & Merge button and select Edit Individual Documents option. iii. The Merge to Printer dialog box appears. Click on OK button. This action will merge all the data (on the separate pages) in a single document 5. The steps to print envelopes are: i. Mailing tab > Create group > Envelopes option. The Envelopes and Labels dialog box appears. ii. Specify the Delivery address and Return address .. (Or, import from MS Outlook if you are using for your contacts.) iii. You can setup Envelope options by clicking on Feed button. An Envelope Options dialog box appears. iv. Set envelope size and addresses' text formatting by clicking on Envelope Options tab. v. Set printer feed method and direction by Printing Options tab. Chapter 5 – Animation and Transition in MS PowerPoint A. Choose the correct answer. 1. c 2. a 3. a 4. a 5. a B. Answer the following questions. 1. Duration: It specifies the timing of the animation effects. Delay: It sets the delay time before the animation begins. 2. Subtle: These are the most basic types of transitions. They use simple animations to move between slides. Dynamic Content: If you're transitioning between two slides that use similar slide layouts, dynamic transitions will move only the placeholders, not the slides themselves. 3. Action buttons are built-in shapes that can be used to launch an action in the presentation such as go to next/previous or a specified slide, play a sound/video or run a program. 4. The steps to add a sound to a slide transition are: i. Select the desired slide on which you want to add sound. ii. On Transitions tab, in Timing group, click on Sound drop-down list box and choose a sound to apply it to the selected slide. 5. Emphasis Animation: It includes the effects that draw attention to an object. For example, the object can become larger. 6. The steps to add an action button on a slide are: ii. Select the slide in Slide Navigation pane. iii. On Insert tab, in Illustrations group, click on Shapes command. A drop-down menu appears. iv. Select the desired action button. v. Drag and draw the action button (shape) on the slide. The Action Settings dialog box appears. vi. In Action on click section, click on drop-down arrow of Hyperlink to: and select the required action. For Page | 30

TECH WIZARD example, click on Next Slide option. 7. Action buttons are built-in shapes that can be used to launch an action in the presentation such as go to next/previous or a specified slide, play a sound/video or run a program. C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. False (×) 3. True (√) 4. True (√) 5. True (√) Chapter 6 – Communication on Internet A. Choose the correct answer. 1. a 2. a 3. d 4. a 5. a B. Fill in the blanks. 1. Instant messaging 2. Forward mail 3. Draft ` 4. E-mail a/c 5. Sign out C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. True (√) 3. True (√) 4. True (√) 5. False (×) 6. True (√) 7. False (×) D. Answer the following questions. 1. Internet is a network of networks. It connects millions of computers of the world with each other. 2. E-mail is the most widely used Internet-based communication tool. It is used to send & receive messages through internet. 3. To create an e-mail account i. Open any browser i.e. Internet Explorer, Mozilla Firefox or Chrome etc. ii. Type any of the e-mail service provider's names in the address bar of the browser. iii. Now click on Create account option. iv. A registration form will appear. Fill the registration form carefully and submit it. v. A congratulation message will appear. Now go to your email account and login. vi. Your email account window appears (containing three mails from Gmail Team). 4. i. Click on mail, which you want to forward. ii. Now, click on arrow next to the Reply option. A menu appears. iii. Select Forward option. iv. A new frame appears below the mail details, to forward the message. v. Type the email address of the recipient in To text box. vi. Click on send button. Chapter 7 – Algorithm & Flowchart A. Choose the correct answer. 1. c 2. d 3. b 4. c B. Answer the following questions. 1. A flowchart is graphical representation of a program flow. It helps in understanding what the program is doing. Page | 31

TECH WIZARD 2. A flowchart easily depicts the program logic. It is easy to analyse the problem using a flowchart. Flowcharts help in better program documentation. Using flowcharts, errors can be identified and removed easily. 3. Connector connects one part of flowchart to another. Process box show the calculations and processing instructions. Chapter 8 – Scratch Game Development A. Choose the correct answer. 1. a 2. b 3. b 4. a 5. a 6. c B. Fill in the blank. 1. Looks 2. Library 3. Pen 4. Variable 5. Stage C. Answer the following questions. 1. if block is associated with a condition. All the blocks that are part of if block are executed only if the condition is true. if block makes use of comparison blocks in Operators category. if block execute only if the condition associated with the if block is satisfied (true), when if condition fails or returns false. This is handled by else part of if-else block. 2. To Sprite Setting is used for the following: i. It hide/unhide the sprite. ii. It provides options to add sprite from the library, draw a new sprite in sprite editor or import an image as a new sprite. iii. It can delete a sprite by clicking on the delete button over the sprite's icon. iv. A duplicate of the sprite can be created by right clicking on it and selecting duplicate option. 3. if-then block executes when the given condition is true otherwise it is skipped (statements enclosed in it do not execute) while in if-then-else block, if part executes when the given condition is true otherwise the else part is executed. 4. repeat block executes the enclosed blocks as many times as the number mentioned in its value section. It is useful when you need to execute certain blocks repeatedly for a given count. while repeat until block takes a condition and executes enclosed blocks as long as that condition becomes true. It is used when you need to control the animation on the basis of a condition such as until sprite touches another sprite, until player's life in a game becomes 0, until user clicks a particular key. 5. Costumes panel is displayed when you click on Costumes tab next to Code tab. It shows various stances or poses or expressions of the current sprite. It also shows a costume editor where you can make changes in the costume or you can also create a new costume by clicking on Paint option. Chapter 9 – Image Processing with GIMP A. Choose the correct answer. 4. d 5. a Page | 32 1. c 2. d 3. a 4. Shift 5. Filters B. Fill in the blanks. 1. Canvas 2. Feather 3. Docks

TECH WIZARD C. Tick (√) the correct statement and cross (×) out the wrong one. 1. True (√) 2. True (√) 3. False (×) 4. True (√) 5. True (√) D. Answer the following questions. 1. Pencil tool draws with a sharp, smooth and dry strokes. 2. In the Toolbox, click on the lower box of Foreground/Background colors icon > In the change Background color dialog box, select the grey color and click on OK > Select the background colors with the Color Picker Tool > Click OK 3. Two common properties are : i. Feather edges: It defines how much part around the selection will be a little blur. The radius of feathering can be changed. ii. Rounded corners: Sets the roundedness of the corners of a rectangular selection. 4. Threshold: It sets the colour sensing of the tool. Higher the threshold, more will be the colour sensitivity. Opacity: It Sets the transparency/opacity of the colour. Feather edges: It defines how much part around the selection will be a little blur. The radius of feathering can be changed. Hardness: It Sets colour darkness. 5. To apply a filter: i. Select the desired region in the image on which filter is to be applied. ii. Select desired filter from the set of submenus under Filters menu. Chapter 10 –Programming Logic and Techniques A. Choose the correct answer. 4. a 5. a 1. b 2. b 3. c B. Fill in the blanks. 1. Relation 2. Compiler 3. Comments 4. Operands 5. FORTRAN C. Tick (√) the correct statement and cross (×) out the wrong one. 1. False (×) 2. True (√) 3. False (×) 4. True (√) 5. True (√) D. Answer the following questions. 1. A computer language is the mean by which instructions and data are transmitted to the computer. In other words, computer languages are the interface between a computer and its user. 2. Machine Language is the only language that a computer can understand. It is expressed in binary form i.e. '0' and '1 '. Machine language has the advantage of very high speed and very low memory utilization. Assembly language uses mnemonic codes or symbols in places of O's and 1 's. Instead of remembering the exact memory locations where data and instructions are stored, symbolic memory addresses are used for data. 3. Some of these translator programs are - i. Assembler : An Assembler is a computer program which converts assembly language program into machine language. ii. Compiler: It is a translator program to convert a high-level language program into machine language. It translates the whole program at once and generates a list of errors, if any otherwise it generates the object code for the program. The execution is very fast. iii. Interpreter: It translates a high-level language program into machine language line by line i.e. it converts Page | 33

TECH WIZARD one line, executes the instruction and then repeats the procedure for the remaining instructions. Program stops when an error is encountered. 4. Object Oriented Programming (OOP): In Object Oriented Programming, a program is a collection of objects. These objects contain both data and functions. Objects belong to classes, and can perform specific tasks. Eg- C + +, Java, C#, etc. Event-Driven Programming: Event-driven programming or event-based programming is a kind of programming in which the flow of the program is determined by events-i.e. on user actions (mouse clicks, key presses). Eg- Visual Basic. 5. Variable: A variable is a named storage location which is used to store the values. Its value can be changed throughout the program. Various types of data can be stored in variable i.e. numeric, character and string. Numeric: Numeric data comprises only numbers. For example, 5, 124, 123.44. Character: A character can be a number, an alphabet or a symbol. It is also known as alphanumeric data type. For example, a, D, 0/o, 3. String: A string can contain numbers, alphabets and symbols. It is also a alphanumeric data type. A string value should be enclosed in double quotes. For example, \"Monkey\", \"1184 Sant Nagar\". a. A variable can be made up of multiple characters, numbers and'_' symbol. b. Name of a variable must start with a letter. c. Reserved words cannot be used with a variable name. E. Write Pseudocodes to do the following. 1. Begin Accept a, b Result = (a * b) / (a + b) Display Result End 2. Begin Accept Radius Area = (22/7)*(Radius*Radius) Display Area End Page | 34