Page 111 - TP_Modular_V2.1_Class7
P. 111
PROJECT WORK
Excel 2016
21 st
Century #Critical Thinking
Project 1 Skills
Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate
the percentage of the marks they have obtained. Here is an example.
Project 2 Century #Technology Literacy
21 st
Skills
Rajat has created a list of the students who are a part of school cricket team.
Sr. Name of the Runs Scored in Total Runs Average
No. Student Match 1 Match 2 Match 3 Scored Runs Scored
1 Ravi 65 45 59
2 Chirag 54 120 63
3 Amit 55 12 85
4 Rohan 68 89 78
5 Anurag 79 50 100
6 Mohan 90 12 36
7 Rajan 45 78 79
8 Devendra 25 36 40
9 Chetan 14 20 18
10 Ravindra 7 9 10
11 Narendra 12 5 0
Now, he wants to add a column titled ‘Designation’ between Name of the student and Runs
scored in columns to put category 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 ‘Total Runs Scored’ and ‘Average Runs Scored’ by each student using formulas.
Project Work 109

