We use a google form to collect questions from our team members. These questions are fed and stored on a google spreadsheet like with normal google forms. Then we download the google spreadsheet as a csv file and name it "Questions.csv"
This code then parses the csv Data and creates 6 PDFs and stores them in the PDF directory. These PDFs are formatted collections of the questions that we collected and stored in our csv file through gogole forms.
This allows for an easy system to keep track of submissions through the form summaries on google forms, and then seamlessly create uniformly formatted PDFs of the different categories. You can just copy and past from these PDFs to create rounds.
#Running the Code There are three main programs: making subject pdf files, making ordered rounds (25 quesionts, but all the physics are stated, then all the math, etc.), make regular 25 question rounds with random order.
Making Regular Rounds: There is a bash scrip nameked MakeRounds.sh on the top level of this repo. To run it do this in your terminal:
./MakeRounds.sh
The rounds will be created in the rounds/ directory
Making Ordered Rounds: There is a bash scrip nameked OrderedRounds.sh on the top level of this repo. To run it do this in your terminal:
./OrderedRounds.sh
The rounds will be created in the orderedRounds/ directory
Making Subject PDFs: There is a bash scrip nameked MakeSubjectPDFs.sh on the top level of this repo. To run it do this in your terminal:
./MakeSubjectPDFs.sh
The Subject PDFs will be created in the PDFs/ directory
#Setting up the Google Form Here is the form we used. If you want this program to work, the form must have the exact same order as this one: Form
Also, here is the how the spreadsheet should look like: Spreadsheet
Here are some images that contain each part of the form to help recreate this type of form - remember to include everything:
END OF FORM
#Author Shantanu Jha President: Stuyvesant Science Bowl