Creating Directories Task

A step by step set of instructions about how to complete the files and folders task.

Fair Trade Project Introduction

Tidy Bedroom Starter 2

A starter activity to get students thinking about how to organise files and folders. An tidy bedroom vs messy bedroom is used to illustrate how a tidy folder structure is easier to manage than a 'messy' folder structure.

Tidy Bedroom Starter

A picture to be used to prompt a class discussion starter. A messy bedroom vs a tidy bedroom. The analogy being that just like in the tidy bedroom it is much easier to find your favorite tshirt, when using a 'tidy' folder structure it is much easier to find your files.

AO2 - Email Evidence Portfolio

This is a PowerPoint with heading written in to show what it required on each slide in terms of evidence. Each slide is also identified against the pass / merit / distinction criteria.

.

Adding a contact to the address book

Creating an email signature

Email Q&A Matching Game

This starter or plenary activity has fifteen questions relating to the unit 1 - AO2 email task. The questions and answers should be cut out, then in small groups students can try to match up the right answer with each question.

Email Starter - Label the diagram

An excel file using macros. This exercise should be done on the interactive white board. Students could come to the front and select option from the drop down lists to label features of an email (using Outlook 2003). You can then click 'check answers' and the diagram will self mark.

Email Starter

A whole class multiple choice starter.

Email walkthrough guide

This is a step by step guide which breaks down the email task into chunks. It also has explanations and a few screen shots to help students understand the task.

Internet Searching

A template for students to use to record their evidence of searching the Internet

Searching The Internet Task Guidelines

Step by step guidelines about how to complete the Internet searching task.

Sending a high priority email

Sending an email

Trustworthiness of information sources starter

A whole class starter activity where students can catagorise the sources of information into trustworthy, untrustworthy or don't know by provoking a class discussion. The PowerPoint is interactive, allowing the sources to be dragged across the screen / whiteboard and placed in the correct column.

Google is kind of a trick source of information as it isn't actually a source, but a way of getting to sources. Bright students might pick up on this.

To make it work, make sure that your macro security is set to medium. Look in Tools -> Macros -> Security.

**You will then need to quit PowerPoint and reopen it before this will work.**

trustworthiness_of_sources.jpg

Using Carbon Copy (CC)

Business Documents Starter

A fun starter activity that gets students out of their seats. Each student is given a piece of paper with either a word or a definition on it. Students must move around the room to find the person with the asociated word or definiton.

Business Letter

Students need to produce a range of business documents including a business letter. Here are some sample paragraphs which could be used by students to construct their own business letter (themed on a mountain biking park), and a starter activity which requires students to fill in the blanks (this gets them to think about the layout of business letters).

Example Business Letter

An example letter from Downloadable Tunes about a buy one get one free offer.

Letter Task Starter / Plenary

This is a quick whole class starter / plenary activity. Students must come to the front of the room and move the components of a letter into the correct place.

.

Mailmerge

Newsletter Task

A full lesson plan and checklist for studnets to follow as they produce a newsletter for AO4 - business documents. Includes a homemade Publisher newsletter template.

What to include in a newsletter

A brainstorm to be discussed / created at the start of the lesson to prompt students about what they should be including in their newsletter for Downloadable Tunes

interactive memo layout

This is a quick whole class starter / plenary activity. Students must come to the front of the room and move the components of a letter into the correct place.

Business Spreadsheet Success Criteria

The success criteria to show students what they need to create a successful business spreadsheet.

Downloadable Tunes Example Invoice

This spreadsheet can be used as an example to students who should then produce their own. The invoice uses formulas to calculate the totals, the SUM function and an IF statement to print a 'free' delivery message if the total spend is over £100

Spreadsheet 'IF' Function

Spreadsheet Formulas and SUM function

Spreadsheet Labelling Starter

Database Cheat Sheet

A step by step guide with screenshots to guide students in adding, editing, and deleting records and setting up queries.

.

Database activity

Simple database starter or plenary.
drag & drop.

.

Databases Test

Students should be given the quiz sheet which has questions and answers that don't match up. On an answer sheet (scrap of paper will do), students just need to write the number of the question and the letter that corresponds to the correct answer. Exam conditions are optional!

Databases starter / plenary activity

Each student is given a question and an answer (which don't match up). One student reads out his question to the rest of the class. Everyone now need to read their answers to see if they have the matching answer. The student with the matching answer should read it out to the class. He should then read out his question and so the process continues.

Databases starter activity

Here's a quick fun starter which requires no resources or preperation!

When the class enter the room get them to stay standing up. Then ask girls to sit down, then students with blonde hair to sit down, then students with glasses on to site down etc.

Eventually you end up with just a handful of students still remaining. You can then explain that this is the same as a database query. You start with a whole collection of records, you specify certain criteria and you are left with a subset of the original collection.

Downloadable Tunes resources for database task

This task has been based upon the Downloadable Tunes casestudy. A sample database is included together with an assessment guide and student check list. A writing frame / temple evidence PowerPoint has also been put together into which students should paste thier screen prints and annotate them.

Practice task for OCR Nationals Level 2 New spec (AO6)

Practice task for OCR Nationals ICT Level 2 suitable for the new spec (AO6).

Task sheet to allow pupils to identify Pass/Merit/Distinction level for this assessment objective with a working database (screenshot shows the table required which you will have to create).

Also includes lesson presentation to fit in with the lesson content with LO.

Step by step guide to allow pupils at pass level to work on their own using a help worksheet.

Please leave feedback if you have used this, thanks.