This is a revision lesson. The activity presentations have hidden slides, run the presentations and click the hyperlinks.\n\nThese revision activities cover binary, hardware and software, input and output.\n\nNo objectives, students were asked to create their own.
How Computers Work Lesson 6 - Year 8 Computing Scheme of Learning.\n\nNetwork layout activity. This task can be used as assessment.\n\nLayouts covered -Star Network, Ring Network and Bus Network.\n\nThe support material for students can be found in lesson 5.
How Computers Work Lesson 4 - Year 8 Computing Scheme of Learning.\n\nThis lesson introduces Binary (5 Bit). This has been customised for my lessons so a little bit of editing maybe need. \n\nAt some point I will upload a new spreadsheet which is uplocked so it can be edited.
How Computers Work Lesson 2 - Year 8 Computing Scheme of learning. \n\nThis lesson focuses on what is inside the computer. Levels are based losely on APP/Own school computing leveling system.\n\nI 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.\n\nIf the video does not work search for 'Computer Basics Inside a Desktop Computer' on youtube.
An intro to Binary for year 7 students. This was developed as a 20 minute interview lesson. It got fantastic feedback.\n\nBinary Code James Bond Computing Computer Science 1s 0s How Computers Work.
Keystage 3 Computing Scheme of Learning. \n\nAimed at Year 8 students, can be adpated for whole KS3.\n\nLesson 1 focuses on 'what is a computer' and input/output devices.\n\nThis scheme of learning looks inside the computer.\n\nKS3 Computing.
Assessment lesson.\n\nKeystage 3 Computing Scheme of Learning. Aimed at Year 8 students, can be adpated for whole KS3. \n\nThis scheme of learning looks inside the computer. KS3 Computing.\n\nThere 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.
How Computers Work Lesson 3 - Year 8 Computing Scheme of Learning.\n\nThis is a continuation from lesson three. Students to complete their hardware presentation to allow teacher assessment.
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.
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 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 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 lesson is designed for a mixed group of year 7 students. Main topics included are:
- What is a computer?
- Inputs
- Outputs
What is lesson includes:
- Starter activity
- Teacher presentation
- Main activity (cut&stick)
- Extension work
- Possible homework
This self marking assessment spreadsheet covers the following topics:
Storage methods
Data conversion
RAM/ROM
Logic gates/Boolean Logic
At the end you can get the students to click the “results” button and they enter a password" test123". This will generate a sheet that can be printed and put in a students book/folder/documents.
I used this as a 30 minute starter task to assess students knowledge before revision lessons.
Covers areas of the GCSE OCR Computer Science specification. Would also be a good extender/push task for KS3.
These differentiated guides are designed to support students with the Cambridge Nationals R002 coursework (Microsoft Access 2013), however these can also be used with any students doing database work.
The guides take through the following skills:
Importing data
Editing records
Adding records
Deleting records
Creating basic queries
Sorting data
Adding a field
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 two lessons cover the majority of the ECDL Excel content. See individual lessons for skills breakdown. Each activity comes with short video guides to take the students through the questions allowing for complete independence.
2 extra Mail Merge lessons for Word ECDL included as a freebie.