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)