We have about 30 that need to imported into our [login to view URL] Exam contains 50 questions (Except for English that has 100 questions)
We have a database schema that we set up and have created a template Excel sheet using that schema. However, this project is new and if you can suggest a new schema that will support ALL the functionality then we will be happy to consider it. However if you are planning to use a different schema you MUST send sample select statements that can be used to display the question, its instructions, its answers and any related images as well as one to display the whole exam.
I have attached the template and excel file for entering data.
There are 5 exams per each subject.
Please note the following:
Each Sheet in the Excel file is a different table in the database.
All data must be entered using HTML to imitate the way it is set-up on the exam sheet (e.g. bold, italics, subscripts etc)
For formulas and images create an image to represent the formula and reference them in the text part of the table.
Image file names should have the following format: MODULEID_MODULENAME_QUESTION#[login to view URL] e.g. : [login to view URL]
Each exam must have its own images folder labeled with the following syntax: MODULEID_MODULENAME eg 01_Physics2001
Please make sure maintain id's and references to them.
i,
I'm a Web-developer having a lot of experience on PHP,MySql, HTML,CSS etc.I can assure you quality work. Please consider my bid and let me start asap.
Thanks
This sounds like an exciting opportunity. I have looked over the database schema provided in the Excel sheet and find that it is intuitively put together. I can assure you that each exam question will be imported into the database using sound W3C certified HTML and will be properly escaped for import into your database. All images needed will be named following your requirements, and I will continue to work on this until you are completely satisfied. I would love to work with you on this and am happily awaiting your response.
Andrew Goulart