spreadsheet

features

advantages

disadvantages

integration in TL

grid, rows & columns

the column are labelled with letters

the rows are labelled with numbers

intersection of a column and a row is called cell

Functions (to evaluate values and perform different kinds of operations)

Formulas (to express the relationship of two or more cells)

Commands (provides several types of commands for value manipulations)

click to edit

User Interface of a spreadsheet
image

Editing - a way to carry out continual analyses and calculations on your data sets automatically.

title bar

menu bar

toolbar

formula bar

cell

cell address

column header

row header

sheet tab

status bar

Formulas - the ability to enter mathematical formulas to carry out a calculation on a numerical data item.

Preset Functions - provide a range of preset functions that encapsulate common formulas, allowing users to apply functions without having them to type manually.

Collaboration is Limited

Lack of controls, vulnerable to fraud

only one person can access and edit the data at a time,

recipients even end up being sent the wrong version which can lead to errors in data.

Graphical Displays of Data - can transform data into various types of graphical displays.

Spreadsheets do not possess any built-in, automatic audit tracking function

No log of change

As values/calculations/source data changes, the spreadsheet does not maintain the prior value for auditing/control

Having this function in a system allows you to review accuracy of data over time and return to previous values if errors are detected.

Not prepared for disaster

If there are no best practices put in place for proper spreadsheet storage or back up, your reinsurance programme is at major risk when disaster strikes.

Difficult to troubleshoot or test

Spreadsheets are notoriously difficult to trouble shoot or test, simply because they aren’t built for that.

However, testing should be an integral component of the quality controls you put in place to maintain accuracy across reinsurance programmes.

When spreadsheets are saved in different folders, departments or even geographical locations, it becomes that much harder to implement and conduct quality control processes.

click to edit

Hard to manage data security

Controlling data access and restrictions on spreadsheets can be difficult over time when there are hundreds of spreadsheets to manage and scores of users requiring access.

image6

images

Spreadsheet skills allow students to organize, calculate, graph, and analyze data 11

Contain 3 primary functions a) Storing data, b) Performing Calculation, c) Presenting Information.

Has many features that make it ideal for curation and organization of information

Single use spreadsheet. Student can create spreadsheet design to complete a single task . spread spread 2

1) Gradebook, 2) Organise resources, 3) Explore & Share Graphs, 4) Use templates

3) Explore and Share graphs. Students can collect data, determine how it should be organized in their sheet and then use the chart feature to create a graph that best fits their data. The graphs can then be easily shared on a class webpage, wiki or blog, where students can share their findings and conclusions with others.

2) Organize Resources. Gather resources for your students and keep it one central location. Using the formatting features and multiple sheets allow you to create a document that’s easy and clear for students to navigate.

4) Use Templates. There are a variety of templates already created for teachers to make your life a little easier! You’ll find gradebooks, attendance sheets, schedules and more in the template gallery.

1) Gradebook, a) create graphs for individual students that you can share with students or parents. b) Use functions to figure out your final grade. c) Using conditional formating to visually organise your data.

click to edit