جاوا - 114533

---

شرح پروژه

سلام

این دو تا assignment هست

زیاد سخت نیست

اگه امکانش هست توی چند جلسه با هم انجامش بدیم

حتما لازم دارم با کسی انجام بدم

ترم قبل کلا غایب بودم

۲ هفته

زبان جاوا

توضیح کامل به زبان انگلیسی هست

من لازم دارم که کسی کمک کنه با هم انجام بدیم

روی هم احتمالا ۲۰. ساعت زمان لازمه

.......

اگه مشکلی در ترجمه هست بگید

بیشتر مشکل من دیتا بیس هستش

و چجوری خوب oop رو استفاده کنم

What is the assignment?

You need to build a Java command-line application that connects to an SQLite database. The program should retrieve student assessment data, calculate grades, and display the results.

The assignment is designed to test your ability to use:

• Java
• Object-Oriented Programming (OOP)
• SQLite database
• SQL queries
• Command-line input and output

What your program must do

Your application has three main features.

1. Display an assessment mark

The user enters:
• Student ID
• Module ID
• Assessment ID

Your program looks up the database and displays the student's mark for that assessment.

Example:

Student ID: 1001
Module: COMP40053
Assessment: Exam

Result:
85/100 (85%)

2. Calculate the final module grade

The user enters:
• Student ID
• Module ID

Your program:
• Retrieves every assessment for that module.
• Applies each assessment's weighting (for example, Exam 60%, Report 20%, Presentation 20%).
• Calculates the student's overall module mark.

Example:

Presentation: 80 (20%)
Report: 70 (20%)
Exam: 90 (60%)

Final module mark = 84%

3. Calculate the student's final degree classification

The user enters:
• Student ID

Your program should:
1. Get all Level 5 and Level 6 modules.
2. Drop the student's lowest module mark.
3. Calculate the average for Level 5.
4. Calculate the average for Level 6.
5. Combine them using:
• Level 5 = 30%
• Level 6 = 70%

Finally, display the student's degree classification.

Typical classifications are:
• Below 40 → Fail
• 40–49 → Third Class
• 50–59 → Lower Second (2:2)
• 60–69 → Upper Second (2:1)
• 70+ → First Class

Important rule

If a student did not submit an assessment, they may fail the module even if their average mark is above the pass mark. Your program should follow the rules given in the assignment specification.

What you need to create

Your project should include:
• Java classes using OOP principles
• SQLite database connection
• SQL queries to retrieve data
• Methods to perform the required calculations
• A command-line interface that asks the user for input and displays the results

Difficulty

• Task 1: Easy (database lookup)
• Task 2: Medium (weighted grade calculation)
• Task 3: Hard (degree classification logic)

این پروژه شامل 2 فایل مهم است، لطفا قبل از ارسال پیشنهاد حتما نسبت به بررسی این فایل اقدام فرمایید.

مهارت ها و تخصص های مورد نیاز

---

---