SocialCalc is a spreadsheet activity developed for functioning in the Sugar environment, OLPC's software paradigm. Initially coded by Dan Bricklin of Software Garden Inc., the OLPC part was started by Manusheel Gupta, Managing Director of SEETA with K.S. Preeti, community friend of SEETA and alumnus from Netaji Subhas Institute of Technology and Luke Closs from Socialtext Inc. under the guidance of Walter Bender, Oversight Board Member at Sugar Labs.
The main idea of the SocialCalc is to include features that enable children to use features of Spreadsheet activities. Tabulation feature enables us to enter data in a tabular format and edit it. The activity facilitates sorting of data, comments to increase understanding, clipboard functions, etc. SocialCalc supports graphing features.
Calculations feature enables us to perform mathematical calculations. The most unique feature is Collaboration, the ability to support sharing of data over the network and multi-user editing. Interoperability is another important feature. It supports interoperability between SocialCalc and Excel (.xls) and SocialCalc and Lotus Notes (.wk3 and .wk4).
A number of features have been introduced:
- Localization in different languages
- Ability to read and edit single sheet Excel .xls files
- Sharing of activity over mesh network
- Ability to read and edit single sheet Lotus notes
- Optimization, sheet extents will include just the part that has data.
SocialCalc offers opportunities for participating in a number of initiatives:
- Develop teacher training videos for SocialCalc in their local languages;
- Develop interoperability between SocialCalc and Excel(xlsx format), Google Spreadsheet, Open Spreadsheet
- Features to modify the charts
- Integration of SocialCalc with other Sugar activities
- Development of 2-D, 3-D area charts
- Creation of shapes
- Creation of templates
Version #5 has been possible due to the efforts of Dan Bricklin, whose guidance has been integral its development; Vijit Singh; Luke Closs and K.S. Preeti, developers' of the JS-Python communication; Nicholas Doiron, author of graphing features; Mahesh Sharma, who developed interoperability; Claudia Urrea, Reuben Caron, Diksha Khatri, Lakky Rawat and Sakshi, who localized SocialCalc.
If you want to give your feedback, join the group on ScalableC, if you are a member there. If you are not, please ask for an invitation at http://www.scalablec.com/register.php with the message "Interested in joining SocialCalc on Sugar group". You can also contribute by writing to [email protected].
Manusheel Gupta is Managing Director of SEETA