Introduction to Databases for Business Analytics
Week 10 Final Exam Advice
Term 2 2022
Lecturer-in-Charge: Kam-Fung (Henry) : Tutors:
Copyright By PowCoder代写 加微信 powcoder
PASS Leader:
• There are some file-sharing websites that specialise in buying and selling academic work to and from university students.
• If you upload your original work to these websites, and if another student downloads and presents it as their own either wholly or partially, you might be found guilty of collusion
— even years after graduation.
• These file-sharing websites may also accept purchase of course materials, such as copies of lecture slides and tutorial handouts. By law, the copyright on course materials, developed by UNSW staff in the course of their employment, belongs to UNSW. It constitutes copyright infringement, if not academic misconduct, to trade these materials.
Acknowledgement of Country
UNSW Business School acknowledges the Bidjigal (Kensington campus) and Gadigal (City campus) the traditional custodians of the lands where each campus is located.
We acknowledge all Aboriginal and Islander Elders, past and present and their communities who have shared and practiced their teachings over thousands of years including business practices.
We recognise Aboriginal and Islander people’s ongoing leadership and contributions, including to business, education and industry.
UNSW Business School. (2022, May 7). Acknowledgement of Country [online video]. Retrieved from https://vimeo.com/369229957/d995d8087f
❑ General Exam Information
❑ Final Exam Section in Moodle ❑ The Day Before the Exam
❑ Exam Day
❑ Exam Preparation
❑ Exam Consultation
General Exam Information
General Exam Information ❑Format: Online Open-book Exam
❑ 50% of your overall mark (paper is marked out of 100)
❑Date: Monday, 22nd August 2022
❑ Start Time (via Moodle): 09:00 am ( )
❑ Finish Time (via Turnitin): 01:00 pm ( )
❑ Duration: submit within 4 hours (3 hours Writing Time + 1 hour Reading/Submission Time)
❑ WORD Document submission only. Answer template provided. PDF or other formats NOT accepted.
❑Late submissions -15% of available marks penalty (-15 marks) for every hour of lateness. ❑ e.g., if you submit between 01:01 pm and 02:00 pm → -15 marks
❑Submit when you finish. Do not wait till the last minute!!
General Exam Information
❑Some of you may have 2 exams on the same day. This is NOT considered a clash. This is a university wide policy (not mine).
❑University academic misconduct rules apply and will be handled and decided by Faculty’s integrity unit (LiCs are not part of this committee).
❑This is an Exam and NOT an assignment.
❑ There is NO marking criteria provided and there will be NO qualitative feedback (i.e., Turnitin
feedback).
❑Final grades will be released as per university schedule. ❑ We will not release final exam numerical marks on Moodle.
General Exam Information ❑ 4 Questions – with sub-parts
❑ You are required to answer ALL questions (i.e., all questions are to be attempted).
❑ Some questions have word limit as specified on the exam paper ❑ Use the word limit as an indication.
❑ You must NOT exceed the word limit!
❑ Text exceeding the word limit will NOT be marked.
❑ Text inserted as pictures will NOT be marked. Only figures can be inserted as
Breakdown of the Exam
❑ Question 1 Functional Dependency – 10 Marks ❑ Question 2 Case Study – 35 Marks
❑ Question 3 Normalization – 40 Marks
❑ Question 4 SQL – 15 Marks
What is Examined
❑ Week 1: ALL
❑ Week 2: ALL
❑ Week 3: ALL
❑ Week 4: ALL
❑ Week 5: ALL, except Relational Algebra Exercises (Anything related to SQL is examinable) ❑ Week 7: ALL
❑ Week 8: ALL
❑ Week 9: ALL
❑ Week 10: ALL; feel free to write/use VIEW if you are asked to write SQL queries.
Final Exam Section in Moodle
1. Pre-Exam Information Section
Declaration Form
You are required to read the declaration form and manually mark the activity as ‘done’ before you can access the final exam.
2. Final Exam Section
2. Final Exam Section
b. Final Exam Paper, Answer Sheet & Submission Link
▪ You will be able to
access the exam paper, answer sheet and submission link after you read the declaration form and mark the activity as ‘done’.
2. Final Exam Section
c. Final Exam Forum
The forum is for exam paper clarification only. The LiC will be attending the forum for the 1st hour of the exam, i.e., 09:00 – 10:00 am, 22nd August 2022.
Sheet Format
Answer Sheet will no longer be customised. That means you need to enter the details onto the answer sheet (e.g., name, student ID, course code, course name, and exam date).
The Day Before the Exam
The Day Before the Exam
❑Have your laptop fully charged. (Ideally, plug-in the AC charger during exam!) ❑Restart your computer; you might choose to install all Windows/Mac updates. ❑Have a backup device if possible.
❑Have a backup Internet connection (e.g., hotspot from your phone).
❑Clear all distractions from your desk.
❑Set your desk and organize your notes, homework, tutorial class work per topic. ❑Set your alarm for the next day.
❑Have enough sleep.
Exam Day – Tips
❑ Have your breakfast prior to the start time of your exam.
❑ Do not place any food or drink (including water) on your desk so you do not spill fluid on your computer.
❑ Create an exam folder (COMM1822 Final Exam) on your OneDrive.
❑ When the exam paper becomes available, download it with other required documents (declaration/template) and save them in that folder.
❑ Keep backups of that folder.
❑ Read the exam paper and the instructions.
❑ Avoid any distractions while working on your exam
(social media, etc.)
Download Instructions
Download exam paper from the course Moodle page under ‘Final Exam – Term 2, 2022’ Section
❑ The LiC will be available to answer ONLY for typographical and grammatical error questions for the first hour (i.e., 09:00 – 10:00 am ) on exam day via COMM1822 – Final Exam Forum under Final Exam – Term 2, 2022 section in Moodle.
❑ Questions on how to address, answer, interpret or what perspective to take will not be entertained.
❑ Your ability to understand or think through what is required is part of the assessment.
Email Etiquette – Reminder
❑ If you need to contact the LiC Kam-Fung (Henry) Cheung you can send emails only from your UNSW account:
❑ The subject field must start with [COMM1822]
❑ You must sign your email message with your Full Name and your zID. ❑ Send short, brief, and concise email messages.
❑ Emails that do not follow the email etiquette may not receive a response.
❑ You cannot contact any COMM1822 tutor for the entire duration of the exam until the final grades are released.
❑ Tutors will NOT respond to any email regarding your exam/marks. ❑ Tutors will NOT forward your email to the LiC.
Referencing and Integrity
❑ You DO NOT need to cite the use of textbook, lecture slides, course notes (you do NOT need to say things like “The lecturer said…”, for the purpose of COMM1822 final exam we consider this as official course materials/internal sources.
❑ ALL OTHER SOURCES OUTSIDE OFFICIAL COURSE MATERIALS including website links you find on course slides is subject to potential plagiarism rules if not properly acknowledged. If you access an external link, you must acknowledge it. Ensure you read the university rules on plagiarism and if in doubt regarding Harvard referencing.
❑ University academic misconduct, fraud and plagiarism rules apply – take the time to know what the rules are. My advice is – don’t risk it!
❑ This final exam guide is NOT exhaustive. It is the student’s responsibility to check the university rules and UNDERSTAND them. If you are unsure, contact the university’s learning advisor for support, as it is not your tutors or LiC’s role to teach you referencing. (support links provided on slide: University Study Support ).
❑ Ensure your answers are your OWN WORK. Copy pasting materials verbatim even if you have in- text referencing does NOT meet the criteria of producing your own work.
Submission Instructions Submission ONLY via Turnitin
❑ You are reminded of UNSW Rules regarding Academic Integrity and Plagiarism: https://www.student.unsw.edu.au/plagiarism
❑ You can only submit once.
❑ We DO NOT accept email submissions.
❑ Word documents are accepted only.
❑ PDF submissions are NOT accepted and they will incur (-10) marks penalty.
❑ TRIPLE-CHECK the file you are submitting.
❑ It is YOUR responsibility to submit the correct file!!
❑ We will mark ONLY what is submitted on Turnitin (No Excuses).
Submission Instructions
❑ File name convention for your word document must be as follows: zID_COMM1822.doc – (example z1234567_COMM1822.doc)
❑ Turnitin Submission Title (the same): zID_COMM1822 – (example z1234567_COMM1822) ❑ (-10) marks penalty for not using the correct naming convention.
Submission Confirmation
❑ Wait for the Turnitin Digital Receipt confirming your submission.
❑ Print and save this receipt.
❑ Check that your submitted file is NOT corrupted.
❑ How? Download it to your computer and open it.
❑ Check that your models read well. (In rare cases the model might be altered by Turnitin). If you spot a problem, contact the LiC before 3:00 pm, 22 August 2022).
❑ Keep checking your UNSW email and the Teams Channel.
❑ Enable Microsoft Teams notifications on your computer/smartphone after you submit in case we need to
contact you urgently.
❑ DO NOT SHARE OR DISCUSS YOUR EXAM IDEAS OR ANSWERS WITH ANYONE!! This makes you BOTH subject to Plagiarism: https://student.unsw.edu.au/PLAGIARISM (Think 3000 times before doing such thing) – Plagiarism is a serious breach of ethics at UNSW and is not taken lightly.
Special Consideration
❑ Special Consideration to take supplementary exam has to be applied online as this is centrally managed by faculty. Please refer to UNSW Special consideration policy and fit to sit rule.
❑ https://student.unsw.edu.au/special-consideration (read carefully)
❑ Do not aim for the supplementary exam (application for supplementary exam only in a narrow range of circumstances, acceptance of application is not guaranteed).
❑ Such cases are not decided by the LiC.
How to Answer Your Exam Questions
❑Use the Word Document template provided ❑ Use Arial Fonts / Font Size 12 / Spacing 1.5 ❑ Follow word limit wherever required
❑One Paragraph = One Idea!
❑Answer the whole question together and in order ❑ ☹️Q1, Q3b, Q2b, Q2a, Q4c … Avoid
❑ 😉Q1, Q2a, Q2b, Q3a … USE THIS!!
❑MUST LABEL your answers clearly so that we know to which questions they belong. If you do not label the questions properly, there will be NO further discussions as to which questions you intended to answer.
❑ Again: text inserted as pictures will NOT be marked. Only figures can be inserted as pictures.
Drawing Models
If you are asked to draw models
❑ Can use Visio, Word, PowerPoint and any other drawing program.
❑ Can use online tools like LucidChart, diagrams.net.
❑ Take screenshot of the model and insert them into your Word document. ❑ Screenshots must be clear and easy to read.
❑ If we cannot read it, we will NOT mark it.
❑ You have plenty of time, submit clean and neat exam paper and diagrams.
Exam Preparation
Exam Preparation Tips
❑ Best help: Your peers! (study in online groups?!)
❑ Your notes, lectures, labs, assignments, etc.
❑ Familiarize yourself with Moodle system requirements and the university rules on plagiarism and misconduct. It is your responsibility as students to understand what the policies are.
❑ Ensure you have set up Multi-Factor Authentication (MFA) using your zID on your smartphone, and know what to do when prompted to verify your sign-in when logging into UNSW systems.
Exam Preparation Strategy
Create a study plan
❑ Decide how you prefer to study (sequentially, based on the level of difficulty, etc.)
❑ As you study each topic, reflect:
❑ Am I able to explain the relationship of one topic with another?
❑ Am I able to explain how it works and applies to real world examples?
❑ Can I Identify solutions as I read through challenges associated with chapter cases? ❑ Can I explain impacts when I read through case problems?
❑ Can I distinguish key themes vs details and understand the ‘big picture’?
Exam Preparation Strategy
❑ Do not make yourself crazy about the exam: if you are on top of the materials, you will pass this examination. This is not a matter of “life-and- death”.
❑ Set your expectations right.
University Study Support
❑ Open Book and Take Home Exams https://student.unsw.edu.au/open- book-and-take-home-exams (take this advice seriously; do not assume that because it’s a take home and open book exam, that it requires less preparation.)
❑ The Learning Consultation Team are offering online individual consultations via ZOOM, Teams, Skype, or phone to help Business School students with their literacy and numeracy questions, study skills, academic writing, exam preparation, assessment tasks, case writing, reports/essays, and referencing……
❑ Get in touch with a learning advisor now – book a consultation through the online booking system.
Consultation
Exam Consultation
❑ Online consultation sessions are available.
❑ The consultations are not meant to do a revision, they are only to answer specific questions about the tested materials.
❑ Please book a 15-minute One-on-One consultation meeting within these scheduled times with the LiC:
❑ Monday, 15th August 2022, 9:00 – 10:30 am ❑ Tuesday, 16th August 2022, 3:30 – 5:00 pm ❑ Email the LiC:
❑ Tutors do NOT provide consultations
Thank You and All the Best!
Source: happybirthdaymsg.com
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com