File: sample-student-scores.tex

package info (click to toggle)
texlive-extra 2014.20141024-1
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 2,016,484 kB
  • ctags: 21,582
  • sloc: perl: 140,144; python: 16,926; makefile: 12,969; sh: 9,285; ansic: 3,415; java: 3,090; csh: 2,987; xml: 1,050; lisp: 630; ruby: 487; lex: 358; tcl: 142; sed: 36; pascal: 25; cpp: 18; awk: 10; haskell: 5
file content (34 lines) | stat: -rw-r--r-- 905 bytes parent folder | download | duplicates (7) 
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}