User:Purnendu/NIOS ICT SAD.doc
|
|
|
/subsystems/definition/procedure /structure etc |
|
/competencies/capacities/capabilities /values to be developed |
OERs
(Type and Name) |
|
|
|
|
|
System Life Cycle | Concept:
What is a System? System Life Cycle.
System Study System Analysis System Design System Development System Maintenance Process:
|
Draw System Flow Chart | Knowledge:
|
|
|
|
/subsystems/definition/procedure /structure etc |
|
/competencies/capacities/capabilities /values to be developed |
OERs
(Type and Name) |
|
|
||
|
|
System Flowchart | Concept:
What is a Flow chart? What are Flowchart Symbols? What is System Flowcharts? What is Run Flowchart? What is program Flowchart?
Start & Stop Box Output Box Decision Box Process Box Connector Flow of Data
|
Draw Flow chart based on some activities | Objective: Understand Flowchart and how it is used to represent data flow in the system graphically
|
|
|||
Data Flow Diagram (DFD) | Concept:
What is a DFD? What are the components of DFDs? What are Physical and Logical DFDs? What is the difference between Flowchart & DFD?
External entities Data Stores Data Processes Data Flows
|
Draw DFD (Physical & Logical) based on some activities | |
||||||
Decision Tables & Trees | Concept:
What is Decision Table? What is Decision Tree? What are the differences between Decision Trees & Table?
Condition Stub Action Stub Condition Entry Action Entry
|
Draw Decision Tree & Table based on some activity. | Knowledge/Skills/Application | |
|
|
/subsystems/definition/procedure /structure etc |
|
/competencies/capacities/capabilities /values to be developed |
OERs
(Type and Name) |
|
|
||
|
|
Understanding database | Concept:
What is data? What is Database? What are the components of a database?
Field Record Tables Database
School Attendance Register Telephone Directory
Capture of Data field Creation of data table Filling of data record Arrange logically similar data tables in to a database
|
Create structure of table.
Identify data field Identify a data record Create a Data table Create a database structure with number of a tables |
Objective: To be able to understand and use data field, data record, data tables and database
Knowledge:
|
|
|
|
/subsystems/definition/procedure /structure etc |
|
/competencies/capacities/capabilities /values to be developed |
OERs
(Type and Name) |
|
|
||
|
|
Data Types
|
Concept:
Field types and naming Fields
Field Type Text/Number/Date/Time/auto Number/Memo/OLE Object Field Size Rules for Field naming
Create Tables Naming and types of Field
|
Draw System Flow Chart | Knowledge: Understanding of Tables
Applications: Creation of a table.
|
|
|||
Creating Date Table
|
Processes:
Create Data Table using any of the database software |
Load database
Create data table in design view/wizard Specify field name, type and properties
|
Application of data table creation | |
|||||