+ Post New Thread
Results 1 to 12 of 12
How do you do....it? Thread, A simple system in Technical; Hello All, I want a really simple system whereby Heads of Faculty respond to two questions for each Yr Group: ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    A simple system

    Hello All,

    I want a really simple system whereby Heads of Faculty respond to two questions for each Yr Group:

    ........Data Verified......Data Validated
    Y07........Y/N.......................Y/N
    Y08........Y/N.......................Y/N
    Y09........Y/N.......................Y/N
    Y10........Y/N.......................Y/N
    Y11........Y/N.......................Y/N


    I want to see a summary of this aggregated data across the facuilties so I can easily identify where the 'NOs' are. Some simple interface that all users can access at the same time is required.

    My question is, how would you achieve this?

    Thank you!

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,707
    Thank Post
    855
    Thanked 901 Times in 746 Posts
    Blog Entries
    9
    Rep Power
    329
    It looks like a job for Excel, only you want everyone to be able to access it at once. I could knock something up in PHP/MySQL but that does seem a little overkill. Maybe a single PHP webpage using a text file to store the data? Maybe in CSV format so you can import it easily to Excel for analysis?

  3. Thanks to tmcd35 from:

    park_bench (1st December 2009)

  4. #3

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by tmcd35 View Post
    It looks like a job for Excel, only you want everyone to be able to access it at once. I could knock something up in PHP/MySQL but that does seem a little overkill. Maybe a single PHP webpage using a text file to store the data? Maybe in CSV format so you can import it easily to Excel for analysis?
    This was my initial thought too, particularly because I am comfortable using Excel - but I would have to produce a seperate sheet for each Faculty, and aggregate the data for admin use on another sheet. I wondered about more elegant solutions.

    I'm not a programmer but can usually teach myself quite quickly. What do I need (software-wise) to put a single PHP webpage together?

    Cheers

  5. #4

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,707
    Thank Post
    855
    Thanked 901 Times in 746 Posts
    Blog Entries
    9
    Rep Power
    329
    Quote Originally Posted by park_bench View Post
    I'm not a programmer but can usually teach myself quite quickly. What do I need (software-wise) to put a single PHP webpage together?
    Like I say, I think it's a bit overkill for the problem at hand. I'd use Excel and make the teachers aware that it may be read only if someone else is accessing it.

    For PHP. You'll need a server running Linux with Apache and PHP or Windows and XAMPP or WAMP (you can also install PHP onto IIS - messy).

    Then head over to google and find a decent online 'how to code PHP' guide.

  6. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Use Google Docs to set up a form, should do what you need.

    Like this.

  7. Thanks to webman from:

    park_bench (1st December 2009)

  8. #6

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    This is crying out for an Access database.

  9. #7
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Vote for Access, easy to implement and does what you want.

  10. #8

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by webman View Post
    Use Google Docs to set up a form, should do what you need.

    Like this.
    This takes the hassle out of creating many exclusive Excel spreadsheets! Thanks.

    Access DB has the majority of votes so far - presumably the benefit is I can easily add tables and forms in the future and it stays 'in-house'?

  11. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,836
    Thank Post
    517
    Thanked 2,476 Times in 1,919 Posts
    Blog Entries
    24
    Rep Power
    836

  12. 2 Thanks to localzuk:

    park_bench (1st December 2009), tmcd35 (1st December 2009)

  13. #10

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,707
    Thank Post
    855
    Thanked 901 Times in 746 Posts
    Blog Entries
    9
    Rep Power
    329
    Quote Originally Posted by localzuk View Post
    Nice one! Learn something new every day - although I think the Googleapps idea is gold

  14. #11

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by webman View Post
    Use Google Docs to set up a form, should do what you need.

    Like this.
    Just a note about this solution...

    As far as I can see, unless you use Google Apps (the subscription service) you only get an anonymous timestamp on the responses so you cannot distinguish who has responded explicitly.

    Is this your understanding Webman?

  15. #12

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324
    Quote Originally Posted by park_bench View Post
    As far as I can see, unless you use Google Apps (the subscription service) you only get an anonymous timestamp on the responses so you cannot distinguish who has responded explicitly.

    Is this your understanding Webman?
    Yes that's right, unless you add a field asking for their name (or other identifier). But without some scripting magic, I don't think you get that by default in Access/Excel either.

SHARE:
+ Post New Thread

Similar Threads

  1. [Video] Sometimes It's The Simple Ideas That Are Best!
    By eduabncs in forum Jokes/Interweb Things
    Replies: 0
    Last Post: 1st March 2009, 02:42 PM
  2. 2 simple update
    By lionsl2005 in forum How do you do....it?
    Replies: 1
    Last Post: 16th January 2009, 07:50 AM
  3. [Pics] Simple but effective
    By Little-Miss in forum Jokes/Interweb Things
    Replies: 8
    Last Post: 7th January 2009, 11:59 AM
  4. Simple 1.5 doesn't look right
    By SimpleSi in forum EduGeek Joomla 1.5 Package
    Replies: 7
    Last Post: 25th May 2008, 11:21 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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