Page 146 - iPlus_Ver_2.0_class_7
P. 146

PROJECT



                                                                                         #Digital Literacy
                                                                                         #Coding & Computational Thinking

                  A.   In Excel, create a tabular data of 5 of your friend’s marks obtained in the previous exams and
                      plot a graph for the average marks and the average percentage obtained for each of them.
                      Here is an example dataset.




































                                                                                        #Coding & Computational Thinking
                  B.  Create three tables in Access as given below:                     #Creativity & Innovativeness

                                                           Table: Purchases

                          Item_ID            Quantity Purchased           Rate per unit               Amount

                                                              Table: Sales


                          Item_ID               Quantity Sold             Rate per unit               Amount

                                                        Table: Stock in Hand


                             Item_ID                    Item Name               Quantity in Hand at the beginning

                  •  Make 5 entries in each table.
                  •  Create a query to calculate the 'Quantity in Hand' at the end for all the items.





                   144
                         iPlus (Ver. 2.0)-VII
   141   142   143   144   145   146   147   148   149   150   151