The PACT Centre - Pewsey Area Community Trust

Menu:

CLAiT Units

Syllabus Information

PACT Training Services

File Management and e-Document
Creating Spreadsheets and Graphs
Database Manipulation
e-Publication Creation
Create an e-Presentation
On-line Communication

File Management and e-Document

Using Windows XP and MS Word 2003. This is a manditory unit and covers:

  1. Identify and use a computer workstation and appropriate system software
    • Gain access to data using a login and password
    • Create new documents
    • Open existing document(s)
    • Save documents
    • Print documents
  2. Use a computer's system software to create and manage files and folders
    • Create and name files and folders
    • Rename a file or folder
    • Delete a file or folder
    • Move a file
    • Copy a file
  3. Identify and use word processing software to enter text, numbers and symbols
    • Set page orientation
    • Set margins
    • Set text alignment
    • Enter text, numbers and symbols
    • Insert table
    • Apply borders
    • Insert headers/footers including automatic fields
    • Use bullets/numbering
    • Use tabs/indents
    • Use word count
Top

Creating Spreadsheets and Graphs

Using MS Excel 2003

  1. Identify, input and amend data in spreadsheet software accurately
    • Insert text and numerical data
    • Insert row/column
    • Delete row/column
    • Amend text and numerical data
  2. Insert and replicate formulae in spreadsheets
    • Use formulae and basic functions that produce correct results
    • Replicate formulae (fill)
  3. Produce pie charts, line graphs and bar/column charts from given data
    • Recalculate data Create graph(s)
    • Select data set(s)
  4. Use common formatting and alignment techniques in spreadsheets and graphs/charts
    • Align text and numerical data
    • Format numerical data
    • Display rows and columns to show borders/shading
    • Enter graph and axis titles
    • Set axes upper and lower limits
    • Display data labels
    • Use a legend
    • Ensure comparative data is distinctive
  5. Save and print spreadsheets and graph/chart
    • Save and close spreadsheet
    • Set page layout
    • Insert headers and footers
    • Print the spreadsheet with data showing in full as a table
    • Print the spreadsheet with formulae showing in full and displaying column and row headings
    • Print graphs on a sheet separate to the data source
Top

Database Manipulation

Using MS Access 2003

  1. Enter data in an existing database and present and print data
    • Open and use existing database
    • Create new records
    • Delete record(s)
    • Amend data
    • Replace data
    • Save data (table, query, report) with specified name
    • Print data
  2. Create simple queries/searches on one or two criteria and sort data
    • Select data on one criterion
    • Select data on two criteria
    • Sort data
    • Present selected fields
  3. Produce appropriate pre-defined reports from databases using short cuts
    • Produce simple database report(s)
    • Set page orientation
    • Display data in full
    • Display page headers/footers (page number, date)
Top

e-Publication CreationFile

Using MS Publisher 2003

  1. Set up a standard page layout and text properties
    • Set page size/orientation
    • Set margins
    • Create text areas/text frames
    • Set column widths/space between columns
    • Use serif/sans serif fonts
    • Use different font sizes
  2. Use basic techniques to combine information
    • Import text file(s)
    • Import image(s)
    • Place images
    • Place text
    • Use line/border features to draw simple lines/shapes
  3. Manipulate text and images to balance page
    • Apply alignment and justification
    • Amend text
    • Resize text
    • Use spell check
    • Manipulate image(s)
  4. Manage and print publications
    • Save publication(s)
    • Print and close document(s) in appropriate format
Top

Create an e-Presentation

Using MS PowerPoint 2003

  1. Set up a presentation accurately
    • Use appropriate application software to create presentation
    • Create text areas/text frames
    • Apply background consistently
  2. Input and format data in presentation software
    • Create new slide(s)
    • Change the order of the slide(s)
    • Insert text
    • Use spell check
    • Use specified font sizes
    • Use bullets
    • Apply alignment
    • Apply enhancement
    • Delete text
    • Replace specified text
    • Promote/demote text
  3. Import/insert images and graphics correctly
    • Insert graphic
    • Insert lines/boxes
    • Shade or fill the drawn graphics
  4. Save and print the presentation
    • Save the presentation
    • Save the presentation with new filename
    • Close presentation
    • Set the page orientation
    • Set the headers and footers
    • Print the presentation as slides
    • Print the presentation as handouts
    • Print the presentation as an outline view
Top

On-line Communication

Using MS Internet Explorer and Outlook Express

  1. Identify and use e-mail and browsing software
    • Use appropriate application software
    • Follow the rules of 'netiquette' when communicating with others
    • Use virus checking facilities
  2. Navigate the World Wide Web and use search techniques to locate data on the Web
    • Access specified web page(s)
    • Navigate the World Wide Web using hyperlinks
    • Use a site-specific (local) search engine
    • Use a general web search engine
    • Locate web page(s) containing required data
    • Save data from web page
    • Store web address (URL)
    • Print selected web page(s)
  3. Transmit and receive e-mail messages and attachments
    • Access incoming message
    • Access attached file
    • Attach file to e-mail message
    • Store e-mail address
    • Recall stored e-mail address
    • Store e-mail messages and/ or attachment
    • Reply to message
    • Forward message
    • Create and format new message
    • Copy message
    • Delete e-mail message
    • Print message(s) and attachment
Top

This course is available during flexi learning sessions.

Mondays 13.30 - 15.30
Tuesdays 10.00 - 12.00 and 18.00 - 21.00
Wednesdays 13.30 - 15.30 and 18.00 - 21.00
Thursdays 10.00 - 12.00