Changes

|3

|3

|Using Spreadsheet for different task

|Using Spreadsheet for different task

|1. Introduction to spreadsheet, navigating and interfaces. Cells (data element), rows (records), columns, types of data (text, numbers and its format, date and its format).

|1. Introduction to spreadsheets, navigating and interfaces. Cells (data element), rows (records), columns, adding and deleting sheets, file saving.

2. Entering your data in spreadsheet.

2. Entering your data in a spreadsheet.

3. Providing headings (columns), formatting rows and columns, working with alignment and text wrap.

3. Providing headings (columns), formatting rows and columns(Text styles, colours, cell background, and border etc,), types of data (text, numbers and their format, date and its format), working with alignment and text wrap.

4. Sorting, filtering your entered data,

4. Adding line breaks, Merging cells, auto fill(1,2,3,....), duplicating data

5. Using basic operations with formulas 6. Creating visual representation of data

5. Sorting, filtering your entered data,

 

6. Using basic formulas - sum, count, average, percentage

 

7. Creating a visual representation of data

 

|Sample data and files

|Sample data and files

|11 am to 1.30 pm

|11 am to 1.30 pm