Based on established paper based process.
My client is currently using a paper based system for screening hourly candidates. They would like to put their employement application and short test online for better record keeping and ease of access.
They want a (hopefully non-public) webpage that is accessed by a changable access code (to be included in the job posting). Users could fill out the application and complete the test online. Information captured will include name, address, past employemnt, and the like. Then it is off to the short exam (see paper version attached).
Platform is expected to be either:
google apps (prefered if it functions correctly)
First phase is a spec workup including all features; user functions (both admin/employer side and user side); back end platform (client already has godaddy or windows azure account if that matters...mysql and php?); general implementation process; and your expectations of me around testing, installation, etc.
Next design and development (by worker)
Then testing and integration (by you or your friend/peer)
Finally install and acceptance.
This project does not have a specific budget at this point so include in your reply your expectations in US$. Assuming at this point it is under $1000 but if not I won't be upset. In bidding, indicate time to deliver if 30 days is too short.
This is a low-risk project for the client so they will forego formal documentation around user manual and possibly job docs and even code documentation. I'll derive the info I need from the project messages and pass it along. Interfaces should be simple and not graphically sexy. Function over form. Good clean code - ugly pages is fine. They just need to function in all the usual browsers (Safari, IE, Chrome). It probably goes without saying...no mobile. The format in the jpg is not required.
If php/mysql*, page needs are:
page1 to set alpha numeric access code, questions verbatim (if it's not hard coded into the user webpage), and a dialogue process to retrive database info into a data dump in csv or txt (if not in .xls) and process to clear the database records for the next job posting.
Client can import raw data from csv into own database for further processing. That last part is not part of the scope of this project.
page1 enter access code (and maybe a field to reference the single job posting url in monster or craigslist)...this won't be scaled for multiple job openings for now.
page2 fill out basic personal information (fields/possible answers to be provided - some required to advance forward)
page3 answer questions around skills
page4 references and qualifier questions like "if you are applying for a driving position, have you ever been arrested for druck driving? (yes/no)" or "have you been convicted of a felony - if yes give basic details".
page5 "by clicking submit you agree to acceptance of terms and conditions around background checking later as well as permission to call references. (T&C's will be posted in a google sites page if they want to read them - no work there for you)
page6 takes them to the test...same as attached over four pages.
page-last - thank you.
I will provide the verbatim for these inputs. There will not be any cascading answering (if yes then open another page). I will need a little assistance assigning the cname but don't have a problem being the one to do it after development is complete. I'm happy if you provide the test environment and then we transfer pages when complete.
The pages may have to send "if yes then explain" data to the database...hopefully not much more complex than that. radio buttons and multiple choice should be expected (see the attached test)
Some data will be required and the user will not be able to advance without filling it out.
email addresses entered do not have to be validated (if they can't enter a proper email address the client doesn't want to hire them them anyway).
*If you could do this project using google apps (disclaimer: I'm new to understanding google apps) I think that would be preferred...then you won't have to code a page for recovering the data in the database if it resides in a google spreadsheet.
If we end up on godaddy or windows azure, I'll provide the access.
What did I leave out?
I'll likely have to edit this post in a few hours after all of you tell me! I'll rebroadcast a message if I did.
I'm looking to earn a ten so you will find I am easy to work with.
**The one expectation I can be hard on is testing your own code in the environment it will run on**. If you make web pages, you will be expected to "eat your dogfood" in chrome, IE, safari (if you don't have access to safari, I can do it from one of my macs).
Here are my design standards up front:
To have a clear understanding of past accomplishments and output of worker. - if I don't have a clear understanding, give them a small trial project.
Read the workers emails/messages and give clear answers. If there is room for interpretation, ask clarifying questions.
Communicate in the simplest English language appropriate.
No back-tracking or changing mind in terms of scope of project once terms are accepted.
Expect three (3) iterations...not more than three.
Expect to provide iterations - up to three (3)
Following instructions completely.
Read employers emails/messages and give clear answers. If there is room for interpretation, ask clarifying questions.
Create work that is the same quality as previous work or samples.
Make suggestions when appropriate (bonus)**
Deliver code and all files required to move site later if need be