In order to create a professional, user friendly grade book, I firstly wrote a list of the items I wanted to include in my spreadsheet using Microsoft Word, before I started creating it. I did this so that I could make sure I had included all the functions required, as I changed their colour from red to black once I had completed that function.
Once I had completed this, I wrote down what functions/data each individual page would contain, and the order each worksheet should go in, in Microsoft Word.
I did this because it allowed me to have a chance to analyse the amount of information and functions which were needed on each worksheet. It also have me the ability to understand the order in which my worksheets should follow, for example, if I had put the maths report after the english worksheet instead of the maths one, then it would not have run in a logical sequence of events, and would have most likely confused the user (the teacher.) I did the worksheet layout before creating my spreadsheet, as if I had not prepared and gave a structure to my Spreadsheet beforehand, I may have made numerous mistakes and I would have had to of gone back and changed it afterwards, or more unfortunate, maybe I would have had to of started a new spreadsheet altogether.
Once I had finished and knew what I was going to include, I was then ready to tie it all together and form a professional grade book in Microsoft Excel; the reason why I decided to create a grade book in Excel is because It is easy to use and can easily be changed, unlike Microsoft Access, where if you make a database and accidently make a mistake it is a long process to actually fix the problem, where in Excel it only...