I needed to create some wordsearches recently. So I turned to Excel. Excel 2010 merge cells wizard free downloads, merge wizard excel, excel 2010 chart wizard, excel mail merge 2010 - software for free at freeware freedownload. Where are pivot table and pivotchart wizard in excel 2007 2010 where are pivot table and pivotchart wizard in excel 2007 2010 where are pivot table and pivotchart wizard in excel 2007 2010 add pivot table wizard in excel 2007 tables. Share this: Click to share on Twitter (Opens in new window). I created two identically-sized grids: a blank one in which I could type the words I wanted to appear in their rightful positions; and another one next to it, which would surround the keywords with randomised letters. And here's the result. I've shaded the keywords on the right for visual effect. The shading isn't there in the finished product, because that would make the wordsearch a bit rubbish. The formula of choice is as follows: =IF(ISBLANK(B4),VLOOKUP(ROUNDDOWN((RAND()*1012)+1,0),Lookups!$F:$G,2,0),B4) The range in the Lookups sheet lists the letters of the alphabet a variable number of times depending on their propensity to appear in the English language. A appears roughly 82 times in 1012, or 8.1% of the time. Should you want to use it. ![]() My daughter's in the midst of learning her times tables. There are various apps out there that can help, but I was after something that addressed a specific need. I wanted to be able to specify the times tables that she had learnt, and to give her a randomised, exhaustive test containing one question for each one learnt. So if I selected 2, 3, 5 and 10, I wanted a randomised test containing 48 questions – one for each of the 12 multiples within each of the four times tables. Not being able to find anything, I decided instead to create something. It can be downloaded here:. The first tab allows the parent or guardian to choose the times tables that the child has allegedly mastered. Enter the same one twice, and it will double-up the questions for that times table. The second tab presents the questions in a randomised order to the child. Each question is presented in turn, each question not showing until the child has attempted to answer its predecessor. The child is given a tick or a cross as soon as they answer the question, and at the top of the screen, they're given a live status (at a jaunty angle) showing their progress through the test. My favourite feature is that the ordering of the questions is randomised, and that random order changes each day you open the spreadsheet. So kids can't get complacent about remembering the order in which the questions appear. =MOD(10000*A1/DAY(TODAY())/MONTH(TODAY()),1) (Basically, take a random number between o and 1, divide it by the day of the month; divide it by the month of the year, multiply the result by 10,000 and figure out its decimal remainder. Excel formula comma separators. Not proper random; but random enough.) Here's hoping it helps. I found out the other day that the carriage return can be used as a delimiter when converting text to columns.
0 Comments
Leave a Reply. |