OER-PUNE/OER-ICT Applications

From WikiEducator
Jump to: navigation, search
NIOS
Content Analysis
Programme Name: IT Applications
Course Name: Computer Applications
Unit Number: 1 Unit Name: System Analysis and Design
Sub Unit Number: 1.1 Sub Unit Name: Introduction of System analysis and Design


Sr.No.
Topic
Sub topic
Concept/terms/processes/approaches/system
/subsystems/definition/procedure
/structure etc
Learning activities
Objectives/Knowledge/application/skills
/competencies/capacities/capabilities
/values to be developed
OERs

(Type and Name)

Concept Map of the OER
Facilitators role
1
System Introduction
System Life Cycle Concept:

What is a System?

System Life Cycle.


Terms:

System Study

System Analysis

System Design

System Development

System Maintenance

Process:


Draw System Flow Chart Knowledge:


Text/Animation/Video/PPTs
Sub Unit Number: 1.2 Sub Unit Name: System Description Techniques


Sr.No.
Topic
Sub topic
Concept/terms/processes/approaches/system
/subsystems/definition/procedure
/structure etc
Learning activities
Objectives/Knowledge/application/skills
/competencies/capacities/capabilities
/values to be developed
OERs

(Type and Name)

Concept Map of the OER
Facilitators role
1
System Techniques
System Flowchart Concept:

What is a Flow chart?

What are Flowchart Symbols?

What is System Flowcharts?

What is Run Flowchart?

What is program Flowchart?


Terms: Flow chart Symbols

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


Knowledge:


Application: Develop Flowchart


Skills:


Competencies:


Text/Animation/Video/PPTs
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?


Terms:

External entities

Data Stores

Data Processes

Data Flows


Draw DFD (Physical & Logical) based on some activities
Text/Animation/Video/PPTs
Decision Tables & Trees Concept:

What is Decision Table?

What is Decision Tree?

What are the differences between Decision Trees & Table?


Terms:

Condition Stub

Action Stub

Condition Entry

Action Entry


Draw Decision Tree & Table based on some activity. Knowledge/Skills/Application
Text/Animation/Video/PPTs
NIOS
Content Analysis
Programme Name: IT Applications
Course Name: Computer Applications
Unit Number: 2 Unit Name: Basics of database
Sub Unit Number: 2.1 Sub Unit Name: Concept of Database


Sr.No.
Topic
Sub topic
Concept/terms/processes/approaches/system
/subsystems/definition/procedure
/structure etc
Learning activities
Objectives/Knowledge/application/skills
/competencies/capacities/capabilities
/values to be developed
OERs

(Type and Name)

Concept Map of the OER
Facilitators role
1
Concept of Database
Understanding database Concept:

What is data?

What is Database?

What are the components of a database?


Terms:

Field

Record

Tables

Database


Context:

School Attendance Register

Telephone Directory


Processes:

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:


Application:


Skills:


Text/Animation/Video/PPTs
Sub Unit Number: 2.2 Sub Unit Name: Working with Data Tables


Sr.No.
Topic
Sub topic
Concept/terms/processes/approaches/system
/subsystems/definition/procedure
/structure etc
Learning activities
Objectives/Knowledge/application/skills
/competencies/capacities/capabilities
/values to be developed
OERs

(Type and Name)

Concept Map of the OER
Facilitators role
1
Creating Data Tables
Data Types


Concept:

Field types and naming Fields


Terms:

Field Type

Text/Number/Date/Time/auto Number/Memo/OLE Object

Field Size

Rules for Field naming


Process:

Create Tables

Naming and types of Field


Draw System Flow Chart Knowledge: Understanding of Tables

Applications:

Creation of a table.


Text/Animation/Video/PPTs
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
Text/PPTs/Animation/PPTs.