Reply to thread

Message

<blockquote data-quote="Ethereal" data-source="post: 375328" data-attributes="member: 32830">Here's a program I made that makes the user take a mathematics quiz, records their name and class number, then logs their score to a database via MSQlite. It then gives the user the ability to output the scores (in sexy tables I might add) of anyone who has taken the quiz in these selectable formats: average score, highest score in ascending order and name of everyone who has taken the quiz alphabetically. The program was designed to be taken by pupils in three different classes.Anyone running the program needs to install Tabulate, as it is the programs one and only dependency:[CODE]pip install tabulate[/CODE] Link to sqlite database file full of users: <a href="https://drive.google.com/open?id=0B9-niqJmPUB3d2F0UTZZSFN2X0E" target="_blank">https://drive.google.com/open?id=0B9-niqJmPUB3d2F0UTZZSFN2X0E</a>Link to private Gist (the code): <a href="https://gist.github.com/JosephLee63/5562eb7891235098afffa68d2fb916fd" target="_blank">https://gist.github.com/JosephLee63/5562eb7891235098afffa68d2fb916fd</a>Location of the module I used to create the sexy tables: <a href="https://pypi.python.org/pypi/tabulate" target="_blank">https://pypi.python.org/pypi/tabulate</a>This program should provide a good understanding of SQLite in Python and a little bit of how maths work too. Sorry that the program is soelongated. :'&gt;Here's a little example of the averaging selection:<img src="http://i.imgur.com/ZQBwOzC.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></blockquote>

[QUOTE="Ethereal, post: 375328, member: 32830"] Here's a program I made that makes the user take a mathematics quiz, records their name and class number, then logs their score to a database via MSQlite. It then gives the user the ability to output the scores (in sexy tables I might add) of anyone who has taken the quiz in these selectable formats: average score, highest score in ascending order and name of everyone who has taken the quiz alphabetically. The program was designed to be taken by pupils in three different classes. [I]Anyone running the program needs to install Tabulate, as it is the programs one and only dependency:[CODE]pip install tabulate[/CODE] [/I] Link to sqlite database file full of users: [URL]https://drive.google.com/open?id=0B9-niqJmPUB3d2F0UTZZSFN2X0E[/URL] Link to private Gist (the code): [URL]https://gist.github.com/JosephLee63/5562eb7891235098afffa68d2fb916fd[/URL] Location of the module I used to create the sexy tables: [URL]https://pypi.python.org/pypi/tabulate[/URL] This program should provide a good understanding of SQLite in Python and a little bit of how maths work too. Sorry that the program is so elongated. :'> Here's a little example of the averaging selection: [IMG]http://i.imgur.com/ZQBwOzC.png[/IMG] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members