File: sample-student-scores.tex

package info (click to toggle)
texlive-extra 2022.20230122-4
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 4,466,588 kB
  • sloc: perl: 398,710; xml: 35,871; python: 29,125; cs: 25,850; sh: 17,610; makefile: 17,304; ansic: 15,490; java: 12,811; javascript: 9,898; lisp: 1,755; csh: 1,129; ruby: 1,072; awk: 151; tcl: 142; pascal: 138; cpp: 41; sed: 36; 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}