COMP107

Graduates for the Digital Society

Aims

  1. To provide the students with a wide-ranging understanding of the discipline of computing, and to introduce students to concepts of professional ethics as well as social and legal aspects of computing.
  2. To equip the students with the communication, time and project management, and employability skills required for a computing professional.
  3. To allow the students to gain an understanding of the importance of appropriate and efficient database design strategies, at the conceptual and logical level, and how to communicate them effectively to stakeholders
  4. To provide the students with practical experience of database programming, including data manipulation and query in SQL.

Syllabus

  1. Overview of Computer Science as a discipline and computing in practice: Economic, historical , organisational, research, and social aspects. The pervasiveness of data, and the crucial issues in data management (2 lectures).
  2. Designing applications to requirements. Requirement acquisition and analysis. Informed search: effective use of search engines, bibliographic databases, the library catalogue, evaluating information sources. Communicating effectively with stakeholders. Application to the database life cycle (4 lectures).
  3. Conceptualisation of requirements, the importance of formal specifications. Application to database conceptual modelling: Entity Relationship and Enhanced Entity Relationship models, UML, capturing the needs of different stakeholders, modelling of user views. Time management, project management and teamwork. Group organisation and management. Peer review organisation. Communicating effectively, techn ical and academic writing, referencing and citation (10 lectures + 2 tutorials)
  4. Producing effective and usable systems. Reasoning and critical thinking skills: Abduction, induction, deduction, argumentation and their use in a Computing context. Application to databases: choosing among different DBMS environments. The relational model and SQL. Database logical Design and Physical design: including secondary storage. Interfaces and front end, PHP. (8 lectures + 5 labs)
  5. Funding opportunities. Presentation skills and pitching. Writing a business plan. CV and application writing, social media profile (e.g. Linkedin). Employability skills: Understanding the skills that graduate recruiters look for from Computer Science Graduates. (4 lectures + 3 tutorials).
  6. Legal framework and, ethical, social and professional (LSEP) issues including data protection and standards (2 lectures).

Learning Outcomes

  • Identify and appraise professional, ethical, legal and social issues related to the work of a professional within the IT industry with particular regard to the BCS Codes of Conduct and Practice.
  • Recognise employability and entrepreneurship skills that prepare students to undertake paid work experience during the course of their degree or independently
  • Identify, describe and discuss economic, historical, organisational, research, and social aspects of computing as a discipline and computing in practice;
  • Identify and apply principles of database conceptual design using ER and UML design methodologies
  • Recognise database logical design principles, and issues related to database physical design;
  • Use SQL as a data definition and manipulation language, and as a language for querying database