Spreadsheet: 84199d1284191287-combine-hyperlink-with-lookup-time-table-2010-2011
Sheet: Year 13 SLD Lecture Plan

 |  | Topics Covered | Notes | Additional Slides | Book Exercises | General Revision Questions | Quiz | Fill in the blanks | Programs | Applets | Videos
Week 1
Single | 1 | 3.1 Language translators
 |  | 3.1.1 Define Syntax and Semantics | Topic 3.1 Language Translators.docx |  |  | Topic 3.1.1 - 3.1.2 Additional HW.php.pdf |  |  |  |  | http://www.youtube.com/watch?v=mWhDAh2Ys6s&feature=related
 |  | 3.1.2 Describe the function of high-level language translators |  |  | Exercise 3.1
 |  | 3.1.3 Software Development Tools |  |  | Exercise 3.2
Single | 2 | 3.5 DATA REPRESENTATION
 |  | APPLICATION OF THIS RELATIONSHIP |  |  |  | Topic 3.5 Additional HW.php.pdf
 |  | Pixel Colour Intensity | Topic 3.5 Data Representation.docx |  | Exercise 3.15
 |  | 3.5.2 NEED FOR STANDARD FORMATS FOR DOCUMENTS AND GRAPHICS |  |  | Exercise 3.16
 |  | Answers
 |  | ASCII |  |  | Exercise 3.17
Single | 3 | 3.5.3 EXPRESS NUMBERS IN DECIMAL, [NAME] AND HEXADECIMAL | Topic 3.5 Data Representation.docx |  |  | 3.1 Language Translators.doc | Binary Numbers Quiz.mht |  |  |  | Binary Numbers  Video.mht
 |  | THE BINARY NUMBER SYSTEM
Double | 4 | 2.1.1-3 DATA TYPES, DATA STRUCTURES AND CONSTRUCTS IN JAVA | Topic 2.1 Program Construction in Java.docx | Lecture 01 - Introduction.ppt |  | 3.5 Data Representation.doc
 |  | VARIABLES AND TYPES |  | Lecture 02 - Variables.ppt |  |  | Variables and the Assignment Statement Quiz.mht | Floating Point 2.mht | Variables and the Assignment Statement.mht
Week 2
Single | 5 | 3.5.4 CONVERSION OF NUMBERS IN DECIMAL, [NAME] AND HEXADECIMAL | Topic 3.5 Data Representation.docx |  | Exercise 3.18 & 3.19
 |  | CONVERTING BETWEEN BASES
 |  | CONVERTING BETWEEN BINARY AND HEXADECIMAL NUMBERS
 |  | CONVERTING BINARY TO DECIMAL |  |  | Exercise 3.20
Single | 6 | 3.5.5 REPRESENTING INTEGERS | Topic 3.5 Data Representation.docx
 |  | Negative numbers |  |  | Exercise 3.21
Double |  | 3.5.6 DEFINE ANALOG AND DIGITAL DATA | Topic 3.5 Data Representation.docx |  | Exercise 3.22
 |  | 3.5.7 CONVERSION FROM DIGITAL TO ANALOG
 |  | 3.5.8 APPLICATIONS OF CONVERSION |  |  | Exercise 3.23
 | 7 | [NAME] AND APPLICATION OF JETS PRIMITIVES | Topic 2.1 Program Construction in Java.docx
 |  | ASSIGNMENT |  |  | Exercise 2.1
 |  | BEYOND PRIMITIVES |  |  |  |  | Primitive Data Quiz.mht |  | Primitive Data.mht
 |  | INPUT/OUTPUT |  | Lecture 04 - User Input.ppt | Exercise 2.2 |  |  | Input and Output 2.mht | Input and Output.mht
 |  |  |  |  |  |  |  | File Input Techniques 2.mht | File Input Techniques.mht
 |  |  |  |  |  |  |  | Introduction to Java.mht
 |  |  |  |  |  |  |  | Small [NAME]
Week 3
Single | 8 | 3.6 ERRORS | Topic 3.6 Errors.docx |  |  | 3.6 Errors.doc |  |  |  |  | Errors Videos.mht
 |  | 3.6.1 HOW DATA ERRORS OCCUR. |  |  |  | Topic 3.6 Additional HW.php.pdf
 |  | 3.6.2 PREVENTING AND DETECTING ERRORS
 |  | Checking for errors
 |  | Verification
 |  | Validation
 |  | Check digits
 |  | Hardware errors
 |  | Software related errors
Single | 9 | 3.6.3 RECOVERY FROM ERRORS |  |  | Exercise 3.24
 |  | Re-input | Topic 3.6 Errors.docx
 |  | Re-transmission
 |  | Backing up
Single | 10 | ARITHMETIC OPERATORS |  | Lecture 03 - Arithmetic Expressions |  |  | Expressions and Arithmetic Operators Quiz.mht | Boolean Expressions 2.mht | Boolean Expressions.mht
 |  |  | Topic 2.1 Program Construction in Java.docx
 |  |  |  |  |  |  |  |  | Expressions and Arithmetic Operators.mht
 |  | PRECEDENCE |  |  | Exercise 2.3
 |  | MATHEMATICAL FUNCTIONS
Double | 11 | CASTING
 |  | PROGRAM [NAME] | Topic 2.1 Program Construction in Java.docx
 |  | SEQUENCE |  |  |  | 2Arithmetic Expressions Worksheet 2.php.pdf
 |  | CONSTRUCTING A MODULAR PROGRAM
Week 4
Single | 12 | SCOPE OF IDENTIFIERS | Topic 2.1 Program Construction in Java.docx
 |  | PARAMETERS |  |  | Exercise 2.4 |  |  | Method Parameters.mht
 |  | METHOD SIGNATURES
Single | 13 | SELECTION | Topic 2.1 Program Construction in Java.docx | Lecture 05 - Conditional Statement and Expressions (Part 1).ppt | Exercise 2.5 | If statement.php.pdf | The if Statement Quiz.mht |  | The if Statement.mht
 |  |  |  | Lecture 06 - Conditional Statement and Expressions (Part 2).pptx |  |  | The Single Branch if Statement Quiz.mht |  | The Single Branch if Statement.mht
Single | 14 | NESTING | Topic 2.1 Program Construction in Java.docx |  | Exercise 2.6 |  |  | Nesting Loops and Ifs 2.mht | Nesting Loops and Ifs.mht
 |  | MULTIPLE SELECTIONS
Double | 15 | REPETITION | Topic 2.1 Program Construction in Java.docx | Lecture 07 - While loops.pptx |  |  | Counting Loops Quiz.mht | Loops and the while statement 2.mht | Loops and the while statement.mht
 |  |  |  | Lecture 08 - do While loops.pptx | Exercise 2.7 |  | More about the for Statement Quiz.mht |  |  | More about the for Statement.mht
 |  |  |  | Lecture 09 - For loops.pptx |  |  | The Conditional Operator and the switch Statement Quiz.mht |  |  | The Conditional Operator and the switch Statement.mht
Week 5
Single | 16 | REPETITION | Topic 2.1 Program Construction in Java.docx |  |  |  | The do Statement Quiz.mht |  |  | The do Statement.mht
 |  |  |  |  |  |  | The for Statement Quiz.mht |  |  | The for Statement.mht
Single | 17 | Tracing loops | Topic 2.1 Program Construction in Java.docx |  |  | 11Tracing Algorithms.php.pdf
Double | 18 | CLASSES, USER-DEFINED METHODS AND OBJECTS | Topic 2.1 Program Construction in Java.docx | Lecture 10 - Methods.pptx | Exercise 2.8 |  | Object Data Quiz.mht | Class Design Example (checking account).mht | Class Design Example (miles per gallon) 2.mht
 |  |  |  | Lecture 12 - Introduction to Objects.pptx |  |  | Object References Quiz.mht | Class Design Example (miles per gallon).mht
 |  |  |  | Lecture 13 - Objects (cont...).ppt |  |  | Objects Quiz.mht | Defining your own Classes.mht
Week 6
Single | 19 | CLASSES AND EXCEPTIONS | Topic 2.1 Program Construction in Java.docx | Lecture 14 - Classes.ppt | Exercise 2.9 |  | Exceptions and Errors Quiz.mht |  | Exceptions and Errors.mht
 |  |  |  | Lecture 15 - Constructors.ppt |  |  | More about Exceptions Quiz.mht |  | More about Exceptions.mht
Single | 20 | CLASSES AND EXCEPTIONS | Topic 2.1 Program Construction in Java.docx | Lecture 16 - Playing with Objects.ppt
 |  |  |  | Lecture 17 - Classes and Exceptions.pptx |  | 7Methods Worksheet 2.php.pdf
Single | 21 | STATIC METHODS |  |  |  |  |  | Parameters, Overloading, Local Variables.mht
 |  | PRIMITIVES VERSUS OBJECT REFERENCES | Topic 2.1 Program Construction in Java.docx
Double | 22 | ARRAYS OR LISTS OF VALUES |  | Lecture 11 - Arrays.pptx | Exercise 2.10 |  | Introduction to Arrays Quiz.mht |  | Introduction to Arrays.mht
 |  |  | Topic 2.1 Program Construction in Java.docx |  |  |  | Two-dimensional Arrays Quiz.mht |  | Two-dimensional Arrays.mht
 |  |  |  |  |  |  | Arrays as Parameters Quiz.mht
Week 7
Single | 23 | ARRAYS OR LISTS OF VALUES | Topic 2.1 Program Construction in Java.docx |  |  |  | ArrayLists and Iterators Quiz.mht | Arrays as Parameters 2.mht | Arrays as Parameters.mht
 |  |  |  |  |  |  | [NAME] |  | [NAME]
Single | 24 | RECORDS AND CLASSES |  |  | Exercise 2.11 |  | If,  Numbers, Loops, [NAME], Arrays Quiz.mht
 |  | DATA FILES | Topic 2.1 Program Construction in Java.docx
Single | 25 | CHARACTER-BASED FILESTREAMS | Topic 2.1 Program Construction in Java.docx |  | May 2004 Paper 1 SL.pdf | Writing Text Files Quiz.mht | Input and Output Streams Quiz.mht |  | Reading Text Files.mht
 |  |  |  |  |  |  | Reading Text Files Quiz.mht |  | Writing Text Files.mht
Double | 26 | TEST
Week 8
Single | 27 | CHARACTER-BASED FILESTREAMS
Double | 28 | 2.14 TRACING ALGORITHMS IN JAVA
 |  | 2.15 EVALUATE ALGORITHMS IN JAVA |  |  | Exercise 2.16
 |  | COMMON PITFALLS IN USING STRING INSTANCES AND METHODS | Topic 2.1 Program Construction in Java.docx
 |  | CONCATENATION
 |  | SUBSTRINGS |  |  |  |  | More about Strings Quiz.mht |  | More about Strings.mht
 |  | EXAMPLE OF STRING MANIPULATION |  |  | Exercise 2.17 |  | Strings and Object References Quiz.mht |  | Strings and Object References.mht
 |  | OTHER METHODS OF THE STRING CLASS |  |  | Exercise 2.18
Week 9
Single | 29 | 2.16 CONSTRUCT ALGORITHMS IN JAVA | Topic 2.1 Program Construction in Java.docx |  | Exercise 2.19
 |  | 2.1.7 EXPLAIN THE NEED FOR SEARCHING AND SORTING
Single | 30 | 2.18 APPLY SPECIFIED SEARCHING AND SORTING ALGORITHMS | Topic 2.1 Program Construction in Java.docx | Lecture 20 - Searching and Sorting.ppt
 |  | SEQUENTIAL (LINEAR) SEARCH |  |  |  |  | Arrays of Objects and Linear Search Quiz.mht |  | Arrays of Objects and Linear Search.mht | Linear Search Applet.mht
Single | 31 | [NAME] |  |  |  |  |  |  |  | Binary Search Applet.mht
 |  | [NAME] | Topic 2.1 Program Construction in Java.docx
Double | 32 | SORTING |  |  |  |  |  |  |  | Sorting Algorithms Applet.mht | Sorting Algorithms Video.mht
 |  | BUBBLE SORT | Topic 2.1 Program Construction in Java.docx |  | Exercise 2.19 (2)
 |  | SELECTION SORT
 |  | COMPARE THE EFFICIENCY OF SEARCHING AND SORTING ALGORITHMS
Week 10
Single | 33 | 2.1.10 DISCUSS THE EFFICIENCY OF SEARCHING AND SORTING ALGORITHMS | Topic 2.1 Program Construction in Java.docx |  | Exercise 2.20
 |  | FURTHER EXAMPLE ALGORITHMS AND ACTIVITIES |  |  | Exercise 2.21
Single | 34 | 2.1.11 PROGRAMMING ERRORS & Revision | Topic 2.1 Program Construction in Java.docx
Single | 35 | REVISION |  |  | Exam Questions.docx
Double | 36 | REVISION |  |  | Past Papers Java.doc
Week 11
Single | 37 | Topic 3.2 Computer Architecture | Topic 3.2 Computer Architecture.docx
 |  | What is Computer Architecture? |  |  |  | Topic 3.2.1 - 3.2.5 Additional HW.php.pdf |  |  |  |  | http://www.youtube.com/watch?v=NNbEBARu6LY&fmt=18
 |  | 3.2.1. The CPU |  |  |  |  |  |  |  |  | http://www.youtube.com/watch?v=9LdtybJbP3U&feature=channel
 |  | Control Unit
Single | 38 | Arithmetic Logic Unit (ALU)
 |  | Accumulator | Topic 3.2 Computer Architecture.docx
 |  | Program [NAME] (PC)
 |  | The Current Instruction Register (CIR) |  |  |  | Topic 3.2.5 - 3.2.6 Additional HW.php.pdf
 |  | The Memory Data Register (MDR)
 |  | The Memory Address Register (MAR)
 |  | CPU Block Diagram |  |  |  |  | The Processor Quiz.mht
Single | 39 | 3.2.2. What is a bit and what is a byte?? | Topic 3.2 Computer Architecture.docx |  |  |  | Analog and Binary Signals Quiz.mht
 |  |  |  |  |  | 3.2 Computer Architecture.doc | Computer Memory Quiz.mht
 |  | Some other terms
 |  | Some differences
Double | 40 | PAST PAPER | May 2009 Paper 1 SL.pdf
Week 12
Single | 41 | 3.2.3 The terms word, register and address and their use in the storage of data and instructions | Topic 3.2 Computer Architecture.docx
Single | 43 | 3.2.4 Machine Instruction Cycle | Topic 3.2 Computer Architecture.docx
Single | 43 | 3.2.5 [NAME] | Topic 3.2 Computer Architecture.docx
 |  | Cache memory
 |  | Virtual memory
Double | 44 | PAST PAPERS | May 2007 Paper 1 SL.pdf
Week 13
Single | 45 | 3.2.6 Secondary memory, sequential and direct access | Topic 3.2 Computer Architecture.docx |  | Exercise 3.3 & 3.4 |  |  |  |  |  | http://www.ehow.com/video_4754170_what-definition-disk-drive.html
Single | 46 | 3.2.7 Microprocessors |  |  | Exercise 3.5 |  | Introduction to Computer Systems Quiz.mht
 |  | 3.2.6 Input devices | Topic 3.2 Computer Architecture.docx |  | Exercise 3.6 |  | http://www.youtube.com/watch?v=Gnl1vuwjHto
 |  | 3.2.8 Output Devices |  |  | Exercise 3.7 |  | http://www.youtube.com/watch?v=CFybx32Mvkw
 |  | 3.2.9 Recent Developments in Computer System Architecture
Double | 47 | PAST PAPERS | November 2007 Paper 1 SL.pdf
Week 14
Single | 48 | PAST PAPERS | May 2005 Paper 1 SL.pdf
Single | 49 | REVISION FOR TEST
Double | 50 | TEST
Week 15
Single | 51 | TEST CORRECTION
Week 16
Single | 52 | 3.4 NETWORKED COMPUTER SYSTEMS |  |  |  | 3.4 Network Systems.doc | Networks Quiz.mht |  |  |  | Routing and Deadlock Video.mht
 |  | 3.4.1 DEFINITION OF THE TERMS LAN, WAN, CLIENT AND SERVER |  |  |  | Topic 3.4 Additional HW 2.php.pdf
 |  | LOCAL AREA [NAME] (LAN) |  |  |  | Topic 3.4 Additional HW.php.pdf
 |  | WIDER AREA [NAME] (WAN) |  |  | Exercise 3.12 | Binary and Networks.mht
 |  | 3.4.2 DIFFERENT NETWORK TOPOLOGIES
Single | 53 | 3.4.3 HARDWARE REQUIRED IN NETWORKING
 |  | 3.4.4 PACKETS, PROTOCOLS, INTEGRITY AND SECURITY OF DATA
 |  | PROTOCOLS
Double
 | 54 | 3.4.5 SOFTWARE INVOLVED IN NETWORKING
 |  | 3.4.6 DATA INTEGRITY IN TRANSMISSION
 |  | PARITY CHECKING
 |  | CHECK SUMS (BLOCK CHARACTER CHECKS)
Week 17
Single | 55 | 3.4.7 DATA SECURITY |  |  |  |  |  |  |  |  | Public Key Encryption Video.mht
Single
 | 56 | 3.4.8 THE NEED FOR SPEED IN DATA TRANSMISSION
 |  | TRANSMITTING GRAPHICAL DATA
 |  | Compression of Bitmaps (JPEG)
 |  | A three digit colour code |  |  | Exercise 3.13
 |  | VECTOR GRAPHICS
Single
 | 57 | 3.4.9 DISCUSS APPLICATIONS AND IMPLICATIONS OF NETWORKING FOR ORGANISATION
 |  | Improved internal communications:
 |  | External communications
 |  | Distributed Processing
Double
 | 58 | BENEFITS OF NETWORKING FOR USERS |  |  | Exercise 3.13 (2)
 |  | 3.4.10 WEB BROWSERS AND SEARCH ENGINES
 |  | Functions of a web browser.
 |  | FUNCTIONS OF A SEARCH ENGINE |  |  | Exercise 3.14
Week 18
Single | 59 | 3.3 Computer Systems |  |  |  | 3.3 Computer Systems.doc
 |  | 3.3.1 Define Operating Systems |  |  |  | Topic 3.3 Additional HW.php.pdf |  |  |  |  | http://www.youtube.com/watch?v=0QRO3gKj3qw
 |  | 3.3.2 Operating System Functions
 |  | Peripheral Communication
 |  | Coordinating concurrent processing
 |  | Memory Management
Single
 | 60 | Resource Monitoring
 |  | Accounting and Security
 |  | Program and Data Management
Single
 | 61 | 3.3.3 Characteristics of Computer Systems and a comparison of these characteristics and applications of different kinds of computers
 |  | Personal Computer (PC S) and Portable Computers
 |  | Mainframes
 |  | Super Computers |  |  | Exercise 3.8
 |  | Number of Users: Multi-User and Single-User Computer Systems
Double
 | 62 | 3.3.4 Comparison and different applications of computer systems
 |  | Personal and Portable Computers
 |  | Mainframe
 |  | Super Computer
Week 19
 | 63 | 3.3.5 Computer System Operation Modes
Single |  | 3.3.6 Applications of different modes of operation |  |  | Exercise 3.9
Single
 | 64 | 3.3.7 Relationship between master file and transaction file |  |  | Exercise 3.10
 |  | 3.3.8 Reliability of systems |  |  | Exercise 3.11
 |  | Backup strategies
Single
 |  | 3.7 UTILITY SOFTWARE |  |  |  | Topic 3.7 Additional HW.php.pdf
 | 65 | 3.7.1 AND 3.7.2 FUNCTIONS AND NEED FOR THE ABOVE UTILITY SOFTWARE.
 |  | FILE MANAGERS
 |  | DEFRAGMENTATION
Week 20
 | 66 | DATA COMPRESSORS
Single |  | VIRUS CHECKERS |  |  | Exercise 3.25
Single | 67 | CASE STUDY
Single
 | 68 | CASE STUDY
Double | 69 | TEST
Week 21
Single | 70 | CASE STUDY
Single
 | 71 | CASE STUDY
Double
 | 72 | 1.1 SYSTEMS LIFE CYCLE |  |  |  | 1.1 Systems Life Cycle.docx
 |  | 1.1.1 MAJOR STAGES
 |  | 1.1.2 DATA COLLECTION IN THE ANALYSIS PHASE
Week 22
Single | 73 | 1.1.3 DATA COLLECTION TECHNIQUES
 |  | 1.1.4 THE REQUIREMENTS SPECIFICATION
Single
 | 74 | 1.1.5 FEASIBILITY REPORT
 |  | 1.1.6 ALTERNATIVE SOLUTIONS
Week 23
 | 75 | 1.1.7 SYSTEM TESTING
 |  | 1.1.8 METHODS OF IMPLEMENTING NEW SYSTEMS
Single |  | 1.1.9 MAINTENANCE |  |  | Exercise 1.1
Single
 | 76 | 1.2 SYSTEMS ANALYSIS
 |  | 1.2.1 IMPORTANCE OF FORMULATING A PROBLEM PRECISELY
 |  | 1.2.2 ASPECTS THAT MUST BE CONSIDERED
Double
 | 77 | 1.2.3 OUTCOMES OF INVESTIGATION
 |  | 1.2.4 PROBLEMS THAT CAN BE SOLVED USING COMPUTER SYSTEMS
 |  | 1.2.5 BASIC CONTROL CONSTRUCTS
 |  | 1.2.6 MODULAR DECOMPOSITION |  |  |  |  | Systems Analysis Quiz.mht
Week 24
 |  | 1.3 SYSTEM DESIGN
 | 78 | 1.3.1 PARTS OF A SYSTEM
Single |  | 1.3.2 DATA IN A COMPUTER SYSTEM |  |  | Exercise 1.2
Single
 | 79 | 1.3.3 DATA CAPTURE AND PRESENTATION |  |  | Exercise 1.3
 |  | 1.3.4 DESIGN OF APPROPRIATE DATA STRUCTURES |  |  | Exercise 1.4
 |  | 1.3.5 HARDWARE COMPONENTS
Single
 | 80 | 1.3.6 USER INTERFACES |  |  | Exercise 1.5
 |  | 1.3.7 SYSTEMS FLOWCHARTS
Double | 81 | 1.3.8 CONSTRUCTING SYSTEMS FLOWCHARTS
Week 25
 | 82 | 1.4 SOCIAL SIGNIFICANCE AND IMPLICATIONS OF COMPUTER SYSTEMS |  |  |  | 1.4 Social Significance.doc
Single |  | 1.4.1 SOCIAL AND ECONOMIC IMPLICATIONS OF INSTALLATION OF NEW SYSTEMS
Week 26
Single | 83 | 1.4.2 SOCIAL SIGNIFICANCE AND IMPLICATIONS OF THE WIDESPREAD USE OF COMPUTERS
 |  | 1.4.3 CURRENT TRENDS AND THEIR CONSEQUENCES
Double
 | 84 | 1.5 THE SOFTWARE LIFE CYCLE
 |  | 1.5.1 OUTLINE THE MAJOR STAGES IN THE SOFTWARE LIFE CYCLE
 |  | 1.5.2 CYCLICAL NATURE
Week 27
 |  | 1.6 SOFTWARE DESIGN |  |  |  | 1.6 System Life Cycle.doc
Single | 85 | 1.6.1 DATA REQUIREMENTS
 |  | 1.6.2 MODULAR DESIGN
Single
 | 86 | 1.6.3 PROTOTYPING
 |  | 1.6.4 PROTOTYPING APPHOACH TO SYSTEMS DESIGN AND DEVELOPMENT
Single
 | 87 | 1.6.5 ADVANTAGES OF PROTOTYPING
 |  | 1.6.6 EFFICIENCY OF SOLUTIONS
Double
 | 88 | 1.7 DOCUMENTATION |  |  |  | 1.7 Documentation.doc
 |  | 1.7.1 DOCUMENTATION OF THE CYCLE
 |  | 1.7.2 SYSTEM DOCUMENTATION
 |  | 1.7.3 USER DOCUMENTATION
Week 28
Single | 89 | PASTPAPERS
Single
 | 90 | PASTPAPERS
Double | 91 | PASTPAPERS
Week 29
Single | 92 | PASTPAPERS
Single | 93 | PASTPAPERS
Double | 94 | PASTPAPERS
Week 30
Single | 95 | PASTPAPERS
Single | 96 | PASTPAPERS
Single
 | 97 | PASTPAPERS
Double | 98 | PASTPAPERS