INFO1903: Exam Review Alan Fekete Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 2 Outline 1 Admin 2 The Exam 3 Exam technique 4 Further Study 5 Summary Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 3 Official notice COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 WARNING This material has been reproduced and communicated to you by or on behalf of the University of Sydney 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 copying or communication of this material by you may be the subject of copyright protection under the Act. Do not remove this notice. Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 4 Advert Tell people about the NCSS Challenge http://www.ncss.edu.au/challenge Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 5 Overview • Unit Evaluation • The Exam • General advice • Future study Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 6 The Exam • The exam is 2 hours long + 10 minutes reading time • It is worth 50% of your assessment • There are a total of 8 questions • Closed-book exam • Non-programmable calculators allowed (and recommended for number representation questions) • Some sample exam questions are online at: http://www.it.usyd.edu.au/~info1903/sample/ sample-exam.pdf • Sample solutions at http://www.it.usyd.edu.au/~info1903/sample/ sample-solutions.pdf Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 7 Topics that are NOT in the exam • Information visualisation • Writing scientific reports • Scientific presentations • Micro-teaching • Java • Guest lectures on brain physics, chemistry and complex systems, bioinformatics, robotics Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 8 Topics that are NOT in the exam • Disaster scenarios • Back of the Envelope calculations (except data related calculations) • Code snippets • History sections — for example: • history of the internet • history of spreadsheets Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 9 Topics that are not in the exam • Creating E-R models • Object-orientation, classes, inheritance • VBA coding • Details of Tornado templates Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 10 What you should know • You will have to work with number formats • You will have to write and/or read Unix tool pipelines • You will have to write and/or read Excel formulas • You will have to write and/or read HTML (including CSS) • You will have to write and/or read Python code • You will have to write and/or read SQL queries • You should be able to discuss advantages/disadvantages/issues of the technologies we have studied • Look through the ‘You should now be able to. . . ’ sections at the end of lectures and labs to get an idea of what you should know Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 10 What you should know • You will have to work with number formats • You will have to write and/or read Unix tool pipelines • You will have to write and/or read Excel formulas • You will have to write and/or read HTML (including CSS) • You will have to write and/or read Python code • You will have to write and/or read SQL queries • You should be able to discuss advantages/disadvantages/issues of the technologies we have studied • Look through the ‘You should now be able to. . . ’ sections at the end of lectures and labs to get an idea of what you should know Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 11 Know the syntax and usage of basic Python constructs • basic expressions, integer/floating point division • basic statements: assignment, print • types: strings, integers, floats • data structurs: lists, tuples, dictionaries • decisions: if, elif and else • loops: for and while • file input and output (e.g. loops over files, handling each line, split line into fields and deal with the fields) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 12 More Python you need to know • functions: • def, • arguments, • local variables, • calling • return • pydoc and doctest • exception handling: try, except, raise Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 13 Question 1 • Question 1 • Unix Tools • 3 subquestions • 6 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 14 Question 2 • Question 2 • Number representations • 6 subquestions • 6 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 15 Question 3 • Question 3 • Spreadsheets • 3 subquestions • 8 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 16 Question 4 • Question 4 • Databases (SQL) • 4 subquestions • 15 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 17 Question 5 • Question 5 • Internet technologies • 5 subquestions • 10 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 18 Question 6 • Question 6 • Python • 3 subquestions, • 15 points • Some subquestions on code reading/tracing, and others on code writing Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 19 Question 7 • Question 7 • Evaluations • 4 subquestions • 20 points Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 20 Question 8 • Question 8 • Python • 3 subquestions • 20 points • Final subquestion is to write a substantial function (16 points) • 3 points for dealing with “bad” cases • 4 points for style and generality (only awarded if code is largely correct) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 20 Question 8 • Question 8 • Python • 3 subquestions • 20 points • Final subquestion is to write a substantial function (16 points) • 3 points for dealing with “bad” cases • 4 points for style and generality (only awarded if code is largely correct) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 21 Time management • Plan how you will allocate time (wisely) • Use reading time for planning and to clarify confusing questions • Answer everything (get the easy marks in each question/subquestion) • Write clearly • If you change your mind, write the new answer, then cross out the old one • If you need more space, use blank pages at the end of booklet, but leave a forwarding pointer in the provided space (where the marker will be looking) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 22 Advice • Find the location of the exam, before the day of the exam! • Bring spare pens • Bring water • Have clothing in layers • Have your student id and put it on the desk • Bring a calculator • Breathe Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 23 Illness • If you are unwell, and it seems that you won’t be able to demonstrate your knowledge/skill properly, then you can request special consideration • Follow the same procedure as during semester (get medical person to fill out special USyd form, hand it in within one week) • Usual outcome: an alternate test, a few weeks later • If you become sick during the exam itself, raise hand and speak to the invigilator • The University goal is to get a fair assessment of what you have achieved Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 24 Computational and Data-centric Units • INFO1105/1905 Data Structures • Semester 2 • Organization of collections of information to make partiucular uses efficient • Uses Java • Prereq for many higher-year computer science topics • COSC1003/1903 • Semester 2 • scientific applications (matrix-based) and visualization • Uses Matlab and some C • INFO2120/2820 Database Systems 1 • Semester 1 • Lots of SQL, E-R design, plus logic/theory behind querying and schema design Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 25 More units to consider after INFO1903 • COMP2129 Operating Systems and Machine Principles in sem 1 (C, memory management issues) • INFO2110 Systems Analysis and Modelling in sem2 (like E-R models but more sophisticated, covering process as well as data) • COMP2022 Formal Languages and Logic in sem1 (theory of regex etc) • INFO2315 Intro to IT Security in sem2 (conceptual issues for security decision-making) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 26 Units that follow from INFO1105/1905 • COMP2007/2907 Algorithms in sem2 (clever techniques for hard problems or efficient solutions) • COMP2121 Distributed Systems and Network Principles in sem2 (issues for multi-machine systems) Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 27 Final comments • Remember we will not be testing anything that is not covered in the lectures, lab notes and assignments. • You have all the material you need to prepare for the exam. • Work through the sample exam, and be sure you understand what each question is testing. • Do as many of the Challenge questions as possible • There are no trick questions in the exam. • Make sure you attempt all (subparts of all) exam questions. • Contact us by email if you have any problems. • Check your email regularly in case we send round any updates. • Good luck! Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 27 Final comments • Remember we will not be testing anything that is not covered in the lectures, lab notes and assignments. • You have all the material you need to prepare for the exam. • Work through the sample exam, and be sure you understand what each question is testing. • Do as many of the Challenge questions as possible • There are no trick questions in the exam. • Make sure you attempt all (subparts of all) exam questions. • Contact us by email if you have any problems. • Check your email regularly in case we send round any updates. • Good luck! Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 27 Final comments • Remember we will not be testing anything that is not covered in the lectures, lab notes and assignments. • You have all the material you need to prepare for the exam. • Work through the sample exam, and be sure you understand what each question is testing. • Do as many of the Challenge questions as possible • There are no trick questions in the exam. • Make sure you attempt all (subparts of all) exam questions. • Contact us by email if you have any problems. • Check your email regularly in case we send round any updates. • Good luck! Alan Fekete Review Lecture ”37”, 4th June, 2014 Admin The Exam Exam technique Further Study Summary 27 Final comments • Remember we will not be testing anything that is not covered in the lectures, lab notes and assignments. • You have all the material you need to prepare for the exam. • Work through the sample exam, and be sure you understand what each question is testing. • Do as many of the Challenge questions as possible • There are no trick questions in the exam. • Make sure you attempt all (subparts of all) exam questions. • Contact us by email if you have any problems. • Check your email regularly in case we send round any updates. • Good luck! Alan Fekete Review Lecture ”37”, 4th June, 2014