FIN~

I've pretty much finished my markbook! I spent all night working on my spreadsheet. I used excel, which was a challenge because I have NO idea how to work anything on there. So, I looked at some information on the internet which was completely UNHELPFUL, but eventually after a long long process, I put it together.
I used macros because it was something I wanted to learn and get better at. I started by creating a title page. It was simply the word "markbook." I then used a button that would take me to a second page. This button said "click to start." On the second page, it had my markbook information. I made up students names. I thought about 10 students would suffice. I then made columns, one where the teachers can record the marks, one where the teachers can record percentage, and a final one where teachers can place the ranking of students within the class. I then put in buttons at the bottom of this sheet. The first button was "new". I put this button so a teacher could make a new sheet for a new subject exam. The make the button produce a new sheet, I simply went to the toolbar and went into the macro option. I then hit 'record new macro'. I named this macro 'newspreadsheet' and started recording my keystrokes. I copied the sheet and pasted it. I assigned the macro to the button "new". Now when I click this button, a replica of the sheet is formed. The next button I made was "save". I did this so teachers can easily save the changes of their progress with the click of a button. I repeated the same process with the macro recording, only this time I recorded my cursor stroke pressing the save button. I then assigned this macro to my new "save" button. I decided to add in a button that will take me back to the first spreadsheet. This can help make navigating easier for the teacher. I called this button "home". I recorded a macro called "GoHome" of me going back to the first sheet. I assigned this to my button. So, I had three buttons on each sheet and one on the homepage.
Later then, I put a formula at the end of the marks column. This enables the teacher to have the average mark added of all the marks whilst she adds them in.
This is what it looks like...


The homepage


The actual marksheets.
So, thats my progress so far! I definitely learnt a whole load about using macros and excel!!