Placement Cell Application is a full-stack web app which allows employees to manage student details, course scores and interview results. Employees can schedule interviews, mark results and export data to CSV for reporting.
Link: https://janardhanej1906-placement-cell.onrender.com/users/signin
- Sign-up/Register: Create an account using your name, email and password.
- Sign-in/Log In: Securely log into your account using your email and password.
- Sign Out/Log Out: Log out of your session.
- List of Students + Add New Student – Employees can view a list of students and add new students with details like name, college, batch and scores.
- List of Interviews + Schedule Interview (Allocate Student to Interview) – Employees can view a list of interviews and schedule new interviews with a company name and date. Employees can allocate students to specific interviews.
- Mark Interview Result – From the interview page, employees can mark the result status for each student (SELECTED, NOT SELECTED, ON HOLD, PENDING).
- Download CSV – Employees can export all student and interview data into a CSV file.
Before running the application locally, create a .env file under the config directory of your project and configure the following environment variables:
- PORT: Port number the application will listen on.
- MONGODB_URI: MongoDB database connection URL String.
Ensure all values are correctly set before starting the application.
Example .env file:
PORT=3000
MONGODB_URI=mongodb://localhost:27017/authdatabase
The project leverages the following Node.js dependencies and technologies:
- Express.js
- MongoDB or mongoose
- Passport.js
- bcrypt
- express-session
- express-ejs-layouts
- dotenv
- fastcsv
Follow these steps to run the project locally:
- Clone the repository: git clone https://github.com/JanardhanEJ/janardhanej1906-placement-cell.git
- Navigate into the project directory: cd janardhanej1906-placement-cell
- Install dependencies: npm install
- Start the project by below command: node index.js
- Open your web browser and visit http://localhost:3000 to access the application.
- Open your web browser and go to http://localhost:3000/user/signin
You will see a login page like this:
a) If you don’t have an account, click on the Register link.
Fill in all the required details and click on the Register button.
eg: 
b) Few common errors while Signing Up:
c) Sample database entry:
Use the same email and password used during registration and click on the Sign In button.
Example: 
a) If the entered details match, you will be redirected to the homepage:
After a successful login, you can Log out by clicking on the Log Out button.
After signing out, you will be redirected to login page like this:
Click on the Add Student button from home page. Fill in all the required student details, then click on the Create Student button.
After adding the student details, the Home page will display a list of all student details like this:
Sample database entry:
Click on the Allocate Interview button from the Company List page (navigation bar). Fill in all the required details, such as the company name, date, and allocate the student to the specific interview schedule.
After adding details, company's details are stored in Database
After adding the interview details, the Company List page will display a list of all student's interview details like this:
Employees can mark the interview result of a particular student with options like Selected, Not Selected, On Hold, and Pending (default option). After selecting the result, they need to click on Update to save it to the database.
Employees can export all student and interview data into a CSV file by clicking the Download Report link from the navigation bar. The CSV file will be generated and downloaded to your local system, allowing you to view, browse, and analyze the details.
You can delete student details by clicking the Delete button in the Action row on the Home page where all student details are listed.
The image below shows the updated list after deleting the details of Naveen Student
