Ditutup

Colour coded data Entry

I have a marking spreadsheet that lists student names down the left hand side of the page.

Along the top I have the correct answers for approx 30 multiple choice questions.

What I am after is a spreadsheet that automatically colours the cell either red or green if they are correct then outputs the score that they received.

Additionally I require the sheet to generate a score based on correct answers. This score would then be compare to a lesser than or greater than value to create a number called a stanine (like a rank) based upon that score. E.g. they get 25 correct = 3 if they get 30 correct = 4 and so on. There is a simple table that is used to work out this scale and I can provide this to you.

I have a spreadsheet already that does this for a different test and can provide this to you so that you may reverse engineer it or in the very least examine its functionality to assist you replicate its functionality.

The task would be to create a replica of the example test for two other tests. E.g. I will provide a maths test sample mark sheet that is functional and you would be required to make a replica for a vocabulary and spelling test. For each type of test there are about 3 - 4 variations, which variation they do is based on what grade they are in.

I can provide the correct answers in rudimentary spreadsheet form. I.e. as raw data along the top of the page.

BONUS - I am likely to pick a bidder that can do the following. These are standardised tests and for each grade level (1-7) the child will be doing a version of these tests twice a year. If you could create a formula or input method that allows me to keep one spreadsheet/sheet that tracks the child over either one or all seven years so that I can observe stanine(rank) growth or lack thereof.

E.g. On the first sheet I can enter student names as an input variable. These then automatically populate all the test entry points. Then on the second sheet I can see Test 1 stanine(rank) and test 2(rank) side by side for the year. This could potentially populate out for grade 1 through to 7. The cell could then be compared to the previous value then coloured or indicated in some way to indicate growth (increased stanine number) or lack thereof.

The files attached is a screen shot of what I can give you to assist you with this project.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic

Lihat lebih lanjut: data entry test like, top data, top coded, spreadsheet data entry form, sample received form, sample data entry tests, sample data entry test, page reverse, number data entry test, data entry table, data entry score, data entry sample test, child data entry, task replicate, student data, raw data, pick basic, observe, maths project, input method, engineer task, data visual, compare spreadsheet, coloured, sample data input

Tentang Majikan:
( 0 ulasan ) Hervey bay, Australia

ID Projek: #1586996

6 pekerja bebas membida secara purata $112 untuk pekerjaan ini

skctechno

I have gone through the "Freelancer Job.png". I can do it in minimum cost ($50) and within a few days. I can start working on it now, I would like you send the sample Excel file. -Thanks and Regards

$50 USD dalam 7 hari
(29 Ulasan)
5.5
nprodrigo

im on it...

$100 USD dalam 4 hari
(0 Ulasan)
0.0
StasJ

Check you PM please.

$50 USD dalam 2 hari
(0 Ulasan)
0.0
andreabeccarini

My matter. Ready to start.

$150 USD dalam 3 hari
(0 Ulasan)
0.0
cosmichighway

I can accomplish everything that you request for this project. To do this, I will be using visual basic coding. I can set it up so that based on the answer on the top, the cells will automatically change color. Also, I Lagi

$200 USD dalam 5 hari
(0 Ulasan)
0.0
HappyHome007

Hi, I am an experienced freelancer in this field and interested to work with you. Could you please see the private message for more details. Thanks. Alam

$120 USD dalam 3 hari
(0 Ulasan)
0.0