Page 149 - iPro_trackGPT_V5_Class7
P. 149

PROJECT WORK









                                                                                  #Digital Literacy
                 Excel                                                            #Creativity & Innovativeness

                    ✶ Rajat has created a list of the students who are a part of the school cricket team.





















                    ✶  Now, he wants to add a column titled ‘Designation’ between  the 'Name of the student'
                       and 'Runs scored in' columns to put the categories as Batsman, Bowler, All Rounder, or
                       Wicket Keeper.
                    ✶  Vikas and Nitin have resigned from the team. He has to remove the details of these students
                       from the list.

                    ✶ Change the width of the column 'Designation' to 20.
                    ✶ Find the ‘Total Runs Scored’ and ‘Average Runs Scored’ by each student using formulas.

                 Access                                                           #Coding & Computational Thinking
                                                                                  #Digital Literacy
                 Project 1

                 Create three tables in Access as given below:

                                                          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.


                                                                                                 Project Work    147
   144   145   146   147   148   149   150   151   152   153   154