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.
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.
WJEC Vocational IT L1-2 Unit 2 Marksheet
Craig_HeardCraig_Heard

WJEC Vocational IT L1-2 Unit 2 Marksheet

(0)
I made this to help keep track of the marks for the coursework section of the WJEC ICT Level 1-2 Vocational course. There are 7 sheets which do the following: Overall - Tracks the whole unit marks with conditional formatting so it’s easy to see where each student is at. Task 1 - Marksheet for the database task. Task 2 - Marksheet for the spreadsheet task 2a - The spreadsheet task requires certain forumlas/functions to get marks so I made this one to track 2d in more detail. Task 3 - Marksheet for the automated document task. Task 4 - Marksheet for the logo task. 4a - As with 2a, this section is split into different criteria so Imade a seperate sheet to keep track of the individual elements. There are buttons to help navigate and if you enter the student names on the “Overall” sheet then they will appear throughout. If you notice any errors please let me know and I will update the sheet. Thank you
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