Ch 9 CS Class 11
Important Easy Notes of Computer Science of Spreadsheet Ch 9 CS Class 11 written by Professor Mr. Syed Werasat Hussain Hashmi Suib. These notes are very helpful in the preparation of Computer Science for students of the 11th class and these are according to the paper patterns of all Sindh Book Boards.
Summary and Contents:
Topics which are discussed in the notes are given below:
- Describe and Explain Spreadsheets with Working and Spreadsheets
- How a spreadsheet is organized – column headings, row headings, and labels
- Where columns and rows meet – cells, cell addresses, ranges, and values
- Why the spreadsheet has become so popular – formulas, functions recalculation, and what-if
analysis.
- Define Functions and Recalculation
- What-if Analysis: What if-analysis allows the user to see how changing one or more numbers changes the outcome
of the recalculation.
- Using worksheet templates – pre-arranged forms for specific task
- Describe and Explain Analytical Graphic: Creating Charts
- Describe and Explain Database Software
- Describe and Explain The Benefits of Database Software
- Today the principal microcomputer database programs are:
Microsoft Access
Corel Paradox
Lotus Approach
Oracle (For large Systems)
- Features of Databases: Let's consider some basic features of databases.
- How a relational database is organized – tables, records, and fields
- How various records can be linked – the key field
- Finding what you want – querying and displaying records
- Sorting and analyzing records and applying formulas
- Putting search results to use – saving, formatting, printing, copying or
transmitting.
- Personal Information Manager PIM.