Page 122 - TP_V5.1_C7_fb
P. 122

Assignments








              Chapter 1: Number System

              1.  Given are the steps for converting a decimal number to a binary number in an incorrect sequence.
                  Determine and rewrite the correct sequence.

                   (i)  Divide the quotient obtained again by 2 and note down the resulting quotient and remainder.

                   (ii)  Note down the quotient and the remainder.
                  (iii)  Divide the decimal number by 2 (the base of the binary number system).
                  (iv)   List the last quotient and all the remainder (moving from bottom to top). You have your
                        binary number.

                   (v)  Repeat the procedure till you reach a quotient less than 2.

              2.  Rihan asks his Aunt Mira her age. Mira told him “101011” and a clue binary. What is Mira’s age in
                  Decimal number system.
              3.  Guess my birthdate. I was born in the 9th month of the year; my date of birth is “10111” in binary.

              4.  Riya is trying to convert her age from a decimal number to a binary number. If Riya is 12 years
                  old, how can she express her age in binary? Explain the steps you would take to convert 12 from
                  decimal to binary.
              5.  Two robots in a factory communicate using binary numbers. If Robot A sends the message (1101)2

                  and Robot B responds with (1010)2, what is the result of adding both messages in binary? Show
                  how binary addition works and provide the result in both binary and decimal form.

              Chapter 2: Advanced Features of Excel

              1.  Sorting a Student Data Table

                   Roll No.       Name             Class         Marks
                   101            Arun             VII           85
                   102            Sneha            VII           92

                   103            Ravi             VII           78
                   104            Ria              VII           88

                  Write steps to sort the names of students based on their marks in descending order in Excel.
              2.  Javisha has prepared her class marksheet in Excel for different subjects, how would she filter the

                  data to display only the students who scored above 90 marks in Math?
              3.  Nimisha has sorted a list of students’ roll numbers in ascending order. Now, she wants to sort
                  them by their last names without changing the roll number order. Which Excel feature should
                  she use?




                  120   Premium Edition-VII
   117   118   119   120   121   122   123   124   125   126   127