Help! PHP/SQL beginner creating Faculty Evaluation System

[moniker]

hello everyone,

 

i dont know if im in the right place to ask this. perhaps im still on the very first forum im trying to seek help for this.

so as the title says, im a beginner in PHP and im really having a hard time trying to create this system that is LAN-based.

ive been working on this for more than a month but im really getting desperate to finally sought help from forums like this cause this project of mine has a deadline. i need this done by the end of july.

 

the system has two users: students and admin

 

the students are the ones of course who are going to evaluate the teachers on each of their subjects their teaching

 

the admin only has the authorization to add, edit and delete students and teachers

 

students can only log in, admin as mentioned above has the only one who has authority to register them

 

a single student can only evaluate once, can evaluate more than one subject from a single teacher

 

auto computation of ratings of teacher from their subjects' average ratings combined

 

from every student, they have subjects they enrolled for a particular semester and all of these subjects are the ones theyll evaluate from respective teachers

 

i have a copy of a manual faculty evaluation, perhaps im trying to make this computerized and i cant figure out specially the computation how the ratings is solved. i dont understand how no matter how much i google

 

there are 15 items of questions with 1- 5 rating scale

 

if my specification is lacking on further elaboration of the system i need to do or things that are confusing, perhaps do i need to be redirected to someplace else where i can get help please do let me know.

 

thanks for the time

(its 4 am in the morning in my place when i made this post so excuse any confusion)

[Sensei]

If you have been working on this project for more than a month, you should have no problem showing PHP scripts that you made already.

 

i have a copy of a manual faculty evaluation, perhaps im trying to make this computerized and i cant figure out specially the computation how the ratings is solved. i dont understand how no matter how much i google

I have no idea what are you trying to Google..

 

It's your system that you have to make, not search ready answers.

 

there are 15 items of questions with 1- 5 rating scale

Value 1-5, can be stored in 3 bits (0...7 at max),

so 15 such questions, could be stored in single 64 bit integer.

You would have to pack/unpack them each time SQL database is read/written.

Alternatively make 15 columns of db row entry. But teachers would probably appreciate that you optimized disk/memory usage packing bits together.

Edited July 18, 2016 by Sensei

[moniker]

If you have been working on this project for more than a month, you should have no problem showing PHP scripts that you made already.

 

unfortunately nope, i havent done a single php script. i cant get my head around it since im too focused on figuring out the auto-computation of ratings. im only still getting myself familiarize with php.

[Sensei]

unfortunately nope, i havent done a single php script.

Then I don't understand what do you meant by "working on this for more than a month", when you didn't work on it at all.. You should simply open text editor and start writing.

 

i cant get my head around it since im too focused on figuring out the auto-computation of ratings.

Who cares about it? That's the last and the less important routine..

You have to make the all code for logging in, logging out, editing entries by admin, filling survey by student etc. generate HTML forms with dozen fields... store them in database...

That's plentiful of work.

While some rating system is just 1% of work at most.

Do what you have to do,

then you will show your teacher that you even started,

because so far you didn't do anything AFAICS.

 

im only still getting myself familiarize with php.

Well, then you should start from making PHP/SQL counter perhaps... ?

Edited July 18, 2016 by Sensei

[fiveworlds]

im only still getting myself familiarize with php.

 

Is this a homework question then??? Many universities here use Moodle which allows for student evaluations and it is free.

[moniker]

Then I don't understand what do you mean by "working on this for more than a month", when you didn't work on it at all.. You should simply open text editor and start writing.

 

Who cares about it? That's the last and the less important routine..

You have to make the all code for logging in, logging out, editing entries by admin, filling survey by student etc. generate HTML forms with dozen fields... store them in database...

That's plentiful of work.

While some rating system is just 1% of work at most.

Do what you have to do,

then you will should your teacher that you even started,

because so far you didn't do anything AFAICS.

 

perhaps explaining myself wouldnt do much. i understand what youre trying to say, the most common sense in fact to do. im full aware of that. but either way, thanks for the plentiful posts. whats less important routine is something important for me to get me started from bottom all the way up. cause thats the hardest part for me to do.

[Sensei]

Your job is to make couple SQL tables,

with rows,

like teacher,

like student,

like answers student gave.

It has to end up in SQL db.

 

Think what layout has to have teacher's table, what layout has to have student's table (what columns are needed), what layout has to have answers table (at least student's id, teacher's id, answer bitfield)..

 

Routine showing final result,

leave for.. final of job.

You can't make it at start when you have nothing, no SQL db tables at all, to work on their data..

 

ps. Nobody will do this for you. At least not on this website.

If you will be finding people doing your job instead of you, you won't be able to be employed and work efficiently in the future in any software company.

Edited July 18, 2016 by Sensei

[moniker]

Your job is to make couple SQL tables,

with rows,

like teacher,

like student,

like answers student gave.

It has to end up in SQL db.

 

Routine showing final result,

leave for.. final of job.

 

ps. Nobody will do this instead of you. At least not on this website.

If you will be finding people doing your job instead of you, you won't be able to be employed and work efficiently in the future in any software company.

 

i apologize if that what my post seems to be. i did mention im sorry about the confusion my post can bring cause im not really good at explaining. im not trying to make it look like im trying to make you guys make it for me. i just presented my idea on the system. but i cant do anything about how its perceived still.

[Sensei]

IMHO you should start from making admin's panel,

logging in and out,

then to teacher's panel,

adding/removing/editing teachers,

then to student's panel,

adding/removing/editing students.

I don't recommend using teacher's/student's row index as id,

because if you remove element in the middle of table,

all ids below it will be no longer pointing to the right entries.

Ids should be unique, auto-incremented without repetitions, or randomized value checked in db to find it's really unique.

 

When you will have above, return back to us.

[bimbo36]

i am a computer science student ... not an expert programmer ... this is not an easy thing to do ...

 

all those things requires a lot of programming...

 

 

i don't know if these pictures might help you ...

 

that was my own attempt to program something useful , with html , php , mysql , javascrip and ajax ...

 

i had to play around with some scripts i downloaded from the internet ...

 

 

 

 

 

 

 

 

 

the first picture is supposed to be the client side ... and the last picture is supposed to be a linux machine where you host your files...

Edited July 28, 2016 by bimbo36