You are here:

Excel/Query::- Preparing Students' Mark-Sheet

Advertisement


Question
Hello There!

I'm not sure if it's the correct topic to ask the question.

But the thing is: I work in a school as a teacher. Currently, our school uses handwritten big-sheet (marks-ledger) and progress report (marks sheet) for different examination held at the school. But I want to implement the digital method i.e. prepare the big-sheet on computer and transfer the marks of each students to prepare computer printed mark-sheet. So, I want to get idea on how it is done. There's must be some simple method to do. Typing each marks on big-sheet and again typing the same data for mark-sheet is going to be time consuming and hectic.

I hope to get some tips and ideas on how it is done in simple way.

Thank You.

Answer
Abhi,

I support your idea.  I am sure that typing a grade one time into an Excel spreadsheet would then allow you to use that information many times in computing total grades or keeping records or whatever.  There is no particular method associated with it.  The spreadsheet was created to be used like a paper ledger.  The advantage it offers is that is has mathematical functions and other functions that allow the user to analyze the data entered.  It is also stored in a file that can be accessed by others if it is located in a network or stored on a disk and passed to another.  At the same time, that information can be altered with little evidence of that fact, so even at the beginning, one must consider security.  

Now the application you describe is one that is pretty much universal throughout the globe.  Since Excel is used worldwide, you should be able to find many free examples of what you want to do on the internet.  Microsoft has a site where it offers "Templates" with pre-designed files for many different types of applications.  Here is a link to a search on "grades" at the template site:
http://office.microsoft.com/en-us/templates/results.aspx?qu=grades&ex=1&origin=F

If you put that in the navigation bar of your browser, it should show you those results.

Also, just search google for  Excel Grade sheet

of search for excel gradebook

Here is a link to a PDF file that shows how to create a grade sheet in Excel:
> http://edsserver.ucsd.edu/courses/eds203/fa07/a/gradebook.pdf

==<revision>===
the above link seems like a bad link.  Here are several others that I tested and they all seem to be good.  

http://domin.dom.edu/documents/office2000/WeightedGradebook.pdf

http://www.educationworld.com/a_tech/techtorial/techtorial064.pdf

http://spider.georgetowncollege.edu/t3/Tutorials/gradebook.htm

http://www.fctl.ucf.edu/teachingandlearningresources/technology/Gradebook/

http://archive.tlt.psu.edu/suggestions/gradebook/formulas.html


==<End Revision>==

That might be just what you need (you will need the acrobat reader software which is free from Adobe).

I hope that is the type of information you were looking for.

--
Regards,
Tom Ogilvy  
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Tom Ogilvy

Expertise

Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]

Experience

Extensive experience.

Education/Credentials
Master of Science (MS) degree Operations Research (ORSA)

Awards and Honors
Microsoft MVP in Excel.

©2016 About.com. All rights reserved.