Lesson Plan Mail Merge

Lesson Plan Mail Merge

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,
MrDaniels14
KS3 Computer Science - Binary/Denary Conversion - Worksheet

KS3 Computer Science - Binary/Denary Conversion - Worksheet

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.
MrDaniels14
A-Level Computer Science - Error Checking - Worksheet

A-Level Computer Science - Error Checking - Worksheet

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.
MrDaniels14
AQA GCSE Computer Science (8520) - Student Tracker

AQA GCSE Computer Science (8520) - Student Tracker

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).
MrDaniels14
A-Level Computer Science - Baudot Code - Handout

A-Level Computer Science - Baudot Code - Handout

This resource is aimed at students looking at Encryption methods, specifically the Vernam Cipher. This is a copy of Baudot code that students would need to use to carry out the logical XOR with their keyword to produce the cipher text for their encrypted message. Whilst they are not required to know Baudot code, being able to more easily recognise this in preparation for their exam is useful.
MrDaniels14
A-Level Computer Science - Fixed Point Binary - Worksheet

A-Level Computer Science - Fixed Point Binary - Worksheet

This resource is aimed at students studying A-Level Computer Science and 20 questions on converting a given Fixed Point Binary number in Denary and a further 20 questions converting a given Denary number into a Fixed Point Binary number. It also includes the associated answer sheet.
MrDaniels14
A-Level Computer Science - Set Operators/Set Comprehension - Help Sheet

A-Level Computer Science - Set Operators/Set Comprehension - Help Sheet

This resource is aimed at students studying A-Level Computer Science and contains most of the common symbols they will come across when learning about Set Operations and Set Comprehension. This will save them time when constructing set comprehensions or set operations as they will be able to copy and paste the required symbols out of this document. It will also strengthen their understand of what each symbol means.
MrDaniels14
GCSE Computer Science - Calculating Image File Sizes - Worksheet

GCSE Computer Science - Calculating Image File Sizes - Worksheet

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.
MrDaniels14
A-Level Computer Science - Data Representation: Binary

A-Level Computer Science - Data Representation: Binary

This bundle contains a series of resources aimed at teaching A-Level Computer Science students about the different conversions and calculations required for A-Level data representation topics. It covers Addition, Subtraction (using Two's Complement), Multiplication, Two's Complement conversions and Fixed Point fractional binary.
MrDaniels14
GCSE Computer Science - Data Representation: Representing Bitmap Images - Worksheet

GCSE Computer Science - Data Representation: Representing Bitmap Images - Worksheet

This resource is aimed at students studying GCSE Computer Science. The worksheet contains a space for students to write down the key definitions for Bitmap image file types. It then provides a space for students to carry out some independant research into common resolutions. It then provides students with 2 image grids which contain strings of binary numbers which must be coloured accordingly in order to produce the associated image. The associated answer document is also included.
MrDaniels14
AQA GCSE Computer Science (4512) - Component 2 - Checklist & Tracker

AQA GCSE Computer Science (4512) - Component 2 - Checklist & Tracker

This is a collection of 2 resources designed to aid in the tracking and monitoring of students who are completing the AQA GCSE Computer Science (4512) Specification. In Component 2 of the specification students are tested on a range of different theoretical elements relating to Computer Science. With this checklist and tracker you will be able to keep track of how much progress each individual student has made across the course content. The checklist can be given to students to fill in, they aim should be to fill in the Student column with either a Y, a P or an N. - If they have answered Y, this means they feel confident with this point on the specification. - If they have answered P, this means they understand some of the content for this point of the specification. - If they have answered N, this means that they do not understand any of the content for this point of the specification. There is also a column available for the teacher to make a mark, again, either a Y, P or N is useful here. This is useful for formattive assessment of how well you think the student is doing with the theoretical content. After you have collected the data from the students you can enter this data in the tracker (this is meant to be a working document, so the checklist in student’s folders gets updated regularly as does the tracker.) The student’s names and GCSE target grades should be entered at the top of the spreadsheet. Then for every point on the specification for every student, you need to enter either y, p or n (lowercase). Once this is done, you will find that each section will show a percentage of how much of the specification has been completed for that student and at the top of the page, you should see a working grade based on how much of the content they have covered (this will only show their overall progress against the whole specification).
MrDaniels14
AQA A-Level Computing - COMP4 Markbook

AQA A-Level Computing - COMP4 Markbook

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.
MrDaniels14
Data Representation - Binary Units of Measurement

Data Representation - Binary Units of Measurement

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
MrDaniels14
GCSE Computer Science - Data Representation: ASCII & Unicode - Worksheet

GCSE Computer Science - Data Representation: ASCII & Unicode - Worksheet

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).
MrDaniels14
GCSE Computer Science - Data Representation: ASCII Table - Handout

GCSE Computer Science - Data Representation: ASCII Table - Handout

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.
MrDaniels14