Lesson Planning Database Application

User Experience

1. Log in

2. Get a view of „schools“ with columns „name“, „street“, „zip“,“city“, „phone“ and „e-mail“

3. Click on icon next to school entry in list and get a list of all active “courses”, sorted asc by start date. Active is defined by “course_state” (checkbox checked in course record means active).

4. Click on icon next to course entry an get a list of all lessons, ordered by lesson_date, lesson_start_time asc

5. Click on icon next to lesson entry and get a list of all “activities” with columns, start_time, end_time, duration, activity_title and description, ordered by acticity_order.

Important: start_time and end_time are dynamic fields, meaning: first activity of the lesson takes start time from lesson_start_time, first activity_end_time is lesson_start_time + duration of first activity. Second activity takes start_time from end_time of first actitivy, second activity end_time is second activity_start_time + duration of second activity and so on…

Admin of schools, courses and lessons

just usual CRUD

Admin of activities

Activity records should be managed as follows:

1. Go to a specific lesson

2. Choose “add activity”

3. Get a list/select box or something like this of activity types

4. Choose one activity type

5. Activity type is insereted a first position (if lesson plan empty) or last position, if there’s already activities)

6. Add additional information to actitivy like duration, description

7. Drag and drop functionality to reorder activities within lessons

8. New start and end times of activities are calculated automatically

9. If total duration of activities is longer than lesson_end_time – lesson_start_time, supernumerary activities are marked with red icon/border or background

GUI Style

Simple bootstrap / pls see attachment

Habilidades: HTML, jQuery / Prototype, PHP, Diseño de sitios web

Ver más: drupal easy website build, alibaba website build, handicapping website build service design, windows application database 2005 server, iphone application database excel, joomla commerce website build, drop box select php mysql, application database sql wikipedia, html simple login application database, full website build, facebook application database structutre, building automobile insurance application database, copy exitsing website build site, drag drop website build bracelet, convert access 2003 application database sql 2000, develop visual jsf application database, teacher rating website build, jquery select box select, bid website build, common questions freelance website build, jsf application database access, website build bid, oop application database, login application database java, poker website build

Información del empleador:
( 11 comentarios ) Adliswil, Switzerland

Nº del proyecto: #12782450

Adjudicado a:


Hello I am very interested in this job, please look at my profile and let me know if you are interessted in hiring me (I will be pleased). I have an experience of +5 years in web and PHP development Best reg Más

$88 USD en 7 días
(33 comentarios)

11 freelancers están ofertando el promedio de $373 para este trabajo


Dear sir/mam, i have gone through your requirements i strongly believe that the posted projectcompletely suits my skills please have a look at my previous works in the same stream of your proposal [login to view URL] Más

$222 USD en 3 días
(0 comentarios)

Hello, and thanks for the opportunity to bid on your project. I am an expert in many different area’s of web and mobile applications based on the following languages: W Más

$210 USD en 3 días
(206 comentarios)

Ready to start work with you, would like to discuss it further, let me know if you are free to discuss it thanks

$1266 USD en 18 días
(392 comentarios)
$155 USD en 3 días
(21 comentarios)

I'm a BSc degree holder in computer science and a master degree holder in strategic management. I have worked on more than 1000 papers in report writing, Assignment delivery, content writing, Business plans, dissertati Más

$155 USD en 3 días
(2 comentarios)

Hey there, If you're looking for excellent development quality and great English communication skills, you've come to the right place. I am a highly experienced PHP developer, with over 12 years of professional exper Más

$1000 USD en 3 días
(28 comentarios)

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Más

$200 USD en 3 días
(100 comentarios)

Greeting Coursera has a simple and cool layout similar to what you are asking. You can inspire more from looking at the site. Concerning the implementation, I think that a Single page application will provide you the Más

$555 USD en 10 días
(2 comentarios)

Hello Hiring Manager, I have seen the attached image and have also read all the points of project description. I know how to use bootstrap for front end. i will write whole mentioned functionality for admin.i am reall Más

$133 USD en 5 días
(78 comentarios)
$123 USD en 3 días
(0 comentarios)