Page 161 - Touchpad_Plus_V3.2_Class 8
P. 161

P R O J E C T W O R K










                 LibreOffice Base
                                                                                                21 st   #Critical Thinking
                                                                                              Century   #Technology Literacy
                 Project 1                                                                     Skills

                 Create three tables in LibreOffice Base as under:

                                                          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 2                                                                      21 st   #Critical Thinking
                                                                                              Century
                                                                                                Skills  #Technology Literacy
                    Create a data entry form for patient record to be maintained by
                    ABC Hospital Services.
                    The fields that need to be part of the table are:

                    •  Unique Patient ID
                    •  Patient Name

                    •  Patient Address
                    •  Symptoms
                    •  Doctor’s Name

                    •  Diagnosis

                    •  Health Insurance Coverage (Yes/No)
                                                                                                        21 st
                                                                                                      Century   #Creativity
                 GIMP                                                                                   Skills
                 Open this image from Pictures Gallery of Ubuntu in GIMP.
                    Use the GIMP tools to create two duplicates of the flower to give it a look of a bunch of

                    flowers.



                                                                                                  Project Work       159
   156   157   158   159   160   161   162   163   164   165   166