悉尼科技大学 课程目录

This subject introduces students to basic database design and implementation concepts, database design techniques, and using a relational design via an entity relationship diagram, including how to interpret an entity relationship diagram. Students learn how to access a database via structured query language (SQL) to retrieve data from the database. The code required to implement a database is also covered. 本课程向学生介绍基本的数据库设计和实现概念，数据库设计技术，以及通过实体关系图使用关系设计，包括如何解释实体关系图。学生将学习如何通过结构化查询语言（SQL）访问数据库，以从数据库中检索数据。还包括实现数据库所需的代码。

This subject introduces students to the software development process and its different stages. It aims to develop the understanding of object-oriented systems development from specifications to code writing and testing. Students develop the skills to write user specifications; the ability to model and design software systems according to industry standards; and the ability to code and build software applications. The subject also aims to develop students' teamwork skills by allowing them to work in project teams and use a real-life case study for software development. 本课程向学生介绍软件开发过程及其不同阶段。它旨在开发对面向对象系统开发的理解，从规范到代码编写和测试。学生培养编写用户规范的技能;能够根据行业标准建模和设计软件系统;以及编写和构建软件应用程序的能力。该主题还旨在培养学生的团队合作技能，允许他们在项目团队中工作，并使用真实的案例研究进行软件开发。

This subject introduces students to the specifics of the World Wide Web (WWW) and internet-based programming. The evolution of the internet and its technical foundation is studied as well as basic techniques for presenting data, text and pictures on the WWW. The client/server paradigm is explored in detail, featuring website design and construction using DHTML (Dynamic Hypertext Markup Language), PHP (Hypertext Pre-processor), MySQL (back-end database), AJAX and JavaScript techniques. This subject provides a sound basis for understanding how the WWW functions, how to construct websites and how to write software for the WWW using scripting techniques. 本课程向学生介绍万维网（WWW）和基于互联网的编程的细节。 研究了互联网及其技术基础的演变以及在WWW上呈现数据，文本和图片的基本技术。 详细探讨了客户端/服务器范例，使用DHTML（动态超文本标记语言），PHP（超文本预处理器），MySQL（后端数据库），AJAX和JavaScript技术进行网站设计和构建。 该主题为理解WWW如何运行，如何构建网站以及如何使用脚本技术为WWW编写软件提供了坚实的基础。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：这门课主要教如何写网页，要学习的语言有html, css, php, javascript, jquery, AJAX, xml等。对于没有基础的同学，是比较好的入门课，难度中等，只要努力肯定可以拿高分的。 考核：包括2个assignment和1个final exam。2个assignment分别是建动态网页，和xml datamanipulate，final exam是40道选择题。 视频资料：32516 Internet Programming HD经验分享

This subject introduces C#, Visual Studio and the .NET development environment. The emphasis is on examining the .NET framework and the practicalities of developing software in this setting using the C# language. 本课程介绍C＃，Visual Studio和.NET开发环境。 重点是检查.NET框架以及使用C＃语言在此设置中开发软件的实用性。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：这门课教的是用C#写程序，建议有object-orientedprogramming基础的同学选，如果没有基础会比较吃力。 考核：要写2个程序，加上final exam，程序一个是consoleapplication，另一个是interface design，final exam是40道选择题。是Double pass。编程想完全写出来是有点难度的，但是老师会按点给分，比如你实现了一个feature就能拿到一部分的分数。所以想Pass还是比较轻松的，想拿D以上就要多花时间了。 视频资料：32998/31927 .NET Application Development HD经验分享

This subject introduces students to the software development process and its different stages. It aims to develop the understanding of object-oriented systems development from specifications to code writing and testing. Students develop the skills to write user specifications; the ability to model and design software systems according to industry standards; and the ability to code and build software applications. The subject also aims to develop students' teamwork skills by allowing them to work in project teams and use a real-life case study for software development. 本课程向学生介绍软件开发过程及其不同阶段。 它旨在开发对面向对象系统开发的理解，从规范到代码编写和测试。 学生培养编写用户规范的技能; 能够根据行业标准建模和设计软件系统; 以及编写和构建软件应用程序的能力。 该主题还旨在培养学生的团队合作技能，允许他们在项目团队中工作，并使用真实的案例研究进行软件开发。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：这门课主要教的是software development life cycle和UML，主要教use case diagram，class diagram和sequence diagram，object-oriented programming，主要是java fundamental。每周就一节课，lecture和tutorial算是在一起上了。 Tutor：老师很友善，有什么问题可以直接问。上课需要提前预习。 考核：考核包括assignment和final exam。First 2 weeks, tutor会发一个case study，每两周都要交一份作业，分别是画usecase，class diagram，sequence diagram和写java code，user interface design。Final exam只有单选题。对于没有software development基础的同学，这门课有一定的难度。

This subject is an introduction to iOS application development. Students learn the Swift programming language, the iOS development environment and explore the iOS app frameworks. The subject has an emphasis on giving students practical exposure to software development in the iOS environment. 本主题是对iOS应用程序开发的介绍。 学生将学习Swift编程语言，iOS开发环境并探索iOS应用程序框架。 该主题侧重于让学生在iOS环境中实际接触软件开发。 本课程介绍是由往届学长学姐回忆编辑而成。 编程语言为Swift。不是很好的一门课，lecture讲解的东西非常少，大部分需要自己查阅Apple开发者文档自学，Assessment和lecture内容没有很大关系。Lab老师也不会统一讲解，都是自己练习。无法通过这个课程获得对IOS应用开发全面的了解。Assessment分为两个个人编程项目和一个小组项目，通过也不是很难，但要花费很大的精力和时间自学。此课需要使用mac电脑。

This subject introduces students to the fundamentals of effective database systems. Students are taught how data is structured and managed in an organisation in a way that can be used effectively by applications and users. They also learn to use the language SQL for effective data retrieval and modification. This subject teaches students to appreciate the significance and challenges of good database design and management, which underpin the development of functional software applications. 本课程向学生介绍有效数据库系统的基础知识。 向学生讲授如何在组织中以可由应用程序和用户有效使用的方式构建和管理数据。 他们还学习使用SQL语言进行有效的数据检索和修改。 该主题教导学生理解良好的数据库设计和管理的重要性和挑战，这是功能软件应用程序开发的基础。 本课程介绍是由往届学长学姐回忆编辑而成。 数据库基础课程。前半个学期讲解数据库设计的方法和理论，后半个学期讲解SQL语言。百分之六十的Assessment和开卷Final是理论建模相关，期末SQL上机考试会有一两题比较难。对与开发和数据方向的同学是非常重要的一门课。Coordinator把评分项目设计的非常复杂，Assessment分成很多个部分，quiz也分为很多个，想要拿高分的同学要关注一下老师发的通知和邮件。

This subject consolidates the student's understanding of cyber security by considering security principles, methodologies and technologies from a technical and management perspective used in practice. The subject allows students to learn about and discuss various cyber attack techniques used in practice, and methods to defend against such attacks using industry standard tools and techniques. Topics include cyber attacks and defenses, web security, firewalls, intrusion detection systems along with security services such as confidentiality, integrity, authentication (CIA) and technologies such as IPSec, SSL, PGP and S/MIME. 本课程通过从实践中使用的技术和管理角度考虑安全原则，方法和技术，巩固了学生对网络安全的理解。该主题允许学生学习和讨论在实践中使用的各种网络攻击技术，以及使用行业标准工具和技术防御此类攻击的方法。主题包括网络攻击和防御，网络安全，防火墙，入侵检测系统以及安全服务，如机密性，完整性，身份验证（CIA）以及IPSec，SSL，PGP和S / MIME等技术。

Data analytics is the art and science of teasing meaningful information and patterns out of large quantities of data. It combines statistical methods for identifying patterns in data and making inferences with a number of IT technologies, including database technologies for handling massive volumes of data, intelligent and smart systems technologies, visualisation and other multimedia techniques that appeal to human pattern discovery capabilities. The subject offers broad background to data analytics and data mining methods and their application in practice. It brings together the state-of-the-art research and practice in related areas and provides students with the necessary knowledge and capacity to initiate and lead data analytics projects that can turn company data into commercially valuable information. 数据分析是从大量数据中挑选有意义的信息和模式的艺术和科学。它结合了用于识别数据模式的统计方法，并与许多IT技术进行推断，包括用于处理大量数据的数据库技术，智能和智能系统技术，可视化以及其他适用于人类模式发现功能的多媒体技术。该主题为数据分析和数据挖掘方法及其在实践中的应用提供了广泛的背景。它汇集了相关领域的最新研究和实践，并为学生提供必要的知识和能力，以启动和领导数据分析项目，从而将公司数据转化为具有商业价值的信息。

Through this subject students gain an understanding of the design principles and implementation issues for the deployment of network servers based on Windows and Linux operating systems. Techniques and skills for system administration are developed through a comprehensive sequence of laboratory activities in combination with mini-lectures and design tasks. 通过本课程，学生将了解基于Windows和Linux操作系统部署网络服务器的设计原则和实施问题。系统管理的技术和技能是通过一系列全面的实验室活动以及小型讲座和设计任务来开发的。

This subject provides basic skills in Java programming and software design, with no assumed knowledge of programming. It covers the topics of object-oriented (OO) programming concepts, data flow, control flow, arrays, and the basics of sorting and searching algorithms. The subject teaches and illustrates a design process using a set of design notations and design rules, and shows how to develop a correct, readable and reusable solution from a problem specification. This subject is taught using a combination of lectures, tutorials, labs and assessments. The subject is taught progressively. The assessments are available progressively so that students can learn at their own pace. The subject content is presented in four face-to-face hours each week: two hours of “live” lecture, and two hours of combined tutorial and laboratory class (i.e. the class listed as “cmp” in the student’s timetable). Note: Students are expected to commit additional study time outside of class time. The university regards a 6 credit point subject as requiring 5-8 hours of study per week, in addition to the four hours of class time. This subject is designed so that students can move through the course at a speed commensurate with the student’s ability and/or other demands upon the student's time, such as assessment deadlines in other subjects, paid-work, family commitments, and illness. All assessment items form part of a sequence. A student may only attempt a new assessment item after passing the preceding assessment item in the sequence. This is the reason why a student does not receive marks for a later assessment item when the student has not completed an earlier assessment item. The enforcement of a sequence of assessments also better utilises the face-to-face tutoring resources; when a tutor helps a student with a particular assessment item, the tutor can safely assume that a student has completed the prerequisite material. Also, feedback on earlier assessments helps the students improve and deepen their knowledge in order to attempt and prepare for later assessment items. The use of live lectures and demonstrations as vehicles of motivation, rather than sources of subject content knowledge. Students will prepare for most live lectures by watching YouTube videos. (Any such lecture pre-viewing will be specified in UTSOnline, and/or communicated by broadcast email, in the week leading up to the live lecture.) Lecture sessions will consist of a live lecture supplemented by opportunities for students to complete provided exercises to develop their understanding and skills. Students may work together on those exercises, and the lecturer will be available to assist and answer questions. Repeated testing, immediate scoring, and one-on-one tutoring, which also enhances the personal-social aspect of the educational process. This is facilitated in two ways. In the first hour (approximately) of each two-hour lab session, students do lab tests under closed book exam conditions. In that time period, students may receive immediate, repeated automatic testing and scoring, by uploading their test answers to the online test system (see details in the assessment section). In the second hour, a student may seek help from a tutor on the assessment item(s) that they could not complete during the previous hour, or on the assessment item that the student will attempt in their next lab. In that second hour, students may also ask any questions related to the subject content, not just questions related to specific assessment items. Students are welcome to seek out a tutor’s help in the second hour of any lab session, not just the lab session in which they are enrolled. 本课程提供Java编程和软件设计的基本技能，没有假设的编程知识。它涵盖了面向对象（OO）编程概念，数据流，控制流，数组以及排序和搜索算法的基础知识。该主题教导并说明了使用一组设计符号和设计规则的设计过程，并展示了如何从问题规范开发正确，可读和可重用的解决方案。 本课程使用讲座，教程，实验和评估的组合进行教学。该课程是逐步教授的。评估可逐步进行，以便学生可以按自己的进度学习。 主题内容每周以四个面对面的小时呈现：两小时的“现场”讲座，以及两小时的组合教程和实验课（即在学生的时间表中列为“cmp”的课程）。 注意：学生应在课堂时间之外投入额外的学习时间。除了4个小时的上课时间外，该大学认为每学期需要5-8个小时的6学分。 本课程旨在让学生能够以与学生能力和/或其他学生时间要求相称的速度进入课程，例如其他科目的评估截止日期，有偿工作，家庭承诺和疾病。 所有评估项目都是序列的一部分。学生只能在顺序中传递前面的评估项目后尝试新的评估项目。这就是为什么当学生没有完成早期评估项目时，学生没有收到后来评估项目的分数的原因。执行一系列评估还可以更好地利用面对面的辅导资源;当辅导员帮助学生学习特定评估项目时，辅导员可以安全地假设学生已完成必备材料。此外，对早期评估的反馈有助于学生改进和深化他们的知识，以便尝试和准备以后的评估项目。 使用现场讲座和示范作为动机的载体，而不是学科内容知识的来源。学生将通过观看YouTube视频为大多数现场讲座做好准备。 （任何此类讲座预先录制将在UTSOnline中指定，和/或通过广播电子邮件在实况讲座前一周进行通信。）讲座将包括一个现场讲座，并辅以学生完成所提供练习的机会。培养他们的理解和技能。学生可以在这些练习上一起工作，讲师可以协助和回答问题。 重复测试，即时评分和一对一辅导，这也增强了教育过程中的个人 - 社交方面。这有两种方式。在每两个小时的实验课程的第一个小时（大约），学生在闭卷考试条件下进行实验室测试。在该时间段内，学生可以通过将他们的测试答案上传到在线测试系统来获得即时，重复的自动测试和评分（详见评估部分）。在第二个小时，学生可以寻求帮助，从评估项目（S）导师，他们无法前一小时期间完成，或在评估项目，学生将尝试在他们的下一个实验室。在第二个小时内，学生还可以询问与主题内容相关的任何问题，而不仅仅是与特定评估项目相关的问题。欢迎学生在任何实验课的第二个小时内寻求辅导老师的帮助，而不仅仅是他们注册的实验课。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：编程入门课，编程语言为java。每周通过一个简单的小程序讲解Java基本语法和基本的OO Programing思想。没有final，每周lab一个小时考试实现当周讲解的小程序代码，课前可以登陆考试系统练习。完成每周考试即可pass。课程内容循序渐进，完成每周的任务可以对编程有较为全面的理解。没有编程基础，规划为开发方向的同学应该重视这门课。

This subject provides students with knowledge of local area network (LAN) hardware and physical layer standards, and basic computer networking concepts and principles, and introduces LAN design and the use of routers and switches, and routing and switching in autonomous system intranets. It also explains how these access WANs. Using the Cisco Networking Academy's online resources and practical work in wiring and configuring LANs, including Cisco routers and switches, is an integral part of this subject. 本课程为学生提供局域网（LAN）硬件和物理层标准的知识，以及基本的计算机网络概念和原理，并介绍了局域网设计，路由器和交换机的使用，以及自治系统内部网的路由和交换。 它还解释了这些访问WAN的方式。 使用思科网络技术学院的在线资源以及布线和配置局域网（包括思科路由器和交换机）的实际工作，是本课程不可或缺的一部分。 本课程介绍是由往届学长学姐回忆编辑而成。 简介：这门课每周只有一节4个小时的lab，postgraduate的话一学期是学2本书，学习进度比较紧张。第一本是introduceto networks，第二本书是routing and switching essentials。第一本书教的是network OSI model，每个layer的protocol是怎样的，包裹是怎么运输的。第二本书教router和switch的内容，包括如何configuration，topology design，VLAN，DHCP，NAT这些知识。 考核：相对比较复杂，包括每个chapter都有online quiz，最后一周还有online finalquiz，中间还有practical skills test，network topology design，还有一篇report。最后还有一个final exam，final exam可以带一张手写A4 note。总体上说这门课想要pass是要付出比较大的精力的，挂科率也是相当高的，我学习的那个学期挂科率高达40%。