Advertisement

Saturday 17 October 2020

FBISE HSSC COMPUTER SCIENCE REDUCED SYLLABUS ONLINE, CLASS 11-fusion stories

 

FBISE HSSC REDUCED SYLLABUS

COMPUTER SCIENCE-XI

1. OVERVIEW OF COMPUTER SYSTEM

 1.1 Introduction to Computer

 1.2 Computer Software

2. COMPUTER MEMORY

 2.1 Introduction

 2.2 Main Memory

3. CENTRAL PROCESSING UNIT

 3.1 Inside CPU

 3.2 CPU Operations

5. NETWORK COMMUNICATION AND PROTOCOLS

 5.1 Introduction

 5.2 Data Communication standards

 5.3 TCP/IP

6. WIRELESS COMMUNICATIONS

 6.1 Introduction

7. DATABASE FUNDAMENTALS

 7.1 Introduction

 7.2 Basic Database Terminologies

 7.3 Planning a Database

 7.4 Data Modeling and Entity Relationship Diagram

 7.5 Relational Schema

8. DATABASE DEVELOPMENT

 8.1 Introduction

(i) Identify various relational database management systems (MS Access,

Open Office Base, SQL Server)

(ii) Select any suitable DBMS as an application for creating and maintaining

databases

(iii) Explain the steps involved to create and save a database (For Practical

only)

(iv) Explain the following in Database Environment:

o Database Toolbar

o Database Window

o Objects

 Tables

 Queries

 Forms

 Reports

30

 8.2 Working with Tables

(i) Explain different ways of creating, saving and editing a table in database.

(For Practical only)

(ii) Identify various available data types

(iii) Create a primary key and foreign key in the tables. (For Practical only)

(iv) Create and edit relationship among tables. (For Practical only)

(v) Use navigation buttons to navigate through records in a table. (For

Practical only)

(vi) Add, modify and delete records from a table. (For Practical only)

 8.3 Working with Forms

(i) Explain different ways of crating, saving and editing a form in a database.

(For Practical only)

(ii) Know different Form views

(iii) Use the navigation buttons to navigate through records displayed in a

Form. (For Practical only)

(iv) Add, modify and delete records. (For Practical only)

(v) Use Form controls. (For Practical only)

 8.4 Working with queries and commands

(i) Explain different ways of creating, saving and editing a query in a

database. (For Practical only)

(ii) Use following queries on database

o SELECT (Where, Group by, Order by)

o UPDATE

o DELETE

o INSERT

o ALTER

 8.5 Generating Reports

 (i) use the report wizard to generate a report. (For Practical only)

(ii) se various report layouts/styles to produce reports

(iii) Set the sort order of records that will appear on the report

(iv) Customized reports using  queries (macros and arithmetic expressions)

(For Practical only)

(v) Save, view and print the report. (For Practical only)

Advertisement