Data Processing Scheme of Work SSS3 Lagos State

Access Data Processing Scheme of work for SSS 3. Lagos State Curriculum Data Processing for Secondary School. SS3 Schemes of Work.

SSS 3 Data Processing Scheme of Work First Term

WKS	TOPICS	LEARNING OBJECTIVES	LEARNING ACTIVITIES	EMBEDDED CORE SKILLS	LEARNING RESOURCES
1	Test/introduction to computer networking	By the end of the lesson, students should be able to: Describe computer networking	1] Administer the learners readiness assessment test 2] whole class discussion	1] critical thinking and problem solving 2] collaboration and communication 3] leadership and personal development	1] charts 2] computer system 3] computer network Greeks Projector
2	Computer networking -intranet -internet -significance of networking	By the end of the lesson, students should be able to: -define computer networking Distinguish between intranet and internet -state the significance of networking	1]thin-pair and share 2]small group discussion to brainstorm on the difference between intranet and internet 3] question and answer	1] critical thinking and problem solving 2] collaboration and communication 3] citizenship	1]charts 2] computer systems Computer networking Greek’s lesson, Youtube Projector
3	Types of networking -local area network	By the end of the lesson, students should be able to: -list example of network	1] think –pair and share	1] critical thinking and problem solving	1] charts 2] computers systems in a network environment

4	Networking -topology -definition of topology Types of topology Ring , star, mesh, tree, bus	By the end of the lesson, students should be able to: 1] define topology sketch the hologram of each types of topology 3] List the characteristics of each topology	1] think –pair and share 2] small group discussion to brainstorm on the difference between intranet and internet 3] question and answer	Critical thinking and problem solving -leadership and personal development   Collaboration and communication	1] charts 2] computer systems in a network environment
5	Internet ii Create an e- mail account -file Attachment Send and receive an e-mail	By the end of the lesson, students should be able to: Create a personal e-mail address -attach files to e-mail -send and receive e-mail	1] whole class discussion 2] teacher demonstration 3] student demonstration	1]citizenship 2] creativity thinking and problem solving 3] digital literacy	1] computer systems with inter-connection 2] tablets, phones with inter-connection 3] projector
6	Internet ii -concept of social media	By the end of the lesson, students should be able to:	1] think-pair and share 2] whole class discussion on the concept of social media	1] collaboration and communication	1] computer systems with inter-connect
WKS	TOPICS	LEARNING OBJECTIVES	LEARNING ACTIVITIES	EMBEDDED CORE SKILLS	LEARNING RESOURCES
	-online registrations -introduction to CBT	1] Explain the concept of social media and mention common examples -discuss online system -itemize steps involved in online registration -attempt computer based tests in class	3] leader demonstration 4]students demonstration of procedures	2] critical thinking and problem solving 3]  citizenship 4] leadership and personal development	2] tablets, phones with internet connection
7	Mid Term Break

8	Computer virus -meaning of computer virus -types of computer virus -virus Warning sign Virus Detections/prevention	By the end of the lesson, students should be able to: -define computer virus -list type of virus State the sources of computer virus Identify virus warning sign State ways to prevent virus	1] Think-pair and share 2] whole class discussion on the concept 3]question and answer	1]collaboration and communication 2] critical thinking and problem solving	1] computer systems
9	Maintenance of computer II -details of hardware Maintenance	By the end of the lesson, students should be able to: -carry out simple computer hardware maintenance -state importance of maintaining computer	1] Teacher Demonstration 2] students demonstration 3] whole class discussion	1] citizenship 2] collaboration and communication	1] computer system 2] real hardware components Printers, keyboard etc
10	Maintenance of computer II -details of software maintenance -ways of protecting computer Software	By the end of the lesson, students should be able to: -carry out detail software maintenance -state ways of preventing computer software	1]whole class discussion 2] teacher and students demonstration	1] citizenship 2] collaboration and communication	—

11	Career opportunities in Data processing -professional in computer -qualities of good data processing professional -computer professional bodies Distances/ sponges	By the end of the lesson, students should be able to: -identify career opportunities in data processing -state the question of Data processing professional -identify some computer professional bodies and state three function	1] group discussion 2] think-pair and share	1] citizenship 2] collaboration and communication 3] critical thinking and problem solving	—
12	Revision
13	Examination

Data Processing Scheme of Work SSS3 Second Term

WKS	TOPICS	LEARNING OBJECTIVES	LEARNING ACTIVITIES	EMBEDDED CORE SKILLS	LEARNING RESOURCES
1.	Test/ introduction to application package	By the end of the lesson, students should be able to: 1] list some application packages	Exploratory talk: students are allow to express their opinion on the definition of application packages. Teachers are to help them to drive their points home   Brainstorming  : through the help of teachers’ though provoking questions; students are  to figure out base on what they do on the system to name some of the application package they are familiar with.	Collaboration and communication Creativity and imagination   Digital literacy	Computer with application packages installed e.g. Microsoft Office, CorelDraw, web browser, music player etc Charts Video (sourced from Youtube

2	Word processing -features of word processing -prepare -Edit -Save -And print a document	By the end of the lesson, students should be able to: 1] list the features of word packaging 2] prepare and edit document an appropriate package 3] save and print document in MS-Word	Think, pair and share: students are paired to discuss features of word processing package   Hands –on activities   The teacher will guide the learners into using the word processing package (Microsoft Office Word) in preparing, edit, save and print –document Group work: students are to be grouped and assign system to use in order to practice and collaborate among themselves on the tasks stated in lesson’s objective column	Creativity and imagination   Critical thinking and problem solving   Leadership and personal development skill   Leadership and personal development skills	-charts Computer system with MS-office suite -Alison.com (learning Microsoft office package)
3	Word processing -application on MS- word in daily life	By the end of the lesson, students should be able to: -apply MS- word in preparing documents	Hand-on demonstrations and exercises: students under the triangle of the teacher, load and identify the features of MS-word Assessment for learning: The learners will perform some activities on how to format a given text document with some list of tasks to do, bold, font size, type etc	Digital literacy   Critical thinking and problem solving   Creativity and imagination	-charts Computer system Youtube

4	Spread sheet -Microsoft excel -features of MS Excel Formula Calculation Graphs in Microsoft Excel	By the end of the lesson, students should be able to: 1] identify the features of MS excel 2] Use MS excel formula to calculate	Prompts for questioning students are called to answer some questions after watching a tutorial video on different features of MS Excel   Hands-on demonstrations and exercises: students under the tutelage of the teacher, load and spreadsheet (MS Excel)	Critical thinking and problem solving   Digital literacy	-charts Computer system MS office suite   Alison .com Youtube
5	Graphic package Corel Draw	By the end of the lesson, students should be able to: 1] identify the features of Corel draw 2] use Corel draw tools	To help them to drive their points home   Hands-on activities: the teacher will guide the learners into using the CorelDraw basic tools in facilitating a simple drawing after watching a video clip on it from you tube in order to be familiar with features and tools in CorelDraw	Creativity and imagination	Computer installed  with Corel Draw

	-features -create simple logo Create an invitation	1] identify the features of Corel draw 2] use Corel draw tools	To help them to drive their points home	Collaboration and communication   Critical thinking and problem solving	Textbook: online with computers, SSS3 by Adedapo F. O. and others   youtube
6	DBMS Data base management system (DBMS) MS-Access	By the end of the lesson, students should be able to:  1] Using MS-Access application	Hands-on activities: explain and demonstrate how to create forms, generate queries and prepare reports using MS-Access to the students while the students follow suites  as the teacher guides them through   Group work: students are to be grouped and assign  systems to use to carry out task as regards the use of MS-Access	Collaboration and communication   Critical thinking and problem solving	Computer  system with MS-Access
7-14			Mid Term Break Test & Project Revision Mock WASSCE/NECO

Achievement Standard Data Processing

  At the end of the session students will be able to:

SS1

1. Collect Data, demonstrate how data can be collected and differentiate between data and information
2. Debate on electronic and non –electronic data
3. Set up computer laboratory to explore ICT gadgets
4. Access internet to make research and differentiate between –system and application software
5. Had, exit create save & retrieve files using Ms word
6. Create document on spreadsheet, retrieve file and print out file
7. Launch MS-excel, load, exit, create save, retrieve file and print out file on Ms-excel

SS2

1. Create, save, retrieve and exit in MS-access
2. Differentiate between types data model
3. Differentiate between tables, forms, queries and …….. reports in data modeling
4. Explain  the determinants of normal forms and describe the functions of normal keys
5. Explain the terms ‘entities, attributes and relationship
6. Explain the term relations: models, describe data can be represent in relational model tables and insert data in appropriate fields
7. Modify relations using database application package
8. Create forms, generate queries and prepare reports using MS-Access
9. Identify and discuss different type of file organization using real life experiences
10. Load, identify features and apply, Microsoft power point application to create a presentation
11. State uses of graphic packages
12. Apply the tools in Corel Draw work environment
13. Create simple logo using Corel Draw
14. Create invitation cards
15. Use Web design packages

SS3

1. Differentiate between intranet and internet
2. State the significance of networking
3. Differentiate between computer Network  and Net working
4. Create an-e-mail account, do file attachments, send and receive an e-mail
5. State ways to prevent virus
6. Use Corel draw tools