
![]() |
Access_Teaching_Lesson_1 Posted by: JackBarnett21
Video duration: 419 seconds This is an introduction to Access Relational Databases. It begins by creating a very simple table and adding records. Subsequent lessons will develop the subject. Thank you. Related: access_teaching_lesson_1 |
![]() |
New Year's Eve 2008 actual Big Ben strikes Posted by: JackBarnett21
Video duration: 141 seconds The countdown - London Related: 2008, actual, ben, big, countdown, eve, fireworks, new, strikes, years |
![]() |
Excel Teaching - Lesson 1 - Formatting cells Posted by: JackBarnett21
Video duration: 521 seconds This Excel lessons takes you through the basics of Excel while looking at a basic spreadsheet. It is worthwhile to enlarge the video to fullscreen size. Related: cells, excel, formatting, lesson, teaching |
![]() |
Excel Teaching Lesson 9 Vlookup HLookup etc Posted by: JackBarnett21
Video duration: 363 seconds I have tried to explain the following things. VLookup, HLookup, Average, Sum, Min and Max. Also how to move numbers from one cell to another by just typing = and then clicking on the relevant cell. Related: and, average, excel, hlookup, lesson, max, min, sum, teaching, vlookup |
![]() |
Reading 4 English important letter / sound combinations Posted by: JackBarnett21
Video duration: 205 seconds This is looking at the sounds made when the five basic sounds are combined together. It is a start on these. Suggestions for future inclusions are welcome. Other lessons that might be useful are English 1, English 2, and English 3. Please feel free to contact me if there are any points you would care to raise. Jack Related: combinations, english, important, letter, reading, sound |
![]() |
Excel Teaching - Lesson 5 - Concatenation - Handling text Posted by: JackBarnett21
Video duration: 477 seconds This Excel video is going to teach you how to take text in Excel and to manipulate it. You can take the first name, the second name, count the letters and so on. This is the kind of teaching session you will need to run more than once to pick up what is to be done. Enlarge the screen to see this video at it's best. Related: arts, concatenation, excel, handling, lesson, performing, teaching, text |
![]() |
King's Troop (Royal Horse Artillery) London UK Posted by: JackBarnett21
Video duration: 158 seconds Early one fine autumn morning the King's Troop (Royal Horse Artillery) were practising in the Inner Circle of Regents Park. There is something very special about people working so closely with such lovely beasts. Related: royal, artillery, circle, horse, inner, kings, london, park, regents, troop |
![]() |
Excel Teaching Lesson 12 Conditional Formatting Posted by: JackBarnett21
Video duration: 582 seconds What is happening in this lesson is that if the figures in Excel are important then you are able to set Excel so that it changes the colour around the figures. For example if you were measuring temperature and you wanted to show the moment the temperature dropped below zero - then you would change the 'conditional formatting' so that it showed the - minus figures with a blue surround. Related: 12, conditional, excel, formatting, lesson, teaching |
![]() |
Nelson Mandela welcome by Ken Livingston - London Posted by: JackBarnett21
Video duration: 75 seconds Ken Livingston, the Mayor of London, spoke about the challenges of getting a statue in somewhere central in London and then they chose Parliament Square. The Prime Minister, Gordon Brown, Richard Attenborough both sat on the platform with Nelson Mandela and his second wife, Dame Mandela. Related: by, ken, livingston, london, mandela, nelson, parliament, square, welcomed |
![]() |
St Pancras Internation the night before opening Posted by: JackBarnett21
Video duration: 165 seconds "I went back to St Pancras the night before it was due to open to the public on 13th November, hoping to see the statue of Sir John Betchaman. The trouble was this was in a section not open till the 14th. Twas ever thus." The roof was astonishing, painted in a light blue. Vast. Related: 13th, 2007, international, november, pancras, railway, st, station |
![]() |
Fireworks on the Embankment New Year's Day 2008 Posted by: JackBarnett21
Video duration: 89 seconds Here is a fraction of these fabulous fireworks. They were amazing. I have seen firework displays in Hong Kong, Dubai and England. These London fireworks were the absolute tops. Well done Ken Livingstone. Me and at least 50,000 other people enjoyed them tremendously. Related: 2008, embankment, fantastic, fireworks, jan1 |
![]() |
Trafalgar Sq fall from fountain - police strip arrest Posted by: JackBarnett21
Video duration: 161 seconds Two men push one another into the fountain, then climb the fountain, sit on the fountain, and then begin to strip. Crowds gather then police come,(you can see the two bike policemen in bright yellow in the background), but one fountain man falls from the concrete fountain, he's ok - he gets out of the water and they leave. (see also Video 1 from same user for closer shots of these two guys) Related: arrest, bathing, biking, fall, fountain, from, london, police, square, strip, the, trafalgar, uk |
![]() |
Access Teaching Lesson3 Frontsheet Posted by: JackBarnett21
Video duration: 518 seconds Having created a database it would be useful to direct anyone using it to the vital parts without them having to go to the mechanics of the programme. Hence the production of a Frontsheet. This is what this lesson takes you through. Related: access, creating, frontsheet, lesson, teaching |
![]() |
Queen Mary College London University Graduation Posted by: JackBarnett21
Video duration: 61 seconds Here is part of a graduation ceremony at Queen Mary College in the People's Palace part of London University. Related: college, graduation, london, mary, queen, university |
![]() |
Excel Teaching Lesson 13 Sumif, Rank and Countif Posted by: JackBarnett21
Video duration: 365 seconds This video looks at the use of Sumif, Rank and Countif. You can see how each of these is used and you should attempt to replicate this. Related: 13, and, countif, excel, lesson, rank, sumif, teaching |
![]() |
Excel Teaching Lesson 6 Nested IF Posted by: JackBarnett21
Video duration: 211 seconds This lesson in Excel, takes a simple IF statement and Nests it three times to make it quite a complex thing. You should try it out with Excel. Related: excel, if, lesson, nested, statement, teaching |
![]() |
Excel Teaching - Lesson 2 - Addition Posted by: JackBarnett21
Video duration: 182 seconds This lesson takes you through the simplest means of adding in Excel. It not only uses the Autosum, (also known as the Sigma sign). It shows how to use the 'drag' cross to repeat 'addition' down through the rows. Related: addition, excel, lesson, teaching |
You like it? Share it!