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...
It's a great honor to greet you in my weblog. Let me extend warm welcome to all of you. From Last decade the access of internet and IT has become crucial and the sharing of Idea, method and experience had become more broad. Apart from the digital divide there is no thing hard as before. I would like to share my Path of learning and experience here and i hope those who are on my path it would be as a milestone. On upcoming days here i will be sharing the techniques and technology of the learning and development. It will be a open source platform for those who want to groom them self. I would be grateful to share my experience and knowledge with everyone through my blog. Stay tuned..