Archive for Excel

Excel VLookup

Sep 29, 2011 No Comments by Mat

  A short video on the use of VLOOKUP in Excel. A basic idea of a lookup table, and the worksheet returning the result from the lookup table based on the lookup criteria.  

Excel, Videos Read more

Excel IF

Sep 29, 2011 No Comments by Mat

A very short video on IF statements using Excel. (Sorry it’s Office 2000, although the code remains the same). Useful files for this video: IF Resources – ZIP

Excel, Videos Read more

Excel Absolute & Relative referencing

Sep 29, 2011 No Comments by Mat

  A beginners video to referening in Excel. This video covers absolute and relative referencing.  

Excel, Videos Read more

Categories

Latest

Encoding & Validation (AS)

  LO1: Students will describe theadvantages and disadvantages ofencoding data LO2: Students will describe and giveexamples of a range of validationmethods and their purpose   We collect data for a purpose. If the data that has been collectedcannot be organised in such a waythat it can be used for the originalpurpose then it is worthless. [...]

Information Sources (AS)

  LO1: Students will compare the use of staticinformation sources with dynamic sources LO2: Students will describe the effects of quality ofinformation produced: accuracy, relevance, age,completeness, presentation, level of detail   An information source is arepository of data that can beaccessed when required. There are two main types of information source: static and dynamic   [...]

Chromebook

My first day with the Chromebook.  An adjustment or rather a paradigm shift to the normal constructed view of how we use everyday computers. The focus of the Chromebook is not the platform or the hardware itself, but the in the infrastructure the Chromebook delivers, not a wondrous new device that will revolutionise the way [...]

Contact form working!

At last, Easyspace have fixed the problem: (A bit late!).   After escalation to our senior technicians it appears that there was a block initiated on the domain in November 2011 when the site was archived after it had been used to send large amounts of spam (ticket ref XXXXXXXXX). This bock is the reason [...]

Purple Spiders (Excel)

  This is a short video I used to help students to understand filtering and sorting data.       The video also includes VLOOKUP. I used this spreadsheet for the practical part.   Purple Spiders – Excel

Contact form issues

Sorry! I’m having contact form issues. Something do with the hosting / server. Hoping to fix this ASAP.   – 27/01/2012 Just updated the contact form. I’m using Google Docs for my contact form, until the server issues are resolved. Contact me here.

New stuff

  Apologies for the delay in adding new ‘stuff’ here. I’m hoping to get all of my A Level ICT (OCR) presentations and resources on here during January 2012. The next plan is to put all of my GCSE ICT (EdExcel) presentations and resources on here during February 2012. That is the plan at least [...]

Different Approaches (A2)

  A2 Level ICT 01 – The systems cycle > Lesson 01   LO1: Students will acquire the knowledge ofdifferent methods that can be used to gatherthe information during the investigation andanalysis stage LO2: Students will evaluate & improve softwaredevelopment methodologies: prototyping andrapid application development (RAD)   Download the lesson plan Different approaches.pdf    

Data Types (AS)

  AS Level ICT 01 – Data information knowledge and processing > Lesson 03 LO1: Students will acquire the knowledge and be able to describe different data types(Boolean, real, integer, string, date/time) LO2: Students will describe different sourcesfrom which data can be derived and explainthe advantages and disadvantages   Download the lesson - Data Types.pdf   [...]

Knowledge & Meaning (AS)

  AS Level ICT 01 – Data information knowledge and processing > Lesson 02   LO1: Students will acquire the knowledgeand be able to discuss representationmethods to convey meaning LO2: Students will describe what is meantby the term knowledge and distinguishbetween information and knowledge   Download the lesson - Knowledge + Meaning PDF