Page 90 - ModularV1.1 _c6_flipbook
P. 90
PROJECT WORK
MS Excel
Project 1 Inter-Disciplinary
Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate
the percentage of marks they have obtained. Here is an example.
Project 2 Subject Enrichment
Rajat has created a list of 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.
88 Modular (Ver. 1.1)-VII

