summaryrefslogtreecommitdiff
path: root/macros/latex/contrib/datatool/samples/sample-student-scores.tex
blob: ff61d4dbbfff81ef7d93e1189bb8eac170f2b2db (plain)
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
 % This file is public domain.
\documentclass[captions=tableheading]{scrartcl}

\usepackage{datatool}
\usepackage{longtable}

\DTLloaddb{scores}{sample-student-records.csv}

\begin{document}
Sort by surname, then first name:
\DTLsort{Surname,First Name}{scores}

% omit Address column
\DTLdisplaydb[Address]{scores}

Sort by assignment 1 score in descending order:
\DTLsort{Assignment 1=descending}{scores}

% omit Address column
\DTLdisplaydb[Address]{scores}

Average score: 
\DTLmeanforcolumn{scores}{Assignment 1}{\averagescore}%
\averagescore\%.
Rounded to two decimal places: \DTLround{\averagescore}{\averagescore}{2}%
\averagescore\%.

A long list will require the longtable environment (supplied by
longtable.sty). Example in Table~\ref{tab:records}.

% Omit RegNum and Address columns
\DTLdisplaylongdb[caption={Student Scores},label={tab:records},omit={RegNum,Address}]{scores}

\end{document}