Daytime

Lesson 2: Performing Calculations
• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

Lesson 3: Modifying a Worksheet
• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
• Modify Fonts
• Add Borders and Colour to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Lesson 5: Printing Workbook Contents
• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks
• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Lesson 7: Customising the Excel Environment
• Customise General and Language Options
• Customise Formula Options
• Customise Proofing and Save Options
• Customise the Ribbon and Quick Access Toolbar
• Customise the Functionality of Excel by Enabling Add-Ins
• Customise Advanced and Trust Center Options

JavaScript
• variables
• conditional statements
• loops
• basic form I/O
• arrays

Java Basics
• Variables
• Conditional Statements
o If Statement, if-then Statement, if then else Statement
o Nested If Statements
o Switch Statements
• Arrays
• Iteration Statements (Loops)
o For Loops
o Enhanced For Loops
o While Loops
o Do While Loops
• Integrating Conditional Statements into Loops
• String Manipulation
• Vectors
• ArrayList
• Lists

Classes and Objects
• Creating Classes
• Class Members
• Constructors
• Assessors – getters and setters
• Class methods
• Encapsulation

Object Oriented Programming: Inheritance
• Superclasses and subclasses
• Relationships between Superclasses and subclasses
• Inheritance Hierarchy
• Constructors in subclasses

Object Oriented Programming: Polymorphism
• Polymorphic behaviour
• Abstract Classes and methods
• Concrete Subclasses
• Indirect Concrete Subclasses
• Implementing interfaces

Exception Handling
• When to use exception handling
• Some common example of exception handling
• Using try-catch-finally

Using UML (Unified Modelling Language)
• UML Elements for classes, abstract classes and interfaces
• Attributes and operations
• Visibility modifiers
• Relationship Specifiers

Using Graphical User Interface Components
• GUI Components
o JFrame
o JButton
o JTextField
o JLabel
o JCheckBox
o JRadioButton
o JComboBox
o JList
o JPanel
• Layouts
o FlowLayout
o BorderLayout
o GridLayout
o JPanels for more complex layouts
• Event Handling
o How event Handling works
o Implementing Listener Interfaces
o Anonymous Inners Classes for event handling

Accessing Databases with JDBC
• Relational databases
o SELECT
o WHERE Clause
o ORDER BY Clause
o INSERT
o UPDATE
• Connecting to an Oracle Database
o Querying the Database
o Looping through ResultSets
o Using Prepared Statements
• Using a Java GUI Interface with a Oracle Backend

Java Server Pages
• Creating a Web Based Project
• Using .jsp files
• Interacting with an Oracle Database using JSP
• Searching, Selecting and Displaying Data in a JSP
• Inserting New records using JSP and HTML Forms
• Updating Existing Records Using JSP Forms

Preparing the Students for the SCJA Exam
• The Format of the EXAM
• Topics and Questions Covered
• Exam Watch
• Mock Exam Questions