The exam is on the 26th August 9am. You must be at the exam location 15 mins prior (i.e., 8:45am).
You can also check your seating allocation via the following URL:
You must login with your zID details.
The exam is for 3 hours. This is to give you more time for the practical part (SQL).
You can check the marks by logging into your CSE account. Then running:
$ 9311 classrun -sturec
Separately to the marks, emails containing marked files + feedback have been sent to your UNSW student email account.
As discussed before, for Week 3 quiz, Q1 both B and D are marked correct, Q4 both B and D are marked correct.
Week 9 lab introduces the CSE VLAB environment (including a bit of unix concept) and SQLite3. Owen prepared them specially for students who are not familiar with the CSE lab environment, and also as a way to introduce a different database environment.
The lab is particularly important because the final exam is going to be run in an almost identical setting. The main aim is to get you to become familiar with writing SQL using the SQLite3 database and using the UNIX terminal environment.
I noticed while walking around the class room that quite a few of you have not setup the work environment (lab/assignment environment) yet ... and not familiar with your way around the server/local computing environments.
Please make sure that you visit one of the lab classes and ask the tutors to go through the environment setup with you so that you know your way around the terminals, shell commands, file transfers, running editors, locating files, etc.
Do this now while you are doing the assignment. You will really NEED it for the final exam.
Any questions, let me (and tutors) know.
The spec for assignment 2 is out now. Tomorrow, I will go through the database and run some exercises together to get you started on the assignment. So if you'd like, you can setup your PostgreSQL server with the ass2 database to do some of the exercises with me. If you are not bringing your laptop, no problem at all, you can still go through the exercises by following the lecture.
There are quite a few students who have a midterm exam this week. So we will move the deadline to Sunday (7th) 5pm.
Week 4 quiz is due tomorrow. The stage 2 of the assignment 1 is due this Thursday 9m.
The solution for the previous lab on Web log data has been released (look at the bottom of the lab instruction page). This week, there is no new exercise to be released for the lab classes. The tutors will be there to help you with the assignment and any catch-up issues on the labs so far.
Sahil and Zhuang have kindly agreed to open an extra consultation time tomorrow (Friday).
Go to K17 Room G01 and G02. 5pm to 6pm (28th June)
They can give you some pointers on the assignment or help you with the lab questions.
Don't forget Quiz 3 (due 10am Monday). Q1 of Quiz 3 has two correct answers. They will be manually corrected later. So don't worry about the marks if you think you are 1 short.
Assignment 1 Stage 2 is out. It is due 4th July Thursday 9pm (moved from 5pm to cater for students who are working part time/full time). Utilise the lab classes with tutors.
Don't forget to spend a few minutes to do the quiz. Due Monday (tomorrow) 10am. Late submissions are not allowed - and I am less likely to repeat a reminder every week from now on :-)
The quiz for Week 2 is out. Due next Monday 10am.
For those of you who already filled in the feedback form, big thank you ... There will be a school meeting on the topic soon, so more responses would be good.
A few points for Week 2 ...
You can find the questions from Activities. Since next Monday is public holiday, I set the due date to Tuesday 10am. You can see the results after the due date - I think the system automatically makes the results visible after the due date.
Big hello to all COMP9311 students!
The course outline is now up. Please check the menu section of the course homepage.
Important note: there is NO LAB in Week 1. This term the labs will operate slightly differently and this will be explained during the intro lecture. I repeat ... NO LAB in Week 1.
See you all at the intro lecture on Monday 3rd June. Looking forward to meeting you in person!