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.
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 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.
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.
A simple to follow revision lesson that allows students to be completely independent with no teacher support needed. The revision spreadsheet gives the students 35 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:
Removing borders
Formatting cells
Editing cells
Functions COUNT, COUNTA and IF
Printing First Row Only
Header & Footer
Basic charts - Editing and labels
ECDL Theory questions inc. Error messages
Thousand separator
Autofil
Find
Editing worksheets
Gridlines
Margins
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.
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
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 takes around 3-4 lessons to complete. Lesson 1/2 is letter writing and CV layout. The spreadsheets have step by step guides on how to create them.
The mail merge task takes the students through mail merge with a video guide to support.
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.
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
This is an introduction to Scratch SoW suitable for KS2 and KS3. The lessons have a range of challenge, the other lessons all come with support material and video guides to allow independent learning.
This lesson covers an introduction to Scratch and Algorithms. Please purchase lessons 3 - 6 if you like them.
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.
This is a revision task I did with my student's after covering various topics in 6 weeks. The revision task covers standards, input and output devices, binary, memory and flow charts.
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.