Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
cours:cours_home_automation_bat4_2018 [2019/03/27 18:43] tigli [Lecture 2 & 3 : C#, Excel and Web Services] |
cours:cours_home_automation_bat4_2018 [2019/05/10 11:39] (Version actuelle) tigli [Lecture 8 : Smart Building Automation] |
||
---|---|---|---|
Ligne 21: | Ligne 21: | ||
<note warning> | <note warning> | ||
- | Every group must send a preliminary **description of the subject of its project** before tuesday the 9th of April at 12 PM. | + | Every group must send a preliminary **description of the subject of its project** before wenesday the 10th of April. |
Then will be able to discuss your proposals during the wenesday course. | Then will be able to discuss your proposals during the wenesday course. | ||
Ligne 36: | Ligne 36: | ||
[BAT4 IMMO PROJECT 2019] GROUP <group number> - <First student Name> - <Second student Name> | [BAT4 IMMO PROJECT 2019] GROUP <group number> - <First student Name> - <Second student Name> | ||
- | ex [BAT4 IMMO PROJECT 2018] GROUP 1 - Tigli - Collaviza | + | ex [BAT4 IMMO PROJECT 2018] GROUP 1 |
- | + | ||
- | </note> | + | |
==== Lecture 2 & 3 : C#, Excel and Web Services ==== | ==== Lecture 2 & 3 : C#, Excel and Web Services ==== | ||
Lecturer: H. Collaviza | Lecturer: H. Collaviza | ||
+ | |||
+ | ---- | ||
=== Lecture 2 : EXCEL as main application and C# for interroperability with other softwares === | === Lecture 2 : EXCEL as main application and C# for interroperability with other softwares === | ||
- | |||
- | ---- | ||
=== Lab : === | === Lab : === | ||
Ligne 60: | Ligne 58: | ||
=== Lecture 3 : Web services and C# to access to these services (data collection in EXCEL) === | === Lecture 3 : Web services and C# to access to these services (data collection in EXCEL) === | ||
- | ---- | + | |
=== Lab : === | === Lab : === | ||
Ligne 71: | Ligne 69: | ||
** What's to do ** : USE the C# solution to access openweather Web Service and to store automatically the data in your excel file. | ** What's to do ** : USE the C# solution to access openweather Web Service and to store automatically the data in your excel file. | ||
- | ==== Lecture 4 : Web Services to access to sensors and actuators with C# (data collection in EXCEL) ==== | + | ==== Lectures 4,5 : Smart Building Project ==== |
+ | Main purpose of this project is to apply the different aquired comptences from the three courses of this BAT4 year: | ||
+ | * Software Programming with C#, graphical user interface design with C# and Excel interroperability with C# | ||
+ | * Web services interroperability with C# to access to world wide information systems | ||
+ | * Web Service interroperability with C# to access to actuators and sensors on the field | ||
+ | The overall architecture consists in : | ||
+ | * A winforms or webforms application | ||
+ | * that invoke some web services to get and/or to send information from information systems, sensors, actuators | ||
+ | * that opens a excel sheet to write and read in cells | ||
+ | |||
+ | == Work Groups == | ||
+ | |||
+ | |Group Number| email Student 1 | email Student 2 | email Student 3 | Project Topic | | ||
+ | |Group 1 | lucille.bouchet | dorine.chiavaro | adele.grandidier | smart garden | | ||
+ | |Group 2 | thomas.kurenov | alban.marrou || smart heater agenda| | ||
+ | |Group 3 | justine.carbonnel | arnaud.bahon || air quality care| | ||
+ | |Group 4 | antoine.bilger | dawid.tusien || ...| | ||
+ | |Group 5 | eric.nguyen | maha.ezzaouia || concrete o'clock| | ||
+ | |Group 6 | yassine.sayerh | mohamed.seifeddine|| ...| | ||
+ | |Group 7 | julien.macke | florian.caillat|| ...| | ||
+ | |Group 8 | gabriel.chavalarias | elena.cojocaru|| smart energy manager| | ||
+ | |||
+ | == More details in French == | ||
+ | [[cours:Projet Int Res et Immotique 2017 | Projets BAT4 Prog -- Int & WS - Immo]] {{:drapeau_francais.jpg?30|}} | ||
+ | |||
+ | == Steps in the Project == | ||
+ | |||
+ | * STEP 1 : General description of the topic of the Project LAb | ||
+ | * STEP 2 : Description of the differents Project entities : | ||
+ | * List of the web services API you're using and all required technical information for C# access | ||
+ | * A mockup of the graphical interface with all the required widgets | ||
+ | * A description of the differents sheets, data, formula and charts in Excel | ||
+ | * STEP 3 : Development of Excel WorkBook with some simulated input data | ||
+ | * STEP 4 : Connection with Web Services to fill input cells | ||
+ | * STEP 5 : Development of the graphical user interface and interaction with excel to read/write in specific cells, to display some charts. | ||
+ | |||
+ | This project plan will be reuseable in other smart building projects (in real use cases studied in BAT4 and BAT5) | ||
+ | |||
+ | |||
+ | ==== Lecture 7 : Web Services to access to sensors and actuators with C# (data collection in EXCEL) ==== | ||
+ | Lecturer: J.Y. Tigli | ||
---- | ---- | ||
Ligne 115: | Ligne 153: | ||
- | ==== Lecture 4 : ==== | + | ==== Lecture 8 : Smart Building Automation Project==== |
---- | ---- | ||
- | Lecturer: J.Y. Tigli | + | Lecturer: WIT engineer |
- | + | ||
- | 8:00 - 12:15 : During the lab : Technical support by teacher to solve last technical difficulties of the students in their project. | + | |
- | + | ||
- | 10:00 : middle time progress assement, to possibily reconsider the ambition of the students project (indeed, the project must be finished at the end of this lab). | + | |
- | ==== Lecture 5 : ==== | + | ==== Lecture 9 : ==== |