J. Correia Lopes

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:sheet

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
teach:lbaw:sheet [25/01/2019 19:37]
Correia Lopes [Table]
teach:lbaw:sheet [09/12/2019 10:28] (current)
Correia Lopes
Line 3: Line 3:
 **Master in Informatics and Computing Engineering\\ **Master in Informatics and Computing Engineering\\
   Database and Web Applications Laboratory\\   Database and Web Applications Laboratory\\
-  Instance: ​2018/2019**+  Instance: 2019/2020**
 \\ \\
 --- ---
 \\ \\
  
-//​**[[https://​sigarra.up.pt/​feup/​en/​ucurr_geral.ficha_uc_view?​pv_ocorrencia_id=420010|Institutional page]]**// ​+//​**[[https://​sigarra.up.pt/​feup/​en/​ucurr_geral.ficha_uc_view?​pv_ocorrencia_id=436452|Institutional page]]**// ​
  
 ===== General information ===== ===== General information =====
Line 15: Line 15:
 **Code**: EIC0085\\ **Code**: EIC0085\\
 **Programmes**:​ MIEIC, 3º\\ **Programmes**:​ MIEIC, 3º\\
-**Academic Year**: ​2018/2019\\+**Academic Year**: 2019/2020\\
 **Semester**:​ 2S\\ **Semester**:​ 2S\\
 **Credits**:​ 7 ECTS\\ **Credits**:​ 7 ECTS\\
Line 29: Line 29:
 BACKGROUND BACKGROUND
  
-The unit aims at revisit ​the learning outcome of the previous courses in databases and web languages ​and technologies,​ providing a practical perspective on these core areas​ of computer engineering.+This unit revisits ​the learning outcome of the previous courses in databases and web languages ​and technologies,​ providing a practical perspective on these core areas​ of computer engineering.
  
 SPECIFIC OBJECTIVES SPECIFIC OBJECTIVES
Line 46: Line 46:
   - Specify the web interfaces and business logic of the information system;   - Specify the web interfaces and business logic of the information system;
   - Implement the web components of the system using web-based, server-based and client-based technologies;​   - Implement the web components of the system using web-based, server-based and client-based technologies;​
-  - Ensure that the web interfaces ​are in accordance with accessibility and usability standards.+  - Ensure that the web interfaces ​adopt accessibility and usability standards.
  
 ===== Working method ===== ===== Working method =====
Line 59: Line 59:
 ===== Programme ===== ===== Programme =====
  
-  * Development of a web application supported by a database: requirements gathering, design, modelling, implementation and documentation. +  * Development of a web application supported by a database: requirements gathering, design, modelling, implementation and documentation; 
-  * General notions ​on the architecture of web applications using client scripting languages and server languages. +  * General notions ​about the architecture of web applications using client scripting languages and server languages; 
-  * Use of frameworks and API for data access. +  * Use of frameworks and API for data access; 
-  * Design of relational databases using data modelling languages (UML), the SQL language and procedural extensions to SQL. +  * Design of relational databases using data modelling languages (UML), the SQL language and procedural extensions to SQL; 
-  * Identification and maintenance of business rules: on the interface, on the business logic and in the database (triggers); define transactions. +  * Identification and maintenance of business rules: on the interface, on the business logic and in the database (triggers); define transactions; 
-  * General notions of usability and Web Design.+  * General notions of web usability and accessibility.
  
 ===== Mandatory literature ===== ===== Mandatory literature =====
Line 79: Line 79:
 ===== Teaching methods and learning activities ===== ===== Teaching methods and learning activities =====
  
-The lectures will be used for presentation of the scripts of the work and representative examples ​and their discussion, analysis of assessments and brief introductions to the technologies they use. +The lectures will be used for the presentation of work scripts, development ​of representative examples, analysis of assessmentsand brief introductions to the technologies they use. 
 The practical classes will be used for laboratory project development as a group project with the teacher as a consultant. The practical classes will be used for laboratory project development as a group project with the teacher as a consultant.
  
Line 85: Line 85:
  
   * PostgreSQL   * PostgreSQL
-  * PHP e Laravel+  * PHP
   * Docker   * Docker
   * Git   * Git
Line 97: Line 97:
 Distributed evaluation without final exam Distributed evaluation without final exam
  
-===== Registered evaluation and occupation components ​=====+===== Assessment Components ​=====
  
-Description ​                                       ^ Type                          ​^  ​Time (Hours ^ Date of conclusion  ​+Designation ​               ​^  ​Weight ​(%) ^ 
-Attendance (estimated) ​                            Lectures ​                     |  70            |                     +Test                                ​20 ​
-User requirements specification ​                   | Laboratory work or fieldwork ​ |  20            |  18/​03/​2019 ​        | +Practical ​or project ​work  |          ​80 ​
-| Database specification ​                            | Laboratory ​work or fieldwork ​ ​| ​ ​20 ​           |  15/​04/​2019 ​        +                    Total: ​|         100 
-Architecture specification and Vertical prototype  ​Laboratory work or fieldwork ​ |  36            |  05/​05/​2019 ​        | + 
-| Product ​                                           | Laboratory work or fieldwork ​ |  44            |  27/​05/​2019 ​        | +===== Amount of time allocated to each course unit ===== 
-Demonstration ​                                     | Attendance ​                   |  2              ​03/​06/​2019 ​        + 
-Individual Questionnaire ​                          Exercises ​                    ​| ​ 0             ​| ​ 29/​04/​2019 ​        +^ Designation ​      ​^ ​ Time (hours) ^ 
-                                                   ​| ​                       ​Total: |  192           |                     |+Autonomous study  ​| ​          122 
 +Class frequency ​             ​70 ​
 +           Total: |           ​192 |
  
 ===== Eligibility for exams ===== ===== Eligibility for exams =====
Line 115: Line 117:
 The theoretical concepts are evaluated using an individual questionnaire with multiple choice questions. The theoretical concepts are evaluated using an individual questionnaire with multiple choice questions.
  
-The approval ​for the course is conditional on the student obtaining 40% in the individual response questionnaire and 50% in each of the components of the practical assessment.+The approval ​on the course is conditional on the student obtaining 40% in the individual response questionnaire and 50% in each of the components of the practical assessment.
  
-A student that does not participate in an evaluation component may have an assessment ​to that component different from the group to which he belongs.+A student that does not participate in an evaluation component may have an assessment ​of that component different from the group to which she belongs.
  
-Given the laboratory nature of the course ​and the work in teams, it is not possible to make an overall evaluation based on a single moment and therefore the practical work can not be replaced by a single exam.+Given the laboratory nature of the course, it is not possible to make an overall evaluation based on a single moment and therefore the practical work can not be replaced by a single exam.
  
 ===== Calculation formula of final grade ===== ===== Calculation formula of final grade =====
Line 136: Line 138:
  
 The final classification of the practical component (NP) can vary from element to element in the same group, plus or minus 2 values​​,​ based on the opinion of the teachers and the self-assessment performed by each group. The final classification of the practical component (NP) can vary from element to element in the same group, plus or minus 2 values​​,​ based on the opinion of the teachers and the self-assessment performed by each group.
 +
 +Students who do not get approved in the final classification have to repeat the two evaluation components (NI and NP) in  a new enrolment to the unit.
  
 ===== Examinations ===== ===== Examinations =====
Line 145: Line 149:
 The project evaluation, conducted in a group, is the same for all students regardless of the enrolment regime. The project evaluation, conducted in a group, is the same for all students regardless of the enrolment regime.
  
-Students exempted from classes must agree to conduct regular meetings with teachers to keep up with the practical work.+Students exempted from classes must agree to conduct regular meetings with the teachers to keep up with the practical work.
 Regarding the final presentation and the individual assessments,​ the rules are the same as for the regular students. Regarding the final presentation and the individual assessments,​ the rules are the same as for the regular students.
  
Line 153: Line 157:
  
 \\ \\
- --- //João Correia Lopes, Sérgio Nunes/+ --- //João Correia Lopes, Sérgio Nunes
teach/lbaw/sheet.1548445057.txt.gz · Last modified: 25/01/2019 19:37 by Correia Lopes