Senior Secondary Technology Curriculum. Federal Data Processing Scheme of Work for SS 1. Working with table –Schemeofwork
DATA PROCESSING SSI FIRST TERM
| WEEK | TOPIC / CONTENT | ACTIVITIES |
| 1 | History of computing Concrete devices | Mention concrete device used in computing e.g tally stick, coins, rope etcIdentify concrete devices used in computing |
| 2 | History of computing Numbering system Conversion from one number system to another | Explain number systems (binary, octal, decimal and hexadecimal number systems)Change from one number system to another |
| 3 | Digitalization of data Definition History of computer development | Definition of digitalizationExplain process of digitalization (how data is changed to machine code)Explain history of computer development e.g. Abacus, Pascal, Babbage, Hotterith and Eniac. |
| 4 | Digitalization of data Types of computers Components of computers | List and explain types of computers e.g. mainframe, laptops etcName and explain computer componentsInput devices e.g. keyboardProcessing device e.g. CPUOutput device e.g. Visual Display Unit (VDU)Identify components of a computer |
| 5 | Data and information Data Data types Information | Definition of dataState types of data e.g. strings, numbers etcDefinition of information |
| 6 | History of computer Generations of computer Characteristics features of each generation | Mention the generation of computerDescribe each generation of computer in terms of year of development, the technology speed of operation storage capacity etc. Identify the generation of computer and match each with its characteristics features |
| 7 | Classification of computers By type By size By functionality | List classification of computer by size e.g. supercomputerBy type e.g. digitalBy function e.g. general purpose computer |
| 8 | ICT Application in everyday life Uses of ICT ICT and the society | Explain the uses of ICTExplain and leads discussion on the importance of ICT in the society |
| 9 | The art of information processing Information processing procedures | Definition of information processing State the procedures for information processing Collation of informationOrganization of informationAnalysis of informationInterpretation of information |
| 10 | Process of information transmission Method of transmission information Method of transmitting information | Definition of information transmissionList and explain method of transmitting information e.g. newspaper, radio, telephone, television etc |
| 11 | Medium of information transmission Types of medium for transmission and receiving information Classify information by means of transmission and mode of receiving | Name types of medium of information transmission Wireless e.g. Bluetooth, infraredSatellite e.g. internetCable e.g. cable TVsRadio waves e.g. Radio station |
| 12 | Medium of information Transmission Classification of means of Tran | Classify means of transmitting information ElectronicNon – electronic |
| 13 | Revision | Revision |
| 14 | Examination | Examination |
Federal Data Processing Scheme of Work for SS 1. Working with table –Schemeofwork
DATA PROCESSING SS I SECOND TERM
| WEEK | TOPIC / CONTENT | ACTIVITIES |
| 1 | Operation system Types of operating system | Definition of operating systemStates types of operating system |
| 2 | Operating system Examples of operating system Function of operating system | Gives example of operating systemOutlines the function of an operating systemListen to teacher explanation |
| 3 | Word processing Uses of word processing software Example of word processing software | Define word processingState the uses of word processing softwareList the examples of word processor (micro soft word) |
| 4 | Exploring the word window Load and exit Ms word Component of the word window Create and save new document | Start Microsoft wordName the componentsCreate a new document and save it. Instructional Resources Computer set, ms office software |
| 5 | Editing a document Open an existing document Correct errors | Open an existing documentCorrect typing errors using arrow, delete and backspace keysCorrecting document using copy, cut and paste facilities |
| 6 | Formatting texts Modify text font and size Align text Indent paragraph Insert headers and footers | Modifying text font and sizeAligning text in documentIndenting paragraph and modifying line spacingInserting headers and footers Instructional resources Computer system, projector with screen, ms office software. |
| 7 | Working with table Tables and its functions Create tables Format tables | Define tables and states its functionsCreate table using insert and draw methodFormatting tables Instructional resources Computer system, projector with screen, Ms Office Software |
| 8 | Working with graphics Using insert tab Working with shapes and Smart Art | Inserting pictures, clip art, Word Art and charts using the insert tabInserting shapes and working with Smart Art graphic Instructional resources Computer system, projector with screen, Ms Office Software |
| 9 | Spreadsheet Uses of Spreadsheet Examples of Spreadsheet | Definition of spreadsheetStates the uses of spreadsheetGive the examples of spreadsheet package Instructional resources Computer set, interactive training CD |
| 10 | Spreadsheet Component of spreadsheet | Load ms – excel softwareShow them the components of Ms Excel (worksheet, workbook, cell, cell range name box, formula bar etc) Instructional Resources Ms excel software, computer set |
| 11 | Revision | Revision |
| 12 | Examination | Examination |
Federal Data Processing Scheme of Work for SS 1. Working with table –Schemeofwork
DATA PROCESSING SS I THIRD TERM
| WEEK | TOPIC / CONTENT | ACTIVITIES |
| 1 | Inserting formulas and using functions Writing simple formula Writing complex formula | Write simple formulas of addition, subtraction, multiplication and divisionUse auto sum, average, product and quotient functionsTotal rows and columns Instructional resources Computer set, ms excel software |
| 2 | Formatting the worksheet Align cells Selecting columns, rows and entire worksheet Inserting and deleting rows and columns Adjust column width and row height Changing vertical alignment and rotating cell content | Type in a range of cells and align the contentSelect column, rows and entire worksheetInsert and delete rows and columnsAdjust columns width and rows heightChange vertical alignment and rotate all content Instructional Resources Computer set, ms excel software |
| 3 | Formatting the worksheet Transferring data Merging cell Inserting and removing borders and gridlines | Transfer data from one worksheet to another workbookMerge cellsInsert and removed borders and gridlines Instructional resources Computer set, ms excel software |
| 4 | Managing data in spreadsheet Creating references Using built in function | Create cell references (BIO, C2 : H2)Use built in functions common to financial and statistical applications. Sum, average, product, cumulative frequency etc.Guide the students to Sort data in ascending or descending orderFilter data using auto filter and custom filter |
| 5 | Managing data in spread sheet Sorting data Filtering data | Sort data in ascending or descending order Filter data using auto filter and custom filter |
| 6 | Creating charts ion spreadsheet Creating different types of charts | Create different types of chart, pie, line, column and bar chart Guide students to create their own chart |
| 7 | Introduction to Database Management System (DBMS) Uses applications of Database Components of DBMS Examples of DBMS | Define database, and database management systemState uses or application areas of databaseList and explain components of DBMSSoftwareHardwareDataProcedureAccess languageUsersGive examples of Database Management System oracle, access, SQL server etc Instructional resources Computer set, interactive training CD |
| 8 | Database working environment Load access Data types Samples of DBMS in local template | Open Ms access and navigate the environment to show different componentsName and explain all the data types: text, memo etc. open north wind in local template practice loading and exiting Ms access Instructional resources Computer set, ms access software |
| 9 | Database objects TableFormsReportQueryMacroCreating table in design view | Define all the access object and show them samples from the systemCreate access table in design view inserting fields and declaring their data typesStudents should practice creating table Instructional Materials Computer set, Ms access software |
| 10 | Computer ethics Computer room management ethics Laboratory rules and regulations | Explain computer room management ethics.List and explain laboratory rules and regulations Instructional Materials Charts of an ideal computer room / laboratory |
| 11 | Safety measures Sitting arrangementPositioning of monitor baseIlluminating the computer roomMaintaining adjust free environmentKeep liquid away from the computers | State adequate sitting arrangement in a computer roomDemonstrate how to position the monitor baseExplain the necessity of illuminating the computer room and keeping liquid away from the computersExplain how to maintain dust free environment Instructional resources Charts, pictures |
| 12 | Revision | Revision |
| 13 | Examination | Examination |
