KS3 Databases in MS Access with Work Booklet

KS3 Databases in MS Access with Work Booklet

A complete Scheme of work for teaching MS Access/Databases to KS3. The booklet includes "I Can" self levelling that is ready for life without levels. Students are levelled using using Emerging/Developing/Secure/Mastery. This scheme of work is designed for use with Year 8 but would also suit years 7 & 9. Tasks are differentiated using a Red/Amber/Green system where students can choose their own tasks for self differentiation. Summative and formative assessment is included as well as opportunities for peer and self assessment. If you would like examples please mail to : rbyrne01@coltonhills.co.uk A homework booklet is included.
russucas
Year 5 / 6 / 7 Computing  ICT  Mobile APP Designing Unit of Work Planning

Year 5 / 6 / 7 Computing ICT Mobile APP Designing Unit of Work Planning

This is an outstanding resource that has all the smartboards and activities for a whole unit of work for APP designing. The lessons lead you through thinking of an APP, market research before designing your own APP. All the smartboards have the LO, Success criteria, partner talk and the main activity. A must for any teachers looking to teach APP design
sparkle1978
Internet Safety/ Hoaxes

Internet Safety/ Hoaxes

A booklet that explores some of the weird and wonderful hoaxes of the Internet. Fake websites range from the endangered tree octopus to an online pregnancy scanner. Learners are asked to evaluate the sites and decide why things on the page may not be as they seem. At the end of the resource the learners are asked to look at some less controversial conspiracy theories such as time travel and life on Mars. This is a light-hearted and fun lesson designed to remind learners not to believe everything they see on the internet.
Rachel___
Spreadsheets for Teachers: Making the most of Excel in and out of the classroom

Spreadsheets for Teachers: Making the most of Excel in and out of the classroom

Teachers rely upon a unique blend of creativity and organisation. From data analysis and planning to custom-built learning tools and games, spreadsheets can enrich your teaching practice both in and out of the classroom. I've been playing with Excel for well over 10 years, and gradually picked up more and more as I adapted my use for the classroom. Many teachers recognise the potential that Excel has, but can't quite find the time to sit and play around with it. This booklet aims to distil some of the more valuable teacher-specific know-how I've gleaned over the years, and hopefully will enable you to pick up a few tricks and techniques that will save you time and add an extra dimension to your teaching practice. I'm a UK secondary maths teacher, which may come across in the examples I use. It is my hope that much of this booklet will be accessible and valuable to any teacher looking to go beyond the basics of Excel, but my particular slant will probably be most applicable to the sciences. See my website for over 100 of my own spreadsheets, and a taster of this booklet's content: http://www.thechalkface.net/spreadsheetsforteachers
thechalkface
A Level ICT Resources

A Level ICT Resources

Excellent range of ICT revision resources based around the AQA A Level ICT specification but would be suitable for other exam boards. This is the last time through for this specification so lets go out with a bang!
maxwell01782
Christmas List spreadsheet to clarify Excel software ability

Christmas List spreadsheet to clarify Excel software ability

This is an editable spreadsheet which has been designed to test the knowledge of Excel or it could be used to teach Excel. There are two tasks: one is to make a family/friends Christmas shopping list and the other is for a Christmas family. The first two worksheets are teacher examples of how to make a basically formatted version of the two tasks. There are three budgets you can set: one for the list, one for the party and these total up to an overall budget. This way students can decide where they will save money from as they may overspend in the list but save on the party and so keep to the overall budget. It is perfect for ICT/Computing/ECDL practice before creating big flat file databases and moving in to relational databases. This can be used as an end of term/topic assessment for the following areas: IT, flat file databases, spreadsheets, software usage, ECDL - used leading up to the students taking the test or as a baseline assessment for years 8 and 9. Skills this document tests are: formatting (which is also useful for PowerPoint and Word), formulas, functions such as IF and VLOOKUP, data validation, budget handling, accounting and software usage. This is a fun activity which can be used leading up to Christmas holidays. You can adjust the "Items Available" list to have whatever you want in it so I would recommend locking that worksheet before you hand it to the students to work on. I have used this very successfully when I was running ECDL and got 95% of a year group through their Excel ECDL exam due to it. This is because it really can be used to thoroughly understand the whole of Excel at a moderately challenging standard (enough to sit the ECDL exam in that Software).
wlm2016
Excel: Basic Calculations

Excel: Basic Calculations

This includes the basic operators of excel including +,-,/,*,Min,Average,Max This doc includes a scoring system to tell the student if the answer is right or wrong.
leonwilberforce