Please enable JavaScript.

Coggle requires JavaScript to display documents.

WSC PORTAL (Modules (Teacher) (Student profile (Particulars, Schooling,…

- - - - Full Backup :red_flag:
      - backup one year based modules tables to excel
    - - one year based modules
        
        attendence
        
        year in title : query from [academic_year] :ok_hand::skin-tone-6:
        
        date selector : query from [school days] :ok_hand::skin-tone-6:
        
        exam
        
        location
        
        invigilator
        
        duration
        
        setter marker
        
        timetable
        
        student profile
        
        student elective
        
        update the year will do the job *need test
        
        student class and c#
        
        update existing student (1-5) record in [student] by importing temp resource table
        refer to (Aug)->(Student Promotion)
        
        add new s1 student record
        
        append schooling data to [student_schooling]
        
        slp
        
        reboot all data every year
        
        discipline
        
        ui year selectors
        
        hard coded need fix
        
        discipline_cst.php
        
        discipline_lat.php
        
        table need reboot every year
        EXPORT BEFORE CLEAR
        
        [discipline_ap_record]
        
        [discipline_case_record]
        
        [discipline_conduct_record]
        
        [discipline_clean_record]
        
        [discipline_lat]
        
        [discipline_cst_total]
        
        table need fully update
        
        [discipline_cst]
        
        clear [#_item*] fields
        
        update [#_year] to current year
        
        update [#_teacher*]
      - multiyear based / non chronologic scoped modules
        
        ECA / School Services
        
        Staff training
        
        clear [tbfu_tch] and import new data
        
        TLC
        
        CLAP
      - Global settings
        
        [academic_year] : academic year date settings
        
        [discipline_cst] : class teacher role assignment
        
        [school_days] : school calendar
        
        [tbfu_tch] : school cycle timetable
      - mandatory data changes every year
        
        student schooling
        
        new students
        
        existing students (class and c#)
        
        calendar and timetable
        
        class teacher
        
        replace
      - add user group :red_flag:
  - - - E.g. Add AAA class teacher of 1A
        
        Table involved
        
        [teacher] : name and password
        
        [discipline_cst] : class teacher record
    - - office staff
      - other staff (eg discipline acc)
        
        long term
        
        temp (student teacher)
    - - staff
        
        teacher_status +'inactive'
      - student (depart)
        
        keep student class and classno empty and student status +'D'
    - - e.g. Add AAA day 1 1st Lesson CP and 2nd lesson 1A M
        
        Table involved
        
        [tbfu_tch]
    - - e.g. Add 1/9/2018 Day 1
        
        Table involved
        
        [school_days] : straight
    - - e.g. ALL 1A students go to 2A
        
        Table involved
        
        [student]
        
        [student_schooling]
        
        method
        
        import new class and c# to [z_student_newcid]
        
        use sql update
        
        better clear the old data first, but not neccessary
        
        may better add an UI for import and update
        or UI for auto/manual class number assignment (like SAMS)
    - - hardcode change traininginsert.php
      - hardcode change training.php?report=1
    - - refer to
        
        [discipline_ap_record]
        
        [discipline_case_record]
        
        [discipline_conduct_record]
        
        [discipline_clean_record]
        
        [discipline_cst_total]
        
        [discipline_lat]
  - - - [student]
      - lack a ui for manually editing of single student record
    - - hardcoded as /student_profile/img/#sid#.jpg
      - privacy concern on the file name
        
        broken link appears if photo not exist
    - - s4
        
        simply new records
      - s5+
        
        update add drop
        
        YEAR CHANGE TO CURRENT
      - GRADUATES
        
        DELETE
  - - - table name same as excel file name
      - W:\Learning_&_Teaching\Academic_Committee\Examination Committee
      - 出世紙
        
        [exam_setter_marker]
      - actual attendance taking MANDATORY
        
        [exam_duration]
        
        [exam_invigilator]
        
        [exam_timetable]
        
        [exam_attendance_adv] : SEN records : require subject, sid, attend status, remarks
        REVISE EVERY YEAR
    - - ych workflow
        
        export report p data as csv
        
        extract STUDENT.csv and SCORE.csv from each form
        
        convert text file codec to UTF-8 in notepad++ or something works
        
        generate TLC data csv by a DIY small script
        
        import to database directly
      - pcw workflow
    - - ?
    - - WYY