Assignment Objectives

This assignment provides you with the opportunity to demonstrate your system and database design skills, as well as your skills implementing a SQLite database.

Your Task in Brief

You are working of a new cyber education start-up. They specialise in micro credentials. The curriculum is accompanied by a system of badges that is given out when students complete certain groups of activities. Teachers need to keep track of which students complete which activities so that they can receive their badges in a timely manner.

Currently, the start-up does this using a (paper) notebook in which it records attendance each week and jots down which activities completed. Each week we have to update the achievement record from our jottings in the attendance record book.

In this project you will design and implement an attendance record system that helps teachers manage student attendance and achievement records by storing details in a SQLite database.

Submission Requirements

You must submit a softcopy of your code (Task 3) by email and hardcopy of your design (Tasks 1&2). You may submit your design as early as you like (week 12 recommended) up until the final due date of 4^th November.

Detailed Statement of Requirements

The micro credential award scheme is fairly complex. There are loads of things people can do. Students attend weekly meetings, weekend activities, and also do work in their own time if they want to. There are Achievement Badges that let students focus on a special interest or skill and badges that focus on the core curriculum. There is also a leader board that shows those students with the highest number of credentials.

The badging system has three levels gold, diamond, and super platinum

Each badge has 14 Tests students must complete all of

Tests 1-7 and any 3 of the remaining Tests (8-14). Each Test 1-14 is broken into topics. Each topic has between 1 and 3 parts that must be completed for the topic to be considered complete. We only need to record the date that the entire topic has been completed, but sometimes we do parts of topics and we thus need to record completion of a part as well (although not necessarily the date). In some tests students do not need to complete all the topics to complete a test. Rather students or teaching staff may choose 2-3 topics of their own preference out of the test.

Key Functionality and Scope

There are a number of things that we do manually each week that wed like to automate using an app:

Marking attendance:

Each week during trimesters 1, 2, and 3, students attend an hour and a half meeting. Sometimes students are sick or otherwise unable to attend. We need to keep a record of which students attend which weeks. Wed like to be able to mark attendance using an app that stores weekly attendance data in an SQLite database. Ideally, in future it would be great if there is a single database.

Recording tests

At most weekly meetings, teaching staff run a program that satisfies the requirements for parts of test topics, whole topics or several topics comprising a test. Some weeks we choose not to do related work. Sometimes we hold weekend intensives and do parts, topics or tests at the intensive. We need to be able to record what we did and when.

Your Task in Detail

Your assignment comprises four sub-tasks for requirements gathering, design, implementation and administration:

1. Requirements List:

2. Design:

• Design a database that can store at least information about o students o completed parts, topics and tests.
• Design an app with the following minimum functionality:
  • Add a student to the database, including at least their first name, last name, DOB and which group they attend.
  • Record attendance for a weekly meeting or weekend intensives.
  • Record parts, topics or tests completed. o Search by name for a student and display their personal details and achievements
• Other functionality you may like to consider: o Search for students by other criteria eg: age o Notify teaching staff when a student has

competed an entire badge (7 compulsory tests

+ 3 optional tests) o Notify or permit teaching staff to search for parts, topics or tests that have not been widely completed (and thus should be the focus of an upcoming meeting program)

• Edit details
• Enter a planned test and the name of the person who will run it.
• A schedule
• Any other requirements you can establish

3. Implementation:

• Implement an app that communicates with a local SQLite database to achieve the following minimum functionality:

• Add a student to the database, including at least their first name, last name, DOB, which colour six they are in. o Record attendance
• Record parts, topics or tests completed at a weekly meeting or weekend workshop.
• Search by name and display their personal details and achievements

4. Administration: