From Script | Spoken-Tutorial
Jump to: navigation, search

Spreadsheet basics Welcome to this tutorial in Orca with Open office suite. In this tutorial we are going to touch upon an interesting application called spreadsheet. So, start the screen reader with alt + f2 and entering Orca. Lets now locate the office submenu in the applications menu. Press alt + f1 to open the applications menu. Use the down arrow to go to the the office sub menu. Now open the menu using right arrow and locate the spreadsheet using the up arrow. Hit enter to open the application. As you heard, orca announced an application called calc is opened, and the file name is untitled by default and that there is a sheet called sheet 1. Well, Calc is the official name for Open Office Spreadsheet. So, let's see what we can do with it. A spreadsheet is a set of rows and columns. A row is denoted by numbers such as 1, 2, 3, etc. And columns are denoted by alphabets such as a, b, c, etc. While columns are vertical, rows are horisontal. A cell is an intersection of row and column. So a cell by the name a1 is an intersection of first row and first column. Let's move around with the right arrow 3 times. As I explained before, columns are vertical. So, when we move the right arrow, we are actually moving from one column to another, keeping the row constant. That's why we hear b1, c1, d1, etc. Now similarly, press the down arrow once. Now Orca says d2. This means that we have moved down to the second row from the first one, keeping the column constant. A spreadsheet is used to manage tabular data. Let's take a simple example. We will make a marksheet for a group of students. The sheet will contain marks for 3 subjects, namely computer science, english and history. So essentially we will have 4 column table. The first column will be name, second column computers, third column english and forth column history. Let us move up to the first row. Press the up arrow to hear Orca announce d1. Now keep pressing left arrow till you locate a1. Enter name. Press right arrow to move to the second column. Type computers Again press the right arrow for the third column and type english. In the forth column we will type history. Now, press the down arrow and come to the next row. Since the column d has not changed, you hear the cell d2. But we want to go to the first column for filling the name. So, press the left arrow 3 times. Also note that the row is 2, thus the cell we want to locate is a2. Now, type a name. I will type Suresh. Press the right arrow and enter the marks 50 for computers. Move to to the right to third column and enter the marks 50 for english as well. Now, to the forth column for history. Type 75. Let's repeat the process for another student. This time, our starting point is a3. Because we are in the third row and the column a. Enter the name jon and then move to the next column by right arrow. Since we are in the b3 cell we are in the column for computers. Now enter 80 for computers and press right arrow. Enter 55 for english, as this is the column for marks on this subject. As we had put history in d1, we will move using right arrow to d3 and put 40. Well, this is good enough sample. Now we will press ctrl + s and then press the backspace to delete the default filename. Enter a nave of your choise. I will enter marklist. The default format for spreadsheet in Open Office is ods. So, we have learned the concept of spreadsheet and how we manage tabulated data. So that's it for this tutorial! This is Supriya and Duhita saying good by.

Contributors and Content Editors