“What?” I hear you cry, a non-allotment based blog post? Yes indeedy… Well, if you head over to the Scholastic site, you’ll be able to order yourself a free copy of the National Curriculum in printed format.
As it says, the “National Curriculum for 2014 has now been released, but for the first time, it is available from the DfE in digital format only.
At Scholastic, we’re aware that a paperback copy of the Curriculum is a staple in many classrooms, so we’re giving away a FREE printed copy to every primary school in England”
So head over to the site and get a copy ordered.
I helped @chris_1974 out recently adding look up tables into an excel document. I did promise then to do a How-To on it, and here it is.
I have put together a google spreadsheet
that goes through it in step-by-step, but here are the instructions!
Step 1 – add names.
Step 2 – Set up the sheet. In the example I have put in, there are two assessments and one homework. It is always much easier if you know what the sheet needs to look like before you start. The look-up tables at the bottom are the grades. At this stage we haven’t done any formulae.
Step 3 – Add the data. Once you have your student’s scores in the table, you can add percentages (not important for vlookup, just FYI). Note, I the formula I have put in =C2/$C$9 has two dollar signs. If you put the dollar signs around the letter of the cell that is going to stay constant, you can drag the formula down to the rest of the cells.
Step 4 – Once the percentages are in, start on the grades. In the same way as I added dollar signs earlier, they become crucial here. The formula for the first cell is: =VLOOKUP(C2,$C$12:$D$18,2). What does this mean? C2 – is Adam’s score. C12:D18 is the data range we want to look up, and the 2 is the column you want to return in your cell. Once you have the first cell done, you can copy the formula down to the rest of the cells. Remember, when you are copying it to the ‘homework’ column, you will need to reset where you want the formula to calculate or it will give you duff results!
That is it!
If there are any other areas that I can help with, shout – more than happy to expand on the above!
Wow! How quickly did this happen?! I am very excited to be a small part of the Teach Meet Takeover plans for BETT 10. I promised on @tombarrett’s blog and on the wiki, that I would put up an idea as to the layout of the Scholastic stand (G40) so that you have a clue what you have to work with when talking.
- There is a large stage/presentation area
- There are two plasma screens with these, we are aiming to tick over a couple of slides to show who is talking at the time.
- There will be an Promethean interactive whiteboard.
- There is a lecturn area housing a PA system and the laptops.
- The PA system has a couple of radio mic’s / CD-player etc.
- Internet connection
- If there is anything else that is needed, let me know.
For other presentations on the stand, I was planning on recording and uploading to YouTube – I am more than happy to do the same for #tmtakeover – and equally happy to put the camera in a box and lock the lid!
As mentioned on Tom’s blog, when I was talking to Tom about this last week, I was very conscious of the concern about commercialism, and expectation about being sold things. One of the best things about TM (from a non-teacher perspective, but someone very interested in education) is that teachers inspire other teachers, without a hint of bias or overt commercialism, and I wouldn’t want that to be watered down at all. I am more than happy to look at what we can do to ensure independence and to try to mitigate the thoughts from people that they are being sold to. Now as you can see, it will be tough to take down the Scholastic logos, but I am happy to put up the #tmtakeover logo onto the plasma screens either side of the whiteboard (and on the iwb if that isn’t going to be used!), and to hand out fliers to explain what TM is all about. Let me know! You can get to me through twitter, skype (c.ratcliffe), email, smoke signals…
<a href="http://www.wordle.net/show/wrdl/1372361/www.scholastic.co.uk-understandingeducation" title="Wordle: www.scholastic.co.uk/understandingeducation" />
<img src=”http://www.wordle.net/thumb/wrdl/1372361/www.scholastic.co.uk-understandingeducation” alt=”Wordle: www.scholastic.co.uk/understandingeducation” style=”padding: 4px; border: 1px solid #ddd;” />