Design database

  • Posted:
  • Proposals: 31
  • Remote
  • #2042132
  • OPPORTUNITY
  • Awarded
Russel W.
Arthur A.Sohel A.Ijaz H.Akshay T. + 26 others have already sent a proposal.
  • 11

Description

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:

Forms:
- Input new pupil
+ First name, surname
+ DOB
+ 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

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

Reports;
- 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,
    Bals.

  • Jomon K.

    Hi

    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.

    Thanks
    Jomon

  • 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,
    Carl.

  • Siva K.

    deadline ?