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.
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