Advanced Legal Information Processing

Outcome 1 - use advanced spreadsheet software features to manipulate and present data

Practical skills

The candidate will be able to:

1. log onto system
2. access a spreadsheet application
3. create a spreadsheet with linked multiple worksheets
4. input and edit data including titles and headings eg office overheads, client fees, house purchases
5. format columns, rows and cells appropriately:
   • insert
   • delete/clear
   • copy
   • move
   • adjust
   • hide columns and rows
6. use enhancements to improve presentation of data:
   • bold, underline, italics, font size, borders, shading
   • left, right, centre alignment
   • currency and decimal alignment, comma separator
7. perform primary and secondary sorts to re-order data eg alphabetical, numerical, alphanumerical, chronological, ascending, descending
8. organise worksheets to aid easy use:
   • insert
   • rename
   • delete
9. insert headers and footers
10. create formulas using logical functions:
    • IF
    • AND
    • OR
    • NOT
    • absolute cell references
11. enter formulas (add/SUM, subtract, divide, multiply, percentage) and apply statistical functions:
    • COUNT
    • MIN/MAX
    • AVERAGE
    • MEDIAN
12. copy and link formulas to new worksheets
13. wrap text within cellls
14. produce charts/graphs as required ie pie, bar, column, line
15. amend chart type and format  as required:
    • legends and data labels
    • titles and axes
16. export charts/graphs to other software applications
17. select page orientation ie portrait or landscape, and fit to one page
18. name and save spreadsheet files
19. print:
    • a part of a spreadsheet/worksheet
    • a whole spreadsheet/worksheet
    • formulas
    • gridlines

Outcome 2 - use database software to manipulate and present data

Practical skills

The candidate will be able to:

1. log onto system
2. access a database application
3. open and create a database to display records and fields for editing
4. produce records from one or more tables using appropriate field names and data types ie text, character, number, currency, yes/no
5. format fields/records as required ie insert, edit, delete, find and replace, select extract, re- arrange
6. perform primary and secondary sorts ie alphabetical, numerical, chronological, alpha-numerical, ascending and descending orders
7. use enhancements to improve the presentation of data:
   • bold
   • italics
   • font size/style
   • borders
   • shading
   • alignment
8. insert headers and footers including page numbers
9. apply relational operators:
   • equal to =
   • greater than >
   • less than <
   • greater than or equal to >=
   • less than or equal to <=
   • not equal to <>
10. use multiple condition searches to create queries from different fields ie reports, queries, tables, records, mailing labels, merged documents
11. select and print page orientation ie portrait or landscape
12. name, save and print database structures ie reports, queries, tables, records, labels, merged documents.

Outcome 3 - produce an integrated file using word processing, spreadsheet and database applications

Practical skills

The candidate will be able to:

1. import data/text/graph from a spreadsheet or database application
2. format and modify imported data/text/graph
3. insert and format a graphic/object, query, report
4. name, save and print an integrated document
5. produce a screenprint showing integrated directory/file structures.