Developing ICT Systems (A0107), 10 op
Toteutussuunnitelma (PDF), 5 sivua
- Toteutus
- NIA1321
- Lukukausi
- 2/2013-2014
- Ajankohta
- 7.1.2014–20.6.2014
- Tyyppi
- INITIATION OF PROFESSIONAL GROWTH (A029)
- Ryhmä
- NIA13SN
- Kampus
- Laurea Leppävaara
- Opetuskieli
- englanti
- Opettajat
- De Arruda Camara Antonius (Teacher in charge), Rathod Paresh (Other teacher)
- Tila
- Valmis
Näytä tekstiversio
1/5
Implementation plan Finished
Study unit Developing ICT Systems (A0107), 10.0
Implementation NIA1321: 2/2013-2014 (07.01.2014 - 20.06.2014)
Type INITIATION OF PROFESSIONAL GROWTH (A029)
Groups Primary: NIA13SN Others :
Involved in the project
Lecturers
Number of participants Minimum: Maximum:
Enrolment period 02.12.2013 08:00 - 08.12.2013
Main timing for implementation
Applicabililty For exchange students: Yes For elective studies: No Open UAS student:
No Suitable for virtual UAS: No
Teachers De Arruda Camara Antonius (Teacher in charge), Rathod Paresh (Other teacher)
Campus Laurea Leppävaara
Main location for implementation
Implementation method Optima realization/student group, Other method of implementation,
Project/venture/R&D, Web/virtual Language: English Virtuality: 4 cr Integration of
R&D: 0 cr
Implementation class
Focus areas
Evaluation at the latest 17.07.2014 Storing of graded material ends.: 17.06.2015
Exam days
Having completed the study unit the ● analyze and explain the behaviour of simple programs involving the fundamental
student is able to programming constructs covered by this unit
● design, implement, test, and debug a program that uses each of the following
fundamental programming constructs: basic computation, simple I/O, standard
conditional and iterative structures, and the definition of functions
● choose appropriate conditional and iteration constructs for a given programming
task
● implement object-oriented programming in working life projects.
● analyze to differentiate and use key terms such as: information, data, database,
database management system, metadata, and data mining
● explain the role of data, information, and databases in organizations
● describe and interpret Entity Relationship and Object Modeling
● formulate and test SQL queries
● design, develop and manage the database system
● describe the structure of the World Wide Web as interconnected hypertext
documents
Previous studies Designing ICT Systems
Previous studies, more information A0105 - Designing ICT Systems
Learning objectives
Contents Section-1: Fundamentals of programming (5 CR)
● information technology: purpose, use, value
● programming basics including variables, operators, expressions, statements and
modifier
● control/Block structures
● class and methods
● Object-oriented programming - overloading, encapsulation, constructors,
inheritence, exception and IO
Section-2: Relational Database Design and Development (5 CR)
SoleOPS 3.5.5 Study offer © 2005-2016 Solenovo Oy
2/5
Implementation plan Finished
● introduction to Database Systems
● Design of relational databases using UML class diagrams
● relational database model
● Basics of SQL
● create and manage databases with a DBMS
Study material Virtual Learning Environment will be provided
Tutoring and communication Teachers will guide students during workshop based contact sessions. During the
workshops teachers will introduce key concepts and support students in completing
exercises from the virtual learning environment.
Evaluation criteria and methods For both sections: Indvidual evaluation based on tests assigned on class.There are two
options for taking tests:Option A) For each section (programming and DB): completing
three small tests during the semesterOrOption B) For each section (programming and
DB): completing a large test at the end of the semesterFINAL GRADE: 50% from the
programming section and 50% from the DB partStudents planning to take Option B
should inform the teachers via email until Tuesday, 04.02.2014
Project (name)
R&D methods
Other arrangements Complete details will be given during Induction class.
Learning events
Date o'clock/at h Subject Content Status Teachers
27.01.2014 09:00-16:00 Workshop - Morning session:Orientation & Computer Antonius De
Orientation Introduction to programming (Paresh room Arruda
Rathod)12:30 - 15:30 Afternoon session: Camara,
DB (Antonius Camara) Paresh Rathod
● Database key concepts,
Introduction to the relational model
● Distibution of user accounts for the
Viope learning platform
● Self-Study: Chapters 1,2, and 4 of
Viope course "A0107 - Relational
Databases and SQL"
03.02.2014 09:00-16:00 Workshop Morning session: Introduction to java Computer
programming (Paresh Rathod) room
● Exercise:Hands on practice &
Self-study Viope chapters 1, 2,3 , 4
12:30 - 15:30 Afternoon session: DB
(Antonius Camara)
● Relational model/schema
● Relational model of database used
in Viope programming exercises
● SQL SELECT queries
● Exercises from Viope DB course
chapter 7 (Simple Select queries)
● Self-study: Viope DB course
chapter 8 (Sorting results)
10.02.2014 09:00-16:00 Workshop Morning session: Java Programming Computer
(Paresh Rathod) room
● Exercise: Hands on practice &
Self-study Viope chapters 4
Afternoon session: DB (Antonius Camara)
● Clarifying doubts/questions about
SoleOPS 3.5.5 Study offer © 2005-2016 Solenovo Oy
3/5
Implementation plan Finished
chapter 8 (sorting results)
● Design of relational databases
● Self-study: Viope DB chapter 11
(Aggregate functions)
17.02.2014 09:00-16:00 Workshop Morning session: Java Programming Computer
(Paresh Rathod) room
● Exercise: Hands on practice &
Self-study Viope chapters 4 & 5
Afternoon session: DB (Antonius Camara)
● Clarifying doubts/questions about
chapter11 (aggregate functions)
● Design of relational databases
● Self-study: Viope DB chapter 12
(Aggregate functions and Group
By)
24.02.2014 09:00-16:00 Workshop Morning session: Java Programming Computer
(Paresh Rathod) room
● Exercise: Hands on practice &
Self-study Viope chapters 5
Afternoon session: DB (Antonius Camara)
● Review of "aggregate" and "group
by" queries from Viope chapter 12
● Resolving different types of SQL
queries - related to Viope chapters
seen so far
● Self-study: DB chapters 6
(INSERT and UPDATE), 13 (AS),
14 (JOINS)
03.03.2014 09:00-16:00 Workshop Morning session: Java Test - 01(Paresh Computer
Rathod) room
● Test topic: Details on Optima
Afternoon session: DB (Antonius Camara)
● Design of relational databases
10.03.2014 12:30-16:00 Workshop Morning session: Self-study (No meeting) Computer
● Exercise: Self-study Viope room
chapters 6
Afternoon session: DB (Antonius Camara)
● DB Test-1: Design of relational
databases
17.03.2014 No Session Morning session: Self-study (No meeting)
● Exercise: Self-study Viope
chapters 6
Afternoon session: Self-study (NO
CONTACT SESSION)
24.03.2014 09:00-16:00 Workshop Morning session: Java Computer
Programming(Paresh Rathod) room
● Exercise: Hands on practice &
Self-study Viope chapters 6
Afternoon session: DB (Antonius Camara)
● Resolving different types of SQL
queries - related to Viope chapters
seen so far
SoleOPS 3.5.5 Study offer © 2005-2016 Solenovo Oy
4/5
Implementation plan Finished
31.03.2014 09:00-16:00 Workshop Morning session: Java Computer
Programming(Paresh Rathod) room
● Workshop:
● Conditions: if, if-else and
if-then-else
● Loops:for, while and
do-while
● Self-study Viope chapters 6
Afternoon session: DB (Antonius
Camara)DB Test-2 (SQL queries related
to following Viope chapters)6 (INSERT,
UPDATE, DELETE)
7 (Simple SELECT queries)
8 (Sorting results)
11 (Aggregate functions)
12 (Aggregate functions and Group By)
13 (AS)
14 (Joins and multi-table queries)
07.04.2014 09:00-16:00 Workshop LV International week ( More details later Computer
on) room
14.04.2014 09:00-16:00 Workshop Morning session: Java Test - 02 (Paresh Computer
Rathod) room
● Test topic: Viope Chapter 1 to 6 +
Conditions + Loops (see workshop
details in 31.03.2014)
Afternoon session: NO CONTACT
SESSION
28.04.2014 09:00-16:00 Workshop Morning session: Java Computer
Programming(Paresh Rathod) room
● Workshop: Paper solution and
Methods
● Exercise: Hands on practice &
Self-study Viope 7 (Array)
Afternoon session: DB (Antonius Camara)
● Reviewing remaining course
agenda (remaining tests)
● Introduction to MySQL/XAMPP
● Running SQL scripts to create
databases
● Viope chapter 5 (Creating database
and tables)
● Reviewing results of DB test-2
(SQL queries)
05.05.2014 09:00-16:00 Workshop Morning session: Java Computer
Programming(Paresh Rathod) room
● Workshop:Arrays
●
SoleOPS 3.5.5 Study offer © 2005-2016 Solenovo Oy
5/5
Implementation plan Finished
Exercise: Hands on practice &
Self-study Viope 6 & 7
Afternoon session: DB (Antonius Camara)
● Given a relational model of a
database, implement a SQL script
to create the database, tables and
insert data
● Running the script in MySQL to
create the database
● Debugging SQL scripts using
MySQL
12.05.2014 09:00-16:00 Workshop Morning session: Java Computer
Programming(Paresh Rathod) room
● Exercise: Hands on practice &
Revision
Afternoon session: DB (Antonius Camara)
● NO CONTACT SESSION
19.05.2014 09:00-16:00 Morning session: Java Test - 03 (or) BIG Computer
TEST covering all topics(Paresh Rathod) room
● Test-03 topics: Viope chapter 6 to
8
● BIG TEST topic: Viope chapter
01 to 08(those students who didn't
take all three tests)
Afternoon session: DB (Antonius Camara)
● DB Test-3 (MySQL and SQL
scripts) or DB BIG TEST
26.05.2014 09:00-16:00 Morning session (09:00-11:30, Neon-Lab Java:
room 011) : Final Retake covering all Neon-Lab
topics(Paresh Rathod) (room 011) /
● Topics: Viope chapter 01 to 08 DB:
topics (including Array chapters) (207/207A)
Afternoon session (12:30 - 15:00, room
207/207A): Final retake DB (Antonius
Camara)
SoleOPS 3.5.5 Study offer © 2005-2016 Solenovo Oy