Page 142 - Trackpad_V1_Book 6_Flipbook
P. 142

Project




                     1.   Write the algorithm for the following and then draw the flowchart:

                         a.  To convert the length given in feet to centimetres.                     Computational Thinking

                         b.  To calculate the sum of the first 10 natural numbers.

                     2.   Create the following worksheet in Excel and perform the given operations:
                                                                                                        Subject Enrichment



















                         a.  Calculate the total bill amount using the SUM function.
                         b.   Change  the  bill amount  of the  patient  having P_ID  as P0023  and observe  the
                              changes in the Total Amount.

                     3.   Enter the following data in Excel:                                            Subject Enrichment














                         Perform the following tasks:
                         a.  C2   =(A2*B2)         b.  C3   =(A5=B3)                  c.   E5   =COUNT(A2:B5)

                     4.   Enter the following data in Excel and draw a line chart and column chart.
                                                                                                        Subject Enrichment


















                  140   Trackpad (Version 1.0)-VI
   137   138   139   140   141   142   143   144   145   146