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 activity when teaching adults Access. It is based around a a national trust lighthouse events programme. Students populate and interrogate the data.
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 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 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.
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
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.