In order to reduce the amount of time spent creating lessons plans during my PGCE I created an excel spreadsheet where I filled in the necessary section of my lesson plan. This then auto-populates into the lesson plan template so it is ready to be printed off. I did this to save time and also to reduce on the amount of files I need on my computer. This way I only need 1 Word Document and 1 Excel Spreadsheet for all my lesson planning. Also attached is a little help guide I made to assist with those who struggle to mail merge documents,

**A digital alternative to the traditional teacher planner. ** This is an excel spreadsheet with space for all of the usual information that would go in a physical teacher planner. Sections M1 to F2: There are 10 worksheets designed to represent the 10 days on a 2 week timetable (from Monday - Week 1 to Friday - Week 2). Each worksheet has space to plan for a 5 lesson day with the lesson times given in the first main column. There is also space for notes to be made for tasks that need to be completed before, during and after school such as lunchtime clubs and/or meetings etc. You simply need to write the date for the current Monday in the cell next to Monday and this will adjust the dates automatically for the rest of the week, there is also a space for you to write down the current half term e.g. “Spring Half Term”. On the F1 and F2 worksheets there is a button titled “Save & Reset”, when clicked this button will save the contents of the current teacher planner into a PDF document - details on how to set this up are shown below. Jobs: The jobs worksheet allows you to list tasks that need completing by specific dates. Simply write the task in the “Task” column and the deadline in the “Deadline” column. This will then tell you the amount of days you have remaining to complete this task. It will also give you some coloured warnings when you are getting close to the deadline AND when the task is overdue. If you complete a task, simply enter a “y” in the “Done?” column and this will turn that row Green. If you click the “Organise Jobs” button, this will move all the completed jobs to the bottom of the page and organise the remaining jobs by date priority. HW: The homework worksheet will display the lessons you have got on that specific day, all you simply need to do is enter the first Monday of the academic year in cell C3 - this will then automatically adjust the calendar for the remainder of the year. Where it says “Week 1” or “Week 2” simply choose which week it is and the sheet will change the lessons accordingly. Det: The detentions worksheet is a space to record any detentions that have been given out during lessons. There are also some additional columns that can be made use of to record arrival of students at detentions and to calculate the time their detentions end. There is also a handy check column to make sure you have recorded their behaviour onto the appropriate system. TT: Lastly, the TT worksheet is where you should enter the details of your timetable. Once you have done this the next time you “Save & Reset” it will clear your worksheets and reset them to the correct lessons. This worksheet is used to populate any data in the rest of the workbook that requires the lessons you teacher during your working day. You can also make comments about

This excel and word document combination is designed to be used to allow you to track and monitor the progress of students as you navigate through the theory elements of the AQA GCSE Computer Science (9 to 1) specification. In the word document there is a space for the students to note down their level of confidence with each of the points off the specification, there is also space for them to update this level of confidence as you revise/go over topics with them. The excel document gives the teacher the opportunity to enter a value of between 1 and 10 for each point on the specification to allow you to track the progress of the students with each part of the theory topics. It will break down each point on the specification and will show you roughly what percentage they have attained for each section of the theory course. It will also provide a working at grade (this is just calculated from all of the percentage understanding values from each section). UPDATE: 30/09/2018 - This resource now also includes an alternate version of the tracker to be used as a “Personalised Learning Checklist” with spaces for both the student and teacher to make comments. The “Book Chapters” mentioned on the PLC reference the AQA Computer Science for GCSE Students textbook by Hodder (Sean O’Byrne, George Rouse).

This resource is aimed at students studying GCSE Computer Science. The worksheet contains a space for students to write down the main steps required to calculate the file size of a given image file. It then contains 10 questions (3 of which are worked through) that require them to calculate the file size of the image. It also contains the associated answer sheet. NB: The measurements for KB, MB, GB have been used as multiples of 1000 as per the new 9-1 specifications.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This worksheet is for Unit 1 - The Online World: Learning Aim B - Client & Server-Side Processing.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Client & Server-Side Processing.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Transmission Modes & Methods.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Network Connections.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Network Diagrams.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Email Protocols.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Data Exchange.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - HTML.

This resource is for the BTEC Level 2 First Award in Information & Creative Technology course. This specific worksheet is for Unit 1 - The Online World: Learning Aim B - Network Protocols.

This resource is aimed at students studying GCSE Computer Science and contains all of the Denary, Hexadecimal and Binary codes for all of the original 128 ASCII characters, alongside the character symbols and a description of each symbol. It also contains details about a possible Extended ASCII set with some descriptions, alongside their equivalent Denary, Hexadecimal & Binary codes.

This resource is a worksheet designed to help students learn the different units of measurement of Binary numbers. They will start off small learning the correct term for 1, 4 and 8 Bits of data and then start moving towards the larger denominations for Kilo, Mega, Giga-bytes etc. At the bottom of the worksheet there is a couple of extension questions aimed at improving the students knowledge of data representation by trying to find some real life applications of these terms. I have also included the answer sheet. PLEASE NOTE: This version of the worksheet is designed to teach students the correct definitions for variations of 1000. There is also a different worksheet for the 1024 variations that will teach students the correct definitions for Kibi/Mebi/Gibi-bytes. Files included: - Data Representation - Binary Units of Measurement - Data Representation - Binary Units of Measurement - ANSWER SHEET

This is a resource aimed to be used with students in KS3 to test their ability to convert to and from Binary and Denary/Decimal numbers. Section 1 - Binary to Denary/Decimal The first section of the worksheet starts with getting students to convert an 8 bit binary number into its equivalent denary value. After they have complete these there are a couple of extension questions that get them to try and expand their understanding by finding out what the next column headings are for the binary numbers that come with 10 bits and then 12 bits. Section 2 - Denary/Decimal to Binary Once students have been shown the way to convert from Denary/Decimal into binary there are a series of conversions that they must carry out to create the binary string from the given denary/decimal numbers. If they finish the main section, there are 2 small extension sections that get students to try and develop their conversion skills by converting number that require 10+ bits. There is also one questions that requires them to use 16 bits. I have also included the answer sheet for both the conversions so you can go through the answers with the students in class.

The attached resources is designed to help you monitor and track students’ progress through the COMP4 project. There are 7 sections in the overall project, each of these sections is given its own spreadsheet worksheet. The 7 sections for each tab are: Analysis, Design, Technical Solution, System Testing, System Maintenance, User Manual, Appraisal Each cell is formatted using conditional formatting to give you a quick visual representation of how well the student in progressing through their project: - If you enter Y the cell will go Green (Section Complete) - If you enter P the cell will go Yellow (Section Partly Complete) - If you enter N the cell will go Red (Section Not Attempted). Based on the amount of sections completed you can then award the student a suitable mark for their work. On the final worksheet there is a summary of the students grades across all 7 sections and then a predicted grade based on the grade boundaries from the AQA past grade boundaries for COMP4 coursework. The content has been created from the Project Log PDF supplied by AQA.

This worksheet is designed to allow students to broaden their knowledge of the ASCII and Unicode character coding schemes. The worksheet contains several questions about the history of ASCII as well as some about how many bits it uses to represent data. The worksheet then moves onto looking at Unicode and getting the students to use the Unicode website to find and retrieve details about specific Unicode characters. The worksheet conclused with a 4 mark questions that asks them to discuss the advantages and disadvantages of ASCII & Unicode. This download also contains the accompanying answer sheet (for everything except the 4 mark question).

This resource is aimed at students studying A-Level Computer Science and provides students with a series of questions aimed to enhance their knowledge of the 3 different error checking methods including Parity Bits, Majority Voting and Check Digits. The worksheet contained 40 questions for Parity Bits, 40 questions for Majority Voting and 40 questions for Check Digits. It also includes the associated answer sheet.

This resource is aimed at students studying A-Level Computer Science and contains 56 conversion questions between Two's Complement Binary & Denary and between Denary &Two's Complement Binary. It also includes the associated answer document.