Hello Everyone, Today I am going to share how to make student Mark sheet and Progress Report. We can prepare it integrating Ms Excel and Microsoft Office Word. It is quite Easy and Time saving Method than the traditional System. To prepare it we need to Follow following steps. Create Main Document First of all, lets create a Mark Ledger using the Ms Excel. Fill up the Name of Students, Respective Marks, Total Marks, Total Attendance Calculate the Total Marks Using the Formula =Sum(Cell1: CellN) i.e. If Cell1 is English and respectively Nepali, Math, Science, Mathematics, Symphony, Social, Optional Mathematics then Last Cell will be Cell9 and formula will be =Sum(Cell1:Cell9). Click the cell for the easy Selection. Find out the Percentage. To do this just click =(total Marks Obtain/Total Subject marks)*100 Find out the Grade using the formula =IF(AND(R2>=90),"A+",IF(AND(R2>=80,R2<90),"A",IF(AND(R2>=70,R2<80),"B+",IF(AND(R2>=60,R2<70...