Today we were told how we can improve our markbook He suggested to use macros which will enable to fo functions such as: -Creating a new class or putting more classes -How many students in a class
---- Today im going to add the Auto Filters onto my prototype. I am also going to start working on my VLOOKUP which im going to use for the grades students will get depending on what there marks were on each task. http://phoenix.phys.clemson.edu/tutorials/excel/stats.html ---- -COMPLETED-
The VLOOKUP involed created some kind of key that involves a value that equals something for my VLOOKUP it will involve allocating a grade depending on the mark that the student has. mine looked like this 80-A 70-B 50-C 30-D 10-E
and if the marks range around the score (the numbers on the left) it will allocate the Grade on the right.
=VLOOKUP(E4,$J$5:$K$9,2,TRUE)
E4 being the cell that contained the score J5:K9 being the Grade Key values
-- The Auto Filters were just selecting the area that you want to filter to be then click on data ---> filters ---> auto filters
this allows the user to create a custom action that involves showing information the use would like to see for example the user wants to view marks above 90 they will click on the arrow then click custom then put the option "greater than" then put 90 then it will show the marks over 90 :)
the only problem i have with this is when it view the marks of grades
---- i had time to add a 'conditional formatting' which involves highlighting what the use wants to see So i highlighted that is a student gets a A or an E it will be highlighted just because this marks are usually ones that teacher will want to look at E being for the student need to improve or A being student might have to do extension or Accelerated class :)
