IT.BLOG.
Sunday, June 7, 2009
CREATING MY MARKBOOK...
In the process of creating my markbook, i have come across some troubles.
These include creating the macros. I have had trouble with making the macros work
this had taken up most of the time as they were not done right the first few times.
Because of this I have had to start a new markbook every time until i got the macros
working, this is because they would not allow me to delete them so i had to start again.
In the end, after startnig my 4th markbook, I had created the macros right and they are working properly.
There are only two macros, NEW SHEET- this creates a new sheet and allows the person
rename it. There is also an INSTRUCTIONS, macro which automatically directs the person
the instruction page.
In the starting markbook, there are only three sheet, one is the homepage, the instruction page and one is a starting sheet which is called template.
On the fist template there are just headings, CLASS, LAST NAME, FIRST NAME, TASK 1, GRADE, TASK 2, etc...
This is just to start the person off on how they would like to make it and they can change this in any way the want.
REQURIEMENTS REPORT...
The purpose of my markbook is to allow teachers to have an electronic personal markbook.
The markbook i have created allows the teacher to insert names, task marks and task grades,
it also allows to find out the final grade and final mark.
The teacher can also use autofilters in order to find a specific person, find out who passed a task
or who failed one.
The markbook includes macros which will allow the teacher to automatically create a new
sheet, and rename it to whatever they like. The sheet they create also includes some
headings, class, name, mark, grade. This is to help the teacher a little to start off creating
a sheet of their own.
The markbook also includes some instructions on how to use it. What certain buttons are for
and how to create things e.g. a new sheet. The instructions are there to help out the teacher
with creating their own markbook.