Results 1 to 9 of 9

Calculate stats from multiple csv files

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Calculate stats from multiple csv files

    I work for a University in Michigan. We are starting to use a software title to deliver and administer tests/surveys. After the test is done the program will write 2 types of files; 1 is an html of all the computer names and their total score, the other is an individual .csv file which details Question number, Question Title, Total Points, and Points Scored. Is there a way to automate the creation of a document that uses all the .csv files to create stats?

    Example:
    (Suppose that each person has their own .csv file with this info)
    Person 1
    Question 1: 0 points
    Question 2: 1 point

    Person 2
    Question 1: 1 point
    Question 2: 1 point

    I am looking for a way to output that 50% of the people got Question 1 right, and 100% of the people got Question 2 right. Assuming that each question will be worth 1 point.

    Attached are 2 of the .csv files that the program spits out when the test is completed. Also please ignore that the first question was worth 4 points, in the future it should 1 point or 0 points.

    Please let me know if what I am asking is possible.

    Thanks
    ~Fletch
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1