Develop Math Questions for Grade 1-12 using Excel
This project received 23 bids from talented freelancers with an average bid price of $183 USD.Get free quotes for a project like this
We are creating "Numerical" Math questions for Grades 1-12. I have been working with an excel file that works with random numbers and generates questions like:
Find the number x:7410+026=7x15||11||LOW||1
using an excel formula like:
=CONCATENATE("Find the number x:",$A11,"",$Q11,"",$R11,"+",$B11,"",$C11,"",$D11,"=",$AA11,"x",$R11*$D11/GCD($R11*$D11,$AB11),"||",$AB11/GCD($R11*$D11,$AB11),"||",$Z11,"||1")
As you notice, this will need a knowledge of basic html tags and math concepts apart from excel expertise.
We are working on roughly 1000 topics categorized into chapters like Numeration, Fractions, Decimals, Area, Perimeter, Volume etc. We need various types of questions within these areas and then randomize variables to generate multiple problems. There needs to be a cursory manual check of the questions as well to remove any inconsistencies like division by zero. The questions will be of different skill levels, and hence the variable values need to be set accordingly.
The problems will also be assigned four different difficulty levels within each topic, depending on the complexity.
Please look at the attached sample excel file and study the formulae involved. The skills necessary to do this project are:
1. Extremely sound Math concept knowledge
2. Innovative thinking to design as many different kinds of problems
3. Sound Excel knowledge
4. Good working knnowledge of html tags, as we use table, font tags quite often.
In the excel file attached, press F9 to show up more random values. FInally, you need to copy the set of questions and paste the contents into an html eidtor to check the questions visually. I find editplus to be a good tool for this. We will need the excel file as well as the text file (as attached) with the questions.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online