gavcradd

Please forgive what may be a stupid question, I am a Computer Science teacher, not a technician :-) I have a number of RM Expert 3030s that I am trying to rebuild using PXE boot. However, to do so I need to get into the BIOS to change the boot order. When I turn the machine on, it displays the "F2 for BIOS" message but mashing the F2 button does nothing. In fact, it seems as though the keyboard (USB) itself is not initialised at this point (num lock / caps lock keys don't work). By the time Windows 7 boots, the keyboard is working fine however to enter log on details. I've tried a different keyboard and the same issue is affecting 10+ machines in one room, so I doubt it's a hardware malfunction. Any ideas?

Hi, I'm trying to work out the best way to do this, either in SQL or VBA... I have an Access database table with all of the staff in the school (containing fields USERNAME, JOBTITLE and LINEMANAGEDBY). The "linemanagedby" field is a reference to the username field. So for example, I can easily find out who line manages the head of ICT or all of the people that an assistant head line manages. This works perfectly. Now onto the problem...I've been asked to extend the system so that I can find out "greater depths" of line management. So for example, the assistant head line manages the head of ICT, the head of ICT line manages the ICT teachers and one of the ICT teachers line manages an NQT in the department. I need the system to be able to search for the Assistant Head and return all of the people that they directly line manage, and all of the people that they "indirectly" line manage if you understand me. I've started SQL queries and given up. I started to write a recursive function in VBA but gave up when it got stupidly complicated... Any ideas? Thanks!

Hi everyone, Head of ICT here (so teacher, please be kind...) I have quite a few programming projects that I've done over the years to do various things in school, but they all rely on me exporting data from SIMS into another database. Many years ago, I tried to get data automatically out of the SIMS database (just things like students names and classes) but hit a brick wall. I tried contacting the company officially but they wanted an extortionate fee for developer access. Has anything moved on over the past few years? Is there any easy way to get data out of the SIMS database? Anyone done anything like this with their projects?

Much easier solution : SELECT * FROM glpi_tickets_users WHERE type = 1 AND id NOT IN (SELECT id FROM glpi_tickets_users WHERE type = 2) Hope I'm not too late to the party! Edit : just looked at the date, November 2012 - oops.

I want to look into shared calendars for the staff at my school (11 - 16 high school, approx 100 staff). The idea would be that one central calendar could be created by the office, with things such as holidays, report deadlines, etc that apply to everyone and then this could be shared with all staff. If possible, I'd also like departments to be able to add their own little bits on, so perhaps the Head of Maths could add in something for other Maths teachers to see, but no one else would get this. We already use Outlook and we have an Exchange 2003 server hosted internally. Could I do this? If so, are there any "getting started" guides anywhere? If this is not possible with Exchange 2003, would an upgrade to Exchange 2010 do this? I've heard this mentioned by various people but I've been bitten before my spending money that's not needed. Is there any other solution? Thanks for your help, I'm a teacher by the way (Subject Leader for ICT/Computing), not a techie!!

I'd given them up as scammers a long time ago... it would be nice to receive something from them (other than spam), like perhaps a USB stick?

Hi, I've just been reading through the thread about whether to learn Python or Perl and it got me thinking about something very similar - which language should I be teaching to my VI Form A Level Computing Students? We currently use Visual Basic 6 but it's extremely long in the tooth and every year I think about switching. I always manage to put it off for another year but I think the time has come. The only criteria are : 1) It needs to be reasonably simple to pick up - I don't want half the class dropping the course in the first few weeks because they can't get their "hello world" program working. Most of the class will never have done any programming before. Ever. 2) It needs to be able to connect to Access databases / text files to store and retrieve data (this is a requirement of the coursework). Other than that, I could choose anything. I *almost* switched to Python last year but was put off at the last minute because I read that variables weren't strictly typed - this would make teaching the theory of data types much more difficult so I got scared and ran back to VB. Pascal / Delphi appeals to me but is it just as out of date as VB? Java and C# just seem too intimidating for the beginner I think? Any ideas?

Still waiting for mine, still receiving their marketing emails. Out of interest, does anyone know anyone who HAS received their memory stick? Maybe Watchdog or someone will want to feature them?

All I really need to get is pupil names, classes, etc. The crucial part is that if a new kid gets entered onto SIMS or any data about them is changed, I need my system to automatically pick it up without any interaction from me. The network manager / technicians are very good and helpful, but don't know how to go with this, hence why I'm no here... I get you though about the importance of SIMs, If I messed it up I wouldn't bother coming into work the next day.

Cheers for the info. Theoretically speaking then, although I'm not allowed to do it, would it be possible?

Hi, first of all can I say that I'm not a techy, I'm a teacher but I'm as much of a geek as you lot I've got a system set up at school that works as an assessment tracker for the kids - it's basically a series of ASP pages linked to an Access database so I can set up tasks for the GCSE kids to do and then add their marks to it. That's simplifying it a little bit, but it's an overview. A major problem looming is that in September I'm going to have to update all of the pupils in the database. The SIMs.NET database will be updated of course, so my plan is to somehow tap in to that... I don't want to write to the SIMs database, just read from it from my webserver. Unfortunately, I haven't got a clue where to start. Has this been done by anyone on here before? Any pointers for help???