Significance of using spreadsheet applications Workbook Worksheets for demonstrating learners ability to explain LO 1 What spread sheets are used for? The advantages of spreadsheets over paper based systems. The main features of spreadsheets. Janna Tierney Available to purchase from Educoot.org Rudimentary terminology Web based tutorials and notes Comprehensive list of terminology used in spreadsheet applications. Good explanations. Page 1 gives a good introduction to spreadsheet. Page 2 has links to Tutorials, How-To Videos and Documents Suny Broome Rudimentary terminology Web article Worksheets and Work Books Outlines details of workbooks and worksheets Ted French Thought Co Rudimentary terminology Website Tech Terms Dictionary Useful site for learners to look up the meaning of terms Tech Terms Creating a basic spreadsheet Web video 13 minute Microsoft Excel Tutorial for beginners who want to make a basic spreadsheet in Excel. This tutorial demonstrations how to make columns and rows that add up or sum automatically. Beginners in will find this an easy tutorial to follow Computer Basics
a Spreadsheet Application Book Introducing ICT – Basic to Intermediate This book provides numerous assignments, with some theory at both basic and intermediate level. Unit 3 covers Spreadsheets with a basic introduction. The assignments are graded and progressive to suit all abilities. Teresa Walsh Available to purchase from Gill Education Can also be purchased from this site as an eBook Computer Applications Book Essential Computer Applications Explained in a simple and logical manner, which are supported with business like examples Each chapter starts with defined learning objectives, and ends with a recap of the key points. A Glossary of Terms is provided at the end of each section Chapter 4 is an Introduction to Spreadsheets with sample exercises and questions/solutions Seamus O'Neill and Gerard Morgan Available to purchase from Gill Education Excel Math Basics Website Tutorials on different aspects of spreadsheet. This section of the website covers, basic math formulas, mathematical order of operations, calculating percentages in spreadsheets and copying and pasting formulas. Keynote Support.com
Formulas Youtube Demonstration of using formulas and some functions – simple and easy to follow. Shows the learner two different methods of creating formulas Andy Mahn Formulas and Functions Website This website provides assistance with Excel functions and formulas. There are numerous examples and exercises and functions introduced in later products are shown. Excelfunctions.net Use Excel as your calculator Web site Microsoft Office have a comprehensive website with help and assistance to complete tasks within their spreadsheet application. This resource demonstrates how to use Excel as a calculator. Adding another significant use for learners. There is a table with the specific key or key combinations to be used to mimic the buttons on a calculator Microsoft Office Theory, Quizs and Practical Exercises Web Teach-ict.com The theory and quiz’s are appropriate to compound learning both in and outside of class the practical exercises are subscription only Teach-ICT
Extra Lessons in Excel Web Based Tutorial This site has a comprehensive course on Spreadsheet. It is broken down into three sections. Basics, Common Tasks and Doing more. The basic section is relevant to L3 Spreadsheet, sub sections include basics, formulas, formatting, and modifying cells GCFLearnfree.org Health and Safety in Using Computers Website Tutorial Concise tutorial on health and safety in using computers – The link provided is on H & S with assessment links BBC Bitesize Health and Safety in Using Computers Website Video tutorial video demonstrating office ergonomics. Health and Safety Authority Environmental Impact Reduction Website Article How can I minimize my computer's impact on the environment? Clear points on reducing environmental impact when using computers Indianan University Health and safety procedures Workbook Unit 1 Health and Safety Procedures Worksheets for demonstrating learners ability to explain LO 7 Evidence that the learner has applied appropriate health, safety and personal hygiene procedures when using a computer. Janna Tierney Available to purchase from Educoot.org