Skip to content

Latest commit

 

History

History
52 lines (40 loc) · 1.74 KB

README.md

File metadata and controls

52 lines (40 loc) · 1.74 KB
Raw

  • Step 0: Assign homework

    Homework can consist of the following tasks:

    1. Define views  
   Example: Define a view that returns all agents from the agent table. Name the view q1.

2. Create tables / add rows to tables  
   Example: Create a table named "books" and insert at least 4 rows.

3. Modify database in such a way that a certain query produces a certain output.  
   Example: Insert rows into the tables "books" and "authors" such that the following query is nonempty:
            SELECT * FROM books NATURAL JOIN authors;

  • Step 1: Add specific homework information

    • Add students to DBGrader/Students.hs
    • Add questions to DBGrader/Questions.hs
    • Add credentials to DBGrader/Config.hs
    • Add flags to DBGrader/Flags.hs

    Note: DBGrader/Types.hs has more information about defining values.

  • Step 2: Get student solutions from database

    $ runhaskell GetStudentAnswers.hs > studentGrades.csv

  • Step 3: Grade homework

    Grade homework by adding flags to the 'flags' column in studentGrades.csv Remeber to define flags in DBGrader/Flags.hs

  • Step 4: Calculate scores

    $ runhaskell createtotalscores.hs > studentTotalScores.csv

  • Step 5: Create a summary sheet for each student

    The following command will produce a summary sheet for each student. The sheets will be placed in the ./gradesheets folder.

    $ runhaskell createSummarySheets.hs

  • Step 6: Compile summary sheets to PDF

    Summary sheets are created in the markdown format. They should be compiled to pdf before sending them to students. If pandoc is installed you can compile them with the given makefile.

    $ cd gradesheets
$ make