S3 Admin and IT: Reporting Window 2

Excel – Spreadsheets

Pupils have been working on their skills and learning the functions of Excel, from basic mathematical functions of + - / *, to average, maximum, minimum and using autosum.  Pupils have been creating Charts from material given to meet the requirements asked for.  They have been presenting their data in both value and formula modes to demonstrate excellent administrative skills.

Access – Database

Pupils have been working on the software skills for MS Access where they are demonstrating their ability to create databases, tables with fields and records, edit these following instructions.  Pupils have learned the further skills of Query and Forms in Database, this is input and questioning of the database to give results.

All pupils have undertaken some of the N4 Administration and IT Unit Assessments, and will continue to do so once the skillset is fully demonstrated through practice.

The majority of work covered in terms 2 and 3 is based around CfE Level 4 outcomes. The majority of pupils at this stage of S3 are working at Fourth Level C or above. All pupils are making progress, but some require more support with CfE Level 4 content than others.

Working Level and Working Grade descriptions for S3 Admin & IT:

Fourth Level A: Making excellent progress at CfE Level 4, performing well against all the outcomes covered. The student can apply the key knowledge and skills of Admin & IT and exhibits good competency levels and confidence using ICT and understanding the fundamentals of the topic. Produces an excellent standard of work and when topics allow for extension, the student copes very well with the increased challenge.

Fourth Level B: Making good progress at CfE Level 4, performing well against most of the outcomes covered. The student copes well with the application of knowledge and understanding of the topic and exhibits good competency and confidence in using their ICT skills. The student applies their knowledge and IT skills to enhance their work. Produces a good standard of work and when topics allow for extension, the student copes well with the increased challenge.

Fourth Level C: Making reasonable progress at CfE Level 4, performing well against many of the outcomes covered while finding others more challenging. Sometimes needs the basic IT fundamental concepts broken down into more manageable chunks and a little extra support to enable the student to gain more confidence to produce a higher standard of presentation.
For pupils working at Fourth A-C, National 5 Admin & IT would be recommended for next session.

Fourth Level D: Making some progress at this CfE Level 4, performing well against a few of the outcomes covered while finding the majority challenging. Often needs the IT concepts to be broken down into more manageable chunks or further consolidation of the level. Often needs to revisit previously visited content to build more solid foundations and confidence before moving forward with developing IT skills further. For pupils working at Fourth D, National 5 Admin & IT would be possible next session.

Third Level A-D:  Finds the work very challenging while continuing to be exposed to CfE Level 3 content in class. The student requires most tasks to be broken down into smaller, simplified versions to make progress.  The student needs support to develop the literacy and ICT skills required and build confidence in responding to questioning using IT. Grading of A-D reflects where a pupil sits within this group. For pupils working at Third A-D, National 4 Admin & IT would be recommended for next session.