Overview

This is the first programming project. It involves (1) writing a Haskell program that manipulates the prior learn survey data. (2) Creating suitable Excel table from your results. (3) Graphing the data inside Excel. (4) Writing a 1 page report that includes the program and the graph.

Examples

I have created several example programs, graphs, and write ups so that you can see an example of what is required.

• Gender vs major. program, excel, word.
• Parental college experience vs Student expectations of graduation. program, excel, word.
• Major vs self rating of quantitative and social abilities. program, excel, word.

Getting Started

• Down load the prior leaning stub program to get started.
• Be sure you have downloaded the newest versions of Excell.hs and the CSV.hs libraries into the same directory. (Download them and just overwrite the old versions).
• You will also need to download the PriorLearn.hs library
• Read through the prior learning key to get some idea what kind of data is available.
• Each question in the key is numbered. Right down the numbers of the questions that you want to use for data in your program. E.g. question 41 is students major.
• Start up Hugs on your program. Inside hugs type "name 41". This returns the name of the Haskell function that will access the data for question 41 "major41". Thus you could type "major41 (priorLearnData !! 22)" to get the major of the 22 student in the prior learning data. See the screen shot for an example.
• Study the example programs to see how to use these functions to select just the data you want.
• Now edit the stub to create some data that answers a question of your interest.
• Work by creating a series of temporary values. Look at each temporary value and decide how to create the next one. You might study the examples I posted.
• Finally use the data to create an Excell table.
• From inside Hugs type "main". This will export the table to a file "myfileName.csv" which can be opened with Excel.
• Use Excel to create a graph or table. Review the multi variable graphing assignment from last term.
• Create a new word document.
  1. Cut and paste the graph into the word document.
  2. Also add some text describing what the graph represents.
  3. Finally cut and paste the code into the word document
• Be sure the names of both people in the team appear on the very first line of the word document.
• See the section below for how to turn in your result.

Grading Rubric

I will grade the project using the following criteria.

• The result has the structure described above with names, graphs, caption, and program.
• The question you answer is original. You will get less credit for a question that more than one team answers.
• The program adds something additional not found any of the examples.
• The graph is labeled and easy to read and understand.
• The caption describes the interesting results, as well as meaningful information not found in the graph itself.
• The result is interesting, the write is aesthetically pleasing, the graph uses color, the program is simple and effective.

What to turn in

Turn in the following things to complete the project. Be sure both team members names are on all documents.

• A copy of the program file you wrote.
• A few short tests that demonstrate that the table is built correctly.
• A copy of the Excel spreadsheet, which includes the graph you produced.
• A copy of the word document, that includes the graph, your writeup, and the propgram.

Back to the Daily Record.

Back to the class web-page.