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