• Types of networks - LAN,WAN
• Network topologies - Bus, Ring, Star
• Network protocols - TCP/IP,NetBeui etc
• Network architecture/components(hubs,switches,routers,cables,etc)
• Types of cables & compare them
• Network operating systems - access/security
• Tools used to represent network components - Draw a schematic representation of a LAN

  ---

• Video - Routing, Ram and Radio (3RRR)

»2.Visual Basic Programming:

• No Visual Basic Programming yet

»4. Theory Work:

Networking Worksheet

»4.Visual Basic Programming

Programming Concepts - Arrays

• Revisit IF & CASE Statements and Control Arrays
• Data types
• Data structures(arrays, records, lists etc)- to be covered in details later in the course
• Data files(.dat, .txt etc) - example of reading and outputting contents of a file. This program will be further modified later on to use arrays(see Parallel Arrays Examples)
• Data dictionaries
• Internal Documentations (purpose and content)
  • Start Programming Task 1c - control arrays + If..Then..Else + Case Statements
  • Start Programming Task 1d - Flag Viewer (Similar to "Animal Show - Year 10 Course)
  • Start Programming Task 1e - Reading contents of a Data file and output to a picture box

»5. Theory Work

System Development Life Cyle (SDLC) - The analysis phase

• Phases of SDLC
• Data collection - (why, how, when, where)
• Data acquisition - methods(interviews, questionaires etc)
• System Goals & Objectives

  ---

  Prepare for Outcome 1 to be held next week

Video - System Development Life Cycle

»5.Visual Basic Programming

• Error Trapping in Programming
  • Types of Errors (Run Time, Logic and Syntax errors)
  • Division by zero
• Programming Task 2a - Error Trapping e.g Division by Zero
• Programming Task 2b - Visual Basic Divisions e.g mod, / and \
  • A module is introduced here(Task 2b) only for Variable Declaration so that the same variables are used in any of the forms. More about Modules will be covered in Week 6!

»6. Theory Work

OUTCOME 1

Systems Analysis/Design Tools

• Context Diagrams
• Data Flow Diagram (DFD)
• Entity-Relationship (ER diagrams)
• IPO Charts
• Feasibility studies resulting in selecting appropriate design options - economic factors, technical factors & operational factors
• Decision Trees/Tables
• Hierarchy Charts
• Structure Charts

»6.Visual Basic Programming

Introducing the use Of Modules in Visual Basic programs
• Programming Task 3a - Module Demonstration
• Programming Task 3b - Program Wages & Commisions (this program was written in VB 6, it uses dialog boxes for particular formatting)

»7. Theory Work

System Tools Con't

• Levelling of DFDs
• Case Tools
• Equipment & procedures
• System Flow Charts

»7.Visual Basic Programming

• Programming Task 4a - more on variables using Simple/Compound Interest
• Programming Task 4b. Mofify the Simple Interest Program by using a module for calculation

»8. Theory Work

Software Development

• Stages of software development - (program development life cycle)
• Approaches to software design
• Roles of programmers
  • legal obligations
  • ethical obligations
• High level programming languages
• Software evaluation

»8.Visual Basic Programming

• Validation Routines - Examine this program used in Year 10 programming and then see the more elegant routines below
• Validation Routines - Deal with not accepting other keys but the ones representing the digits "0" to "9"
• Programming Task 5 - These routines check for specified data inputs

»9. Theory Work

Algorithms - Tools

• NS Diagrams
• Flow Charts
• Pseudocodes
• IPO Charts
• Structure Charts

»9.Visual Basic Programming

Interation - Loops

Problem raised by a student

One student wanted to mask the first character of the content of a textbox. It just happened that the content consisted of numbers with a negative sign at the front. Two possible solutions were raised:

1. One was to simply multiply the content by a -1
2. The other was to use a loop to count the content of the characters in the textbox and take away 1 from the total number of characters - this is implemented here using a "For" loop and either the Mid() or the Right().

• Programming Task 6a - The masking program
• Programming Task 6b - Coding an NS Diagram problem (Similar to Question on 2003 Exam)

»10. Theory Work

Algorithms

• Pseudocodes and algorithm
• From pseudocodes to VB programs
• Data Backup/Storage - Data can be stored and retrieved from data files
• Data security - Demonstrated by the use of passwords (see password programs) for authorise users only

»10.Visual Basic Programming

• Programming Task 7a - Flight Program
• Programming Task 7b - Grades Program

The two programs above re-inforce the idea of boundary testing whereby values are either >,< >= or <=. These are typical testing which featured in both 2001 & 2002 algorithm questions.

»11. Theory Work

Test Data, Testing Tables and Desk Checking

• The need for appropriate test data
• Boundary testing
• Contents of a testing table
• The need for Desk-Checking before coding
• Evaluation criteria
  • criteria for evaluating software
  • criteria for evaluating a system
• Physical design alternatives to implement the logical design of a system

»11.Visual Basic Programming

• Programming Task 8a - The Security Wages program(comboboxes, validation and boundary testing)

»12. Theory Work

OUTCOME 2

• The whole week is dedicated to Outcome 2

»12.Visual Basic Programming

• Also deals with accessing and writing to a file - See StartUp Form codes for the Quadratics Program version 2.
• Programming Task 8b - to be done at home (The quadratics Program)
  • This program has two version - both are supplied
• User Defined variables in Modules
• Why use Modules in Visual Basic programming?

»14. Theory Work

OUTCOME 3

»15. Theory Work

OUTCOME 3 Con't...

»16. Theory Work

Networks - in a global environment

• types and cababilities of networks and network topologies in regards to a global environment such as the internet
• purposes for use of networked information systems in a global environment
• types of problems associated with the use of networked information systems in a global environment
• advantages/disadvantages of using networked information systems in a global environment

Good use of modules is shown by Ross' Auto Repair Shop

Outcome 3 is due this week!

»16.Visual Basic Programming

• Programming Task 10a - Ross' Auto Repair Shop
• Programming Task 10b - Lavinia's Beauty Salon

»17. Theory Work

Software Engineering:

Data Files Access & Manipulation

• serial access
• sequential access
• random access

  ---

• Modify Program "Reading contents of Files" done in Week 13 to use a Validation Function and Parameter Passing

»17.Visual Basic Programming

• Programming Task 11a - Random file
• Programming Task 11b - Writing/Append file
• Programming Task 11c - Functions & Parameter passing ByVal
• Programming Task 11d - Read/Manipulate/Output contents of 3 data files

»18. Theory Work

Software Engineering:

Data Structures/Algorithm and Data manipulation

• Review Arrays & Records
• Special algorithms - Search and Sort
  • Linear Search
  • Binary Search
  • Bubble Sort

    ---

    The following sorting programs can be left out if there is no time. Bubble sort is enough for our purposes anyway.

  • Insertion Sort
  • Selection Sort

»18.Visual Basic Programming

• Sorting and Searching Program examples
  • Programming Task 12a - Linear Search
  • Programming Task 12b - Binary Search
  • Programming Task 12c - Bubble Sort

    ---

    
    May leave these two programs if you so wish!
  • Programming Task 12d - Insertion Sort
  • Programming Task 12e - Selection Sort

»19. Theory Work

• System Software & Utilities
• Conflict between developers and end users
• Factors affecting software design
• Security - password protected & encryption

»19.Visual Basic Programming

• Programming Task 13a - multi-user password program(bugs)there are a few bugs with this program, see if you can fix it
• Password Program - multi-user password program(fine)
• Programming Task 13b - Encryption Program

»20. Theory Work

Software Engineering: - Testing & Documentation types

• Algorithms
• Software - purposely designed
• Hardware - equipment required to run the system
• Documentation
  • User Documentation
  • Technical Documentation

»20.Visual Basic Programming

• Programming Task 14 - Tax Program

»21. Theory Work

• Review of Text Files
• Review Validation Routines
• Review Search Routines
• Review Testing Data and Testing Tables
• Review of Modules

»21.Visual Basic Programming

• Programming Task 15 - Putting Codes snippets together( a password program is used here which requires the use of a module)

»22. Theory Work

• Debugging programs
• Review of possible conflicts between developers and users
• Review of Software/hardware requirements for running a purpose designed software

»22.Visual Basic Programming

• Programming Task 16a - Debugging a program(some of the codes have been altered, get students to debugg the program)

»26. Theory Work

• Review of Algorithm - Revisions Exercises
• Review other phases of the SDLC as preempt for the Implementation and Evaluation of a system

»27. Theory Work

Development, Implementation & Evaluation

• Project Management Tools & Techniques:
  • Gantt Charts
  • PERT Charts

• Worksheet

»28. Theory Work:

Implementation of proposed system

• Conversion Methods
• Training
• System support documentation
• BackUp
• Security
• Disaster Recovery Plan