Page 157 - Trackpad_ipro 4.1_Class7
P. 157
PROJECT WORK
#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.
Project Work 155

