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
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.
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.
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.
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 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 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 was designed for Alevel Economics B Edexcel 1.3, however works for Economics A specs and Business Studies A Level.
The lesson goes through Supply and Demand, what causes movements? What causes shifts? Diagrams and practice exam questions.
The worksheets and presentation are enough for 3-4 hours worth of learning.
There is an addition lesson of price determination with exam practice and homework activity.
#Supply #Demand #Economics #EconomicsB #Shifts
Scratch Lesson 2. The Scratch SoL (Scheme of Learning) Lesson 2. This lesson introduces Scratch, Sprites and the software key areas.\n\nThe video guides allow students to be independent and are used as support/extension (Sorry for my annoying voice).
Lesson 5 of 6. Students are to create an audio slide where they must record phrases in their countries language and insert it into their presentation.\n\nSupport guides for recording using camtasia and useful websites to support students with translations included.
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 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.
A one off Adobe Flash lesson. The lesson goes through some of the basics and builds up to create a motion tween around the Olympic rings. Video guides included however they show how my school access the program.
Lesson 3 of 6 in an olympic ICT themed project. This lesson focuses on the student filling the presentation with information. Example minimum outcome included.
This is lesson one in a series of ICT KS3 lessons. Levels are included and taken from APP.\n\nStudents are to create a digital presentation which includes media. The presentation should convince the Olympic committee to host the 2020 games in their given country.\n\nCould be used cross curricular to deliver languages.
How Computers Work Lesson 5 - Year 8 Computing Scheme of Learning.\n\nThis lesson focuses on 'What is a Computer Network?'. The Networking Help presentation is the teach ICT website networking section broken down, I gave this to support weaker students.