Skip to content

C# & SQL feedback system extended with gamification ๐Ÿ‘พ ๐Ÿ“„

License

Notifications You must be signed in to change notification settings

nahnova/Verbosify

ย 
ย 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

78 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Verbosify: Student Feedback and Goal Management System extended with gamefication

License: MIT C#

Verbosify is an open-source WinForms application built with .NET, designed to help teachers and students communicate effectively by managing feedback and tracking goals. Teachers can leave feedback for students, while students can register goals and subgoals to improve their learning experience extended with gamefication elements.

Explanation Video / Pitch of System(CLICKME)

Table of Contents

Features

  • Teachers can leave feedback for students.
  • Students can register goals and subgoals.
  • Students can be motivated by gamification elements, including:
    • Experience Points (XP) earned for completing assignments and providing feedback.
    • Student level system based on XP, allowing students to progress and challenge themselves.
    • Leaderboards displaying student rankings based on their level.
    • Visual badges to recognize students' achievements and contributions.
    • Titles that students can earn and use for specific visualizations.
  • Intuitive and user-friendly interface.
  • Secure data storage and handling.
  • Easily customizable and extensible.

Deprecated N-Tier Architecture

โš ๏ธ Deprecated: The initial design of Verbosify involved an N-Tier Architecture. However, during the development process, it was determined that the N-Tier Architecture made the modeling of the software using UML more challenging. As a result, the architecture was deprecated, and the system has been implemented using a different approach.

The project is built using the N-Tier architecture, which allows for a scalable, maintainable, and modular application. The architecture is divided into the following layers:

  1. FBS.Entity: Contains the entities: Feedback, Goal, Group, Student, Subgoal, and Teacher.
  2. FBS.Repository: Includes all SQL statements that interact with the SQL Server.
  3. FBS.DataAccess: Data access layer containing the connection string for the database.
  4. Frontend: Contains the WinForms forms for the user interface.
  5. FBS.Testing: Contains a console app to test the SQL connection.

Monolith Architecture

๐Ÿšง Transitioned to Monolith Architecture: Based on valuable feedback received, the project has transitioned to a Monolith Architecture. However, some aspects of layering have been retained to maintain a logical separation of responsibilities.

In the updated architecture, the frontend of the application utilizes WinForms, where all designs and methods are implemented using classes. The classes contain lists and objects that are populated by methods referencing the data access layer. For example, the Student class includes a StudentDal (StudentDataAccessLayer), which is responsible for executing SQL queries and interacting with the database. This design choice aligns more closely with the UML diagrams, as suggested by Miel Noelanders.

By adopting the Monolith Architecture with a partial layering approach, the application still benefits from a modular structure while ensuring simplicity and easier alignment with the UML diagrams.

Installation:

  1. Clone or download the project to your local machine.
  2. Open the solution file in Visual Studio.
  3. Restore the database using the provided bak file located in the project root directory. This can be done by opening SQL Server Management Studio, right-clicking on the Databases folder and selecting "Restore Database", then selecting the .bak file and following the prompts to restore the database.
  4. Update the ConnectionString inside FBS.DataAccess with the appropriate server name and database name. This can be done by opening the FBS.DataAccess project in Visual Studio, opening the /FeedBuf/FeedbackCollection/DataAccess.cs file, and updating the connectionString property with the appropriate server name and database name.
  5. Install the SQL Server NuGet package by right-clicking on the solution in Visual Studio and selecting "Manage NuGet Packages...", then searching for and installing the System.Data.SqlClient package.
  6. Build the solution in Visual Studio.

Usage:

  1. Restore the database using the provided bak file located in the project root directory. This can be done by opening SQL Server Management Studio, right-clicking on the Databases folder and selecting "Restore Database", then selecting the .bak file and following the prompts to restore the database.

  2. Update the ConnectionString inside FBS.DataAccess with the appropriate server name and database name. This can be done by opening the FBS.DataAccess project in Visual Studio, opening the /FeedBuf/FeedbackCollection/DataAccess.cs file, and updating the connectionString property with the appropriate server name and database name.

  3. Install the SQL Server NuGet package by right-clicking on the solution in Visual Studio and selecting "Manage NuGet Packages...", then searching for and installing the System.Data.SqlClient package.

  4. Run the Windows Forms application called FeedBuf by opening the Frontend project in Visual Studio, setting the startup project to FeedbackBuf, and running the application. Once the application is running, you can log in as a teacher or a student and begin using the application to manage feedback and goals.

Contributing

In order to maintain a clean and well-organized codebase for the Verbosity project, we require all contributors to follow these commit guidelines. This will help ensure a smooth development process and easy collaboration among team members.

Branching

  1. Always create a new branch from the staging branch.
  2. The branch name should be the name of the linear ticket you are working on, e.g., LIN-123.

Committing

  1. Commit messages should be clear, concise, and written in the imperative form, e.g., "Add new feature", not "Adding new feature" or "Added new feature".
  2. Use the linear ticket name as a prefix in your commit messages, e.g., LIN-123: Add new feature.

Pull Requests

  1. When your work on the branch is complete and tested, create a pull request (PR) targeting the staging branch.
  2. PRs should have a descriptive title and a detailed description of the changes made.

Review and Merge Process

  1. For changes to be merged into staging, at least one team member must review and approve the PR.
  2. For changes to be merged into main, at least two team members must review and approve the PR.
  3. The staging and main branches are protected. Only approved PRs can be merged into these branches.
  4. After the required number of approvals is reached, the PR author is responsible for merging the PR.
  5. Once the PR is merged, remember to delete the feature branch.

License

This project is licensed under the MIT License - see the LICENSE file for details.

About

C# & SQL feedback system extended with gamification ๐Ÿ‘พ ๐Ÿ“„

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C# 100.0%