1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
% This file is public domain.
\documentclass[captions=tableheading]{scrartcl}
\usepackage{datapie}
\DTLloaddb{marks}{sample-student-records.csv}
\begin{document}
% Compute average mark for each student:
\DTLforeach{marks}{%
\assignI=Assignment 1,%
\assignII=Assignment 2,%
\assignIII=Assignment 3}{%
\DTLmeanforall{\theMean}{\assignI,\assignII,\assignIII}%
\DTLround{\theMean}{\theMean}{0}\DTLclip{\theMean}{\theMean}%
\DTLappendtorow{Average}{\theMean}}
% Sort according to average mark
\DTLsort{Average=descending}{marks}
\begin{table}
\caption{Student Marks}
\centering
\DTLdisplaydb[Address,RegNum,Title]{marks}
\end{table}
\begin{figure}
\caption{Pie Chart}
\centering
\DTLpiechart{variable=\Average,outerlabel={\Surname, \FirstName},rotateouter}{marks}%
{\Average=Average,\Surname=Surname,\FirstName=First
Name}
\end{figure}
\end{document}
|
