Project Ideation

[nitinsandiego]

Topic

The purpose of this project is to help Mr. Mortensen manage his CSSE, CSP, and CSA classes more easily. It will help him keep track of student information, organize group assignments, and monitor progress in different courses. This will save time, allowing Mr. Mortensen to focus more on teaching and less on keeping track of progress of each team.

Frontend UI design

Data

Field Name	Data Type	Description
id	Long	Unique identifier for each student.
name	String	Full name of the student.
username	String	Unique username for the student.
tableNumber	int	Assigned table number in the classroom.
course	String	The course the student is enrolled in (e.g., CSSE, CSP, CSA).
tasks	ArrayList<String>	List of tasks or assignments assigned to the student.
trimester	int	Trimester during which the student is enrolled.
period	int	Class period for the student.

Coding Work

This is my code creating the Student Class and initializing some starter data into the SQL Database

@Data  // Annotations to simplify writing code (ie constructors, setters)
@NoArgsConstructor
@AllArgsConstructor
@Entity // Annotation to simplify creating an entity, which is a lightweight persistence domain object. Typically, an entity represents a table in a relational database, and each entity instance corresponds to a row in that table.
@Table(name = "students" , uniqueConstraints = @UniqueConstraint(columnNames = "name"))
public class Student {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    private String name;
    private String username;
    private int tableNumber;
    private String course;
    private ArrayList<String> tasks;
    private int trimester;
    private int period;

    public Student(String name, String username, int tableNumber, String course, ArrayList<String> tasks, int trimester, int period) {
        this.name = name;
        this.username = username;
        this.tableNumber = tableNumber;
        this.course = course;
        this.tasks = tasks;
        this.trimester = trimester;
        this.period = period;
    }

    @Service
    public static class StudentService {

        @Autowired
        private StudentJPARepository studentJPARepository;

        @PostConstruct
        public void initializeData() { 
            if (studentJPARepository == null) {
                throw new RuntimeException("studentJPARepository is not initialized!");
            }
            List<Student> students = new ArrayList<>();
            students.add(new Student("Akhil Singamneni", "Akhil353", 4, "CSA", new ArrayList<String>(Arrays.asList("Task 1", "Task 2")), 1, 3));
            students.add(new Student("Srinivas Nampalli", "srininampalli", 4, "CSA", new ArrayList<String>(Arrays.asList("Task 1", "Task 2")), 1, 3));
            students.add(new Student("Aditya Samavedam", "adityasamavedam", 4, "CSA", new ArrayList<String>(Arrays.asList("Task 1", "Task 2")), 1, 3));
            students.add(new Student("Nitin Balaji", "nitinsandiego", 4, "CSA", new ArrayList<String>(Arrays.asList("Task 1", "Task 2")), 1, 3));

            for (Student student : students) {
            Optional<Student> existingStudent = studentJPARepository.findByUsername(student.getUsername());

            if (existingStudent.isEmpty()) {
                studentJPARepository.save(student);
            }
        }
        }

        public Iterable<Student> findAll() {
            return studentJPARepository.findAll();
        }
    }

}

This code handles the API paths. We have set a tester API path that returns all the student details in a JSON.

package com.nighthawk.spring_portfolio.mvc.student;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("/api/students")
public class StudentApiController {

    @Autowired
    private Student.StudentService studentService;

    @GetMapping("/all")
    public ResponseEntity<Iterable<Student>> getAllFlights() {
        return ResponseEntity.ok(studentService.findAll());
    }

}

Evidence of Research

Our project was inspired by the organizational tools found in platforms like Monday.com, which is a popular work management software used for team collaboration. Monday.com allows users to create detailed boards for tracking tasks, projects, and workflows. It provides a visual way to assign tasks, monitor progress, and collaborate within teams, making it a versatile tool for organizing work in an efficient manner.

Seeing the functionality of Monday.com, we decided to apply a similar concept to classroom management. The idea is to provide Mr. Mortensen with a tool to manage his CSSE, CSP, and CSA classes more effectively, similar to how Monday.com enables team management. By tracking students, assignments, and progress in one place, our project mirrors Monday.com’s ability to handle task assignments and group organization, but it tailors these features specifically for the educational context.

[DavidL0914]

0.93: The idea and topic is very beneficial and seems will be very helpful to Mr. M. The visual designs of the frontend of your project seems detailed and visually appealing - I would suggest changing the theme to match the Nighthawks pages theme though because the end goal is for Mr. M to pull your project onto his site. You have good description on the data you will capture and even have already initialized a database with strong code showing you guys have already started working on your project. There is evidence of research put into the project.

[JoshThinh]

.91 They had a detailed project description with visuals of what the front end would look like. It also included backend Java code for the database with a working API. Also included reference sites like Monday.com where they were able to gain inspiration for their website design and functionality. Something that you can change is to match the style of the website to something more similar to Mr. M theme so that the style is consistent within Mr. M repo. Overall I think the overall website will be very useful to Mr. M to pull it onto his own repo.

[Th35py27]

0.92/1

Code that works perfectly. I like how you already have an sqlite database setup with useful information for Mr.Mortensen such as the name, and who is in each group.

1. Helps the teacher perfectly with organizing groups across multiple classes.
2. Shows a visual in the frontend showing how they would format the UI.
3. Showed the data captured through whatever is in the database. Incorporated a use of different variable types.
4. Showed backend code which initializes data inside of the sqlite database.
5. Used Monday.com which helped with their overall project research and used it for inspiration.