Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 121 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 121

    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

| 116 117 118 119 120 121 122 123 124 125 126 |