Building a Spreadsheet

Synopsis

Looks at how a simple spreadsheet computer program might be designed. Covers the choice of main data structure - the spreadsheet itself - and the effects of this choice on the program modules which have to manipulate it. Graphics show the development of the design from a brief, top-level version to a form which could be coded in Pascal. Simplifications mean that a spreadsheet produced in this way would not be suitable as a commercial package. Concludes with a brief discussion of the way that real spreadsheets differ from the design shown here.

Series

Fundamentals of Computing, Course M205

Language

English

Country

Great Britain

Medium

Video; Videocassette. Standard formats. col. 24 min.

Year of production

1989

Availability

OUT OF DISTRIBUTION

Subjects

Information technology

Keywords

computer applications; spreadsheets

Credits

Producer

David Saunders

Production Company

Name

BBC Open University Productions

Distributor

Name

Open University Worldwide

Web

http://www.ouw.co.uk External site opens in new window

Phone

+44 (0) 1908 274066

Address

Walton Hall
Milton Keynes
MK7 6AA

Notes

NB. As of May 2016 Open University Worldwide are no longer distributing DVDs. They have posted this message on their website: ‘Unfortunately Open University Worldwide Limited has decided that product sales are no longer viable given the reduced funding to Higher Education institutions and diminishing demand for the products we have traditionally stocked. At present the Open University Students Association (OUSA) will continue to sell the "Good Study Guide", and we are in discussion with other possible distributors to continue to make The Open University’s products available for purchase. As soon as we have any information on other channels of distribution we will update this notice’. Some products are still available via second hand dealers on Amazon.co.uk