Re: [AI] Using MS Excel for taking attendance of students
I have found out the shortcut key for it. It is alt+ctrl+insert+c. Cursor must be on the title column. Alternately, you can use alt+ctrl+insert+r for setting the title row. With best regards, Amiyo Biswas Cell: 9433464329 - Original Message - From: "Amiyo Biswas" <am...@bpa.org.in> To: "AccessIndia: a list for discussing accessibility and issues concerning the disabled." <accessindia@accessindia.org.in> Sent: Friday, October 21, 2016 9:07 AM Subject: Re: [AI] Using MS Excel for taking attendance of students Use the verbosity dialogue box to set column a for title reading. This is a bit tricky, but it works fine. Make sure your cursor is in column a if it is the column you want announced. Press insert+v for verbosity dialogue box. In the opening search field type title and wait for the results. Now all options containing the word title will come up. Arrow down to Define Name Column and Row Titles Override and press spacebar on it to select. Jaws should say for all files. Now arrow down to the option Row Titles to Column Range. It should say column a. If it down't, use spacebar to define it. Tab over to ok button and activate it. Now test your action. If it does not work, try it again checking each step. With best regards, Amiyo Biswas Cell: 9433464329 - Original Message - From: "Mohib Anwar Rafay" <mohibra...@gmail.com> To: "accessindia" <accessindia@accessindia.org.in> Sent: Thursday, October 20, 2016 6:22 PM Subject: [AI] Using MS Excel for taking attendance of students I want to take attendance of the students directly in the excel sheet provided by the office on which the rol numbers and the names of the students are written. So please guide me how to mark attendance on different dates? As I will be calling students Rol number vise, so how is that possible that I am in a particular date column, listening the roll number . Let me tell you the structure of the sheet: at the extreme left column, mean A1 to A50 there are rol numbers of the students, in column B, from B1 to B50 there are names of the students. other collums like C, D, E represent the dates of lectures. now I want, that my cursor should be in the column of date, while jaws would announce me the roll number so that quickly I could put the attendance. Using Excel 2003 with jaws 17. -- Mohib Anwar Rafay Phone: +919 555 555 765 Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] Using MS Excel for taking attendance of students
Use the verbosity dialogue box to set column a for title reading. This is a bit tricky, but it works fine. Make sure your cursor is in column a if it is the column you want announced. Press insert+v for verbosity dialogue box. In the opening search field type title and wait for the results. Now all options containing the word title will come up. Arrow down to Define Name Column and Row Titles Override and press spacebar on it to select. Jaws should say for all files. Now arrow down to the option Row Titles to Column Range. It should say column a. If it down't, use spacebar to define it. Tab over to ok button and activate it. Now test your action. If it does not work, try it again checking each step. With best regards, Amiyo Biswas Cell: 9433464329 - Original Message - From: "Mohib Anwar Rafay"To: "accessindia" Sent: Thursday, October 20, 2016 6:22 PM Subject: [AI] Using MS Excel for taking attendance of students I want to take attendance of the students directly in the excel sheet provided by the office on which the rol numbers and the names of the students are written. So please guide me how to mark attendance on different dates? As I will be calling students Rol number vise, so how is that possible that I am in a particular date column, listening the roll number . Let me tell you the structure of the sheet: at the extreme left column, mean A1 to A50 there are rol numbers of the students, in column B, from B1 to B50 there are names of the students. other collums like C, D, E represent the dates of lectures. now I want, that my cursor should be in the column of date, while jaws would announce me the roll number so that quickly I could put the attendance. Using Excel 2003 with jaws 17. -- Mohib Anwar Rafay Phone: +919 555 555 765 Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] Using MS Excel for taking attendance of students
Just put the cursur at the roll number column. Choose the date of which the attendance has to be marked. As you take the roll call, keep on changing rows by down arrow. The roll numbers will change but the date shall remain the same. Vedprakash Sharma http://www.musicalexpressions.myehome.in/ -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mohib Anwar Rafay Sent: Thursday, October 20, 2016 6:23 PM To: accessindiaSubject: [AI] Using MS Excel for taking attendance of students I want to take attendance of the students directly in the excel sheet provided by the office on which the rol numbers and the names of the students are written. So please guide me how to mark attendance on different dates? As I will be calling students Rol number vise, so how is that possible that I am in a particular date column, listening the roll number . Let me tell you the structure of the sheet: at the extreme left column, mean A1 to A50 there are rol numbers of the students, in column B, from B1 to B50 there are names of the students. other collums like C, D, E represent the dates of lectures. now I want, that my cursor should be in the column of date, while jaws would announce me the roll number so that quickly I could put the attendance. Using Excel 2003 with jaws 17. -- Mohib Anwar Rafay Phone: +919 555 555 765 Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..