University home »
Faculty of Science »
Department of Computer Science »
Courses » COMPSCI 280 S1 C » Lectures »
Computer Science
Lectures: COMPSCI 280 Semester 1, City Campus
Section 2 (6 weeks) - Angela
Top
| Week | Date | Handouts(pdf) | Examples | Exercises | Answers | Videos |
|---|---|---|---|---|---|---|
| 7 | 26/04 | Public Holiday | ||||
| 27/04 | Term Test | |||||
| 29/04 | ||||||
| 8 | 3/05 | 07 Arrays | 07 | 07 | Answer | |
| 4/05 |
|
|||||
| 6/05 | ||||||
| 9 | 10/05 |
|
||||
| 11/05 |
|
|||||
| 13/05 |
|
|||||
| 10 | 17/05 | 18 Excel Automation | 18 | 18 | Answer | |
| 18/05 | 19 Intro to Ado.net | 19 | 19 | Answer | ||
| 20/05 | 20 DataCommands | 20 | 20 | Answer | AddDataCommand | |
| 11 | 24/05 | 21 DataSets | 21 | 21 | Answer | |
| 25/05 | 22 DataTables | 22 | 22 | Answer | ||
| 27/05 | 23 DataBinding | 23 | 23 | Answer | BindAndFillDataSet | |
| 12 | 31/05 | 24 DataSet Updates | 24 | 24 | Answer | |
| 01/06 | UsingTableAdapters | |||||
| 03/06 | Revision |
Section 1 (6 weeks) - Ulrich
Top
COMPSCI280 PHPMyAdmin page for database management (can be used from home)
- Week 1:
- Lecture 1: slides handout and lab sheet for revision.
- Lecture 2: slides handout and lab sheet for revision.
- Lecture 3: slides handout and lab sheet for revision.
- Week 2:
- Lecture 4: slides handout and lab sheet for revision.
- Lecture 5: slides handout and lab sheet for revision of this and the next lecture. To complete the lab sheet, you will also need the SQL scripts for the social networking database example and the City table setup.
- Lecture 6: slides handout. The lab sheet for this lecture is included in the lab sheet for Lecture 5.
- Week 3:
- Lecture 7: slides handout and lab sheet for revision. To complete the lab sheet, you will also need the SQL script for the MP3 collection example.
- Lecture 8: slides handout and lab sheet for revision. To complete the lab sheet, you will also need the SQL script for the airline database example.
- Lecture 9: slides handout and lab sheet for revision.
- Week 4:
- Lecture 10: slides handout and lab sheet for revision. To complete the lab sheet, you will also need the SQL script for the airline database upgrade.
- Lecture 11: slides handout and lab sheet for revision.
- Lecture 12: slides handout and lab sheet for revision.
- Week 5:
- Lecture 13: slides handout. There is no lab sheet for this lecture.
- Lecture 14: Overflow. This lecture will be cancelled if we finish lecture 13 on time. However I will be available in the lecture theatre for assignment-related questions, demos, etc.
- Lecture 15: Review of lectures 1 to 13.
- Week 6:
- Note: The lectures in this week are not timed and there is no guarantee that we will finish all of them. Similarly, we may skip a few slides and so it's worth bringing the handouts for the following lecture along to each lecture as well.
- Lecture 16: introduction slides handout, IDE slides handout and lab sheet.
- Lecture 17: first program slides handout, data types slides handout and lab sheet.
- Lecture 18: operators slides handout, control flow slides handout and lab sheet.
-
Related Programmes
