INFS 1021 – Systems Analysis
INFT 1020 – Database Fundamentals
Lecture 1 – Course Introduction
1
Week 1 Learning Objectives
Students should be able to
Identify the course communication channels.
Become familiar with the course website navigation and its contents.
Review the contents of the Module Information Booklet including assessment items and due dates.
Identify the level of commitment required each week to maximise performance in the course
2
2
Database Fundamentals
Lecturer Andy Jordan
Andy.Jordan@unisa.edu.au
Course Coordinator Mrs Michelle Davy
michelle.davy@unisa.edu.au
michelle.davy@navitas.com
Student Services
SAIBT.CELUSA.StudentServices@navitas.com
3
3
Course Aims
To be able to interpret a problem situation and model system requirements
Problem solving is a vital skill for anyone working in IT
Problem Solving and Programming is a pre-requisite
Modelling the problem important regardless of the type of problem
Following syntax
Understanding errors and error messages
4
Databases are built and integrated with the majority of systems, whether for business or even games. To study this course, you need to have successfully completed PSP so that you have a good understanding of solving problems, following syntax and understanding errors.
4
Course Intended Learning Objectives
Explain how data is stored, interpreted and queried.
Express and describe the structure of data.
Design and structure information.
Form a query.
Administer a database.
5
Objectives of this course relate to generating a good understanding of the key elements of database development and using SQL to create queries. Extending from systems analysis when analysing the data and information requirements for the problem domain, database fundamentals embraces the design and creation activities as well as creating queries / asking questions of the database to create information required from the system users
5
Website Tour
Top section
Module Information Booklet
SAIBT Student Guide
Communication
Three menus
Assessments
Resources
Weekly Tasks
Survey becomes visible towards the end of semester
Assessments temporarily hidden until survey is complete
6
6
Assessments
7
Assessments tab provides a summary and access point to assessment tasks for the semester.
There are five major elements of assessment for Database Fundamentals.
Tutorial and Practical submissions worth 10%. You must submit answers to the weekly tutorial and practical tasks. The lowest two scores of each will be ignored and your mark calculated across the top eight submissions
Quizzes in weeks 4, 8 and 11. You have two chances at each quiz. They will open after class on the Friday and close at 11:59pm on the Thursday of the following week.
Assignment 1 is worth 20% due Friday of week 8 at 11:55pm. Information about the requirements for this assignment will be made available in the Week 5 lecture.
Assignment 2 is worth 20% due Friday of week 12 at 11:55pm. Information about the requirements for this assignment will be made available from Week 8 lecture.
The exam is worth 40% and you must pass the exam to pass the course. Questions in the exam will be similar to the tutorial work and quizzes throughout the semester. This further emphasises the importance of completing the weekly tasks and preparation. The Sample Exam in Week 12 and work through some of the answers. It provides you with a good guideline of what to expect in the exam.
7
Assessments
Schedule time for assignments in all courses
Start early
Extensions given only in extenuating circumstances
Be organised
Avoid plagiarism
Complete all continuous assessment tasks
Equivalent to 2 grades
Can pass the exam but fail the course
8
It is vital to ensure you plan for all assessments throughout all of your current courses, making time to complete them within the due time. It is recommended that you
look at the assignment details as soon as you receive the information so that you can determine the tasks required
link the tasks to the lecture material which can help with the planning
Don’t leave it to the last minute. Take advantage of the offer for submitting drafts to improve your grade
Assessment submissions are checked by the plagiarism software Turnitin and any academic misconduct will be dealt with accordingly.
The tutorial and practical assessment tasks are just as important as the major assignments. This 10% is vital to your success – it is one grade band so if you choose not to complete any of these tasks, your grade will be severely impacted. This has been the difference between a student passing and failing in the past.
8
Resources
Lecture resources
Download weekly materials as a zip file
Lecture notes
Practical tasks
Tutorial tasks
Textbook resources as pdf files
9
9
Resources
Assessment resources
Tips related to assignment tasks
General assignment help
Smarthinking
10
10
Resources
Database tool resources
Instructions for using draw.io / diagrams.net and umlet
Information about downloading and using SQL resources
11
11
Weekly Tasks
Each week
Weekly objectives
Readings
Tasks before, during and after class
Lecture notes and recordings, videos and other resources
Notes section included in lectures like a transcript of the lecture video
12
The Weekly Tasks tab provides access to weekly resources.
Each week you will be provided with details about
the weekly objectives
reading relevant to the lecture material
preparation tasks including links to assessment tasks due during the appropriate week
tutorial tasks
lecture notes
videos
any necessary additional resources.
The lecture notes will be provided as .pdf as this enables access by any technology. The notes section is provided at the bottom of each slide with helpful details to assist with your learning and understanding. There will also be sufficient space in this area to add notes. Alternatively, you can print the summary page and include notes provided in relevant sections. Either of these will assist you to bring together your weekly revision of materials and help enhance your learning of the course material.
12
Weekly Tasks
It is your responsibility to keep up with weekly tasks
Before class
Prepare tutorials
Download notes, watch videos, annotate notes as necessary
Complete assessment tasks
During class
Review lecture content
Complete practical and tutorial tasks
Demonstrate practical tasks to the lecturer
After class
Collate notes and complete tutorial questions
13
In order to succeed in any course, it is important to get into the habit
Before class
Prepare for tutorials before class
Download lecture notes
Annotate as necessary
Complete tutorial and practical tasks
It is vital that are prepared to take notes of important points I make or hints about the assignments or exam.
After Class
Write up / combine notes
Complete tutorial questions
Ensure practical tasks completed for the week
Note areas of poor understanding and post questions to the discussion board
Work on assessments where necessary
For true success in any course, you need to spend at least the same number of hours out of class that you are scheduled in class. Remember, studying four courses is the equivalent of a full time job – 40 hours per week
13
Communication
Communication etiquette
Spelling and grammar checked, no all caps
No SMS terms, extra punctuation or emoticons
Include a greeting
Sign off appropriately so you are clearly identified
Include a message with any attachment
Include a subject at all times relevant to the topic of the email
May be asked to upload a question to the discussion board
14
Effective two way communication is essential to success in any course. The video “Communication etiquette” shows some of the common “errors” students make when communicating to lecturing staff. These include
Making sure you use the spelling and grammar checker before sending the email or at least proof read the message before sending. If I feel that I cannot read your message, I will ask you to correct the language and resend before I answer your queries
Do not write in all caps as it appears you are shouting
Do not use SMS terms
Do not use emoticons, even in SMS messages
Do not use extra punctuation – one full stop or question mark is sufficient
Include a greeting at the beginning of your message – Hi Michelle
Sign off appropriately with your name so that I know to whom I must reply
If sending an attachment, make sure you include a relevant message. If the message area is blank, the email will be returned and you will be asked to resend with a proper message
Include a subject relevant to the topic of the email
Do not send personal emails with links to Youtube clips or other non-SAIBT related content
14
Course Communication – Which method
Course Discussion Board
Questions central where the answers will benefit all students about
Assignment
Course work
Misuse will not be tolerated
Response to a post will be within 24 hours
Email sent to subscribers
15
Discussion board rules
Discussion boards are to be used to post questions in a central area where it , not give negative feedback or abuse
Anyone can post or reply to a message
Response will be posted within 24 hours
Inappropriate comments
Comment will be removed from the forum
Student may be banned from use of the forum
Student will be required to see the Academic Director
15
Course Communication – Which method
Email
Notify of illness
Request a meeting
Request an extension
Must be before the assignment due date
Response within 24 hours
Emails read each morning during the week
Use UniSA or SAIBT Outlook rather than personal email
Easier identification
16
Personal communication relates to
Assignment questions related to your submission only
Personal issues
Extension requests – these must be emailed before the due date of the assignment and be accompanied by relevant and appropriate reasons for the extension
Emails are read each morning so you should have a reply within 24 hours. Please note that sometimes Outlook moves emails to “junk” so if no reply has been received within 24 hours please don’t hesitate to send a reminder.
If a general question related to the course or assignment is emailed, your reply may be a request to post the question to the Discussion Board before receiving an answer
Use your Outlook account on the Student Portal and email to michelle.davy@navitas.com or michelle.davy@unisa.edu.au
Select “Contact Us” and select Michelle Davy from your list of lecturers
Avoid using your private email address
Easier for us to identify you via SAIBT or UniSA email
Record of communication can be saved for later reference
16
Responsibilities
It is your responsibility to check your SAIBT and UniSA email at least twice a week
This is our only point of contact with you
We will not communicate with your personal email
Check the Announcements and Discussion Forum weekly
May have missed an email
Be aware of all deadlines
Extension request reasons likely to be denied
“I forgot”
“I have a lot of assignments due this week”
Create a schedule for all of your studies and any work
17
It is the responsibility of each student to check your emails at least twice a week. This is the only point of contact that lecturers and other SAIBT staff have with you. You also need to make sure you check the announcements and discussion forum at least once a week for any course related communication.
Make sure you are aware of when each assignment is due – for all courses – and plan your time accordingly. Don’t wait until the last minute to start. Extensions are not given if the excuse is “I forgot” or “I had other assignments to work on”.
17
How to Succeed
There is no such thing as a “stupid question”
If you do not understand a concept please ask
I do not care how many times you ask a question. It is the only way I can determine what you do or do not understand
I do not care how many times you ask the same question. I will work through the problem with you to help you to determine the answer
18
I always say to my students that there is no such thing as a “stupid question”. A question is a question. I will never mock you, say things like “Are you kidding! Don’t you understand this yet? I have been through it four times already!”. I will not allow students to mock you if you ask a question in class.
I don’t care how many times you ask the same question about theory. If you have not understood previously, I will spend the time to help you. If you don’t ask questions, I cannot accurately determine how you are progressing in the course.
18
How to Succeed
Prepare tutorial questions and practical tasks each week
Take notes from lecture recordings
Ask questions about sections of the course you do not understand
During class
Via the discussion board
Get started on assignments as soon as you receive the information
Help desk / additional time for help will be provided weekly from week 3
19
To really succeed in this course you need to review the week’s content, complete the practical tasks and weekly tutorial questions. If you can, allocate the weekend to this so that you have a better chance of recalling what was said in class. At this time, write any questions that you may wish to ask in class or via other media so you do not forget.
During class, take additional notes to help you in your understanding – examples given, hints or even examples you from your own experience that are similar to the theory
Completing tutorial questions is very important as this will help you in the exam. The questions that are asked each week are similar to those in the exam.
Lastly, get started on assignments as soon as you receive them. Download them, read the questions, schedule time to complete the tasks. It is a good idea to make sure you have time to ask for a draft check to give you the confidence that you are on the right track with your answers.
Attend the weekly sessions as necessary to ask questions. Each individual will be assisted
19
Copyright Regulations
COMMONWEALTH OF AUSTRALIA
Copyright Regulations 1969
WARNING
This material has been reproduced and communicated to you by or on behalf of University of South Australia pursuant to Part VB of the Copyright Act 1968 (the Act).
The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act.
Do not remove this notice.
20
20
/docProps/thumbnail.jpeg