rocknrollstar

Thanks for everyone's input on this question. I managed to work it out using vba scripting. It's to do with automatically creating a custom sort list in vba, then allowing that sort mechanism to be used via a button at the top of the column that you want to sort. Attached is my full version of the tracking document, which also performs some analysis and creates graphs. It's created for use in a junior school, as I don't like Assessment Manager! Note that it needs Macros to be enabled to work, and I promise it doesn't do anything dodgy like delete files from your hard disk. Certainly doesn't on mine! Hope it's useful to someone. Tracking and Analysis.xls

Thanks Michael. However, I really need to be able to sort the list in the correct 'level' order, and show all the data too. I know I can do this if I do Tools -> Data -> Sort -> then choose my custom sort list, but it involves selecting all the data first. The spreadsheet is pretty big! Any thoughts?\I thought about overridding the default sort ascending method in excel, but don't know VBA very well. I've had a lot of experience in Java programming, but not VBA/Excel stuff. Thanks again for your efforts.

Hi, I want to sort levels in ascending or descending order correctly. So a list like "2a, 2c, 1a, 2b" should sort to "1a,2c,2b,2a". I know how to do this with Custom Lists. However, I have recently found the AutoFilter option which automatically gives you sort drop down boxes, which is very useful! But the default sort ascending option will sort it like "1a,2a,2b,2c", not the way that I need. Is it possible to use AutoFilter with a custom sort list? If not, do you know of another way to sort according to the levels, and get a drop down sort box (or button)? Thanks in advance.

I'll put the answers on very soon

It's our Summer Fair this Saturday (), and I was asked to come up with a name that tune stall. It's attached if you fancy 2 minutes break BTW, it's for Junior School, so can't be that difficult! Apologies for the MP4, edugeek's obviously not a fan of MP3. FINAL MIXED 2.MP4

pm me and i'll sponsor you

Hi, you may have checked this thread, but when I couldn't access the net via the school proxy, I did get it working using the last few posts in http://www.edugeek.net/forums/nix/35654-proxy-ubuntu-fog.html Not a ubuntu wiz at all, but managed to get it to work.

Just a follow up on this thread. We had 2 more new 660i's installed today, and I asked for the speakers not to go through the IWB control panel. I.E. on a previous installation, the 30w speakers only worked when the IWB was turned on, and the volume was too low for many DVDs So I asked the gent who did today's installation to make the speaker leads bypass the IWB panel, and go directly into the PC. Not only did it work, but the sound is now incredibly loud, and now has to be limited! We did use the ac3filter on a few pcs, but to be honest it tended to distort the sound too much. So it's a winner- more than enough volume through the speakers, and the IWBs don't have to be turned on to listen to the speakers, saving bulb life. Moral- Ignore the SmartBoard Junction panel for the audio, as it seems to reduce the volume. Go directly from the speakers to the PC with a 3.5mm jack.

I wouldn't say Serif is awful- I was sent an evaluation copy for free, and it does all my needs. The children don't use it, but I am sure they could with minimal training. Can easily make dvds with nice menus etc. The problem with Premier Elements is that you need a beast of a PC to run it properly, and it's also much more advanced to use. Serif software falls in the middle of MovieMaker and Elements. Certainly recommended for Primary age.

Thanks for your replies. Yes, I know, I'll put XP on it. Comes with the downgrade option Be interesting when XP really does stop being supported by MS, if it's not already. My guess is we'll be using it for a good while.

Hi, we are looking at buying 16 of Toshiba Satellite Pro L300D-224 Laptop - Laptops at Ebuyer . £350 on ebuyer, with £50 cashback, so great price. But are they any good? Would you recommend them? Thanks.

Haven't heard that phrase in a while!

We had a 2600, worked as long as you turn off the bidirectional printing thing. Not a fan of it really, so now the HT has it in the office

We managed to get 26,000. Problem is, I'm not really a fan of most of the technical stuff available in the catalogue (RM), so we're using the vouchers for pe/outdoor equipment. I also find the value of the vouchers varies considerably. If you work out the voucher cost for a certain item, then compare it to another, it is massively different. Just annoys me Got 3 Asus EEE PCs last year, and last week found time to get them to work and on the network

I'd buy a good few for school...

I knew it... It was either going to be my grandad or a pro racing driver Too tall for Daemon Hill, my first guess. BBC NEWS | Entertainment | Schumacher 'revealed' as the Stig

Does anyone know of any software that can monitor the amount of energy being used by individual pcs on a network? No idea if it's even possible, but my guess is that it is. Prefereably free, but will pay! Thanks.

I've got to say that we have had a few issues with RA2009. Although the tech support have been extremely helpful, there were definite issues with doing reports this year. A teacher's file became corrupt on the server/client version, so all the teachers had to almost start again for their reports for that class. At other times, the work didn't quite save. It can certainly be a bit grumpy. Next year, we will be going back to some sort of tick box system through Word. Or even Google Docs for multiple concurrent users. Or perhaps a custom Moodle module...

I'd agree with secretlife- try and upgrade your Moodle, keep it as current as possible, if only for security reasons. Older versions do have security flaws, which are fixed in newer versions. Difficult to tell, and even if the module requires a certain version, module dependencies may require a newer version. Bite the bullet (backup before you do)....

i usually go to 'list all hosts' then pick an individual host. On the left it has the basic tasks option. First click upload host to take an image of a client and store it on the server. Pxe boot client and it will automatically upload it's own image. Then click on a group, basic tasks, and do a deploy. This will send out the image from the server to the clients. Pretty much all there is to it. Could do more detailed step by step instryuctions if needed.

It depends really. If you have setup PXE boot on your network, the best way to register hosts (clients) is to boot the client using PXE boot. It will then get an IP Address, and hopefully the FOG menu will come up on the client. I think the third item down is the full registration and inventory option, which I have done. You go through that, and it asks you a few questions, and then contacts the FOG server and saves it all. To be honest, the way that I set it up is as follows: Installed Ubuntu desktop on an older PC Made sure it had network and internet access Downloaded and installed fog Left our Win2k server as the DHCP server- made things easier I think to just have 1 DHCP, instead of 2 which could complicate things. Set up Win2k to be able to allow PXE boot (see FOG Wiki) Changed client PCs to be able to PXE boot (in BIOS settings) PXE'd boot clients and performed self registration and inventory Grouped client PCs (hosts) in FOG server Created an image option in FOG for each image that I needed. This is basically creating an entry in the FOG database so it knows about an image, and then the image can be assigned to individual hosts or a group of hosts. Assign this image option to each group as appropriate to your needs. Once a PC had been prepared for imaging (sysprep'd), I told FOG server to do an upload of that host. Next time I PXE booted that host, it automatically talked to FOG and knew that it had to upload the image to FOG- you'll see a progress bar, it's pretty quick. Once complete, you can either unicast or multicast that image to the group of associated PCs/clients/hosts whatever you call them. This is basically deploying the image to the clients. I didn't touch the AD settings on FOG, as sysprep did it for me. I also made the mistake of installing FOG on a PC with a smaller HD (40GB initially) but later took an image of that HD using clonezilla, replaced with a new larger HD, and then reimaged the new HD. Worked a treat. Multicast didn't really work for me- much slower than unicasting for some reason. I don't do low level networks, so didn't look into it. However, you can set the number of unicasts that can be done at the same time, the rest will queue until a slot is free. I actually set this to be 1 unicast at a time. It was much faster in the long run I believe than doing 2 or 3 at a time. The FOG server is a P4 2.8GHZ with 512MB ram- not a fast piece of kit, but worked happily enough. Hope this helps.

Thanks AngryTechnician, that's really useful to know. Little by little I seem to get there, wherever 'there' is....

Solved! There are 2 underscores, which was a problematic typo. However, the command attrib -S -H "c:\freecom__backup" worked (only when I took off the /S). Thanks very much for your help SYNACK, kmount and James. Cheers

James, the only way I can see the folder is if I have that tickbox ticked. It is definitely some sort of system folder, as it looks ghost-like. Not sure how it got like that!

Thanks SYNACK, I gave this a go, but got a file not found error (see attachement). Any ideas?