Welcome to my online teacher resources shop!
I'm an Enterprise educator at Durham University, AFHEA, and a Fellow of Enterprise Educators UK, with over 20 years of experience in Adult Education and the commercial industry. I specialise in designing and delivering impactful programs that foster agile thinking and creativity. Explore my free IT resources from my Further Education days along with my newer Enterprise Resources.
Feel free to browse
Welcome to my online teacher resources shop!
I'm an Enterprise educator at Durham University, AFHEA, and a Fellow of Enterprise Educators UK, with over 20 years of experience in Adult Education and the commercial industry. I specialise in designing and delivering impactful programs that foster agile thinking and creativity. Explore my free IT resources from my Further Education days along with my newer Enterprise Resources.
Feel free to browse
This Excel Task provides a structured exercise for students to practice their spreadsheet skills using a real-world scenario from The Retired Greyhound Trust. The task involves creating and managing a spreadsheet to track merchandise orders for the charity, including calculations and data management.
Classroom Application:
Introduction to Spreadsheet Applications: Start with a brief overview of spreadsheet functionalities, such as entering data, formatting cells, and using formulas.
Step-by-Step Instructions: Follow the task’s step-by-step instructions to guide students through the creation of a spreadsheet that includes column headings, data entry, and formula applications.
Real-World Relevance: Explain the context of the exercise, emphasizing how spreadsheets are used in non-profit organizations for data management.
Assessment and Review: Review students’ spreadsheets for accuracy, proper formula use, and data entry. Provide feedback based on the clarity and correctness of their work.
Key Features:
Spreadsheet Creation: Students will learn to set up a spreadsheet with titles, column headings, and data entry.
Formula Application: Emphasises the importance of using formulas to calculate totals, manage costs, and update data dynamically.
Formatting Skills: Focus on formatting cells for currency and ensuring data visibility.
Data Management: Practice adding, updating, and deleting data as required, including handling voluntary donations.
Description:
Create a detailed spreadsheet for The Retired Greyhound Trust, focusing on merchandise orders. Learn to enter data, apply formulas for cost calculations, format cells for currency, and manage customer details. This task includes creating columns for item descriptions, quantities, designs, prices, and more. Ideal for practicing spreadsheet skills in a real-world context. Includes steps for calculating totals, handling donations, and formatting. Perfect for Excel assignments and data management practice.
This is a mock test that I use with adult students. It is from an older version of ECDL but the word processing tasks are still relevant to those learning the fuctions availble within Word.
These are mock tests that I use with adult students. They are from an older version of ECDL but is still relevant to those learning the jargon, security aspects and 'behind the scenes&' aspects of PC usage.
This is a mock test that I use with adult students. It is from an older version of ECDL but the Excel tasks are still relevant to those learning the fuctions availble within spreadsheets.
This is a mock test that I use with adult students. It is from an older version of ECDL but the word processing tasks are still relevant to those learning the fuctions availble within Word.
Each test consists of 8 open questions, which are constructed to elicit 3 or 4 knowledge facts. The first 6 questions have 4 marks available and the last 2 questions have 3 marks available in each test. An indication is given after each question to show the number of marks available for the question. Where 3 marks are available in the question three knowledge facts or points are anticipated in the answer. Where 4 marks are available in the question four knowledge facts or points are anticipated in the answer.
This is a sample test only. The students task is to prepare a circular letter giving notice about an upcoming annual general meeting of a club. In the test they are asked to modify the letter, to apply various formatting actions to it; and to carry out a mail merge
operation so that the circular can be delivered to all the members of the club. It should take no longer than 45 minutes
I use these activities when teaching adults spreadsheets. There is data input and simple formulae inputting and alteration and they are useful as extra resources for those that are getting well ahead or for just getting them to do the same tasks until they are comfortable.
I use this when teaching adults. This is a longer Excel activity that shows different aspects of level 1 use including some formulae. The task can be given section by section to less confident learners .
I use these activities when teaching adultss spreadsheets. There is data input/manipulation for graphs use. They are useful as extra resources for those that are getting well ahead or for just getting them to do the same tasks until they are comfortable.
I use these activities when teaching adultS spreadsheets. There is data input/manipulation for graphs use. They are useful as extra resources for those that are getting well ahead or for just getting them to do the same tasks until they are comfortable.
I use these activities when teaching adults Powerpoint. There is data inputting,alteration and image use. They are useful as extra resources for those that are getting well ahead or for just getting them to do the same tasks until they are comfortable.
I use these activities when teaching adults spreadsheets. This is a progression the Level 2 exercise including data input and a little more complex formulae inputting and alteration and they are useful as extra resources for those that are getting well ahead or for just getting them to do the same tasks until they are comfortable
Normally if a workbook is open, no other user can open it until it has been closed. It is possible however to share workbooks so that they can be seen and amended simultaneously by several users. This is useful for complex workbooks where different users are responsible for different areas, or data lists where changes can be entered from several sources. This activity is around this function