Java程序辅导

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 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 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