LosOjos

You may also want to look at Assessment Lookup Tables (Focus > Assessment > Lookup Tables). These provide a convenient way to map two different values for comparison. For instance, I have a lookup table which takes a KS2 level as input and returns the GCSE grade equal to 3 LOP. I can then compare this grade to the target/estimated grade. To make this easier to set up, put in your default values then hit 'Apply' in the 'Age Standardised Score' panel, which will give you an empty table to start with. If you then press 'Copy', you can past this table in to Excel where it's easier to manipulate (you can also remove row if needs be). Then copy the finished table in Excel and select 'Paste' in SIMS to transfer the data across.

Yeah I've been passed this too, having to do quite a bit of digging before I draft up a statement for staff (at the moment I'm tempted to simply say "Don't use cloud storage!") The Google link is here: https://drive.google.com/folderview?id=0B4froD7RGVqtaFlKc3VnTHF0THc&usp=sharing# Now, while that document makes it seem as if Google Drive is perfectly safe, I suspect it only applies if you've signed up through Google Apps for Education, so staff members' personal Drive accounts are not necessarily compliant. Likewise, Office365 looks to be secure but staff should not confuse this with SkyDrive/OneDrive, which I can't find documentation for therefore must assume it's not compliant. Dropbox I still think is best just avoided in school. I think it really comes down to advising staff to only use services we as a school have bought in to and distributed and to absolutely never use their personal accounts. It's the only way I can see to ensure compliance with DPA. What do you think; would you agree with me or do you have other ideas about it?

Owning a license for a piece of software does not exempt you from the copyright restrictions of any material you use it to download.

Only make the same exceptions as the law.

Yeah you could do a vlookup, if the value was missing it'd return #N/A which you could filter down to find who's not done it (assuming everyone has spelt their username correctly of course) To pull the %USERNAME% part of the text, use left and search. e.g. if you're looking at the value in cell A1: =LEFT(A1,SEARCH(",",A1)-1) Alternatively, use Excel's 'Text to Columns' routine to separate the values by splitting them by comma. All in all, say Sheet1 had survey usernames in rows 1 to 50, your formula for cell A2 on your AD username sheet would be: =VLOOKUP(LEFT(A1,SEARCH(",",A1)-1),'Sheet1'!$A$1:$A$50,1,FALSE) If it returns the username, it found it (i.e. it's been completed) if it returns an error it didn't (i.e. not completed) And if you wanted to tidy it all up a bit and return TRUE if it's entered and FALSE if not, wrap it all in an ISERROR (and NOT, to reverse it) i.e.: =NOT(ISERROR(VLOOKUP(LEFT(A1,SEARCH(",",A1)-1),'Sheet1'!$A$1:$A$50,1,FALSE)))

Yeah, but now you can see the dashboard

* grammar * their [statement] I'm sorry, but you set yourself up for this one EDIT: I was out-trolled by @3s-gtech

I'm finding it generally quicker, but then mine has always been a dog anyway

Haha don't worry, I'll try it out. I'd be more interested in the USB headsets if they had standard connectors and a USB sound card (like the really expensive ones do), but without standard adapters I'm a bit put off - I do plan to eventually buy a PS4 and don't fancy shelling out for another headset

OK I did some research of my own, and they're all software in the price range I'm looking at. Therefore, I'm going to go for the HyperX and try out the software @LeMarchand posted, as they have standard 3.5mm jacks so will work with anything unlike most of the headsets advertised as 7.1 which are USB

Hmm OK, I buckled and looked at 7.1 headsets - there are some Creative well under £100 - which particular ones are people recommending? I assume for these prices they're software 7.1 rather than hardware? Ref: http://www.amazon.co.uk/Corsair-CA-9011125-EU-Vengeance-Wireless-Comfortable/dp/B00EZ5N1UC/ref=sr_1_3?s=computers&ie=UTF8&qid=1416317408&sr=1-3&keywords=Corsair+7.1+headset @Sunnyknight - those Plantronics look good too - again, do you know if they're HW or SW 7.1? How do you rate that aspect of them?

Actually, I see what you're getting at now. The only way I can think of to do that in Excel is to develop an algorithm to generate the cell reference on the fly. Given your example, the following would do it: =ADDRESS(ROUND((ROW()+1)/4,0),IF(MOD(ROW(),4)=0,4,MOD(ROW(),4)),1,TRUE,"text") If you wanted the value of the referenced cell (as opposed to the cell reference itself), wrap it in an INDIRECT i.e. =INDIRECT(ADDRESS(ROUND((ROW()+1)/4,0),IF(MOD(ROW(),4)=0,4,MOD(ROW(),4)),1,TRUE,"text"))

Difficult to see what you're aiming for, but at a guess you need to lock the references. To do so, you put a $ in front of the element you want to lock (row, column or both). For instance, if you wanted to reference A1, and you always wanted to reference that exact cell no matter where the target cell was copied to, you'd change it to $A$1

That does look interesting, will give it a go Don't think I'll be buying 7.1 headset as I have true 5.1 surround at home I'll use mostly, so can't justify the massive price hike just for when I'm using headphones... Those Kingston Hyper X look like a good bet, by all accounts the reviews seem to think they're up their in terms of sound quality with much more expensive sets.

Braintree - it incorporates a few major payment methods in to one API https://www.braintreepayments.com/

See, I'd agree RE below 30FPS but I genuinely can't see any difference above - maybe it's just me! I can understand the logic behind aiming for 60FPS average so that spikes don't kill the game though

I'm considering one next time I spend some money on my PC, but I mostly play on the TV since I built a "Steambox" (Windows based) Such as? (not being arsey, I genuinely don't understand why)

No thanks

People with an interest in Wolverhampton - apparently their niche interest is Wolverhampton Wanderers Also, they're writers, vide gamers, loaded (>£1000 spare cash) - not the same Wolverhampton I grew up in!

(I edited my post while you were posting) - I always enable Vsync because screen tearing really irritates me

Yeah, but I'm sure my GTX 760 will be playable! (it won't) I'm a bit of an oddity amongst PC gamers - I really don't understand the fuss over getting minimum 60FPS. You can't physically see that many FPS! I'm happy with a 40FPS average, still more than you can actually interpret and still enough not to notice any 'juddering'... EDIT: in fact I'll happily play a game at 30FPS, though I admit once you start dropping below that, things get ugly. Oh, and I always use Vsync - nothing irritates me more than screen tear. So, anyone want to tell me why I'm wrong? (I should probably start a new thread...)

I'd rather they delay it and do it properly than give us another bad port... let's just hope they don't still give us a bad port! Can't wait to see those 4K textures on my nice new telly (will no doubt cry when my GPU can't handle it (it definitely can't handle it))

Bear in mind, it's only based on people who take YouGov polls, and according to YouGov's profiler, "People who like YouGov Polls" are center right, 60+ males from the North East

I used it once and refused to again - you could put money on to it, but unless that money was enough to cover the whole transaction, you couldn't use it. Means I've had about 50p stuck in mine for 2 years!

is it 1GB?