JSS3 Second Term Computer Studies Lesson Note and Scheme of Work
Week 1: Advanced Word Processing Skills
Document formatting in Microsoft Word
Advanced editing features
Inserting tables and images
Hands-on activity: Creating a professional document
Week 2: Advanced Spreadsheet Techniques
Advanced Microsoft Excel functions
Data analysis using pivot tables
Chart creation and customization
Project: Analyzing and presenting data
Week 3: Computer Security
Importance of computer security
Types of cyber threats
Antivirus software and best practices
Group discussion: Creating a cybersecurity plan
Week 4: Introduction to Python Programming
Basics of Python programming
Variables, data types, and basic operations
Writing simple Python scripts
Coding exercises: Basic Python programs
Week 5: Graphics Design and Animation
Advanced graphic design tools
Animation basics
Creating animated graphics
Project: Designing and animating a digital logo
Week 6: Mobile App Development Basics
Introduction to mobile app development
Basics of App Inventor
Building a simple mobile app
Group project: Creating a basic mobile application
Week 7: Advanced Internet Concepts
Web development frameworks
Introduction to JavaScript
Dynamic web page creation
Practical session: Building an interactive webpage
Week 8: Advanced Database Management
Relational databases
SQL queries and database management
Advanced features of Microsoft Access
Database project: Designing and implementing a complex database
Week 9: E-commerce and Online Transactions
Understanding e-commerce
Online payment systems
Security measures for online transactions
Case study: Analyzing e-commerce websites
Week 10: Network Administration Basics
Introduction to network administration
IP addressing and subnetting
Troubleshooting network issues
Practical exercise: Configuring a small network
Week 11: Revision Week
Comprehensive review of second-term topics
Mock exams and quizzes
Q&A session
Week 12: Examination Week
Written examination on second-term topics
Practical assessments for programming and projects
Week 13: School Dismissal Week
Recap of the entire course
Certificate distribution
Farewell and encouragement for future studies in computer science.
