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

