Help solve the task (more accurately evaluate the quality and clarity)

Question

PHP

1. There is a rating table:

"Rating" "Nick" "Number of points" "Date of passing the test" "Time of passing the test" It is

necessary to write a script for automatic rating on three criteria:
Number of points,
Time of passing the test,
Date of passing the test The
signs are indicated in in order of priority from highest to lowest.
Requirements - query execution speed of 10,000 records per 1 sec.
2. Write a script for finding duplicates, indicating the number of repetitions and a nickname, to the table in Task 1.
3. Write a script for selecting the number of participants, without taking into account duplicates, for a period, the boundaries of the period must be included both. Table in Task 1
4. Table of results
“Test” “Nickname” “Number of points” “Date of the test” “Time of the test”

Field “Test” — link to the test table Test table

“
Name” “Question” “Correct answer” “Answer options ” Test" "Question" "Answer" "Nick" Field "Test" — link to the test table Field "Nick" -text Field "Question" -text Field "Answer" -text Using PHP and MySQL write a script that displays the number of erroneous answers of each tested in the context of tests, with the output of the date of passing the test. Test date output format dmYYYY




5. Using the result of Task 4, use smarty to display the data in the form of a table. When outputting, use 2 files - one contains only calculations, the other only the output template.
6. Using the results of the solution of Task 3, JS, Smarty, PHP, HTML, CSS, create an external representation that allows you to select a period and display the result right there, under the selection fields in the form of a table.

Output example:

"Nick" "Number of attempts"



7. Using the initial data of Task 4 using JS, Smarty, PHP,HTML, CSS, display the number of passes for each test, with the output of the average score and average time to pass
"Test" "Number of passes" " Average score" "Average passing time"


8. Using the initial data of Task 4 using JS, Smarty, PHP, HTML, CSS, display a list of test participants, indicating the name of the test, the number of points and the passage time. From the list, exclude all those whose scores deviate downward from the average score of the current test by more than 10%. Sort by Test, number of points, passing time, nickname.
Also make a table with a list of those who were not included in the first list, indicating the test, nickname, number of points, average test score, deviation in%

List of those who passed the test " Test
" "Nick" "Number of points" "Time to pass" » "Nickname" "Number of points" "Average score" "Deviation %"

Answer 1

Excuse me, what do you want?
If you do not understand something in the tasks - what exactly?
If you have already done something, but stalled at some incomprehensible moment - at what specific point?
Otherwise, it gives the impression of "do me a thank you, and I'll pass at the university."

Answer 2

Okay, I confess - I'm writing a test to find a job candidate. requirements - knowledge of PHP and mysql
The partner says that the tasks are not clear, we decided to check

Answer 3

Yes, this is a whole TK for finding an artist and not a task.
What do you want to help you? Do all items? That's what freelancing is for.
Are you able to do at least one of the points yourself?

Answer 4

I have a job, I'm looking for an employee

Answer 5

Help solve the task (more accurately evaluate the quality and clarity)

They gave the following assignment at the university

Okay, I confess - I'm writing a test to find a job candidate. requirements - knowledge of PHP and mysql
The partner says that the tasks are not clear, we decided to check

Have you already decided?

Answer 6

While we are preparing a test for candidates.
If you are from Khabarovsk, write your resume to [email protected]

Answer 7

Ask Ontico for their test task, and then compare it with yours.

Answer 8

Discussed here ;)