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
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.
Spreadsheet skills allow students to organize, calculate, graph, and analyze data
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 .
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