Find Jobs
Hire Freelancers

I need to generate printable MCQ papers with seperate answer paper from a bank of questions stored in an excel spreadsheet

£20-250 GBP

Closed
Posted over 7 years ago

£20-250 GBP

Paid on delivery
Problem I need a way of generating printable MCQ papers with seperate answer paper from a bank of questions stored in an excel spreadsheet Situation I have a question bank of 800 questions and answers stored across 6 spreadsheet tabs in an excel spreadsheet The 800 questions are split into 2 types: 500 Type A and 300 Type B Exact number of questions in the bank will vary with time 3 spreadsheet tabs (tabs 1 to 3) for Type A questions and 3 spreadsheet tabs (tabs 4 to 6) for Type B questions I need to be able to print off 15 separate question and answer papers at a time. The exact number of papers generated should be user definable Each paper should consist of 30 Type A questions first and 15 Type B questions second. There needs to be an even distibution of questions from each spreadsheet tab. So 10 from each of Tab 1 to 3 - type A questions and 5 from tabs 4 to 6 -type B questions The exact split of the number of Type A and Type B questions should also be user definable. The questions must be randomised across the 15 papers with no repetition. A separate printable answer paper of corresponding answers and explanations needs to be generated at the same time. Format of papers Question Paper Question number - [Question Code] [Question] [Stem A] [Stem B] [Stem C] [Stem D] [Stem E] Answer sheet Question number [Question code] [Answers] [Explanation]
Project ID: 11704424

About the project

5 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average £145 GBP for this job
User Avatar
HI I am an excel-vba Expert and I can finish your project so fast ............................................................................
£122 GBP in 3 days
5.0 (38 reviews)
5.3
5.3
User Avatar
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. It would be nice to see some sample af questions you already have. Looking forward for further clarifications of the details. Regards, Sergey
£150 GBP in 7 days
4.9 (10 reviews)
4.4
4.4
User Avatar
I will write VB code to select 10 questions each from Tab 1 - 3 (randomly, without repeating) and 5 questions each from Tab 4-6 ((randomly, without repeating) and copy all these questions in a new sheet named QP-1 and so on depending upon the number of question papers required. based on the questions selected, the answers will be chosen and copied in new sheet named A-1 and so on. Then these question papers and corresponding answers can be printed.
£77 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've experience working with MS Excel for 10 years. My skills include data processing, data analysis and VBA programming to automate the processes. In addition, I have done a web-based system for question bank previously.
£177 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
DELHI, India
0.0
0
Member since Aug 10, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.