Page 104 - iPro_trackGPT_V5_Class7
P. 104

Code Clues                                                   #Experiential Learning
                                                                                   #Problem Solving & Logical Reasoning

                  Locate eight terms related to Access in the following grid:

                                                     R  E   P O R    T   S N T M
                                                     E  F   Z  Y  U  B   L  P  F  R
                                                     C  S  H   L  I  L   T  A O B
                                                     O V    Z D X    A Q G R      Y

                                                     R Q U     E  R  Y  H   E M L
                                                     D K D     S  G O H     S  Y M
                                                     S  J  K   I  R U    B  E  I  T
                                                     I  P   Y  G M T     I  T  L  E
                                                     L  O C N Z       I  Y  U K Q
                                                     Z  P Q M W O N P          X  E


                            SDG Activity



                     Use  Microsoft Access  to track and analyse the consumption and
                     management  of  school resources,  promoting  responsible usage  and
                     sustainability.






                       Digital Drills                                              #Digital Literacy
                                                                                   #Creativity & Innovativeness

                        Create a table for Student Fee System.
                        Create a table for Student Clubs and activities

                        Create a table for Student details
                        Create a relationship between three tables using the common fields.
                        Create a form for Student Clubs and activities and enter the following details:
                       •  Avni Singh                    VII C          Horse Riding             Rs. 1500
                       •  Aman Gupta                     IX B          Football                 Rs. 1450
                       •  Ananya Aggarwal              VIII D          Painting                 Rs. 1200
                        Write a query to find total fee of students studying in class VIII D

                        Generate a report of the query created.



                  Teachers' Turf


                  1.   Make the concepts of Query, Form, and Report clear and the difference between these to the students.
                  2.  Demonstrate how forms and reports can be customised.
                  3.  Explain different types of queries to the students.


                   102    TrackGPT iPRO (V5.0)-VII
   99   100   101   102   103   104   105   106   107   108   109