Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 90 - CodePilot V5.0 C7
P. 90

    2.   If you want to calculate the total score for multiple students using the same formula, which Excel
                             feature will help you quickly apply the formula to other rows?

                                    (i)  Find and Replace                     (ii)  Autofill
                                   (iii)  Sort                                (iv)  Pivot Table

                         3.  Which structure follows this pattern: If true, do one thing; else, do another?

                                    (i)  Loop                                 (ii)  If-Then-Else
                                   (iii)  Switch                              (iv)  While

                         4.  Select the main advantage of using a loop in a computer program.

                                    (i)  Saves time by repeating tasks        (ii)  Makes programs longer

                                   (iii)  Runs code only once                 (iv)  Avoids checking conditions

                         5.  Pick the option that describes Smartness when evaluating a solution.
                                    (i)  Simplicity                           (ii)  Time

                                   (iii)  Resources                           (iv)  Accuracy

                      B.  Fill in the blanks using the given hints:

                         1.                 means the solution gives the correct result.                           Hints
                                                                                                                 Accuracy
                         2.  Pattern               is identifying common trends or repeated actions in a task.   Recognition
                                                                                                                  Quickly
                         3.                 help the program make decisions.                                     Conditions
                                                                                                                 Evaluation
                         4.  Efficiency refers to how             the task can be completed.

                         5.                 ensures that the solution is not only correct but also practical and optimal.

                      C.  Write  T  for true and  F  for false.

                         1.  Patterns can be reused in different situations.

                         2.  Accuracy means giving the correct solution.

                         3.  If the condition is True, then Else will be executed.

                         4.  Conditions are useful when you need to do the same task many times.

                         5.  When solving a problem, there are often different ways to approach it.

                      D.  Answer the following questions:
                         1.  Give one real-life example of pattern recognition in everyday tasks.

                       88
                            CodePilot (V5.0)-VII

| 85 86 87 88 89 90 91 92 93 94 95 |