Congleton High School  
Functional Skills
Homepage Homepage
.pdf Portable Document Format (352 KB) (This will open in a new window) ICT_Chapter 5 Learner Materials
.pdf Portable Document Format (522 KB) (This will open in a new window) ICT_Chapter 7 Learner Materials
.pdf Portable Document Format (1,848 KB) (This will open in a new window) ICT_Chapter 1 Learner Materials
.pdf Portable Document Format (243 KB) (This will open in a new window) ICT_Chapter 4 Learner Materials
.pdf Portable Document Format (419 KB) (This will open in a new window) ICT_Chapter 2 Learner Materials
.pdf Portable Document Format (746 KB) (This will open in a new window) ICT_Chapter 6 Learner Materials
.pdf Portable Document Format (3,151 KB) (This will open in a new window) ICT_Chapter 3 Learner Materials
.pdf Portable Document Format (229 KB) (This will open in a new window) ICT_Chapter 8 Learner Materials
.pdf Portable Document Format (169 KB) (This will open in a new window) ICT Level 2 Practice Test
.doc MS Word Document (2,708 KB) (This will open in a new window) Camdale Graphics
.doc MS Word Document (28 KB) (This will open in a new window) Camdale PPT L2
.doc MS Word Document (38 KB) (This will open in a new window) Exemplar Data Capture Form
.doc MS Word Document (25 KB) (This will open in a new window) Exemplar Email
.ppt MS PowerPoint Presentation (799 KB) (This will open in a new window) Exemplar Presentation L2
.xls MS Excel Worksheet (32 KB) (This will open in a new window) Exemplar spreadsheet L2
.doc MS Word Document (44 KB) (This will open in a new window) Camdale Data L1
.doc MS Word Document (2,708 KB) (This will open in a new window) Camdale Graphics
.doc MS Word Document (29 KB) (This will open in a new window) Camdale PPT L1
.pdf Portable Document Format (223 KB) (This will open in a new window) ICT Level 1 Practice Test
.ppt MS PowerPoint Presentation (28 KB) (This will open in a new window) Excel 2007 Tutorials
.mht MIME HTML (63 KB) (This will open in a new window) Excel 2007 Tutorials - Review Number Three
.mht MIME HTML (87 KB) (This will open in a new window) Excel 2007 Tutorials - CountIF
.mht MIME HTML (105 KB) (This will open in a new window) Excel 2007 Tutorials - SumIF
.mht MIME HTML (102 KB) (This will open in a new window) Excel 2007 Tutorials - Review Two
.mht MIME HTML (167 KB) (This will open in a new window) Excel 2007 Tutorials - The Average Function
.mht MIME HTML (170 KB) (This will open in a new window) Excel 2007 Tutorials - The IF Function
.mht MIME HTML (283 KB) (This will open in a new window) Excel 2007 Tutorials - Conditional Formatting
.mht MIME HTML (339 KB) (This will open in a new window) Use ICT systems
.mht MIME HTML (492 KB) (This will open in a new window) City & Guilds ICT Functional Skills sample assessment
.pdf Portable Document Format (766 KB) (This will open in a new window) Functional Skills SAMs ICT Level 1 2 Booklet 2010
.xls MS Excel Worksheet (16 KB) (This will open in a new window) Cafe
.xls MS Excel Worksheet (25 KB) (This will open in a new window) Congleton Holiday Packages L2
.xls MS Excel Worksheet (27 KB) (This will open in a new window) Car Sales L1
.avi Audio Video Interleave (17,331 KB) (This will open in a new window) Level 2
.doc MS Word Document (39 KB) (This will open in a new window) Task Car Sales L1
.doc MS Word Document (40 KB) (This will open in a new window) Task Holidays L2
Functional Skills Exam Jan 2011 Functional Skills Exam Jan 2011
Functional Skills Feb 2012 Functional Skills Feb 2012
Level 1 Level 1
Level 2 Level 2
 

Congleton High School
 
Congleton High School > Curriculum Areas > ICT > Functional Skills
Functional Skills
This is a practical exam that will allow you to gain 1/2 a GCSE. If you are taking a Diploma you need to pass this at the appropriate level. This qualification will also show an employer that you have good basic ICT skills.

June Preparation

Level 2



Video Walk Through Level 2 - .avi Audio Video Interleave (17,331 KB) (This will open in a new window)Level 2  


YouTube link to level 2 walk through video: 


Level 1



Y11 February Preparation
Level 1
Practice file -
 
Practice Questions
Level 2
 
Practice file -
Note the sale price is 10% off, ie you pay 90%.
 
Practice Questions
Past Papers
Click the links below for past papers. With the papers are the files they would give you in the exam.
This is the actual paper from January and the files that you would be given to work with.
 
Excel additional support
 
See files on the left handside also notes below:
 

Function

Formula

Average

=average(A1:A5)

Minimum

=min(A1:A5)

Maximum

=max(A1:A5)

Excel help:
 
.mht MIME HTML (167 KB) (This will open in a new window)Excel 2007 Tutorials - The Average Function
.mht MIME HTML (170 KB) (This will open in a new window)Excel 2007 Tutorials - The IF Function
.ppt MS PowerPoint Presentation (28 KB) (This will open in a new window)Excel 2007 Tutorials
 
Below are links to resources and activities that will help you to pass the qualification.
 
 
Login
Forgotten password?
Having trouble logging in?