Page 157 - TP_iPlus_V2.1_Class7
P. 157

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.





                                                                                                                 155
                                                                                                       Project
   152   153   154   155   156   157   158   159   160   161   162