INFS1200/ INFS7900 Introduction to
Information Systems
Semester 1,
2012
This course introduces the student to the area of computer-based information systems.
It focuses on database management and includes basic concepts necessary to correctly design, and implement, a stand-alone information system.
The course will prepare students to deploy small information systems in practice and will also prepare them for further study of advanced information
system concepts taught later in the IT programs. Senior Math B or MT 140 is assumed background.
Basic set theory is useful. No computer
programming experience is assumed.
 |
|
 |
 |
|
Course Profile |
Resources |
Assessments and Results |
Contacts and Consultation |
| 20.05.2012 |
Quiz 2
Solutions and Summary of common
mistakes available now |
| 16.05.2012 |
Plan for weeks 12 and 13: Week 12: Tutorials: Quiz 2 feedback/solutions and exams to be returned Practicals: More practice on SQL in LDBM Monday Lecture: Further practice of advanced SQL, start Module 8 Wednesday Lecture: continue Module 8 Week 13: Tutorials: Revision Practicals: More practice on SQL in LDBM or other exercises in LDBM Monday Lecture: Complete Module 8, Introduction to Final Exam, Class Exercises and Questions relating to Final Exam, Student Feedback, Annoucement of the WINNER FOR OLYMPIC DATABASE COMPETITION! Wednesday Lecture: Optional (revision only) |
| 09.05.2012 |
Quiz 2 will take place @ 10AM on Monday 14 May 2012 Mock Quiz 2 available for practice. See also LDBM P7-Practice SQL |
| 24.04.2012 |
Quiz 1 results are now available
here. Please
ensure that your marks are correctly entered and report any errors to your
tutor. In addition to the marks, you will also see what is known as a
Kiviat chart as part of your feedback for your engagement and performance
in the course so far. The chart allows you to compare yourself with the
class averages. There are 5 dimensions available in the chart: P1 and P2
refer to your engagement with the first two sets of exercises in LDBM;
Lecture refers to your attendance in lectures; Tutorial refers to your
attendance in tutorials and Quiz 1 refers to your marks in Quiz 1. Note
that besides Quiz 1 marks, nothing else carries any actual marks that will
count towards your grade. The rest is all for your feedback, including a
short recommendation at the end which simply identifies for you what
element of the course you could focus on to further improve your learning
and results. As further feedback for the Quiz, see also the Solutions and Summary of common mistakes. |
| 23.04.2012 |
Frequently Asked Questions (FAQs) on Assignment as presented in lecture today are available here (browse to the bottom of the page) |
| 02.04.2012 |
Quiz 1 will take place @ 10AM on Monday 16 April 2012 On Wednesday 4 April 2012, there is no lecture and instead I will go through the content for Quiz 1, including a mock quiz and/or sample questions dependning on time. Attendance is optional as no new content will be introduced. Here is the Mock Quiz 1 as discussed in class on Wednesday |
| 28.03.2012 |
Competition!! As part of the assignment, you have to enter some sample data in your MSAccess implementation to allow us to assess the forms, queries and reports you will create. However, a (near) complete historial record of the entire Olympic games is available from www.databaseolympics.com. Any student or group of students who can enter (copy/paste, import etc) "all" the data into their MSAccess database will get a surprise prize from me. Submission can be made as a .zip file of your MSAccess .accdb file to me via email shazia@itee.uq.edu.au anytime before 5PM 9th May 2012. |
| 16.03.2012 |
Assignment (25 Marks) available here Due date: 4 May 2012 @ 5PM |
| 12.03.2012 |
Tutorial and Practical signup on sinet extended to 31 March. |
| 07.03.2012 |
Reminder that Tutorials and
Practicals start from Monday 12 March. Weekly plan, tutorial questions
and tips for practicals available here |
| 28.02.2012 |
Note change of venue for both lectures. (Many more students joined the course, so bigger rooms were needed) · Monday 10-12pm 01-E109 · Wednesday 12-1pm 08-139 |
| 28.02.2012 |
If you are not confident with MSAccess, NOW is the time to get started. There will be 2 supervised prac session in weeks 3 & 4 to assist with MSAccess, so it is a good idea to get the MSAccess textbook (Grauer, Mast & Poatsy Exploring Microsoft Access, 2010)
and go through the required chapters now - this way you will be
prepared to take your questions to the supervised prac session in week
3 & 4. |
| 28.02.2012 |
Lecture recordings for monday
lecture now available from blackboard (under Learning Resources ->
Lecture Recordings). Links also available from here |
| 28.02.2012 |
You are welcome to use the
newsgroup for the course (uq.itee.infs1200). Help on how to use
newsgroup at help.its.uq.edu.au/myuq/newsgroups/ |
|
10.02.2012 |
Welcome
to INFS1200/7900. This course will be your first introduction to
databases and information systems. As most of you will be aware,
computer based information systems are found all around us in almost
every domain. Correct database design, and effective data management
form to a large extent, the foundation for the success (or failure) of
an information system. The database community is very significant both
in academia and industry. It consists of large industry/vendors like
Oracle www.oracle.com
, DB2 (IBM) www.ibm.com/db2, SQLServer
(Microsoft) www.microsoft.com/sql
. This community is also privileged to have some of the top researchers and
scientists in computer science. You will find a database group in almost all
IT/CS schools in the top universities around the world. The Data and Knowledge Engineering Group at the School of ITEE conducts research and teaching in this area. The |