For students who are granted supplementary exam:
1. Could you please check your email and contact me at wenjie.zhang@unsw.edu.au as soon as possible.
2. Supp exam is scheduled at 1PM to 5:30PM Sydney time, 14 Jan. The exam paper will be posted in webcms in a tab name "Supp Exam" in this website.
3. Submission is the same as for assignments. If any trouble, send to my email directly.
Dear Students,
A Final Exam tab has been created in this website. On 4:00 PM, 3rd December, the exam paper will be released here. Any possible corrections will also be posted here.
Please read below to avoid misconduct in the exam.
Good luck.
Dear Students,
There is some inconsistency between the weekly learning outcomes of PLpgSQL and the final exam scope in Week 10 revision.
To make it consistent,
- PLpgSQL will not be assessed in final exam.
- SQL may be assessed in True/False questions.
Dear Students,
Below are the details for our final exam COMP9311 T3 2020.
Time: 4PM to 8:30PM, Sydney time. 3rd December 2020, Thursday.
Where to get the exam paper: will be released on our course website (https://webcms3.cse.unsw.edu.au/COMP9311/20T3/), on 4: 00PM 3rd Dec.
How to submit: via Moodle, the same way as you submit assignments.
- It will be a normal 2-hr exam paper similar to previous years. Extra 2.5 hours allowed to compensate the time spent on downloading the exam paper, uploading solution, etc.
- How to get the exam paper and how to submit is the same as what you did for the 2 assignments.
- You may submit multiple copies and we will mark the LAST one.
- In case near 8:30PM and you have trouble submitting via Moodle, send your solution to comp9311unsw@gmail.com with your name and zid.
- Any questions during the exam, send email to wenjie.zhang@unsw.edu.au or comp9311unsw@gmail.com.
- We accept any format: directly answering using word, or handwriting and convert to word / pdf. We only require the file to be clear and in .doc or .pdf.
Dear Students,
A sample exam paper and its solution are released. Please note it only gives you an idea how the final exam paper looks like, but not the scope of exam.
On Tuesday Week 10 we will review the whole course and discuss about the scope of final exam.
Dear Students,
We will run daily consultation before the final exam. You will be able to get support instantly in case you have a problem in preparing for the exam.
Join the session the same way as you do for our normal weekly consultation sessions.
Time: 3PM to 4PM
Monday 23rd Nov
Tuesday 24th Nov
Wednesday 25th Nov
Thursday 26th Nov
Friday 27th Nov
Monday 30th Nov
Tuesday 1st Dec
Wednesday 2nd Dec
Dear Students,
As mentioned in this week's lecture, besides the regular weekly lab session / consultation / lectures / course forum, if you experience difficulty in this couse and would like to seek extra support, please email me at wenjie.zhang AT unsw.edu.au. I will arrange individual help sessions in which a tutor will mentor you through the difficulty.
Dear Studnets,
Assignment 2 has been released and the due date is 5PM, Wed 18 November.
Assignment 2 allows a shorter period because we need to release the solution soon so you can start preparing for final exam. We can only release the solution several days after the due date since some of our students are approved by the university with special consideration to extend the due date for medical reasons.
At the meantime we minimize the workload for assignment 2 so it will not take much of your time. Please start working on it early !
Dear Students,
Even there are no teaching activities scheduled for week 6, if you have any questions you may still seek help via the Forums of course website or send emails to comp9311unsw@gmail.com . Tutors will regularly check and respond during week 6.
Dear Students,
Project is released. As requested by many students, the due date now for project is 5PM Sunday, 1 Nov.
Please start early !
Dear Students,
Assignment 1 is released, due 5PM Friday 9 Oct (Sydney time). The submission site is with Moodle.
Please start early. Enjoy !
Dear Students,
As requested, we will also record the consultation and all lab sessions. This means from week 2, there will be more than 10 videos recorded in Moodle each week. We will put the short-cut links for lecture recordings in the Lectures tab, just below the corresponding lecture notes. For consultation and lab sessions, you will need to log into Moodle and locate the recorded videos.
Consultation time : 3PM-4PM Monday from week 2.
Lab sessions : if you miss your own lab session, you can always join the other lab sessions instead to ask questions.
Information about how to join live consultation and lab sessions, and how to access the recorded videos in Moodle has been discussed in the previous notice.
Dear Students,
First, I would like to welcome everyone and I hope all of you are looking forward to learning about database systems.
In this notice, I will briefly outline how I plan to run the course in T3 2020.
Due to the COVID-19 situation, we will be running all course activities online. In the context of our course, this means lectures, consultations and lab sessions are done via a mixture of online platforms and tools.
Course management: We use WebCMS3 ( https://webcms3.cse.unsw.edu.au/COMP9311/20T3/ ) to manage the course (the very system you are reading this notice from). All announcements, lecture notes, lab notes, assignment spec, etc. are going to be posted here. Moodle is used to provide access to online live lecture and lecture recordings.
Lectures (lectures start from Week 1): We will deliver lectures live online at the scheduled lecture time - 4PM to 6PM Monday, and 1PM to 3PM Tuesday (Sydney time). We understand that many students are overseas with different time zones and hope this will not cause too much inconvenience to you. The reason we want to use live lecture delivery is to make the teaching as interactive as possible as I will be able to take questions during the lecture. In case you find it difficult to join the online lecture, you can always access the recorded video afterwards.
All lectures will be delivered and recorded via Blackboard Collaborate in Moodle. There are two ways to access the lecture: 1) we will provide a link to access the lecture (live and recording) in the Lectures tab, next to the lecture notes each week. 2) you may log into Moodle ( https://moodle.telt.unsw.edu.au ) first, find our course, click "lectures and recordings", click Menu (in up left corner), click "Sessions" to join a live lecture or "Recordings" to access the recorded lecture.
Labs (labs start from Week 2): Detailed lab notes will be provided and you are expected to follow the guide using your own computer. We will schedule online lab sessions throughout the course (via Blackboard Collaborate) and there will be tutors present to help you. Similar to lectures, a link will be provided in the Labs tab in WebCMS for each week, and you are also able to access via Moodle.
Note that only the first lab in week 2 (introduction to the environment setting up) will be recorded. All other sessions are supposed to help students with questions.
Consultation (consultation starts from Week 2): weekly consultation will also be presented via Blackboard Collaborate. You may join the consultation if you have any questions regarding the course. Consultations will not be recorded. A link will be provided in the Consultation tab for you to join, also you may join via Moodle.
Assessment : All assignments, projects and final exam will be conducted offline. Generally we allow 2-3 weeks for you to work on assignments and projects.
You can start using the "Q and A page" Forum to ask questions and discuss with your fellow students. Tutors will visit the forum regularly to answer questions. Feel free to ask questions and talk amongst your fellow students in the class.
Looking forward to meeting you all soon.