Comprehensive Notes
1. Collect Organizational Data
1.1 Data Collection
Data collection refers to the process of identifying and gathering relevant
information required by an organization to support decision-making,
planning, and operations. Data may include customer information, employee
records, financial data, sales figures, inventory details, or operational
statistics. Data collection must follow organizational policies, legal
requirements, and ethical standards to ensure accuracy, confidentiality, and
reliability.
1.2 Methods to Collect Data
Organizations use various approved methods to collect data depending on
the type of information required. Common methods include:
Surveys and questionnaires
Interviews and meetings
Observation of work processes
Review of existing records and reports
Digital systems such as databases, CRM systems, or online forms
The chosen method must be efficient, reliable, and compliant with
organizational policies.
1.3 Appropriate Resources in Data Entry
Resources required for data entry include both human and technological
resources. These may include:
Trained staff or data entry personnel
Computers, laptops, or tablets
Data entry software such as spreadsheets or database systems
Internet access and secure networks
Data entry forms, templates, and guidelines
Using appropriate resources helps ensure data accuracy, consistency, and
security.
1.4 Data Collection
During the data collection process, information is gathered carefully and
accurately using approved methods and resources. Data must be checked for
completeness and correctness before being entered into systems.
Confidential information must be handled securely, and all data collection
activities must comply with organizational policies and data protection laws.
2. Compile and Analyze Organizational Data
2.1 Data is Keyed
Data keying refers to entering collected data into approved systems such as
spreadsheets, databases, or organizational software. Data must be entered
accurately, following set formats and standards, to minimize errors and
ensure consistency.
2.2 Data is Analyzed
Data analysis involves examining collected data to identify trends, patterns,
relationships, or issues. This may include sorting, filtering, comparing, or
summarizing data. The purpose of data analysis is to support decision-
making and improve organizational performance.
2.3 Data Compiling
Data compiling is the process of organizing analyzed data into meaningful
formats such as reports, charts, tables, or summaries. Compiled data makes
information easier to understand, interpret, and communicate to
stakeholders.
2.4 Data is Saved
Data is saved according to organizational policies to ensure it is secure,
accessible, and protected from loss. This includes saving files in approved
locations, using correct file naming conventions, and applying access
controls where required.
2.5 Data Backup Methods
Data backup methods are used to protect information from accidental loss,
damage, or system failure. Common backup methods include:
Cloud-based storage systems
External hard drives or USB devices
Network servers
Automated backup systems
Regular backups ensure business continuity and data recovery when needed.
3. Create Database
3.1 Blank Database Creation
A blank database is created using approved database software such as
Microsoft Access, MySQL, or other organizational systems. The database
structure is designed according to database standards, including tables,
fields, and data types.
3.2 Blank Database is Named
The database is named according to organizational or database naming
conventions. Clear and consistent naming helps users identify the database
easily and prevents confusion.
3.3 Database Creation
Database creation involves designing tables, defining relationships, setting
primary keys, and entering data into appropriate fields. The database must
be structured to ensure data accuracy, efficiency, and integrity.
3.4 Data Saving
Database data is saved regularly to prevent loss of information. Saving
ensures that all updates and changes are stored correctly and can be
accessed when required.
3.5 Data Backed Up
Database backups are created in accordance with database standards and
organizational policies. Backup copies are stored securely and tested
periodically to ensure data can be restored if needed.