Week |
Class | Topic | Due | Where | ||||
|---|---|---|---|---|---|---|---|---|
| 0 | 0. Computer Career and Data Research & Technologies | |||||||
| 0.1 A computer career | ||||||||
| 0.2 Data research | ||||||||
| 0.3 Data technologies | ||||||||
| 1 | 08/25 08/27 |
1. Introduction to CSCI 513 | ||||||
| 1.1 Course outline | ||||||||
| 1.2 Tentative schedule | ||||||||
| 1.3 Software to be used | ||||||||
| 2 | 09/01 09/03 |
2. Programming Exercise I | ||||||
| 2.1 Specifications | ||||||||
| 2.2 A sample website | ||||||||
| 2.3 Construction steps | ||||||||
| 09/02 |
Last day to add a course or drop without record — 100% refund Last day to add audit or change to/from audit Last day to receive a refund on a dropped class Drops after the last day to add will appear on a transcript. |
|||||||
| 3 | 09/08 09/10 |
3. Essential Technologies for Exercise Construction | ||||||
| 3.1 HTML (Hypertext Markup Language) | ||||||||
| 3.2 CGI (Common Gateway Interface) | ||||||||
| 3.3 Using Oracle | ||||||||
| 4 | 09/15 09/17 |
4. Database-driven Website Construction | ||||||
| 4.1 Frontend development | ||||||||
| 4.2 Full stack web development | ||||||||
| 4.3 Database-driven website development | ||||||||
| 5 | 09/22 09/24 |
5. Database Models | ||||||
| 5.1 Relational databases | ||||||||
| 5.2 Object-oriented databases | ||||||||
| 5.3 Website construction summary | ||||||||
| 6 | 09/29 10/01 |
6. Oracle Databases | ||||||
| 6.1 Oracle SQL*Plus | ||||||||
| 6.2 Oracle data dictionary | ||||||||
| 6.3 SQL (Structured Query Langauge) | ||||||||
| 7 | 10/08 | 7. Web-JDBC Programming | ||||||
| 7.1 GET and POST methods | ||||||||
| 7.2 CGI forms and input fields | ||||||||
| 7.3 CGI radio buttons and checkboxes | ||||||||
| 10/06 (no class) |
|
|||||||
| 8 | 10/13 10/15 |
8. JDBC Programming | ||||||
| 8.1 Database connection | ||||||||
| 8.2 Query execution | ||||||||
| 8.3 Processing the result sets | ||||||||
| 9 | 10/20 10/22 |
9. Introduction to Android Programming | ||||||
| 9.1 Programming Exercise II | ||||||||
| 9.2 Android introduction | ||||||||
| 9.3 An Android hello-world project | ||||||||
| 10 | 10/29 | 10. Android User Interface Processing | ||||||
| 10.1 Hypertext | ||||||||
| 10.2 Radio buttons | ||||||||
| 10.3 Checkboxes | ||||||||
| 10/27 |
|
|||||||
| 11 | 11/03 11/05 |
11. Android SQLite Database | ||||||
| 11.1 Using SQLite | ||||||||
| 11.2 SQLite shell commands | ||||||||
| 11.3 SQLite in Android | ||||||||
| 12 | 11/10 11/12 |
12. An Android SQLite Project | ||||||
| 12.1 SQLite data declaration | ||||||||
| 12.2 SQLite data management | ||||||||
| 12.3 An SQLite example | ||||||||
| 11/13 |
Last day to change to or from S/U grading Last day to change to or from audit grading Last day to drop a full-term course or withdraw from school |
|||||||
| 13 | 11/19 | 13. Oracle Object-relational SQL | ||||||
| 13.1 Object types, tables, and references | ||||||||
| 13.2 Constructor methods | ||||||||
| 13.3 Data dictionary and objects | ||||||||
| 11/17 (no class) |
|
|||||||
| 14 | 11/24 | 14. Oracle PL/SQL | ||||||
| 14.1 Control structures | ||||||||
| 14.2 Cursors | ||||||||
| 14.3 Procedures and functions | ||||||||
| 11/25 11/26 11/27 |
|
|||||||
| 15 | 12/01 12/03 |
15. Oracle Object-relational SQL (Cont.) | ||||||
| 15.1 Nested tables | ||||||||
15.2 VARRAY (varying-length array) |
||||||||
| 15.3 Methods | ||||||||
| 16 | 12/08 12/10 |
16. Object-oriented DBMSs | ||||||
| 16.1 A non-relational representation | ||||||||
| 16.2 Object-oriented properties | ||||||||
| 16.3 Object-oriented database properties | ||||||||
| 17 | 12/15 |
|
||||||
| 18 | 12/22 | Grades posted before noon, Tuesday |
| If it’s not one thing, it’s another. |