Page 7 - Viva ICSE Computer Studies 7 : E-book

Suggested Learning Resources Computers/IWB with spreadsheet software Questionnaires/ surveys/polls Discussion on advantages of spreadsheet and workbook IWB with database software Telephone directory Student registration record. Computers/IWB with HTML editor Internet facility

• • • • • • erent • •

Suggested Transactional Processes Demonstrating to children the different components of a spreadsheet along with discussion Demonstrating the use of spreadsheets using real life examples: children can be individually/in groups asked to collect data of a group of people on two- three criteria (e.g., age, height, weight, etc.), enter the data on a spreadsheet and perform various functions on them Using formatting features by children created on the Discussion on advantages of spreadsheet and workbook Providing each

• • • spreadsheets • •  Selecting cells  Using AutoFill feature • • a database • • • • friendly • •

Learning Outcomes Defi ne a spreadsheet. List the features and components of a Create a worksheet. Identify the components of Spreadsheet Differentiate between a workbook and a Edit/Format a worksheet. Defi ne database and DBMS. List real life examples of databases. Design a database. Describe different data types. Defi ne a primary key. Create a table, insert data, save and edit Build query statements. Add advanced features to a web page like lists, images, links, tables and forms.

• • spreadsheet. • • window. • worksheet. • • • • • • • a table. •

Features of spreadsheet and its advantages bar, row, column, Name Box Entering data in a spreadsheet Types of data (number, string and formula) Performing calculations Entering simple formulae Changing content of cells Using Undo and Redo features Insert and deleting columns and rows Copying and moving data Using AutoFill feature Meaning of database and DBMS Uses of database with examples Creating and saving a database Querying a database Creating lists (<OL>, <UL>) Inserting images in web pages <img src> Displ

Key Concepts Components of Spreadsheet window: workbook and worksheet, Sheet tab, cell, cell address, active cell, formula Inserting links <a href>, tables <tr>, <td>, <table>

• • • • • • Selecting cells • • • • • • • • • Primary key • • • • • • •
5. Spreadsheets— 6. Database and 7. HTML— Advanced Features
Theme An Introduction DBMS—An Introduction