Lesson 1: Introduction to System Analysis and Design

• What is a system?
• Characteristics of a System
• Information System
• The Components of Information Systems
• Purpose of information System
• System Analysis and Design
• System Analyst
• System Development life cycle
• Stage of System Development life cycle
• Planning
• Analysis
• Requirement Specification
• Design
• System Construction
• Testing
• Deployment of the system
• Maintenance

Lesson 2: System Development Methodologies

• Waterfall Model
• What is agile method?
• Rapid Application Development (RAD)

Lesson 1: Introduction to Database Management

• Overview
• What is a database?
• Why do we use a database?
• The advantages of having a database include:
• Disadvantages of Database
• Database Objects:
• I. Tables
• Table 2.1: Microsoft Access Data Types
• II. Forms
• III. Queries
• IV. Reports

Lesson 2: Managing Databases and Objects

• Getting Started Microsoft Access 2016
• To open Microsoft Access 2016:
• Working with your Access environment
• The Ribbon
• To minimize and maximize the Ribbon:
• The Quick Access Toolbar
• Backstage view
• The Navigation pane
• To minimize and maximize the Navigation pane:
• Sorting Objects in the Navigation pane
• Creating a database
• Creating a Table
• To open an existing database:
• To close a database:
• To open an object:
• Saving objects
• To close an object:
• To rename an object:

Lesson 3: Working with Tables

• Table basics
• To open an existing table:
• Navigating within tables
• Adding records and entering data
• To save a record:
• Editing records
• To delete a record:
• Resizing fields and rows
• Hiding fields
• Alternate row color
• Creating Primary Keys in a Table
• To create a Primary Keys

Lesson 4: Working with Forms

• Overview
• Why use forms?
• To create a form
• To open an existing form:
• To add a new record:
• To find an existing record to view or edit:
• To save the current record:
• To delete the current record;

Lesson 5: Designing a Query

• Overview
• What are queries?
• Advantages of query:
• To create a simple query:
• To modify a query:
• Designing a Multi table Query
• Planning a query
• Creating a multi table query

Lesson 6: Creating Reports

• Overview
• To create a report:
• To save your report:
• To delete a field in a report:
• Printing reports in Print Preview

Lesson 1: Basics of Programming

• Overview
• What is a Programming?
• Programming Languages
• IDE
• What is debugging?
• Syntax errors
• Runtime errors
• Semantic errors
• Debugging
• Stepping
• Most popular programming languages
• Why Python?

Lesson 2: Introduction to Programming Using Python

• Overview
• Getting Python
• Installing Python on Windows
• Open IDLE
• Your First Python Program
• The Interactive Window
• The Script Window
• Values, Data Types, Variables and Expressions
• Data Types
• String
• Integers
• Floats
• Expressions
• Basic Calculations in Python
• More Complex Calculations
• String expressions
• Variables
• Creating Variables with Assignment Statements
• Variable names
• Comments in Python
• Reading Input from the Keyboard
• Reading Numbers with the input Function
• Calculating a Percentage
• Conditional Statements and Boolean Logic
• If Statement
• Boolean Expressions and Relational Operators
• Using the if Statement
• The if-else Statement
• Using the if-else Statement
• The if-elif-else Statement
• Using the if-elif-else Statement
• Loop Structures for Repetitions
• The for Loop: A Count-Controlled Loop
• Iterating over a List with the for Loop
• Using the range Function with the for Loop
• Using the Target Variable inside the Loop
• Letting the User Control the Loop Iterations
• The while Loop: A Condition-Controlled Loop
• Infinite Loops

Lesson 1: Digital Security, Safety and Privacy

• Overview
• Digital Security Risks
• Cybercrime
• Internet and Network Attacks
• Tips to Safeguards against Internet and Network Attacks
• Firewalls
• Access Controls
• User Names and Passwords
• Software Theft
• Information Theft
• Tips to Safeguards against Information theft
• Backing Up

Lesson 2: Computer Ethics

• Overview
• What are ethics?
• Computer ethics
• Intellectual property
• Copyright
• Plagiarism
• Privacy Concerns
• Free Software, Freeware and Shareware
• Free software
• Freeware
• Shareware