By the end of the lesson, students should be able to: Describe database system
1. administer leathers readiness Assessment Test Whole class discussion: learners express their view of what database management is Explorative talk: students are allow to talk extensively on the term database
Communication and collaboration Critical thinking and problem solving
Audio visual Charts Computer system Projector Sound system Web resources Video site Youtudejenny’s lectures Youtubelucidchart Document site
2
Database management system Definition of database and database management system
By the end of the lesson: student should be able 1. explain the term database 2. discuss the use of database management 3. give example of database software 4. list feature of MS-access
Explorative talk: students are allow to talk extensively on the term database management system and then share with the class Prompts for questioning: learners give answer to the prompts on the examples of database software and the features of MS-Access
Critical thinking and problem solving Communication and collaboration Personal development
Audio visual Charts Computer system Projector Sound system Web resources video site Document site
3
Database management system –MS-Access
By the end of the lesson students should be able to: 1 create and save files 2] retrieve files in MS-access 3] exit MS-Access
Small group Discussion, students in their small groups discuss on the list of steps to follow in creating save and retrieved files on MS-Access Demonstration and practice Students practice how to create save and retrieve files in MS-access following teacher’s demonstration
Citizenship Communication and collaboration Critical thinking and problem solving Digital literacy
Audio visual Charts Computer with MS office sites Installed Web resources Video site Document site
4
Data Model 1
By the end of the lesson students should be able to: 1] explain the term data model 2] outline stages of data models 3] give examples of data models
Brainstorming students contribute their views and ideas together in order to explain the term data model Think pair and share: students pair up with their seat mates and examine the stages of data model and then share with the class Prompts for questioning: learners give answer to the prompts on the examples of data models
Collaboration and communication Critical thinking Leadership and personal development
Audio visual Chart Computer with MS office sites Interactive training Cd Sound system Web resources Document site
5
Data model 2 Types of data model -flat model Hierarchical model Network model Object oriented
By the end of the lesson students should be able to: Explain each types of data model 2] examine different features of each data model type 3]differentiate between types of data model
Think-pair and share to brain storm on the meaning of data model and share with the entire class Small group work: students are given different types of data model in their various groups to discuss features of each Whole class discussion: the students express their views on the differences between types of data model
Collaboration and communication Citizenship Critical thinking and problem solving Leadership and personal development
Audio visual Charts Computer MS office site Interactive training Cd Web resources Document site
6
Data modeling 1 Creating tables forms
By the end of the lesson students should be able to:
Small group discussion: students in their small groups
Collaboration and communication
Audio visual Chart
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
Creating queries reports
1] explain the following terms tables, forms, queries and reports in data modeling 2] create tables and queries 3] generate reports
Discuss the terms tables, forms, queries and reports in data modeling Demonstration and practice: students practice how to create tables and queries using MS- access to generate reports following teacher’s demonstration
Citizenship Critical thinking and problem solving Digital literacy
Computer with MS office suites Interactive training Cd We resources
7
Mid Term Break Test & Project
8
Data modeling II -significance of data Modeling Examples of standard data models
By the end of the lesson students should be able to: 1] explain the significance of data modeling 2] state the components of DBMS 3] identify and use DBMS
Explorative Talk: students discuss their ideas and views of the significance of data modeling Think-pair and share students pair up to brainstorm on the components of DBMS and then share with the class Demonstration and practice Students on DBMS identify some tolls and practice how to use them following teacher’s demonstration
Collaboration Critical thinking and problem solving Digital literacy
Audio visual Charts Computer system Interactive training soft ware Web resources
9
Normalization Definition of normalization Tables in 1st , 2nd and 3rd Normal form Problems of tables In 1st normal form
By the end of the lesson students should be able to: 1] explain the term normalization 2]create tables in normal form 3] identify problems of tables in 1st normal form
Whole class discussion: students brainstorm to bring out the meaning of normalization Think-pair-share: students pair up to discuss on how to create tables in normal form and identify problems of tables in 1st normal form and share with the class
Collaboration and communication Citizenship Leadership and personal development Digital literacy
Audio visual Charts Computer system Interactive training soft ware Web resources Video site
Investigative: students are to watch and learn more with this video link Youtube studyonnight
Critical thinking and problem solving
–
10
Normalization II -keys Primary keys Foreign keys Composite key Determinant of normal form
By the end of the lesson, students should be able to 1] discuss key in relation to data base 2] explain the determinants of normal forms 3]describe the functions of normal keys 4] differentiate between keys 5] use these keys in data base
Explorative talk: students present their views on keys in reaction to debase Brainstorming: students critically examine the different types of keys. Hands –on-activities: students follow teacher’s guide to use keys in database Small group discuss lot: learners fail into groups to explain the determinants of normal forms and group leader presents views to the class Prompts for Questioning Students respond to prompt as given by the teacher on function of normal keys Investigative: students are to watch and learn more with this video link
Critical thinking Creativity and imagination Digital literacy Leadership and personal development
Audio visual Charts Computer system Interactive training soft ware Web resources Video site
11
Entity relations models -definition Features of Entity model Entities
By the end of the lesson, students should be able to 1] explain the terms entities, attributes and relationship
Whole class discussion Students brainstorm to bring out the meaning of each term as listed in the objectives
Collaboration and communication Citizenship
Audio visual Charts Computer system with MS-office Suite installed
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
Attributes
2] list features of entity model and identify objects around the entity set 3] describe the relations between entities
Think-pair-share Students pair up to brainstorm on the features of entity model and objects around the entity set and share with the entire class Explorative Talk: students present their views on relations between entities
Critical thinking and problem solving
Web resources Video site Document site
12
Revision /Examination
13
Examination
Access Data Processing Scheme of work for SSS2. Lagos State Schemes of Work for Senior Secondary School – Schemeofwork.com
Data Processing Scheme of Work SSS2 Second Term
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
1
Test /relational model -definition of relational models -creating relations Using application package e.g. SOL
By the end of the lesson, students should be able to: -explain the term relational models -describe how data can be represented relational model -create tables and insert data in the appropriate fields
1] brainstorming students are made to rearrange a set of mixed up books for easy access and management using library as a guide in order to learn relational database and how data can be represented 2] hands-on – activities (where it is possible, students follow teacher’s guide on steps and commands to create data base tables
Critical thinking and problem solving Creativity and problem solving Creativity and imagination
Audio visual Charts Computer system with SOL application software Web resources Video site
2
Relational models Modifying relations using application packages integrity constraints in over relation
By the end of the lesson, students should be able to: 1] modify relations using database application package 2] explain integrity constraints over relations 3] state terms related to RDBMS
Small group discussion students are arranged together in session groups that focus on a data representation in relational model Within each group, every students contributes thoughts and ideas on how data is represented Prompts and questioning Students respond to prompts as given by the teacher on following them cordially, entity integrity, connectivity, constraints, integrity, constraints and relationship type as related to RDBMS Investigative: students are to visit internet and learn more with this video link
Collaboration and communication Citizenship Digital literacy Leadership Critical thinking and problem solving
Audio visual Charts Computer system with RDMS application software Web resources Document site
3
Relational model -enforce integrity constraints -querying and reports
By the end of the lesson, students should be able to: 1] create forms 2] generate queries 3]prepare reports using MS-Access
Demonstration and practice Students practice how to create forms, generate queries and prepare reports using MS-Access following teacher’s demonstration Investigative Students are to visit internet and watch more with this video link
Digital literacy, collaboration and communication
Audio visual Charts Computer system with MS-Access Web Resources Video site
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
4
Data base security -concepts of data base security -Access control -data encryption
By the end of the lesson, students should be able to: 1] explain the concept of data security 2]state the importance of security 3] encrypt data using the appropriate method
Small group discussion: students come together in session groups that focus on concept of data security. Within each group, every student contributes thoughts and ideas on concept of data security and importance of security and importance security. Students are guide and encourage to discuss and collaborate , each group to choose a representative to present the summary of their discussion in their various group Exploratory Talk: Students present their views on data encryption as teacher guide to drive their point home
Critical thinking and problem solving Collaboration and communication Citizenship Leadership and personal development
Audio visual Charts Web resources Video site
5
Role of data base administrator in data base security -who is a data base administrator? -functions of data base administrator Methods of data base security
By the end of the lesson, students should be able to: 1] describe a data base 2] state the functions of a data base administrator 3] list methods of data base security
Think-pair-share Students are paired to discuss who a database administrator is and his functions then share with the class No hand up Students pointed to in order to answer question on database security. This will give opportunity to students that will never want to raise hand to contribute to class discussion to be carry along and learn
Critical thinking and problem solving Collaboration and communication Leadership and personal development
Audio visual Charts Computer system with MS-Access Web Resources Video Site
6
File organisation 1 Definition of file organization Types of file organization Sequential Serial Index
By the end of the lesson, students should be able to: 1] explain the concept file organization 2] list the types of file organization Describe each type of file organization
Small group discussion : students come together in session groups that focus on concept of file’ and organization, relate the two together, come up with a definition of file organization Brainstorming Students identify and discuss different types of file organization using real life experiences such as shopping lists, audio cassette recording, payroll etc Students are to visit internet and watch more with this video link
Critical thinking and Collaboration and communication Citizenship
Audio visual Charts Computer system Audio cassette recording CD Shopping lists Web resources Video site
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
7
Mid Term Break/Test & Project
8
File extension, doc, xis, pdf, ipeg, etc -indexes, clustered indexes, dense versus sparse, primary and secondary indexes, indexes sing composite search keys, -significant of choosing appropriate file organization method for data differences between types of file organization
By the end of the lesson, students should be able to: 1] explain the concept of file extension 2] Give examples of the extension 3] save file with different file format (extension) 4] determine the appropriate method for file organization of data 5] give example of storage media appropriate for each file organization
Brainstorming students are grouped and each group discuss concept classify identified computer files/ documents into different classes/categories Buzz session Students based on the definition gives each computer files appropriate nomenclature Demonstration and practice Students practice how to save file with different extension from specific application packages follow teacher’s demonstration Small group Discussion Students come together in session groups that focus on the topic . within each group, every student contribute thoughts and ideas Encourage discussion and collaboration among the students within each groups about significant of choosing appropriate file organization method for data. Everyone should learn from each other’s input and experience Prompts for questioning Students respond to prompts as given by the teacher on the appropriate storage media
Critical thinking and problem solving Collaboration and communication Creativity and imagination Digital literacy
Audio visual Charts Computer system Application packages e.g. Microsoft Office suites, corel suites etc. Web resources Documents site
9
Presentation packages -definition of presentation Packages Types of file Presentation Packages Feature of presentation Packages
By the end of the lesson students should be able to 1] explain presentation package 2] give exercises of a presentation package 3] list uses of presentation package
Exploration talk: Students express their views of a presentation package give example and state the uses of the package Hands on practical: students are taken to the computer lab to have hands on experience on how presentation package lock like and its features
Leadership and personal development Critical thinking and problem solving Digital literacy
Audio visual Charts, printed materials etc Videos, multimedia projector Computer system Computer with presentation Package (MS-Power point) installed Web site
10
Basic concepts of entrepreneurship Entrepreneurship education
By the end of the lesson students should be able to: Explain the term entrepreneurship
1] whole class discussion on the meaning of entrepreneurship 2] students in small groups discuss the term entrepreneurship education
Communication and collaboration Critical thinking and problem solving
–
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
QUALITIES of an entrepreneur Importance of entrepreneurship
2] examine the concept entrepreneurship education critically 3] outline the importance of entrepreneurship
And share their knowledge with the class 3] students, as a class discuss the importance 4] students, in the same groups critically analysis the qualities of an entrepreneur
Leadership and personal development
Charts Pictures
11
Presentation package Microsoft power point Creating Saving Presentation
By the end of the lesson students should be able to: 1] load Microsoft power point application 2] identify features of Microsoft PowerPoint application to create a presentation
Demonstration and practice Students under the tutelage of the teacher, practice on how to load MS-Power point and identify the features of MS-Power Point and as well follow teacher’s demonstration steps on creating presentation Investigative Students are given across to use the internet to make research by access this link
Digital literacy Creativity and imagination
Audio visual Charts Computer system with Microsoft power point application software Video site
13
Revision Examination
14
Examination
Data Processing Scheme of Work SSS2 Third Term
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
1
Graphic packages -definition of graphic packages -uses of graphic packages -examples of graphic -package E.G Corel Draw, Instant Artist, Photoshop. etc
By the end of the lesson, students should be able to: 1] define graphic packages 2]give examples of graphic package 3] State uses of graphic package
Whole class discussion: students discuss on the concept of graphics Hands on practical: students are taken to the computer lab to have hands on experience on how graphic packages look like Exploratory Talk: students engage critically , but constructively with each other sharing ideas of what they know about graphic package Think-pair-share Students are allowed individually pan down examples of graphic packages they know, later paired up with a group, each group is to discuss and share their work with the class Investigative: students are given a link for further personal study
1] collaboration and Communication 2] critical thinking and problem solving
Audio Visual Charts Computer system Application packages (Corel draw, MS-paints) Web resources Documents Site
2
Graphic packages -introduction to Corel Draw
By the end of the lesson, students should be able to: 1] identify tools in Corel Draw package 2] State the function of each identified tools 3] apply the tools in Corel Draw work environment
Small group discussion: students in their small groups discuss the tools in Corel Draw and the function of each tools discussed Demonstration and practice: Students practice how to apply the tools following teacher’s demonstration Investigative: students are given access to use the internet to make researches on each tools in Corel Draw and what they are used for following the link below
Communication and communication Creativity Citizenship Critical thinking and creativity
Audio visual Charts Computer system Application packages (Corel draw, S-paints) Web resources Document site
3
Graphic packages -Corel Draw -Create logo
By the end of the lesson, students should be able to: -create simple logo using Corel draw Save Corel Draw documents
group work: students are divided into groups. Each group come up with a logo of their choice Hands on practical: students are taken to the computer lab and be guided on how to generally design a logo
Collaboration and communication Citizenship Creativity Digital literacy
Audio visual Chr Computer system Application packages (Corel Draw, MS-paint) Web Resources Document site
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
4
Graphic package Creativity invitation cards
By the end of the lesson, students should be able to: 1] Use Corel draw to create invitation card 2] save files in Corel draw 3] retrieve documents in Corel Draw 4] print life in Corel Draw using appropriate setting
Group work: students are divided into groups . each group to come up with a type of invitation card Hands on practical: students are taken to the computer lab and be guided on how to generally design an invitation card Students are allowed to use the computer in computer lab with the same group they designed with the previous week to print their saved document
1] collaboration and communication 2] creativity
Audio visual Charts Computer system Application packages (Corel draw, MS-Paints) Web Resources Video site
5
Web design packages -definition of web design -examples of packages -features and uses of web design packages
By the end of the lesson, students should be able to: 1] explain web design packages 2] give example of web design packages 3]state the uses of web design packages State the components of web design package
Exploratory Talk: students engage critically but constructively with each other sharing ideas of what they know, about web design packages and mention some examples Small groups Discussion: students are divided into groups, they are to discuss some of the features of web design packages and select a leader who presents to the entire class Investigative: students are to watch a short video that explains the components of web design packages on his site
Collaboration and communication Citizenship Creativity Digital literacy
Audio visual Charts Word development app Computer system Web resources Document site Video site
6
Internet -definition of internet -terminologies used in internet Benefits of the internet
By the end of the lesson, students should be able 1] explain the term “the internet” 2] List some of the term used in the internet State benefits of internet
Whole class discussion: students express their views on what they know about the internet Think-pair-share: students are allowed to individually pen down some terms the use when using the internet and benefits of the internet, they share the ideals in a group and later with the class
1] collaboration and communication 2] critical thinking and problem solving
Audio visual Charts Computer system Internet tools
7
Mid term break /Test & Project
8
Presentation package -definition of presentation Packages -example of presentation packages -features and uses of presentation packages
By the end of the lesson, students should be able to: 1] Explain ‘presentation package’ 2] give example of presentation package 3] state features of presentation package 4] list the uses of presentation package
Explorative Talk: Students express their views on presentation package, give example and state the uses of the package Hands on practical: students are taken to the computer lab to have hands on experience on how presentation package look like and its features
Collaboration and communication Creativity thinking and problem solving Digital literacy
Audio visual Charts, printed materials etc Videos, multimedia projects Computer system Computer with presentation package (MS-Power point installed Web resources Video site
WKS
TOPICS
LEARNING OBJECTIVES
LEARNING ACTIVITIES
EMBEDDED CORE SKILLS
LEARNING RESOURCES
9
Basic concepts of marketing (a) meaning of marketing [b] methods of marketing (c) importance of marketing Marketing /distribution channel chart
By the end of the lesson, students should be able to: 1] describe the term marketing 2] examine the methods of marketing 3]analyse the importance of marketing 4] create a flow chart of the marketing of channel distribution
1] students, as a class brainstorm on the term marketing 2] whole class discussion on the different methods of marketing 3] small group discussion on1] students, as a class brainstorm on the term marketing 2] whole class discussion on the different methods of marketing 3] small group discussion on why marketing is important 4] small groups activities on chart of distribution channels of marketing
Communication and collaboration -critical thinking and problem solving Leadership and personal development -creativity and imagination
10
Marketing continued Product branding Product packaging Costing Pricing
By the end of the lesson, students should be able to: Highly the factors to be considered in product price tag. Distinguish between the term packaging & branding Develop a feasibility study for setting up a profitable business or a product unit Creativity design a befitting package for their products
1] whole class discussion on the factors to be considered before fixing a product price 2] students in pairs discuss the difference between packaging & branding 3]students in small groups, present a feasibility study of a said production or business setup (group project) 4] students, in the same groups, produce or come up with befitting packages for their products
Communication and collaboration -critical thinking and problem solving Leadership and personal development -creativity and imagination
Branded products Package products Pictures Charts
11
Presentation package -Microsoft power point -Creating -Saving and retrieving presentation file
By the end of the lesson, students should be able to: 1] use Microsoft Power point 2] identify features of presentation packages 3]create and save a presentation 4] retrieve and show a presentation
Demonstration and practice students under the tutelage of the teacher, practice on how to load MS-Power Point and identify the features of MS-Power Point and as well follow teacher’s demonstration steps on creating presentation Investigative Students are given access to use the internet to make researches by access this link
Digital literacy Creativity and imagination
Audio visual: Charts, printer materials etc Videos, multimedia projector Computer system Computer with presentation package (MS-Power point) installed Web Resources Video site
13
Revision/ Examination
14
Examination
Achievement Standard Data ProcessingSS2
At the end of the session students will be able to:
Create, save, retrieve and exit in MS-access
Differentiate between types data model
Differentiate between tables, forms, queries and …….. reports in data modeling
Explain the determinants of normal forms and describe the functions of normal keys
Explain the terms ‘entities, attributes and relationship
Explain the term relations: models, describe data can be represent in relational model tables and insert data in appropriate fields
Modify relations using database application package
Create forms, generate queries and prepare reports using MS-Access
Identify and discuss different type of file organization using real life experiences
Load, identify features and apply, Microsoft power point application to create a presentation
