If you are going to sit for A level ICT (Applied ICT) exam then you are supposed to know these stuff:
For Written Exam (Paper 1):
Topic 1:
Information and the Proffesional
Topic 2:
Topic 3:
Topic 4:
Computer coded information-ASCII
Topic 5:
Health and Safety Implications of ICT
Topic 6:
Topic 7:
For Practical Exam (Paper 2):
Spreadsheets
- How to import a CSV or text file into a spreadsheet
- How to insert/delete rows
- How to name the cells
- How to format a cell
- How to use Sum, Average, Count, Max, Min, If, Sumif, Lookup, Vlookup, Hlookup, Mid, Left, Right, Transpose functions
- How to replicate the formula
- How to sort rows (ascending/descending)
- How to use alignments
- How to merge cells
- How to filter data
- How to create chart
- How to create header and footer
- How to change orientation of a page
- How to print by showing all formulas used
- How to import a RTF or text file into a word document
- How to change page size and orientation
- How to change margins
- How to insert header and footer
- How to set a style
- How to change font type/size/color
- How to use line spacing
- How to insert columns in a page
- How to align a text
- How to use font effects
- How to insert image in a page
- How to resize/crop image
- How to create hyperlink within a document
- How to save a document
- How to print a document
- How to import a CSV or text file into a database
- How to create a primary key
- How to format field types
- How to establish relationships between different tables
- How to perform queries
- How to produce reports
- How to produce grouped report
- How to perform calculation in a report
- How to add title in a report
- How to sort data in a report
- How to format text in a report
- How to create a cross-tab (pivot table)
- How to perform calculation in a field
- How to create graph and chart
- How to print a report
Acknowledgment: Most of A level revision notes has been taken from Mr.James’s website. I was using his website as a great resource for my classes and recently i emailed him and ask his permission whether i can put his note on my website or not. And the answer was yes. So now I would like to thank him for allowing me putting this excellent notes on here and also on our school website. He is providing these amazing resources for free to everyone. If you would like to make some donations please visit his donation page here.
![[Google]]( http://gcse-ict.net/wp-content/plugins/easy-adsenser/google-light.gif)
