Difference between revisions of "Users Guide to SOLM-2024 database"
(Created page with "==This is the start of the Users Guide== 1. Overview of the database - Technology: - Size: - Dimensions - Conceptual structure: 2. Conceptual structure 3. People 4. Ships...") |
|||
Line 1: | Line 1: | ||
− | + | [TOC] | |
− | + | '''This is the start of the Users Guide to the SOLM-2024 databsae''' | |
− | + | == Overview of the database== | |
− | + | ||
− | + | ||
− | + | ||
− | + | - Technology: Excel Workbook | |
+ | - Size: 22 MB | ||
+ | - Dimensions: 23,715 rows; 320 columns | ||
+ | - Sheets: One | ||
+ | - Conceptual structure: Flat semi-structured database | ||
+ | - Author: Colin Greenstreet | ||
+ | - Date started: 2017 | ||
+ | - Latest version: SOLM-2024 Ver.13.2 08/04/2024 | ||
+ | ---- | ||
+ | ==Conceptual structure== | ||
− | + | - Primary dimension is formed by the personal depositions of people | |
− | + | - Secondary dimensiob is formed by the named ships with which most of the personal depositions of people are associated | |
− | + | - Each of the primary dimensions is characterized in multiple ways, which can be grouped into sub-categores | |
+ | |||
+ | e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical | ||
+ | |||
+ | ==People== | ||
+ | |||
+ | PEOPLE: BASICS | ||
+ | -- Name [Forname; Surname] | ||
+ | -- Age [Years; Estimated birth year] | ||
+ | |||
+ | PEOPLE: GEOGRAPHY | ||
+ | -- Current residence [Street/Hamlet; Parish; Town; County/Province] | ||
+ | -- Current state [e.g. England; e,g. France] | ||
+ | |||
+ | PEOPLE: GEOGRAPHY ADVANCED | ||
+ | -- Place of birth [Parish; county; Province; State] | ||
+ | -- Length of time in current residence [Years; textual comment] | ||
+ | |||
+ | ==Ships== | ||
+ | |||
+ | SHIPS: BASICS | ||
+ | -- Name of ship | ||
+ | -- Place of affiliation of ship [e.g. the Seaventure of Yarmouth] | ||
+ | -- Name of master of ship | ||
+ | |||
+ | SHIPS: VOYAGES | ||
+ | -- Extent of voyage knowledge [None; Partal; Full] | ||
+ | -- Voyage nodes [Named nodes in route order, if known] | ||
+ | |||
+ | SHIPS: PHYSICAL | ||
+ | -- Shp burthen [Tons] | ||
+ | -- Ship company size [including master and boys] [Number] | ||
+ | -- Ship ordnance [Guns] | ||
+ | |||
+ | SHIPS: PEOPLE | ||
+ | -- Name of master of ship | ||
+ | -- Ship company size [including master and boys] [Number] | ||
+ | |||
+ | |||
+ | ==Sorting the database== | ||
- Use of filters | - Use of filters | ||
+ | |||
+ | - Use of sort buttons | ||
+ | |||
+ | - Use of F5 function | ||
+ | |||
+ | ==Practice exercises== | ||
+ | |||
+ | |||
+ | ==Special requests== | ||
+ | |||
+ | |||
+ | ==Providing feedback |
Revision as of 10:26, April 9, 2024
[TOC]
This is the start of the Users Guide to the SOLM-2024 databsae
Contents
Overview of the database
- Technology: Excel Workbook
- Size: 22 MB
- Dimensions: 23,715 rows; 320 columns
- Sheets: One
- Conceptual structure: Flat semi-structured database
- Author: Colin Greenstreet
- Date started: 2017
- Latest version: SOLM-2024 Ver.13.2 08/04/2024
Conceptual structure
- Primary dimension is formed by the personal depositions of people
- Secondary dimensiob is formed by the named ships with which most of the personal depositions of people are associated
- Each of the primary dimensions is characterized in multiple ways, which can be grouped into sub-categores
e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical
People
PEOPLE: BASICS
-- Name [Forname; Surname]
-- Age [Years; Estimated birth year]
PEOPLE: GEOGRAPHY
-- Current residence [Street/Hamlet; Parish; Town; County/Province]
-- Current state [e.g. England; e,g. France]
PEOPLE: GEOGRAPHY ADVANCED
-- Place of birth [Parish; county; Province; State]
-- Length of time in current residence [Years; textual comment]
Ships
SHIPS: BASICS
-- Name of ship
-- Place of affiliation of ship [e.g. the Seaventure of Yarmouth]
-- Name of master of ship
SHIPS: VOYAGES
-- Extent of voyage knowledge [None; Partal; Full]
-- Voyage nodes [Named nodes in route order, if known]
SHIPS: PHYSICAL
-- Shp burthen [Tons]
-- Ship company size [including master and boys] [Number]
-- Ship ordnance [Guns]
SHIPS: PEOPLE
-- Name of master of ship
-- Ship company size [including master and boys] [Number]
Sorting the database
- Use of filters
- Use of sort buttons
- Use of F5 function
Practice exercises
Special requests
==Providing feedback