Hero image

Digital Heard

Average Rating5.00
(based on 1 reviews)

ICT Teacher trying to create newer versions of old resources.

ICT Teacher trying to create newer versions of old resources.
Excel (ECDL and General Use)
Craig_HeardCraig_Heard

Excel (ECDL and General Use)

(0)
I have made this to help with some features for the ECDL test. Small tasks designed to help with questions that may come up. Autofill IF Formulas vs Functions Changing Calculations Decimals Borders Absolute Cell Referencing Sorting The second tab goes through some chart features. Selecting Data Changing Data type Creating a Chart Editing a Chart (Title, colour, values, font size, axis names) The third sheet has some quick guides for the following features: Fitting worksheet on page setup Using find command Copying, Moving or Renaming Sheets Saving as a different file type Thousand Seperator
WJEC ICT Spreadsheet Guide GCSE
Craig_HeardCraig_Heard

WJEC ICT Spreadsheet Guide GCSE

(1)
I have made a guide for my students who are studying the WJEC GCSE ICT exam for Unit 1. This covers almost all of the specification apart from how to generate graphs. Added lots to it over the past year and figured it may be useful to other teachers. It contains lots of past paper questions. Any feedback is appreciated, feel free to contact me on twitter: @MrCHeard I may make one for the database section on Unit 1. Sections on: Formulas Functions IF Percentages Exam Questions Relative vs Absolute Referencing What if’s Terminology Formatting Contains 67 slides.