HELP! Faculty Evaluation System LAN-Based Thesis (PHP/MySQL)

[moniker]

• UPDATE! 2 tsaka po yung SEMESTER will also play a big role para po ma-categorize yung mga results of evaluated prof
  • since twice in a year po ginagawa ang faculty evaluation before/after finals, hence 1st semester and 2nd semester of specific year
  • kunwari po, i developed this system this year and pede po sya magamit this year of 2016: 1st semester, 2nd semester. and then 2017: 1st semester and 2nd semester. 2018, 2019 and so on
  • basta po ma-categorize at maviview results divided into two semester yearly ni sa home page ni admin
• UPDATE! nagtanong po ako ulit sa prof about the system, they clarified to me na dapat daw po based po sa COURSE at MAJOR SUBJECTS ng student yung mga prof na kailangan nilang i-evaluate

• kung BSCS po COURSE ng student, then yung pang BSCS MAJOR like IT subjects na nakaenroll lang po i-evaluate na mga prof, di na po kasama MINOR SUBJECTS na meron na kinukuha

---

hello po mga ate/kuya ng symbianize!

sa october na po defense namin
thesis proposal po namin is like the title says: Faculty Evaluation System na LAN-BASED using PHP/MySQL (either using WAMP or XAMPP)

nung bakasyon pa po ako trying my best to self study PHP/MySQL pero im still so lost kung pano ko sisimulan yung program lalo na sa pagcreate ng tables for MySQL Database

(my attempt trying on figuring out the tables)

medyo gets ko naman po ADD/EDIT/DELETE/VIEW

• pero dun lang po talaga ako sa kung anong gagawin kong mga tables at pano ko po sila pagkoconnect sa isat isa at i-organize

yung program consists of: log-in system, rating system, survey system

• users: admin, students

yung mga questions po sa evaluation is exact replica nung gamit ng school/college namin so need pong baguhin yun to add or edit the questions for the evaluation

• specific for college students lang po gagamit neto

wala na pong peer-to-peer evaluation from kapwa professors nor dean/department heads

• yung rating scale po nya is 1-5

• kailangan din po nagso-solve, may formula para sa average nung score nag maga-add. di na po needed yung interpretation if pass or failed yung rating nung isang prof. ang kailangan po is basta nagsosolve at nagii-store sa database para maview ng admin. again, meron na po akong formula na hiningi sa admin office na naghahandle ng manual evaluation. pero di ko pa rin po alam kung pano koconvert to PHP

(formula)

• ang gusto po kase ng prof gawin namin is kung ano yung enrolled subjects ang mga kinukuha nung student during that semester, yun lang daw po lalabas sa evaluation page of teachers page upon logging in. yung wala na pong kailangan i-enter na information through typing or drop down menu box. ire-retrieve po ang mga data automatically. like yung name nung prof, subjects na tinuturo, date, semester

(evaluation form for students prototype)

kunwari po may 6 subjects po kong enrolled, tas yung isang prof 2 handle nyang subject pagpalagay, bali 5 na evaluation form for specific professor po sa iisang page. depende daw po talaga sa kung anong enrolled nung students na subjects.

• tas may comment box po for students to leave comments about each professors their evaluating

• ano pa po bang kailangan po ng tables bukod sa: students, professors?

• i cant convert the manual evaluation to computerized version properly using PHP as a noob

help po im desperate para matapos ko na po kahit maaga pa lang

• what are the things i still need po to get or to do?

---

kung nakakalito po yung explanation ko at confusing, please do ask
di nyo naman po kailangan magbigay ng exact code kung bawal o against the rules
kahit guidance lang po to guide me making this program

sorry for the long post
salamat sa time TT_TT

 

[jskhulitz]

Question:

May table ka na din ba for the questions? If not, gumawa ka na din. They might need to change the set of survey questions para maging relative sa teaching styles.

tblSurveyQuestions
---------------------
* id - you'll be needing this para ma-gather yung set of questions na ginamit for a specific instructor / professor
* question - actual questions
* qtype - question type (ratings) or essay (comments)
* qstatus - enabled / disabled

tblSurveyAnswers
---------------------
* id - answer id
* q_id - i-relate mo sa survey questions
* prof_id - i-relate mo kay instructor
* answer -
* etc

 

[JackFrost10]

Hi, paki bullet points po ung features na may problem kau, d ko kasi masyado ma intindihan, salamat

 

[lawdog]

Pahingi po TS after ng defense nyo

 

[jskhulitz]

Pahingi po TS after ng defense nyo

sarap buhay ni boy abanger o

 

[JackFrost10]

Pahingi po TS after ng defense nyo

haha, wag po sana leecher XD.

 

[moniker]

Question:

May table ka na din ba for the questions? If not, gumawa ka na din. They might need to change the set of survey questions para maging relative sa teaching styles.

di po ko gumawa since di naman po sila nagbabago nung format ng evaluation form pero osige po ill add table for survey questions. salamat po sa tables!

Hi, paki bullet points po ung features na may problem kau, d ko kasi masyado ma intindihan, salamat

added bullet points at naka-bold na po yung mga kailangan ko pong malaman. salamat din po sa time!


ill come regularly dito sa thread ko at baka iclose haha

 

[sibal_alvin]

suggestion TS. ayaw mo ba MS-SQL. mas madali kasi i-manage physical database.

 

[jskhulitz]

@moniker

Magbago man sila or hindi ng survery questions, kailangan mo gumawa ng table for your questions. Kakailanganin mo yun kapag nagre-relate na ng answers and ratings lalo na pagdating sa report generation ng scores per instructor, average among instructors, etc.

 

[lawdog]

DI PO AKO LEECHER, penge po TS ha

 

[JackFrost10]

Tingin ko po mostly sa database structure ung problema, kilangan mo ng table relationship para maka kuha ka ng data sa isang table gamit ang data sa kabilang table.

try mo read to --> http://www.databaseprimer.com/pages/table-relationships/
suggestion ko umpisa ka sa one-to-many relationship,

kilangan mo ata is:

Student Table
Questions Table
Survey Results Table
Prof Table


as per sa average, pwd mo eh calculate sa javascript, kng mas comportable ka sa PHP pwd dn,

for PHP sample:

$init_ave_1 = $cell_1_5 + $cell_1_4 + $cell_1_3 + $cell_1_2 + $cell_1_1 / $number_of_students;

$ave = $init_ave_1 + $init_ave_2 + $init_ave_3 / 3;

suggestion ko sa php ka solve para mas madali mag insert at select sa database.

 

[s p e c t e r]

Tables/Model:
User *Create users table to prevent duplication of fields
--id
--firstname
--lastname
--type (student/professor/admin)

Student
--id
--user_id
--other fields like sections, year level, etc...

Professor
--id
--user_id
--other fields


Subject
---id
---code
---description

StudentSubject
---id
---student_id
---subject_id

ProfessorSubject
---id
---student_id
---subject_id

Criteria
---id
---text

Evaluation
---id
---student_id
---professor_id

EvaluationData
---id
---evaluation_id
---criteria_id
---rating

Comments *Create separate comments table to prevent null data/ if comments are optional
---id
---evaluation_id
---text

View attachment 283633

Suggestion: Use a php framework with good object role modelling library.

 

[moniker]

UPDATE! nagtanong po ako ulit sa prof about the system,

• they clarified to me na dapat daw po based po sa COURSE at MAJOR SUBJECTS ng student yung mga prof na kailangan nilang i-evaluate

example is kung BSCS po COURSE ng student,

• then yung pang BSCS MAJOR like IT subjects na nakaenroll lang po i-evaluate na mga prof
• di na po kasama MINOR SUBJECTS na meron na kinukuha

malalaking tulong po yung mga tables niyo but baka magulo structure ng tables from this update? ;_; ewan ko lang po basta for now im still following through yung mga suggestions nyo sa paggawa ng tables. ill update again for progression

---

BIG THANKS:
@jskhulitz
@JackFrost10
@s p e c t e r

 

[s p e c t e r]

UPDATE! nagtanong po ako ulit sa prof about the system,

• they clarified to me na dapat daw po based po sa COURSE at MAJOR SUBJECTS ng student yung mga prof na kailangan nilang i-evaluate

example is kung BSCS po COURSE ng student,

• then yung pang BSCS MAJOR like IT subjects na nakaenroll lang po i-evaluate na mga prof
• di na po kasama MINOR SUBJECTS na meron na kinukuha

malalaking tulong po yung mga tables niyo but baka magulo structure ng tables from this update? ;_; ewan ko lang po basta for now im still following through yung mga suggestions nyo sa paggawa ng tables. ill update again for progression

---

BIG THANKS:
@jskhulitz
@JackFrost10
@s p e c t e r

TS lagyan mo na lang ng additional fields yung sa students/prof gaya ng course. dun naman sa subjects table dagdagan mo ng column kung major/minor siya.
Tanong ko lang ts panu ba iinput kung anung subject yung enrolled nung students? Pwede rin kasi kung naka CSV yung list ng students at subjects tapos upload then parse na lang siya sa server then save to database. Maraming foreign keys/ relationship kaya mas maganda kung gagamit ka ng framework. Yung laravel subok na subok ko na sa paghandle ng ganyang relationships. 2-3 days matatapos mo yan sa laravel

 

[jskhulitz]

medyo makakagulo nga yung additional requirements ng instructor mo pero siyempre mas magiging organized ang survery forms mo dahil restricted ang forms na pwedeng ma-fill ni student dahil sa mga assigned / enrolled subjects nya. medyo magiging matrabaho nga lang talaga yan dahil madami nga relationships dahil ang isang course / subject, hindi lang din naman isang instructor ang humahawak. at hindi lang din naman isang course / subject ang hawak ng bawat instructor... haha... masaya yan

 

[moniker]

TS lagyan mo na lang ng additional fields yung sa students/prof gaya ng course. dun naman sa subjects table dagdagan mo ng column kung major/minor siya.
Tanong ko lang ts panu ba iinput kung anung subject yung enrolled nung students? Pwede rin kasi kung naka CSV yung list ng students at subjects tapos upload then parse na lang siya sa server then save to database. Maraming foreign keys/ relationship kaya mas maganda kung gagamit ka ng framework. Yung laravel subok na subok ko na sa paghandle ng ganyang relationships. 2-3 days matatapos mo yan sa laravel

yung nasa isip ko kase sa paga-add ng subjects para sa students ay separated by comma in one textbox. since naalala ko how substring work sa vb.net (i think), di ko alam pa kung pano sa php yun gagawin.

dun po sa csv, im not really familiar lalo na sa laravel. although i checked them out, para ata lalo akong nalilito lol considering im still learning basic php coding. basta subjects enrolled ng students will act as a key kung sino sinong prof ang kanyang i-evaluate talaga.

• UPDATE! 2 tsaka po yung SEMESTER will also play a big role para po ma-categorize yung mga results of evaluated prof
  • since twice in a year po ginagawa ang faculty evaluation before/after finals, hence 1st semester and 2nd semester of specific year
  • kunwari po, i developed this system this year and pede po sya magamit this year of 2016: 1st semester, 2nd semester; 2017: 1st semester and so on
  • basta po ma-categorize at maviview results divided into two semester yearly ni sa home page ni admin

will i need more fields o tables para sa semester?

salamat ulit sa mga time!

(added more screenshots)

 

[jaks]

gawa ka muna ng drawing mo ng screen designs mo ts
para mas madali mo mavisualize and ma analyse kung need mo pang mag dagdag ng table/s and fields
as much as possible wag masyadong magrely sa mga frameworks etc.. kung kaya ng base code dun mo gawin
e.g. jquery, kasi ang goal mo is maging js developer hinde jquery developer.

since naalala ko how substring work sa vb.net (i think), di ko alam pa kung pano sa php yun gagawin.

hinde mo siya malalaman hanngat hinde mo siya sisimulan

 

[soapboy]

Pwede mo itong gawing guide TS, from some expert in the field. mas madali kasi kung visually nakikita mo yung relationship ng entities para madaling makita yung problem, scope, possibilities.

based on experience yung database design ang paiba iba so its more easier kung may pang design or generator ng sql yung gagamitin mong framework like yung laravel, django etc., if i were you as much as possible di na ako mag code ng sarili ko implementation kung makakahanap ako ng already tested and stable code of same functionality, most of the time naman its already in the library or available sa open source projects, this will save you time, para sa ibang task. anyways goodluck sa system.