Design database

  • Posted:
  • Proposals: 31
  • Remote
  • #2042132
  • Awarded
Alif J.Tarak G.Eduardo M.Vancho D.Sylvester A. + 26 others have already sent a proposal.
  • 11


Experience Level: Intermediate
We've got a simple spreadsheet we use for school registration of pupils
Pupils name, am & pm registration for each day.
We use 26 codes to show different types of absence, / \ B C etc
We then have a seperate sheet that calculates their attendance percentages, for the term to date
At present we manually count their attendances to calculate these attendance percentages,

I'd like to change this to a database system:

- Input new pupil
+ First name, surname
+ NC Year Group
+ Class
- Record attendance per class for am & pm registration
(need to be able to recode attendance by term/year)
+ Day
+ Date
+ Attendance code
- Record interventions used
+ as per list on spreadsheet
- Record communications home
+ as per list on spreadsheet

- calculate authorised attendance % per term
- calculate authorised attendance % per academic year

- Attendance per term
+ Pupils Name
+ Class
+ Autumn / Spring / Summer term
+ year
+ Overall attendance %
+ Break down of attendance per day of week (Mon. - Fri.) am / pm
- Attendance per year
+ as above

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Zahid N.

    Any timeline for project award?

  • Bals S.

    Hello John,

    Is this job still open for new proposal?

    Look forward to hearing back from you.

    Best Regards,

  • Jomon K.


    I can get this done. My understanding as per your description is to make few web forms as you described, and store data into database.

    Could you please let me know if you have the domain and web space available for this hosting.

    I can do it for you. The development and design of database can be around your budget.

    Awaiting your response.


  • Carl W.

    Good afternoon,
    Could you please advise aprox how many concurrent users there would be and do you require access outwith the building. i.e. the ability for access from home.
    Kind regards,

  • Siva K.

    deadline ?