Guru Nanak Dev Engineering College, Ludhiana

Technical Activity Committee

Ref.No.GNDEC/TAC/2019-20/20                                                           September 23,2019

Hackathon’19

Oct 04 - 05, 2019

at Guru Nanak Dev Engineering College, Ludhiana

Rules for participants

============ Registeration Link ============

  1. A team of four members is permitted. All members must be bonafide students of Guru Nanak Dev Engineering College (GNDEC) Ludhiana or mentee Institute Atal Bihari Vajpayee Government Institute of Engineering & Technology (ABVGIET) Shimla. The mentor (one, on-site) could be a bonafide student or a faculty member of the participating college.
  2. Each team is allowed one  mentor over and above the participating member. Mentor may be offsite.
  3. The event shall be a 36 hour non-stop event. Participants (excluding mentors) shall not be allowed to move out of the premises where the event is being conducted.
  4. All arrangements for refreshments / lunch / dinner etc shall be made inside the venue. However, incase some students desire something extra, it can be ordered from the 24 hours open cafeteria operational near the premises of competition.
  5. Students are encouraged to bring their own laptops. However, systems will also be available in the laboratory.
  6. Use of mobile phones is not allowed during competition.
  7. Internet Access will be provided
  8. Certificates of participants / winners shall be delivered digitally.
  9. All participating teams have to decide one name for their team.
  10. Participants are to pick their choice of problem and indicate the same to organizers not later than 28th September, 2019 along with the team registrations.
  11. There is no registration fee for this event.
  12. The participants need to use free and open source platforms for providing solutions.
  13. The winners shall be adjudged by following criteria:
  1. Novelty and feasibility of solution / Contribution during Hackathon and its potential.
  2. Technical process used to arrive at the solution.
  3. Time taken to complete the task.
  1. Decision of the jury shall be final and binding. No claims shall be entertained.
  2. The problem statements shall be uploaded by 24.9.2019. The problem statements are suggestive. In case any team wants, it can suggest its own problem for solution. This needs to be conveyed to organizes not later than 28.9.2019 5.00 PM.
  3. Students may attempt the problem in full or may take up part of the problem. In case a group finishes its task of a small problem, they can choose other problem also.
  4. All teams need to report their progress every hour to the organizers.
  5. Cash prizes by means of crossed account payee cheque / RTGS in bank account of winning teams:

1st Prize        Rs.15,000/-

2nd Prize        Rs.10,000/-

3rd Prize        Rs.7,500/-

 

 

Convenor

Hackathon’19

 

Guru Nanak Dev Engineering College, Ludhiana

Technical Activity Committee

Ref.No.GNDEC/TAC/2019-20/20                                                             September 23,2019

Hackathon’19

Problem Statements

 

You need to use existing FOSS to provide solution. Any new solution from scratch (not based on existing FOSS) should need a justification. All work will have Open Source License (to be decided by Organisers) and all the code needed to be on some public version control system. Every  team needs to post their progress every hour.

Problem might be big and small. Your total achievement / contribution will be considered. If you are able to solve a small problem, you may take a second one. If you are working on a big project, then you may not able to achieve goal, but achievement of your milestones will be considered. So, better define your small goals, from a big project.
        Background material is only suggestive, you may search for better or similar FOSS alternatives. Before use of any such software, teams need to ensure that
license of that software meets the requirements of Hackathon’19

All demonstration shall be on Ubuntu 18.04.3 LTS (Bionic Beaver).

 

Our priority for solution:

  1. As an App for SandStorm: https://github.com/sandstorm-io/sandstorm
  2. PWA: https://en.wikipedia.org/wiki/Progressive_web_applications 

 Suggested Problem Statements

  1. Updating Apps for SandStorm

Background information:


https://sandstorm.io/
https://github.com/sandstorm-io/sandstorm 

  1. Document Management System

Demonstrating implementation of Document Management System for an Engineering College

Background information:

https://sourceforge.net/projects/seeddms/
https://github.com/openkm

  1. Digital Signature

Demonstrate working of private (not involving CA) "Digital Signature" system (for internal use) in an Institute / University / Corporate, just like what is Intranet to Internet, Intercom to BSNL. Some background material:

            http://computer.howstuffworks.com/digital-signature.htm 
https://security.stackexchange.com/questions/97620/run-our-own-certificate-authority-for-internal-use-only-safe-or-not 
https://security.stackexchange.com/questions/94465/is-it-complicated-to-deploy-my-own-ca 
https://www.esecurityplanet.com/network-security/how-to-run-your-own-certificate-authority.html 
https://www.esignlive.com/blog/3-steps-to-e-signature-deployment 
https://www.globenewswire.com/news-release/2019/01/15/1691702/0/en/SignNow-releases-private-cloud-e-signature-solution-2-0-for-government-organizations-heavily-regulated-industries-and-the-public-sector.html 
https://yourstory.com/mystory/555b93da0e-here-s-why-you-need-di

  1. Seating plan:

           Background material:

            https://github.com/GreatDevelopers/bakaplan/network
https://www.behance.net/gallery/14575039/BaKa-Plan 

  1.  Students’ Information Management:

Should be generic, deployable for any school, college, university; but needed to be demonstrated for an Engineering College.

Background material:

https://projectfedena.org/
https://blog.capterra.com/the-top-6-free-school-administration-software/


 

  1. Employee’s Information Management

Should be generic, deployable for any school, college, university, corporate; but needed to be demonstrated for an Engineering College for teaching / non-teaching / administrative staff. Make note that student may become teacher or any other employee.

https://blog.capterra.com/free-hr-software/ 
https://www.softwaresuggest.com/blog/top-free-open-source-hrm-software/

  1. Conference Management System

https://github.com/ISCPIF/myreview

https://feeding.cloud.geek.nz/posts/list-of-open-source-conference/

  1. Export import for Questionnaire (Moodle addon)


https://github.com/PoetOS/moodle-mod_questionnaire 

  1. Question paper OTA: Question paper Over to Air

A server of University should able to display Question paper on the authorised / register device (Mobile / Laptop / Desktop) in a secure manner for the scheduled period of examination.

  1. Scan Answer sheet

Students should be able to scan their answer sheet, and then upload scanned copy to University server in a secure manner.

  1. Computer Based Examination

Making a system where student may attempt papers on computer rather than on paper based answer sheets and drawing sheets.

  1. Leave Management System

Background Material:

https://github.com/bbalet/jorani 

  1. Exam Browse


Demonstrating Safe Exam Browser (solution for major platforms like Linux, MS Windows, Mac OS, for desktop as well as for Mobile) suitable for conduct of examinations.

Background Material:

https://sourceforge.net/p/seb/discussion/844843/thread/51518a70/
https://affanindo.github.io/seb-and-linux
https://www.safeexambrowser.org/vdi/

  1. Question Bank with attributes


Adding feature to Moodle’s question bank to have question with attributes like Difficulty Level, classification as per Bloom’s Taxonomy and Time duration required to attempt the question.

Some more problems:

  1. Propose solution to regulate parking of vehicles in GNDEC parking. The solution should include regulated entry, parking in marked area.
  2. Prepare a based solution for Training and Placement department. This should enable a prospective employer to find out the list of eligible candidates, the details of the candidates branch wise with their academic and curricular activity record.
  3. Prepare a solution for student section which should allow the concerned authority to have at click of button all records including name, parents name, phone nos., emails, addresses, academic records, curricular records, photograph.
  4. Prepare a solution to allow an activity incharge to register, mark attendance, see student involvement level (participant/organizer/winner) in an event and generate an non temperable e- certificate.
  5. Propose a solution to manage faculty related data including their qualifications, photograph, activity related to academics like subjects taught, their research interests, publication & project details.

STUDENTS ARE FREE TO PICK ANY PROBLEM OR A GROUP OF PROBLEMS OF THEIR CHOICE. THE LIST IS SUGGESTIVE ONLY AND MAY BE UPDATED TIME TO TIME. ALSO THE PARTICIPANTS ARE ENCOURAGED TO FIND OUT THE OPEN SOURCE SOLUTIONS FOR THE ANY OF THESE PROBLEMS IF THEY EXIST AND DEMONSTRATE THEIR PRACTICABILITY TO THE GIVEN SITUATION.


Schema for student information

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- --------------------------------------------------------

--

-- Table structure for table `branch_code`

--

CREATE TABLE `branch_code` (

  `branch_code_id` int(11) NOT NULL,

  `course_code` int(11) NOT NULL,

  `aicte_approved_status` enum('Yes','No') NOT NULL DEFAULT 'Yes',

  `branch_name` varchar(50) NOT NULL,

  `branch_code` int(11) NOT NULL,

  `department_code` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `branch_code`

--

INSERT INTO `branch_code` (`branch_code_id`, `course_code`, `aicte_approved_status`, `branch_name`, `branch_code`, `users_id`, `department_code`) VALUES

(1, 1, 'Yes', 'Civil Engineering', 14,  14),

(2, 1, 'Yes', 'Computer Science and Engineering', 15,  15),

(7, 1, 'Yes', 'Production Engineering', 31,  31),

(8, 3, 'Yes', 'Masters in Business Administration', 28,  28),

(9, 4, 'Yes', 'Masters in Computer Application', 29,  29),

(10, 2, 'Yes', 'Computer Science and Engineering', 50,  15),

(11, 2, 'Yes', 'Electronics and Communication Engineering', 35,  17),

(12, 2, 'Yes', 'Electrical Engineering', 34,  16),

(13, 2, 'Yes', 'Environmental Science Engineering', 36,  14),

(14, 2, 'Yes', 'Industrial Engineering', 37,  30),

-- --------------------------------------------------------

--

-- Table structure for table `course_code`

--

CREATE TABLE `course_code` (

  `course_code_id` int(11) NOT NULL,

  `course_name` varchar(50) NOT NULL,

  `course_code` int(11) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `course_code`

--

INSERT INTO `course_code` (`course_code_id`, `course_name`, `course_code`) VALUES

(1, 'B.Tech.', 1),

(2, 'M.Tech.', 2),

(3, 'MBA', 3),

(4, 'MCA', 4);

-- --------------------------------------------------------

--

-- Table structure for table `student_info`

--

CREATE TABLE `student_info` (

  `student_info_id` int(11) NOT NULL,

  `course_code` int(11) NOT NULL,

  `branch_code` int(11) NOT NULL,

  `shift` varchar(6) DEFAULT NULL,

  `semester` int(1) DEFAULT NULL,

  `admission_year` int(4) DEFAULT NULL,

  `sc_st_category` varchar(20) DEFAULT NULL,

  `gill_quota` varchar(1) DEFAULT NULL,

  `hostel_facility` varchar(20) DEFAULT NULL,

  `college_roll_no` varchar(20) DEFAULT NULL,

  `university_roll_no` varchar(20) DEFAULT NULL,

  `ssection` varchar(20) NOT NULL,

  `sgroup` varchar(20) NOT NULL,

  `leet_non_leet` varchar(8) DEFAULT NULL,

  `fws` varchar(1) DEFAULT NULL,

  `sfname` varchar(50) DEFAULT NULL,

  `smname` varchar(50) DEFAULT NULL,

  `ssname` varchar(50) DEFAULT NULL,

  `ffname` varchar(50) DEFAULT NULL,

  `fmname` varchar(50) DEFAULT NULL,

  `fsname` varchar(50) DEFAULT NULL,

  `mfname` varchar(50) DEFAULT NULL,

  `mmname` varchar(50) DEFAULT NULL,

  `msname` varchar(12) DEFAULT NULL,

  `date_of_birth` date DEFAULT NULL,

  `gender` varchar(6) DEFAULT NULL,

  `blood_group` varchar(9) DEFAULT NULL,

  `martial_status` varchar(10) DEFAULT NULL,

  `nationality` varchar(6) DEFAULT NULL,

  `c_address_type` varchar(7) DEFAULT NULL,

  `c_address_line_1` varchar(500) DEFAULT NULL,

  `c_address_line_2` varchar(500) DEFAULT NULL,

  `c_city_name` varchar(39) DEFAULT NULL,

  `c_vpo` varchar(52) DEFAULT NULL,

  `c_pincode` varchar(7) DEFAULT NULL,

  `c_tehsil` varchar(19) DEFAULT NULL,

  `c_district` varchar(37) DEFAULT NULL,

  `c_state` varchar(17) DEFAULT NULL,

  `p_address_type` varchar(7) DEFAULT NULL,

  `p_address_line_1` varchar(100) DEFAULT NULL,

  `p_address_line_2` varchar(66) DEFAULT NULL,

  `p_city_name` varchar(25) DEFAULT NULL,

  `p_vpo` varchar(52) DEFAULT NULL,

  `p_pincode` varchar(14) DEFAULT NULL,

  `p_tehsil` varchar(19) DEFAULT NULL,

  `p_district` varchar(37) DEFAULT NULL,

  `p_state` varchar(17) DEFAULT NULL,

  `father_mobile_no` bigint(11) DEFAULT NULL,

  `mother_mobile_no` varchar(24) DEFAULT NULL,

  `residence_phone_no` varchar(13) DEFAULT NULL,

  `residence_phone_no_std` varchar(12) DEFAULT NULL,

  `parents_annual_income` varchar(23) DEFAULT NULL,

  `student_mobile_no` varchar(11) DEFAULT NULL,

  `father_email` varchar(50) DEFAULT NULL,

  `mother_email` varchar(50) DEFAULT NULL,

  `student_email` varchar(50) DEFAULT NULL,

  `father_qualification` varchar(56) DEFAULT NULL,

  `father_occupation` varchar(50) DEFAULT NULL,

  `father_office_address` varchar(500) DEFAULT NULL,

  `father_office_phone` varchar(18) DEFAULT NULL,

  `father_office_phone_std` varchar(14) DEFAULT NULL,

  `mother_qualification` varchar(38) DEFAULT NULL,

  `mother_occupation` varchar(50) DEFAULT NULL,

  `mother_office_address` varchar(500) DEFAULT NULL,

  `mother_office_phone` varchar(19) DEFAULT NULL,

  `mother_office_phone_std` varchar(14) DEFAULT NULL,

  `student_status` enum('Onroll','Ex') NOT NULL,

  `religion` varchar(9) DEFAULT NULL,

  `student_category` varchar(20) DEFAULT NULL,

  `aicte_rc` varchar(10) NOT NULL,

  `full_part_time` varchar(10) NOT NULL,

  `remarks` text NOT NULL,

  `fee_paid_status` enum('N','Y') NOT NULL,

  `eligibility` enum('Y','N','L') NOT NULL,

  `batch` int(4) NOT NULL,

  `advisor_id` varchar(25) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- Dumping data for table `student_info`

--

INSERT INTO `student_info` (`student_info_id`,  `course_code`,  `branch_code`, `shift`, `semester`, `admission_year`, `sc_st_category`, `gill_quota`, `hostel_facility`, `college_roll_no`, `university_roll_no`, `ssection`, `sgroup`, `leet_non_leet`, `fws`, `sfname`, `smname`, `ssname`, `ffname`, `fmname`, `fsname`, `mfname`, `mmname`, `msname`, `date_of_birth`, `gender`, `blood_group`, `martial_status`, `nationality`, `c_address_type`, `c_address_line_1`, `c_address_line_2`, `c_city_name`, `c_vpo`, `c_pincode`, `c_tehsil`, `c_district`, `c_state`, `p_address_type`, `p_address_line_1`, `p_address_line_2`, `p_city_name`, `p_vpo`, `p_pincode`, `p_tehsil`, `p_district`, `p_state`, `father_mobile_no`, `mother_mobile_no`, `residence_phone_no`, `residence_phone_no_std`, `parents_annual_income`, `student_mobile_no`, `father_email`, `mother_email`, `student_email`, `father_qualification`, `father_occupation`, `father_office_address`, `father_office_phone`, `father_office_phone_std`, `mother_qualification`, `mother_occupation`, `mother_office_address`, `mother_office_phone`, `mother_office_phone_std`, `student_status`, `religion`, `student_category`, `aicte_rc`, `full_part_time`, remarks,`fee_paid_status`, `eligibility`,  `batch`, `advisor_id`) VALUES

(11767,  1,  15, 'Second', 5, 2019, '', '', 'Day Scholar',  '1715397', '1736295', 'E', 'E3', 'N', 'N', 'Gursajan ', 'Singh', 'Aulakh', 'Varinderjeet', 'Singh', 'Aulakh', 'Harpreet ', 'Kaur', 'Aulakh', '1998-12-17', 'Male', 'O+', 'Married', NULL, 'Village', '528/2', 'PAKHOWAL ROAD', '', 'SUNET', '141012', 'LUDHIANA', 'LUDHIANA', 'PUNJAB', 'Village', '528/2', 'PAKHOWAL ROAD', '', 'SUNET', '141012', 'LUDHIANA', 'LUDHIANA', 'PUNJAB', 9988900361, '9914755535', '', '', '500000', '9780100414', '', '', 'gursajanaulakh@gmail.com', 'B.A. II', 'Aggriculture', '', '', '', '', 'House wife', '', '', '',  'Onroll', 'Sikh', 'General',  'AICTE', 'Full Time','','Y', 'Y', 2017,  'goldendeepkaur')

--

-- Indexes for dumped tables

--

--

-- Indexes for table `branch_code`

--

ALTER TABLE `branch_code`

  ADD PRIMARY KEY (`branch_code_id`,`branch_code`);

--

-- Indexes for table `course_code`

--

ALTER TABLE `course_code`

  ADD PRIMARY KEY (`course_code_id`,`course_code`);

--

-- Indexes for table `student_info`

--

ALTER TABLE `student_info`

  ADD PRIMARY KEY (`student_info_id`),

  ADD UNIQUE KEY `college_roll_no` (`college_roll_no`),

  ADD UNIQUE KEY `university_roll_no` (`university_roll_no`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `branch_code`

--

ALTER TABLE `branch_code`

  MODIFY `branch_code_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--

-- AUTO_INCREMENT for table `course_code`

--

ALTER TABLE `course_code`

  MODIFY `course_code_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--

-- AUTO_INCREMENT for table `student_info`

--

ALTER TABLE `student_info`

  MODIFY `student_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12902;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


Schema for Employee Information:

CREATE TABLE `users` (

  `id` int(11) NOT NULL,

  `username` varchar(20) DEFAULT NULL,

  `course` varchar(25) DEFAULT NULL,

  `branch_code` int(11) NOT NULL,

  `designation` varchar(100) NOT NULL,

  `email` varchar(50) DEFAULT NULL,

  `prefix` enum('Er.','Dr.','Mr.','Ms.','Ar.') NOT NULL,

  `name` varchar(50) NOT NULL,

  `usertype` varchar(50) NOT NULL,

  `mobile` bigint(20) DEFAULT NULL,

        `appointment_type` enum('','Regular','Contract') NOT NULL,

        `employee_id` int(11) NOT NULL,

 

) ENGINE=MyISAM DEFAULT CHARSET=utf8;