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

