HSC Enrichment - Information Processes and Technology Singleton - PDF document

4/30/17 HSC Enrichment - Information Processes and Technology Singleton Presentation 2017 1 How to do well in the HSC exam n Understand the course content n Practical AND theory n Use the appropriate terminology n Respond to the terms used in the question n Refer specifically to the question n Use your time well n Show what you know 2 1

4/30/17 HSC exam format 3 Core topics n Information Systems & Data Bases n Communications Systems n Project Work Not considered as separate topics 4 2

4/30/17 For the one question, recognise.. n transmission n relevant hardware & software n hardware n protocols n input requirements n output requirements n how data is n social & ethical organised considerations n storage n involvement of n data manipulation participants n flow of information n project management 5 TIPPPE • T echnology • I nformation • P urpose • P rocesses • P articipants and • E nvironment together describe an information system 6 3

4/30/17 7 The Seven Processes C ollecting O rganizing A nalyzing S toring & Retrieving P rocessing T ransmitting and Receiving D isplaying 8 4

4/30/17 The Seven Processes C ollecting ome C O rganizing n O A nalyzing ll A S toring & Retrieving tudents S P rocessing at P T ransmitting and Receiving he T D isplaying og D 9 Steps in Development and Implementation of System n For each step….. n Name each step n Specific tasks performed n People involved n Documentation produced n Terminology n Social issues 10 5

4/30/17 The Steps U nderstanding the problem P lanning D esigning solutions I mplementing T esting, evaluating and maintaining 11 Understanding the Problem n Define the purpose n Speak to participants n Survey n Questionnaire n Interview n Observation n Build a prototype n Requirements Report 12 6

4/30/17 Understanding the Problem n Define the purpose n Speak to participants n Survey n Questionnaire n Interview n Observation n Build a prototype n Requirements Report 13 Planning n Feasibility study n Constraints n Requirements Report n needs n TIP n time frame for subtasks n participants n Approach 14 7

4/30/17 Planning Technical n Feasibility study Operational n Constraints Economic n Requirements Report Scheduling n needs n TIP Technology n time frame for subtasks Information n participants Purpose n Approach 15 Planning n Feasibility study n Constraints n Requirements Report n needs n TIP n time frame for subtasks n participants n Approach 16 8

4/30/17 Designing Solutions n Build system n Traditional / waterfall n Prototype development n Participant development n Agile n Outsourced n Customised 17 Designing Solutions n Build system n Traditional / waterfall n Prototype development n Participant development n Agile n Outsourced n Customised 18 9

4/30/17 Designing Solutions n Build system n Traditional / waterfall n Prototype development n Participant development n Agile n Outsourced n Customised n Use Documentation tools 19 Documentation Tools n Gantt charts n Storyboard n DFD's n Specific interfaces n Schema's n Decision table n Queries (SQL) n Decision tree n Data Dictionary n Network Topology 20 10

4/30/17 Data Dictionary A data dictionary is a table providing a comprehensive description of each field in the database. This commonly includes: field name, data type, data format, field size, description and example. This is shown in the example below (from Specifications document) Field name Data type Data format Field size Description Example UserId Text NNNNNNNN 8 Unique eight-digit number represented as text 0001539 FirstName Text 25 First name of employee Bill Surname Text 25 Surname of employee Smith DOB Date DD/MM/YYYY 10 Date of birth as a short date format 15/07/1982 HourlyPayRate Currency #####.## 8 Rate of pay expressed in dollars per hour 34.50 Height Real #.## 3 Height in metres, with two decimal places 1.58 FeesPaid Boolean 1 Y or N for Yes or No Y 21 Schema n Sample answer from Q24 HSC 2009 22 11

4/30/17 Schema and SQL statement n Sample answer from Q24 HSC 2009 SELECT Song_Id, Song_Name FROM Song WHERE Song_size < … And Song_Length < ….. ORDER BY Song_Name Asc 23 Storyboard Good design elements in Database forms / Interfaces Heading n Logo n Text Boxes n Radio buttons / check boxes n Drop down menus n Understand the importance of validation checks 24 12

4/30/17 Storyboard Good design elements in Database forms / Interfaces Heading n Logo n Text Boxes n Radio buttons / check boxes n Drop down menus n Understand the importance of validation checks Don’t forget to show all links between screens 25 Storyboard Good design elements in Database forms / Interfaces Heading n Logo n Text Boxes n Radio buttons / check boxes n Drop down menus n Understand the importance of validation checks Don’t forget to show all links between screens 26 13

4/30/17 Network Diagram n Draw diagrams n to represent the various topologies n to show hardware required n to show communications links 27 28 14

4/30/17 29 30 15

4/30/17 Documentation tools Each shows a different view of a system Be prepared to…… n Recognise / Identify n Interpret n Modify or complete n Construct n Compare and contrast n Select relevant tool 31 Implementing n Acquire hardware & software n Implementation plan n Training n Conversion of data n Systems testing n Implementation of system n Direct n Parallel n Pilot n Phased n Operation Manual 32 16

4/30/17 Testing, evaluating and maintaining n Live, Volume, Simulated test data n Have needs been met? n Have social issues been addressed? n Trialing & using Operation Manual n Ease of use n Appropriateness for audience 33 Project Management n Refer to your project, and the experiences gained…… n Gantt charts n Communications plan n Regular reporting n Stumbling blocks n Communication strategies n Active listening n Conflict resolution n Negotiation skills n Interview techniques n Team building n Documentation tools 34 17

4/30/17 Calculations n File and database sizes n Transmission times n (Image, Video clip & Audio clip sizes …for Multimedia option) n Show all working! n Convert sizes to Kb, Mb, Gb and specify your choice of unit 35 Calculations 36 18

4/30/17 Hardware Operation n Tape, Hard Drive, CDROM, DVD n CRT, LCD, plasma screen, IWB n inkjet printer, laser printer, scanner, digital camera, mobile phone…. n Show understanding n Label all relevant features 37 Hardware Operation n Communications technology n Devices – hubs, switches, routers n Bridges and Gateways n Network Interface Cards (NIC) n Mobile phones (emerging and converging) n Cables n Wireless access points n Bluetooth devices n Client Server Architecture n Protocols 38 19

4/30/17 Protocols Application level protocols HTTP SMTP SSL Communication Control and Addressing Level protocols TCP IP Transmission Level protocols Ethernet Token ring 39 Options - Choose 2 only! Use Core Skills… n Recommend TIPPE n Define COASPTD n Data Modeling/ Documentation Tools n Participant involvement n Social and Ethical Considerations 40 20

4/30/17 Project Work n Use and recall steps (UPDIT) n Full documentation n Operations manual n Installation guide n Tutorial n Diary/ log n Project management techniques 41 In the exam…. 42 21

4/30/17 In the exam…. n 1.5 minutes per mark n 30 minutes for 20 multiple choice questions n 15 minutes for each of 4 x ~10 mark short answer questions n 30 minutes for each of 2 x 20 mark option short answer questions n Read the question! n Refer to the scenario described in the question n Be prepared to relate practical experiences, from projects and assessments 43 In the exam…. n Use the keywords n Compare and contrast n Evaluate n Explain……. n Number of marks - depth required n Use correct terminology n Use diagrams where possible and relevant. n We can only mark what we read! 44 22

4/30/17 Finally n Make sure you have learnt your terminology, and that you understand what you have learnt n Read the question carefully, so you know what area to write about n Relate your response to the context of the question 45 n Remember - the examiner wants to see what you know, and how well you understand it. n Good luck! 46 23

4/30/17 Resources n Syllabus n Learn to… n Learn about… n Course and Software Specifications n Past HSC exams, Marking Guidelines & Notes from the Marking Centre n Past Trial papers and supplied answers n Texts n Heineman - Greg Powers n Jacaranda - Chivers… and cards n Excel Study Guide and cards 47 Web sites n www.hsc.csu.edu.au n whatis.com n howstuffworks.com 48 24