Re: PPIG discuss: Identifying Goals in Spreadsheets
On 19 Sep 2007, at 17:58, Bennett Kankuzi wrote: I am working on some research topic in spreadsheets. One of the basic questions in this research is on the idea of goals in spreadsheets. Since a spreadsheet is a program, it has to have high-level goals . Hello Bennet Good for you. You will be pleased to know that there is previous relevant research. Besides the work of Margaret Burnett's team at OSU that Alan Blackwell mentioned, may I draw your attention to work in Finland by Jorma Sajaniemi and his colleagues, especially Markku Tukiainen: Sajaniemi, J. (1989). Goals and Plans as a Basis for User Interfaces in Spreadsheet Calculation. West of East (eds. K. Pulliainen & H. Sihvo), The University of Joensuu, 129-140. Sajaniemi, J., Tukiainen, M. (1996). Goals and Plans in Spreadsheets and Other Programming Tools (Extended Abstract). PPIG 8, Proceedings of the 8th Annual Workshop of the Psychology of Programming Interest Group, (eds. P. Vanneste, K. Bertels, B. De Decker, J-M. Jaques), KaHo Sint Lieven, Belgium, 114-122. Tukiainen, M., Sajaniemi, J. (1996). Spreadsheet Goal and Plan Catalog: Additive and Multiplicative Computational Goals and Plans in Spreadsheet Calculation. University of Joensuu, Department of Computer Science, Technical Report, Series A, Report A-1996-4. The PPIG presentations can be downloaded from the PPIG website, and I am sure that Professor Sajaniemi would be delighted to send full versions of all relevant papers. His email address is [EMAIL PROTECTED] . Best wishes and good luck - I hope you'll make sure to give a PPIG paper on your findings in due course - Thomas Green Visiting Professor University of Leeds -- PPIG Discuss List ([email protected]) Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss Announce admin: http://limitlessmail.net/mailman/listinfo/announce PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/
Re: PPIG discuss: Identifying Goals in Spreadsheets
Dear Sir, Many thanks for your reply and guidance. Currently I already have two of your papers: "Goals and Plans in Spreadsheet Calculation" and "Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization" . I would therefore appreciate very much if you may send me the other two papers:"Goals and Plans in Spreadsheets and Other Programming Tools (Extended Abstract)" and "Spreadsheet Goal and Plan Catalog: Additive and Multiplicative Computational Goals and Plans in Spreadsheet Calculation" Once again, many thanks for your help. And I would also like to thank all who have provided me with their valuable assistance on this PPIG forum. Kind Regards, Bennett > On Wed, Sep 19, 2007 at 06:58:03PM +0200, Bennett Kankuzi wrote: > > > ... do you know of any research papers on goals > > and plans in spreadsheets that could help answer my question? > > The following papers might be of use to you: > > Sajaniemi, J., Tukiainen, M. (1996). Goals and Plans in > Spreadsheets and Other Programming Tools (Extended Abstract). > PPIG 8, Proceedings of the 8th Annual Workshop of the Psychology > of Programming Interest Group, (eds. P. Vanneste, K. Bertels, B. > De Decker, J-M. Jaques), KaHo Sint Lieven, Belgium, 114-122. > > Tukiainen, M., Sajaniemi, J. (1996). Spreadsheet Goal and Plan > Catalog: Additive and Multiplicative Computational Goals and > Plans in Spreadsheet Calculation. University of Joensuu, > Department of Computer Science, Technical Report, Series A, > Report A-1996-4. > > Sajaniemi, J., Tukiainen, M., Väisänen, J. (1999). Goals and > Plans in Spreadsheet Calculation. University of Joensuu, > Department of Computer Science, Technical Report, Series A, > Report A-1999-1. > > Sajaniemi J. (2000) Modeling Spreadsheet Audit: A Rigorous > Approach to Automatic Visualization. Journal of Visual Languages > and Computing 11(1), 49-82. > > I can send you copies of the papers if you wish. > > Saja > > -- > > Jorma Sajaniemi > Professor > > University of Joensuu E-mail: [EMAIL PROTECTED] > Computer SciencePhone: + 358 13 2517933 > P.O.Box 111 Fax: + 358 13 2517955 > FI-80101 Joensuu, Finland http://cs.joensuu.fi/~saja/ > -- Photo Collection: http://www.flickr.com/photos/[EMAIL PROTECTED]/page2/ Google Talk: bfkankuzi VoipCheap: bkankuzi Skype: bfkankuzi Mobile: +267 72 938 886 Blog: http://bkankuzi.blogspot.com
Re: PPIG discuss: Identifying Goals in Spreadsheets
On Wed, Sep 19, 2007 at 06:58:03PM +0200, Bennett Kankuzi wrote: > ... do you know of any research papers on goals > and plans in spreadsheets that could help answer my question? The following papers might be of use to you: Sajaniemi, J., Tukiainen, M. (1996). Goals and Plans in Spreadsheets and Other Programming Tools (Extended Abstract). PPIG 8, Proceedings of the 8th Annual Workshop of the Psychology of Programming Interest Group, (eds. P. Vanneste, K. Bertels, B. De Decker, J-M. Jaques), KaHo Sint Lieven, Belgium, 114-122. Tukiainen, M., Sajaniemi, J. (1996). Spreadsheet Goal and Plan Catalog: Additive and Multiplicative Computational Goals and Plans in Spreadsheet Calculation. University of Joensuu, Department of Computer Science, Technical Report, Series A, Report A-1996-4. Sajaniemi, J., Tukiainen, M., Väisänen, J. (1999). Goals and Plans in Spreadsheet Calculation. University of Joensuu, Department of Computer Science, Technical Report, Series A, Report A-1999-1. Sajaniemi J. (2000) Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization. Journal of Visual Languages and Computing 11(1), 49-82. I can send you copies of the papers if you wish. Saja -- Jorma Sajaniemi Professor University of Joensuu E-mail: [EMAIL PROTECTED] Computer SciencePhone: + 358 13 2517933 P.O.Box 111 Fax: + 358 13 2517955 FI-80101 Joensuu, Finland http://cs.joensuu.fi/~saja/ -- PPIG Discuss List ([email protected]) Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss Announce admin: http://limitlessmail.net/mailman/listinfo/announce PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/
Re: PPIG discuss: Identifying Goals in Spreadsheets
Dear Sir, Many thanks for your reply and useful information. I will try to get in touch them. In fact I have also referenced several of their papers in my work. By the way, I received your email while I was reading a printed copy of your paper entitled "What is Programming". What a coincidence! Once again, many thanks for your guidance. Kind Regards, Bennett On 19/09/2007, Alan Blackwell <[EMAIL PROTECTED]> wrote: > > Dear Bennett, > > This is an interesting area of work, and I encourage you in your > research. > > You will certainly find the work of Martin Erwig, Robin Abraham, > and Margaret Burnett, along with other colleagues of theirs at > Oregon State University, relevant to your ideas. I would hope > that some of them read this list and will respond, otherwise I > recommend that you get in touch with them directly. > > Alan > > > Dear All, > > > > I am Bennett Kankuzi, an MSc in Computer Science student at the > > University of Botswana. I am new to this list. > > > > I am working on some research topic in spreadsheets. One of the basic > > questions in this research is on the idea of goals in spreadsheets. > > Since a spreadsheet is a program, it has to have high-level goals > > which are implemented by plans as in procedural programming. Another > > question that comes to mind is: how can one identify high-level goals > > in a created spreadsheet? In attempting to answer this question, I am > > proposing that sink cells (output cells) are representing high-level > > goals of the spreadsheet program. (A sink cell can be defined as a > > formula cell without any dependent cells yet it has precedent cells. > > An input cell will only have dependent cells. Computational cells have > > precedent and dependent cells since they are intermediary > > computations) > > > > Why can sink cells represent goals ? Goals are what the user wants to > > achieve. In other words, these are the primary results the user wants > > to see. Output cells or sink cells contain these results otherwise > > they could be used as part another formula (intermediary computation) > > and therefore they could have dependent cells. > > > > Is my proposal alright? Or do you know of any research papers on goals > > and plans in spreadsheets that could help answer my question? > > > > Many thanks in advance for your time. > > > > Regards, > > > > Bennett > > -- > > Blog: http://bkankuzi.blogspot.com > > Photo Collection: http://www.flickr.com/photos/[EMAIL PROTECTED]/page2/ > > Google Talk: bfkankuzi > > VoipCheap: bkankuzi > > Skype: bfkankuzi > > Mobile: +267 72 938 886 > > > > -- > > PPIG Discuss List ([email protected]) > > Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss > > Announce admin: http://limitlessmail.net/mailman/listinfo/announce > > PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/ > > > > -- > Alan Blackwell Computer Laboratory, University of Cambridge > http://www.cl.cam.ac.uk/users/afb21/ Phone: +44 (0) 1223 334418 > > > -- Photo Collection: http://www.flickr.com/photos/[EMAIL PROTECTED]/page2/ Google Talk: bfkankuzi VoipCheap: bkankuzi Skype: bfkankuzi Mobile: +267 72 938 886 Blog: http://bkankuzi.blogspot.com
Re: PPIG discuss: Identifying Goals in Spreadsheets
Dear Bennett, This is an interesting area of work, and I encourage you in your research. You will certainly find the work of Martin Erwig, Robin Abraham, and Margaret Burnett, along with other colleagues of theirs at Oregon State University, relevant to your ideas. I would hope that some of them read this list and will respond, otherwise I recommend that you get in touch with them directly. Alan > Dear All, > > I am Bennett Kankuzi, an MSc in Computer Science student at the > University of Botswana. I am new to this list. > > I am working on some research topic in spreadsheets. One of the basic > questions in this research is on the idea of goals in spreadsheets. > Since a spreadsheet is a program, it has to have high-level goals > which are implemented by plans as in procedural programming. Another > question that comes to mind is: how can one identify high-level goals > in a created spreadsheet? In attempting to answer this question, I am > proposing that sink cells (output cells) are representing high-level > goals of the spreadsheet program. (A sink cell can be defined as a > formula cell without any dependent cells yet it has precedent cells. > An input cell will only have dependent cells. Computational cells have > precedent and dependent cells since they are intermediary > computations) > > Why can sink cells represent goals ? Goals are what the user wants to > achieve. In other words, these are the primary results the user wants > to see. Output cells or sink cells contain these results otherwise > they could be used as part another formula (intermediary computation) > and therefore they could have dependent cells. > > Is my proposal alright? Or do you know of any research papers on goals > and plans in spreadsheets that could help answer my question? > > Many thanks in advance for your time. > > Regards, > > Bennett > -- > Blog: http://bkankuzi.blogspot.com > Photo Collection: http://www.flickr.com/photos/[EMAIL PROTECTED]/page2/ > Google Talk: bfkankuzi > VoipCheap: bkankuzi > Skype: bfkankuzi > Mobile: +267 72 938 886 > > -- > PPIG Discuss List ([email protected]) > Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss > Announce admin: http://limitlessmail.net/mailman/listinfo/announce > PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/ > -- Alan Blackwell Computer Laboratory, University of Cambridge http://www.cl.cam.ac.uk/users/afb21/ Phone: +44 (0) 1223 334418 -- PPIG Discuss List ([email protected]) Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss Announce admin: http://limitlessmail.net/mailman/listinfo/announce PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/
PPIG discuss: Identifying Goals in Spreadsheets
Dear All, I am Bennett Kankuzi, an MSc in Computer Science student at the University of Botswana. I am new to this list. I am working on some research topic in spreadsheets. One of the basic questions in this research is on the idea of goals in spreadsheets. Since a spreadsheet is a program, it has to have high-level goals which are implemented by plans as in procedural programming. Another question that comes to mind is: how can one identify high-level goals in a created spreadsheet? In attempting to answer this question, I am proposing that sink cells (output cells) are representing high-level goals of the spreadsheet program. (A sink cell can be defined as a formula cell without any dependent cells yet it has precedent cells. An input cell will only have dependent cells. Computational cells have precedent and dependent cells since they are intermediary computations) Why can sink cells represent goals ? Goals are what the user wants to achieve. In other words, these are the primary results the user wants to see. Output cells or sink cells contain these results otherwise they could be used as part another formula (intermediary computation) and therefore they could have dependent cells. Is my proposal alright? Or do you know of any research papers on goals and plans in spreadsheets that could help answer my question? Many thanks in advance for your time. Regards, Bennett -- Blog: http://bkankuzi.blogspot.com Photo Collection: http://www.flickr.com/photos/[EMAIL PROTECTED]/page2/ Google Talk: bfkankuzi VoipCheap: bkankuzi Skype: bfkankuzi Mobile: +267 72 938 886 -- PPIG Discuss List ([email protected]) Discuss admin: http://limitlessmail.net/mailman/listinfo/discuss Announce admin: http://limitlessmail.net/mailman/listinfo/announce PPIG Discuss archive: http://www.mail-archive.com/discuss%40ppig.org/
