St John’s Curriculum Overview – Year 11 Introduction

Subject title

Cambridge Nationals IT

Setting arrangements

No setting

Time allowance each fortnight

6hrs

Full-time study programme for students who wish to develop applied knowledge and practical skills in using information technologies. There are two units of assessment. Learners must complete both units of assessment to achieve the qualification. Unit R012 is assessed by an exam and is externally marked, Unit R013 is marked internally and moderated by the exam board.

Topics, Skills and Assessment covered during the course

Term 1

Topics covered

Skills developed

Assessment

Spreadsheet design and use of formula. Understand the factors to be considered when collecting and processing data and storing data/information.

•

Students will be assessed on their theoretical knowledge and understanding of the systems development life cycle using exam style questions. They will also have a practical assessment to assess their ability to use database software and applications.

• • •

Spreadsheet skills: o Advanced functions. o Advanced formula. o Creating and editing graphs. o Printing and displaying information Reasoning Analysing Evaluating

Term 2

To be able to import and manipulate data to develop a solution to meet an identified need.

• • •

Software specific skills. select the appropriate tools required. Independence.

Term 3

Controlled assessment .

Term 4

Controlled assessment. Understand the factors to be considered when collecting and processing data and storing data/information.

• • • •

Project management and planning. Time management. Evaluation. Word processing, spreadsheet and database software specific skills.

Term 5

Revision for final assessment.

• •

Exam paper assessed and mark externally Exam technique. Writing to complete longer answer questions. by exam board.

Controlled assessment internally assessed and externally moderated by the exam board.

Resources Recommended for Revision and where they are available: All topics are covered on the VLE/OneNote and contain presentations, activity worksheets and help guides for some software packages. Homework • Expected time allocation for the subject: 45 minutes each week. • Students should review and conduct additional research into the theoretical concepts covered and should practise the software skills taught independently to enhance and develop their skills and ability to use software applications.

Additional support and help for the course www.teach-ict.com http://www.ocr.org.uk/qualifications/vocational-education-andskills/cambridge-nationals-information-technologies-level-1-2-j808/ Extra-Curricular: