Secondary PGCE
INTERVIEWS & ADMISSIONS 2015-16Subject Knowledge Audit – ICT Computer Science
Please self-grade and identify the source/s of your knowledge for each of the topics listed below.
Source of Knowledge / Skills (write one or two codes):
NNone (or below GCSE)
GGCSE (or O Level)
AAdvanced Level (including AVCE, HNC)
DDegree Level (including HND)
PPost-graduate
WWork-related training
Current Level of Knowledge / Skill (write one grade only):
4Little or No Secure Knowledge.
3Basic Personal Knowledge up to GCSE level, however you are not fully aware of possible misconceptions and how to address them and you may inadvertently reinforce misconceptions.
2Secure knowledge / skill up to GCSE that would enable you to teach this to pupils. You would be aware of the common misconceptions in this skill area and you would be able to address these in a lesson.
1Secure knowledge / skill up to A Level standard.
Name: / Date:Area / Skill / Knowledge / Source
N/G/A/D/P/W / Level
0/1/2
Data and information sources / Identifying information required for a task
Devising criteria to evaluate sources
Justifying and evaluating sources
Sampling methods and bias
Misuse of data
Searching and selecting / Search a variety of sources
Refining searches using keywords, synonyms
Refining searches using AND, OR, NOT.
Assessing information from sources
Forming and testing hypotheses
Identifying correlations
Drawing conclusions and making predictions
Reviewing predictions or conclusions
Organising and investigating / Designing a questionnaire
Creating appropriate database structure
Data validation techniques
Producing graphs, charts and reports
Relationships between variables
Testing processes and reports
Exploring data in order to draw and check conclusions
Use of data processing in commerce
Impact of data processing on society
Potential misuse of personal data
Analysing and automating / Templates, master pages, styles
Mail-merge
Macros
Diagrammatic representation of simple design specifications
Spreadsheets for creating and testing a simple model
Benefits and drawbacks of automation
Models to hypothesise and predict
Evaluating the validity of models
Control and monitoring / Compiling instructions for control tasks
Using loops and procedures for control
Using feedback in a control task
Evaluating performance
Control systems in business
Refining and presenting information / Planning the presentation of information
Selecting and justifying software choice
Capturing and editing still images
Capturing and editing moving images
Capturing and editing sound
Importing and exporting data
Using word processors
Using DTP software
Using multimedia software
Using web-authoring software
Fitness for purpose / Use of common forms and conventions
Devising criteria to evaluate publications
Assessing multimedia publications
Communicating / Using e-mail securely and efficiently
Protection of personal details
Technology issues (eg. bandwidth, file size)
Social issues surrounding the Internet
Databases / Using data entry forms
Using a relational database
Searching and sorting related tables
Complex reports from related tables
ICT in business / The four main business functions
How and why businesses use ICT
DFDs to represent business functions
Components / Input devices
Output devices
Processors
Storage devices
Ports and Cables
Networking (e.g. )Internet, modem, ISDN, ADSL
Mobile tech. (Phones, PDAs, SMS, WAP)
Designing and implementing ICT systems / Identifying user requirements
Identifying critical success factors
Producing a design specification
Implementing the system
Testing the system
Producing user documentation
Evaluating the system
Social aspects / Effect on work styles
ICT Legislation: Data Protection, Computer Misuse, Copyright
Effect on personal communication
How ICT is used in community activities
ICT and people with special needs
Spreadsheets / Using data entry forms
Using data validation
Using multiple worksheet functions
Using conditional functions
Using lookup functions
Nesting functions
Databases / Using subtotals in reports
Creating mainformand subforms
Establishing database relationships
Creating user defined functions
Using macros
Using SQL to work with a database
Programming / Loop structures
Conditional structures
Manipulation of data files
Programming common data structures such as stacks, queues and trees
Diagrammatic representation
Assembly language
Knowledge / Internal representation of data
Machine architecture and functions of the major busses and registers
Network topologies and the functions of hubs, switches, bridges and routers
Functions of operating systems
DBMS including ER modelling and normalisation up to BCNF
Website Design / HTML basics
Use of HTML software
Knowledge of forms
Experience of Hosting
Use of CSS
Animation / Animated GIF creation
Frame by frame animation
Motion tweening /shape tweening
Programming of events
Graphic design / Use of image manipulation software
Image compression
Laying of images
Knowledge of Bitmaps & vectors
Additional relevant information (optional):