MarkSheet Making

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.

1. 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),"B",IF(AND(R2>=50,R2<60),"C+",IF(AND(R2>=40,R2<50),"C",IF(AND(R2>=35,R2<40),"D","NG")))))))
  
  On above Formula R2 Represent the Result Mark Cell.
• Give the Remark Using following Formula
  
  =IF(S2="A+","Outstanding",IF(S2="A","Excellent",IF(S2="B+","Very Good",IF(S2="B","Good",IF(S2="C+","Satisfactory",IF(S2="C","Acceptable","Very Poor"))))))
  
  
• Find The Rank using following Formula
  
  =RANK(Q2,$Q$2:$Q$30)
  
  This Formula helps us to find the Position of The student. Where Q2 is the mark of Student and $Q$2 and $Q$30 is the Fixed Range of List. If we put $ Sign on the Excel, then Relatively with the marks the reference does not move. To Fix the cell we use F4 Key from the Top row of Keyboard.
  
  
2. Create The Word Document

• First of all, Lets Design the Progress Report on a blank document.
  
• Let's put all Detail and keep the blank place where we can insert it from the Excel sheet.
  
  
  
• After that we need to mail merge.

Mail Merge

• After we create the main document lets go to the Word document and start the mail merge wizard
• Let's go to the mailing Tab on 2007 later version of Microsoft office, if you are using the Microsoft office 2003 Then Go to tool and find for the Mail merge option.
  
  
  
• Click on Select Recipient
• Go to ' Use an Existing List'
• Then 'Select Data Source' Browser will open and Redirect it to the Mark ledger Excel Sheet.
  
• On this Document Class 7 is the mark ledger and 'FORMATE' is The Progress Ledger Design.
  
  
  
  
  
• Then Just Click on OK button.
• Now We can insert the Merge element on our document.
  
• Putting the Each field on the Respective Place we can create the Template and After Finishing it we simply Merge the document and export it to the PDF.