An intro to Binary for year 7 students. This was developed as a 20 minute interview lesson. It got fantastic feedback.
Binary Code James Bond Computing Computer Science 1s 0s How Computers Work.
How Computers Work Lesson 2 - Year 8 Computing Scheme of learning.
This lesson focuses on what is inside the computer. Levels are based losely on APP/Own school computing leveling system.
I taught this with a practical element. Actual hardware components were scattered around the room for students to look at and several PCs had their cases removed to allow students to apply what they had learnt.
If the video does not work search for 'Computer Basics Inside a Desktop Computer' on youtube.
Keystage 3 Computing Scheme of Learning.
Aimed at Year 8 students, can be adpated for whole KS3.
Lesson 1 focuses on 'what is a computer' and input/output devices.
This scheme of learning looks inside the computer.
KS3 Computing.
This is a revision lesson. The activity presentations have hidden slides, run the presentations and click the hyperlinks.
These revision activities cover binary, hardware and software, input and output.
No objectives, students were asked to create their own.
How Computers Work Lesson 6 - Year 8 Computing Scheme of Learning.
Network layout activity. This task can be used as assessment.
Layouts covered -Star Network, Ring Network and Bus Network.
The support material for students can be found in lesson 5.
This is designed for GCSE Computer Science Bubble, Merge and Insertion Sort Exam Questions.
The spreadsheet is self marking and gives the students an example of a finished sort.
It follows the same format as the OCR GCSE Computer Science Exam Answers.
This task takes students through a mock assessment. There are 30 questions which cover:
Mail Merge
Paragraph formatting
Line spacing
Automatic Hyphenation
Tables
Subscript/Superscript
Bullet points
Dates
And more..........
Each question comes with a short video to support SEN/Weaker students and allow them to be independent learners.
How Computers Work Lesson 4 - Year 8 Computing Scheme of Learning.
This lesson introduces Binary (5 Bit). This has been customised for my lessons so a little bit of editing maybe need.
At some point I will upload a new spreadsheet which is uplocked so it can be edited.
Assessment lesson.
Keystage 3 Computing Scheme of Learning. Aimed at Year 8 students, can be adpated for whole KS3.
This scheme of learning looks inside the computer. KS3 Computing.
There is a tab at the bottom called 'results'. This show the answers and marks the work. I usually have this tab hidden and use a macro 'Ctrl+Shift+R' to unhide it when students have finished, however TES does not allow macro enabled workbooks to be uploaded.
This task takes students through a a range of questions for the ECDL Improving Productivity Exam practical section. It includes activities on Word, PowerPoint and Excel skills.
Some of the skills covered are....
Importing Data
Charts
Functions and formulas
Mail Merge
Moving data from one software to another
And Many More More.....
Each question comes with a video that takes the student through the question. This supported SEN/Weaker students and allowed them to be independent in the lesson.
This task takes students through a mock assessment. There are 32 questions which cover:
Master Slide
Header and Footers
Usernames
Slide layout
Charts
Smart Art (Hierarchy Charts)
View settings
Save types
And More.....
Each question comes with a video that takes the student through the question. This supported SEN/Weaker students and allowed them to be independent in the lesson.
This bundle includes a revision lesson for ECDL Word, Excel and PowerPoint. Each lesson comes with video guides which take the student through the activity allowing them to be completely independent.
Please see individual lesson for the skills breakdown.
This is an assessment lesson for scratch cover the areas in lesson 1 - 5. The lesson comes with a presentation creation guide, video support and worksheets.
A simple to follow revision lesson that allows students to be completely independent with no teacher support needed. The revision spreadsheet gives the students 30 short questions that link to the ECDL Excel exam. Each question comes with a short video that shows the students how to do the question if they get stuck.
There is a progress checker so students can monitor their own progress throughout the lesson.
The skills this lesson covers are:
Merge & Center
Double bottom border
Alignment
Formatting cells
Inserting rows and changing their size
Basic formula
Functions including SUM, AVERAGE, MIN, MAX, COUNT AND COUNTA
Setting the printing page size
Header & Footer
Sorting
Filters
Basic charts
These are 3 differentiated booklets which go through the following:
Gross Profit Percentage
Net Profit Percentage
Return on Capital Employed
Current Ratio
Acid Test Ratio
Debitor Payment Period
Creditor Payment Period
There are practical examples included and a large 10 mark exam question.