Data processing is the heart of information technology, and the SSS 2 scheme of work spans three terms to cover essential areas like data modeling, file organization, and graphic design.
Each term focuses on specific aspects of data management and processing, preparing you to handle complex digital systems.
By the end of the course, you gain the skills needed to navigate everything from database structures to web design.
The recommended textbooks serve as valuable resources, offering in-depth knowledge and practical exercises to master these concepts.
SSS 2 DATA PROCESSING First Term Scheme of Work
Week 1: Data Model
- Definition of data models
- Types of data models: hierarchical, network, relational
- Importance of data models in database management
Week 2: Data Model (Continued)
- Further exploration of data model structures
- The application of different data models in real-world scenarios
Week 3: Data Modelling
- Definition and purpose of data modelling
- Steps in data modelling: conceptual, logical, and physical models
- Components of data models: entities, attributes, relationships
Week 4: Data Modelling (Continued)
- Detailed case studies of data modelling in business systems
Week 5: Normalization
- Introduction to database normalization
- The need for normalization in reducing redundancy
- Steps of normalization: 1NF, 2NF, 3NF
Week 6: Third Normal Form (3NF)
- Detailed study of the third normal form
- Identifying transitive dependencies and removing them
Week 7: Mid-Term Break
Week 8: Entity Relationship Model
- Definition and components of the entity-relationship (ER) model
- Entities, attributes, and relationships in ER diagrams
- How to create ER diagrams for data systems
Week 9: Determinants of Normal Forms
- Explanation of determinants and their role in normal forms
- Identifying determinants in database tables
- Practical exercises on determinants and normalization
Week 10: Attribute
- Definition and types of attributes: single-valued, multi-valued, derived, etc.
- Attributes in database design and their importance
- Practical examples of defining attributes in ER models
Week 11: Revision
Week 12: Examination
Week 13: Closing
SSS 2 DATA PROCESSING Second Term Scheme of Work
Week 1: File Organization
- Definition of file organization
- Types of file organization: sequential, indexed, random
- How to choose an appropriate file organization method for different tasks
Week 2: Internet
- Overview of the internet: history, components, and infrastructure
- Internet services and their uses: email, FTP, WWW
- The role of internet service providers (ISPs)
Week 3: Internet (Continued)
- Detailed study of internet protocols: HTTP, HTTPS, TCP/IP
- Benefit and abuses of interbet
Week 4: Presentation Packages
- Introduction to presentation software (e.g., Microsoft PowerPoint)
- Components of presentation packages: slides, multimedia, transitions
- Creating simple presentations using a presentation package
Week 5: Presentation Packages (Continued)
- Advanced features of presentation packages: animations, embedded media
- Customizing slide layouts and themes
- Practical exercises on creating a professional presentation
Week 6: Web Design Package
- Introduction to web design software (e.g., HTML, CSS)
- Basics of web page creation: structure, layout, and formatting
- How to design simple web pages using web design packages
Week 7: Mid-Term Break
Week 8: Practical on PowerPoint Presentation
- Hands-on session to create presentations
- Application of animation, transitions, and multimedia in presentations
- Class evaluation of practical exercises
Week 9: Web Design Package (Continued)
- Further development of web design skills
- Creating multi-page websites with navigation features
- Practical assignments on web design
Week 10: Practical on Web Design
- Hands-on practical on creating websites
- Use of HTML, CSS, and simple web development tools
- Review of classwork and individual projects
Week 11: Revision
Week 12: Examination
Week 13: Closing
SSS 2 DATA PROCESSING Third Term Scheme of Work
Week 1: Graphics Design / Package
- Introduction to graphics design software (e.g., CorelDRAW, Adobe Photoshop)
- Components of a graphics package: tools, menus, layers
- How to create and manipulate simple graphics
Week 2: Graphics Package (Continued)
- Advanced tools in graphics design: gradients, masks, filters
- Creating professional designs and illustrations
- Practical exercises on creating posters, logos, and flyers
Week 3: Maintenance of Computer
- Importance of computer maintenance
- Types of maintenance: preventive, corrective, predictive
- Basic maintenance tasks: cleaning, software updates, backups
Week 4: Maintenance of Computer (Continued)
- Troubleshooting hardware and software issues
- Installation and removal of software
- Hands-on sessions on basic computer maintenance
Week 5: Introduction to E-Mail
- Overview of email services
- Components of an email system: inbox, outbox, drafts, spam
- How to compose and send an email
Week 6: Advantages of E-Mail
- Benefits of using email over traditional mail
- Email features: attachments, CC, BCC, forwarding
- Email etiquette and security measures
Week 7: Mid-Term Break
Week 8: Practical
- Hands-on session on using email for communication
- Sending attachments and using CC/BCC effectively
- Review of email security practices
Week 9: Practical
- Practical on graphics design: creating simple advertisements
- Application of layers, text effects, and image manipulation
- Class review of practical work
Week 10: Practical
- Final practical sessions on web design and PowerPoint presentations
- Group projects to create presentations and websites
- Assessment and feedback on practical exercises
Week 11: Revision
Week 12: Examination
Week 13: Closing
SSS 2 DATA PROCESSING Recommended Textbook
- Data Processing for Senior Secondary Schools by O.A. Oyelade
- Comprehensive Data Processing for Schools by Nwaocha Ozioma
- Essential Data Processing for Senior Secondary Schools by D. A. Adegboye
RECAP
SSS 2 Data Processing allows you to dive deep into the foundations of data modeling and normalization, equipping you with the skills to handle database structures effectively.
You break down complex topics like entity relationship models and determinants of normal forms in the first term.
In the second term, your understanding of file organization grows, and you explore presentation and web design packages, with hands-on practical sessions.
By the third term, you focus on graphics design, computer maintenance, and the practical use of email, preparing you for a digital world.
DISCLAIMER: Everything on this page is based on our research of what is obtainable for schools in all the states in the country, including government and some private schools. Schemes of work normally undergo a series of reviews and some schools modify them to suit their specific needs.
While we do all our possible best to keep up with the latest and approved schemes of work in the country, check the specific template your school uses. For example, some private secondary schools integrate the British curriculum. If you teach in such schools, expect to see slight changes to what we offer on this page. If you have any questions or require personalised support, kindly feel free to contact us.
