\documentclass[12pt,twoside]{article}
\usepackage{german}
\usepackage{typearea}
\usepackage{klausurmanagement}
%% topic-dependent preferences
\usepackage{pst-dbicons} % database icons etc
\usepackage{amssymb} % subsetneq

%% required for printing exam sheets
\usepackage{klausur-pre}

%% required for printing certificates
%% here, locally cutomized styles may be used
\usepackage{modulklausurschein}

\begin{document}

\def\kommanote#1.#2{#1,#2}
\def\myline#1#2#3#4#5#6#7#8{%
   \mylineii{#1}{#2}{#3}{#4}{\kommanote#5}{#6}{#7}{#8}}
\def\mylineii#1#2#3#4#5#6#7#8{%
   {\immediate\write\auxOut{#2; #3; #4; #5; #6; #7; #8}}}

\pagestyle{empty}

%%% klausurdatei must be set if exams are printed
\teilnehmerdatei{db-ws1011-faketeiln}
\klausurdatei{db-ws1011-klausur-ilias}
\klvorlesung{Datenbanken}
\klvorlAbbrev{DB}
\kldozent{Prof.\ Dr.\ W.\ May}
\klsemester{Wintersemester 2010/2011}
\kldatum{9. Februar 2011}
\klects{4}

\klhoechstpunktzahl{90}
\klmindestpunktzahl{42}
\klnote{1}{78}{74}{70}
\klnote{2}{66}{62}{58}
\klnote{3}{54}{50}{46}
\klnote{4}{42}{42}{42}


%%%%%% Produce Output %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%% Comment out items that are not needed %%%%%%%%%%

\PrepareForReports %%%%% this is always needed.
%% note that it generates the ASCII <jobname>.tab file that
%% can be used for further processing by scripting
%% languages

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%  Before: If Participant Lists are needed %%%%%%%%%%%%%%%%%

%\areaset{16cm}{25cm} %% Teilnehmerlisten

%%% List of participants by ID numbers (intended: public)
%\printTeilnehmerNummern
%\cleardoublepage

%%% List of participants by ID numbers (intended: internal)
%\printTeilnehmerliste

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 
%%%  The Exam: Protocols (oral) or exams (written)  %%%%%%%%%%
%%%  usually, only one of them is needed

%\cleardoublepage
%\alleprotokolle

%%% exams: they come with pagenumbers; 

% as the printed exams are ordered, it is advantageous to place
% the students in the room accordingly.
% use the below cards+scotch tape (or handwritten post-its instead)

%\cleardoublepage
%\printTischkarten

\cleardoublepage
\pagestyle{plain}
\areaset{16cm}{25cm} %% Klausuren
\alleklausuren
%\pagestyle{empty}


%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 
%%%  After: generate result lists           %%%%%%%%%%%%%%%%%%

\cleardoublepage
\areaset{18cm}{23cm} %% Tables

%%% print full list with all participant and full names
\def\abovetabletext{Klausurergebnis ``Datenbanken'' Wintersemester 2010/11 \\
 (Klausur am 9.2.2011) \\
 Modul: ``CS.B.inf.301: Datenbanken'',  2+1 SWS, 4 ECTS}

\printInternalList
%\cleardoublepage

%%% print public list:
% only matrikel/registration numbers, no names
% excludes \nopublic entries
%\printPublicList

%%% write to a file that can be used as input for an SQL database
%
%\writeToSQL

%%% write to an ASCII output in any style (see for details how
%   to customize it in the style file)
%
%\CustomizedOutputToAscii
%
%
%\newpage 
%\include{db-ws1011-notenspiegel}

 % \areaset{18cm}{28cm} %% Scheine
 % \begin{scheine}
 %   \zweiproseite
 %   \allescheine
 % \end{scheine}

\end{document}

% Local Variables: 
% mode: latex
% TeX-command-default: "LaTeX"
% TeX-PDF-mode: nil
% End:
