 |
Prescription:IC230 Spreadsheets |
| Aim of Module | To introduce students to the concepts, functions and applications of spreadsheets
|
| Credits | 5
|
| Suggested Time | 50 student learning hours
|
| Prescription Expiry Date | Nov 2003
|
LEARNING OUTCOMES
The Student Will
| | | | | C | 1 | Demonstrate an understanding of the basic terminology of spreadsheets, and their uses. | |
A | 2 | Complete a practical exercise to demonstrate understanding of the basic principles. |
CONTENT
| | | | > | Define the following terms and concepts: | |
| Work area/worksheet | |
| Columns and rows | |
| Cell | |
| Range | |
| Cell pointer | |
| Cell address | |
| Formulae | |
| Cell width | |
| Absolute cell address/relative cell address | |
| |
> | Describe some uses of spreadsheets | |
| |
> | Plan and design a spreadsheet for a simple problem
|
top
| | | | Complete a practical exercise(s) using a spreadsheet package which involves: | |
> | Entering labels and values | |
> | Formatting cells (eg alignment, numbers, dates) | |
> | Changing cell width | |
> | Creating simple arithmetic formulae (eg: add, subtract, multiply, divide and sum) | |
> | Creating other simple formulae including date and time, statistical (eg average, min, max, count), financial (eg pmt)) and logical functions (eg if( ), and( ) or( ) ) . | |
> | Copying formulae using absolutes and relative cell addresses | |
> | Checking results, including check-totals and data compared with original sources | |
> | Sorting columns in terms of alphabetically and numerically. | |
> | Undertaking ëwhat-ifí analysis, by manipulating simple cells of data | |
> | Graphing data (including eg. non-contiguous ranges, appropriate titles and labels) | |
> | Printing, including header and footer, formulae, selections
|
top
|
|
|
