Design database
- or -
Post a project like this- Posted:
- Proposals: 28
- Remote
- #2042132
- OPPORTUNITY
- Awarded
Description
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
John J J.
100% (1)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Any timeline for project award?
-
Hello John,
Is this job still open for new proposal?
Look forward to hearing back from you.
Best Regards,
Bals. -
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 -
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. -
deadline ?