Blog moving

So, after a few years here I've finally gotten around to dealing with the horrible images not showing at work issue.

The only way I seem to be able to solve this is to start blogging somewhere else.

So, the new blog can be found over at Wordpress. Probably.

This stuff'll stay here for a while at least as it might be vaguely useful for someone or other. But the new stuff'll be there from now on.

Spreadsheet Work Stuff

Henry asked for a list of stuff he had to do...

Here's a list:

1. get a timeplan together (row A)
2. make sure you have all your client intro stuff done (row B)
3. check your client needs (row C part 1) is done
4. come up with some evaluation criteria (row D)

Then...

5. get a prototype spreadsheet up and running (do not include this in your timeplan!)

Then...

6. check your client needs and evaluation criteria still make sense. Add anything in you need to (and delete anything you need to as well)
7. check your client intro makes sense as well - you might need to tweak this

Then...

8. do the inputs, outputs, processing section (row C part 2). This needs to be quite detailed. Anything anyone types in (or uses the mouse) on the prototype is an input for example. Most inputs will produce outputs (at least to the screen) and may well lead to processing.
9. develop annotated designs (row E). This will take a while
10. show the designs to your client and get them to write on them. Each one needs to at least be signed off
11. they have to ask for changes on at least some of the screens (these can be cosmetic or can be in the functionality of the spreadsheet (what it does...)
12. produce final annotated designs taking into account the changes
13. produce a detailed test plan (row F)

That's the prep work done. The designs will take ages and can be really frustrating. As ever, That Blue Square Thing has some suggestions.

In the exam time you will need to produce the spreadsheet, test it (documenting every test you do) and produce screenshots demonstrating what you have done. Then there'll need to be an in depth evaluation section.

Blackberry crumbles

See what I did with the title there? :-)

So, it seems Blackberries stopped working today. I didn't know until some of my Year 11 class period 5 told me about it - just as I'd asked them to scan a QR code to make life so much simpler for everyone concered - me included.

This EDP article seems to explain vaguely why.

Now, back to my old fashioned Nokia which, of course, kept working. Not that I had it turned on...

Accessible computing

One of the key things you need to be able to write about is how users with specific needs can make use of ICT.

Specific needs means users who need some form of assistance to use ICT. They might be partially sighted or blind for example. Other key specific needs might include hearing loss or some form of motor (or movement) disability. All of these needs can make some ICT devices or applications difficult, or impossible, to use to their full potential - a YouTube video, for example, may not be effective without subtitles for a hearing impaired user, whilst a visually impaired user may find it difficult to use the keys on a phone keypad to send an SMS.

In order to use ICT more effectively it sometimes needs to be adapted to meet a users needs.

There are a range of ways this can happen - sometimes content can be adapted, for example by adding subtitles - whilst at other times specific software or hardware needs to be used. Examples include screen reader software for visually impaired users or adapted pointing devices to replace a mouse for users with motor disabilities.

It's important to find out a bit more about this sort of stuff, so here are some quite useful places to start looking, maybe...

• How disabled users access the Internet - Webcredible has a pretty useful summary of some internet related stuff
• Screenreaders at See The Difference - a very short summary
• Smartphone cameras bring independence to blind people - a recent article from the BBC
• The RNIB has some helpful guidance on using film, TV and radio, with examples of adaptive technology
• The BBC website has an accessibility guide which might be both useful and interesting

Legal Man

Some links to useful stuff for the legal bits and bobs that you need to know about...

• Data Protection Act - the ICO; Wikipedia
• Computer Misuse Act - GCSE Bitesize (actually v useful - page 2 has more stuff); Wikipedia
• Copyright, Designs and Patents Act - UK Copyright Service; Wikipedia
• Health and Safety at Work Act - the HSE page; Wikipedia
• Regulation of Investigatory Powers Act - Guardian (and it explains it too); Wikipedia
• Health and Safety Regulations (focus on the 1992 regs) - Knolwedge Base; Wikipedia
• Freedom of Information Act - the ICO; Guardian; DirectGov; Wikipedia
• Disability Discrimination Ac/Equality Act (NB: in 2010 the Equality Act largely replaced the DDA) - DirectGov; Wikipedia (DDA); Wikipedia (Equality Act)
• Digital Economy Act - Wikipedia; the Guardian has a whole section on the DEA; BBC

As the man said,

Get out of the city and into the sunshine
Get out of the office and into the springtime

Number Plate Recognition Kerfuffle in Birmingham

Automatic Number Plate Recognition and CCTV are used all over the place. When I drive into John Lewis' car park in Norwich I get scanned by both (I think - ANPR certainly). In many cases it's Quite Useful, I suppose, but things aren't always as straight forward...

It seems that in Birmingham in 2010 CCTV and ANPR was being targeted at areas with high muslim populations. Hmmm, now that strikes me as "dodgy" at least - to start with it's indiscriminate surveillance of everyone.Not to mention a potential breach of human rights legislation.

It's interesting (although complex) to consider quite what happens when ICT and human rights laws collide. We can (and do) monitor loads of stuff using ICT - your ISP is probably monitoring, in a way, whatever you do each time you use Google. If you're reading this blog at school then there are certainly people monitoring what you're doing. Are they infringing your human rights? Or are they just making sure you're not up to something illegal or unwise?

In this case, the authorities soon backed down and cancelled the scheme (I was tempted to write 'idea', but I'm not sure they had much of one really. The legal case against the scheme looked sound and it would have been difficult, at least, to justify that much surveillance of ordinary people without any form of intelligence (but, then, I watch Spooks remember...).

A report into the scheme, published in September of 2010, concluded that it was, indeed, largely illegal and had little justification. It highlights, however, the difficulties that the "authorities" have with the potential to use ICT and the legal safeguards which protect all of us. How far should they go? Compared with how far they could go?

The newly elected Tory/Liberal Democrat coalition Home Secretary, Theresa May, called for a significant reduction in the use of CCTV and ANPR in July 2010 - interestingly just after the Birmingham scheme was withdrawn. I'm not entirely certain how that fits with the publication of CCTV images after the inner city riots of the summer of 2011 though - seems that the government thinks CCTV is good some of the time but not all of it.

And I'm not quite sure how they square the legal and ethical circle of that.

The "I never knew how to do that" column #23

Here's some cool stuff that, maybe, you never knew about. Trust me, worth a look.

These are all videos with sound and stuff btw...

RSS Feeds and how they work and why they're useful for you, perhaps

Wikis and what they do (and maybe why you should be interested)

Social Bookmarking. Trust me on this - very cool idea, although I have no idea if you'll be able to use it at school.

Some interesting reading...

Ah, a blog post. That's interesting in itself.

Some links to take a look at to explore some of the recent stories that I find Quite Interesting. This generally falls under the category "Stuff that's happening that you should maybe know a little bit about for Unit 1".

Facebook changes and the impact on you? Maybe - Your life on Facebook

A thing about gaming in 'The Cloud' and it's potential for changing the way we use the Interwebz - OnLive cloud gaming comes to UK

How to unlock a car with an SMS? Yes, it seems possible. 


The arrest of a LulzSec hacker - which is possibly something you need to be aware of.

Let's go with that for now.

Sum in reports

Easy - just do a textbox with =sum(nameofthefield)

BUT

make sure it's in the Report Footer - not the Page Footer!

Searching for a blank field

Sometimes you want to search for fields which have been left blank - say you've put the date a job was completed on.

All you do is add the criteria of Is Null (the space is important!!!) and it'll do it.

Personally I'd tend to suggest using a Yes/No field to record if it's been paid for this sort of thing, but sometimes client needs mean you need to record the actual date.

Versions of Access

Here's the version screenshot (assuming it actually shows - sometimes blogs and stuff can be tricky to show images):

You must be really old...

Well, quite.

All that new fangled mobile technology stuff eh?

Interesting article that's actually about an economic summit thingy (Davos, which isn't the name of the chief bad dalek from Dr Who fwiw) but is actually a bit of a commentary on why mobile devices are arguably much more important than those big old fashioned PC things. Which I guess you probably sort of new. But, like, I'm far too old...

One top politician at Davos tells the story of how she visited a technology bootcamp for teenagers, and was stunned when the youngsters freely swapped computer code with competitors. When she challenged one of them, he said "you must be really old" and told her that the swap would make both projects better.

Which, I guess, is part of that awfully old fashioned idea that the best thing about technology is it's openness - and that only dinosaurs try to close it off too much.

Paying with your mobile

Hmm, interesting- paying for stuff using your cell phone.

It's all part of the way in which ICT can help people to use stuff more efficiently. Why do you need a wallet full of cards when you have a cell phone and the ability to pass information over short distances securely? Everything, Penny, is better with bluetooth (although this might be using RFID...)

Some half decent links from the news report as well.

Data Protection and Charities

The Jan 2011 paper needs you to be able to write about the risks to charities of using the interwebz. It specifically requires you to write about the "relevance of the Data Protection Act to charities".

I'm sure there is lots about this on the interwebz. Lots and lots.

The Conversation:
I had a question. The question went like this:

"Hey, Mr F dude, this booklet thingy I printed off the interwebz, it's about the Data Protection Act. It's wikid, look - it tells you everything about the Data Protection Act and charities. Kewl eh?! Blud"

My reply:

"Hmm, Emily, this appears to be from the Isle of Man. I wonder if their Data Protection Act is the same as the UK one"

And, guess what? They're similar, but not exactly the same.

So - be careful where you're getting your Data Protection Act information from! Lots of places have something called very similar.

The Happy Ending:
As a result of  our conversation, I wandered over to the Information Commissioner's Office website (that's the dude who is in charge of Data Protection in the UK - so we know this is a pukka source). If you go there you'll see it has a search bar at the top right. Try typing charities into it and hitting the search button.

Make sure you're looking for the right sort of information:

• what the data protection is - it's date and that sort of general background
• what charities have to do to comply with the data protection act
• why they need to comply with it
• what might happen if they don't

OK?

DPA - fines

Just some news about fines for organisations found breaching the conditions of the Data Protection Act which could be useful.

Commissioner issues first Data Protection Act fines

Charity and Facebook

Might be useful for ICT 01 exam in January 2011...

Pudsey and the social networks

Online Newspapers - examples to use

Yahoo has a handy list of newspapers by country - you could use this to find newspapers that other people haven't looked at perhaps.

The Big Project has something similar.

I've looked at the Beccles and Bungay Journal (I chose it because I know it's a nice small site and a very local newspaper), the Nome Nugget (because it's very small and easily doable - and it has a kewl name) and the Derry Journal (because I thought it might have some interesting features) as well as the West Highland Free Press (just because).

You probably don't need as many as that.

Index for a Word document

Someone, let's call her "Jodie"*, was having some difficulties producing an Index in Word. Neither I or my Evil Assistant had ever used Word 2007 to produce an Index before. We couldn't find "Mr Glitter" who knows what he's doing with such things.

So I used a "Popular Internet Search Engine" to find this awfully useful page from the Dummies (no, not those ones, the real ones) about how to do an Index.

That page used a keyboard shortcut to mark each index entry. You can use that, sure (as everyone knows, keyboard shortcuts are the coolest thing this side of Oslo) but you might find it easier to go References > Mark Entry (on the right). Mild!

Check the Tips bit at the bottom for a handy Mark All tip. Trust me.

*Jodie's name has been anonymised in this blog post.

Colour Swatch Generators

There are lots of interesting ways to find colour swatchs and to try out possible colour combinations - particularly useful for websites.
Try:

Colourschemer
Colours on the web colour wizard
Colour scheme designer
Colour combos (scroll down)

Or try searching using a popular internet search engine...

BBC Connect - useful resource for Data Protection stuff?

Might be a useful starting point - http://www.bbc.co.uk/connect/needtoknow/your_rights.shtml