function [m,A,B]=markquiz(filename)
% filename is character string representing excel file, first column=student ID, second and remaining columns=answer in characters
%ans=vector of correct answers.  The answers are in  the first line of the excel file.
%  for example m=markquiz('quiz.xls')
[A,B]=xlsread(filename);
n=size(B);
mark=zeros(n(1)-1,n(2)-1);
for i=2:n(1)
    for j=2:n(2)
    T0=cputime;
    eval(char(B(i,j)));
    mark(i,j-1)=(cputime-T0)*(t-ans(j-1))^2;
  end
end

sd=sqrt(var(mark));
mark=3-standardize(mark);
m=[A(:,1) mark sum(mark,2)];
%mark=average mark(=3)+zscore for each question, last column is total mark




    
    
    
    
