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
I use this exercise when starting in Excel. The students have normally done Word already so are familiar with the formatting toolbar. I then go on with this to practice inserting and deleting rows and columns in different ways (so they can see when eyes and noses disappear) We also do drag and drop – turning our face into a jigsaw by dragging out the features and then dragging them back. You can also go on to working with the format cell menus to add borders for glasses, or a moustache … Hope you have fun with this.
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.
I use this when teaching adults. This is an Excel activity that shows aspects of level 1 use including some formulae. It is based on a beding shop and is good for % calculation in formulae.
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.
I use these activities when teaching adult absolute beginners in spreadsheets. There is data input and simple formulae inputting and alteration as well as graphs use 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 adults Word Processing. There is text 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.
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.
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 or as a complete document to more confident learners.
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.
I use these activities when teaching adults Powerpoint. There is data inputting,alteration and shape 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 adult absolute beginners in spreadsheets how to create graphs. 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 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.