Course overview - Study Period 1 - Impact of technology
Study Period 2 - SQL and Databases
C11 start their learning journey to gain knowledge and an understanding of the impact of technology on individuals, organisations, and the planet. Through a range of real-world examples, they will learn how to identify the specific type of impact, ie legal, cultural, privacy, environmental, and ethical. They will then progress to identifying stakeholders who are impacted by technology, and learn how these impacts are experienced, negated, or adapted to. Throughout the unit, learners will be encouraged to discuss their views and make use of sample long-form answers as either cloze or comprehension exercises, to further develop their rhetorical skills. Lastly, they will complete an assessment and identify which of the technologies that they have studied they believe to have had the most negative or positive effect on our society as a whole. In both exam papers, they will be given either a 6 Mark or 9 Mark question to apply the knowledge learned.
Following this Unit of Work, learners will be taught their final unit of work, “SQL and Databases” that was introduced to the new scheme of work for AQA 8525. Learners explore the key terms used in a database and learn why relational databases are used to eliminate redundancy and inconsistencies that can occur in a flat file database. Next they explore increasingly challenging SQL commands where they retrieve, update and delete data in a relational database.
Learners will have the opportunity of a few learning session to revise in preparation for their C11 Mocks that will take place just before Christmas.
Key Concept:
Ethics, Security, Networks, Systems
Assessment Points:
Unit 8 – Impact of Technology
End of Unit Summative Assessment before half-term in October to complete the Unit of Work.
Unit 3 – SQL and Databases
Learners will complete a short Summative Assessment
November – Learners will sit AQA GCSE Computer Science Paper 1 – Programming, and Paper 2 – Computational Thinking for their Mock Exams.
Guidance:
Learners will receive guidance in a variety of ways. These include marked assessments, reports, verbal feedback, written feedback in books, 1:1 interaction, Google Classroom and whole class feedback.
Key Vocabulary:
Technology, Data Protection, Copyright, Freedom of Information Act, Cultural Acts, Computer Misuse Act, Privacy, Surveillance, Environmental Impact, Ethical Impact, Database, Field, Record, Primary Key, Foreign Key, Flat File Database, Relational Database, Relationship, Data Redundancy, Data Inconsistency, Structured Query Language, SQL, Float, Integer, Real, String