Chapter 13 Computer Systems Files and Traceable Geological Data

Year 1 · Introduction to Computing · G115-L1

Understand hardware, software, operating systems, files and programming concepts through a reproducible field-data organization exercise.

A repeatable workflow from a testable question to an evidence-based interpretation. Original Geology Hub teaching diagram.

Learning objectives: Distinguish hardware and software, describe operating-system functions, separate data from interpretation, and organize files so a geological result can be traced.

Computers transform representations

A computer takes encoded input, processes it according to instructions, stores information and produces output. Hardware includes processors, memory, storage and input or output devices. Software supplies instructions that make those components useful. Working memory supports active computation, whereas persistent storage retains files when power is removed. A faster processor cannot compensate for incorrectly entered measurements or an unsuitable interpretation.

Data are recorded representations, such as a sample identifier, a measured mass or a coordinate. Information emerges when those records acquire context and interpretation. The value “32” is ambiguous; “bed dip 32 degrees toward southeast” is more meaningful. A dataset therefore needs field names, units, definitions and a method description. A digital file is not automatically well-documented evidence simply because it looks precise.

Follow one measurement through a computer system

A keyboard, sensor or file supplies input. The processor executes instructions using working memory, storage preserves records, and an output device displays or exports the result. A geological balance can therefore supply a mass measurement without the computer understanding what geological question it answers. The application must associate the number with a sample, unit and method. Separating these roles explains why a functioning device chain can still produce an uninterpretable scientific dataset.

Representation determines what a file can preserve

Bits encode information through two-state distinctions; larger sequences represent numbers, characters and other structures under agreed conventions. A photograph stores spatial colour information, while a table stores fields and records. A plain-text export may preserve values but lose spreadsheet formulas, formatting or metadata. An image of a table may preserve appearance while making reliable numerical reuse difficult. Format choice is therefore a decision about information retention, not merely which application icon should appear beside the filename.

Operating systems coordinate shared resources

An operating system manages processes, memory, devices and file access so applications can work without controlling every physical component directly. A directory or folder organizes named entries; a path identifies a location within that organization. An application can fail to find a file because its path changed even though the data still exist. Copying an entire project can preserve relative relationships among its files, whereas moving only one linked figure may break a report’s image reference.

Instructions can be expressed at different levels

Machine-level representations correspond closely to processor operations, while higher-level languages express tasks through more readable abstractions. A compiler translates a program into another executable representation; an interpreter or managed execution system handles instructions through its own implementation. The same geological algorithm can be written in different languages. For example, a density calculation must divide mass by volume regardless of syntax. Selecting the correct relationship and units precedes choosing the implementation.

System software and applications solve different problems

Device drivers and operating-system services support the platform. A spreadsheet, word processor, graphics editor and GIS application support particular user tasks. A large analysis package may contain several such functions, but their evidential roles remain distinct. In a hypothetical sample project, raw mass and volume belong in an observation table, a calculation produces density, and a document explains its interpretation. Keeping these stages connected by stable sample identifiers prevents a polished final report from becoming detached from the measurements that support it.

Operating systems and applications

An operating system manages resources, devices, storage and access between applications. A word processor, spreadsheet, image editor and mapping package serve different tasks. File extensions indicate formats, but changing an extension does not convert the underlying content. A text file, spreadsheet and raster image each represent structure differently. Choose a format according to the next user’s needs and the information that must survive transfer.

Programming languages express instructions using formal rules. A compiler translates a program into another form before execution in a typical workflow; an interpreter executes or manages instructions through a different execution process. Real language implementations can combine techniques. Algorithms are ordered procedures for solving problems and are independent of a particular brand of software. Sorting sample identifiers or calculating corrected elevations are simple geological examples.

Folders are part of the scientific method

Keep original observations separate from cleaned data and calculated outputs. A practical project structure might contain raw observations, working data, scripts or calculation notes, figures and final reports. Descriptive names should convey content and version without relying on memory. Avoid using a filename such as “final-final-new” as the only record of revision history. Retain a short log explaining changes that alter interpretation.

Copying creates another file; moving changes its location; renaming changes how it is addressed. Deletion can remove the only original if no verified backup exists. Practice these operations on disposable sample files before applying them to field records. A backup should be tested by opening a recovered copy. Synchronization alone does not necessarily preserve a previous state when an accidental change propagates.

Worked data-organization exercise

Imagine three notebook entries: “A1, 2.65,” “A2, 2.71” and “A3, not measured.” Build a table with sample_id, density_g_cm3, method and note. Preserve the missing third measurement as explicitly missing rather than zero. A zero would imply a physical measurement and would distort the mean. Add a readme stating that the first two values are fictional teaching data measured by an assumed displacement method.

Save an unchanged source copy and a working copy. In the working copy, add a column indicating whether each measurement passes a chosen completeness check. The result should let another student reproduce which rows were included in a later calculation. This is the essential connection between basic computer literacy and defensible geological work: every transformation remains understandable after the original author leaves.

Self-check

Does changing .txt to .xlsx create a valid spreadsheet?

No. Renaming an extension does not transform the internal file format.

Why is missing density not entered as zero?

Zero would be treated as a real measurement and could bias calculations.

What makes a backup useful?

It must preserve needed data and be recoverable; testing a recovered copy confirms that it works.

Sources and further study

Topic framework: the supplied University of Peshawar BS Geology curriculum, session 2004–05 onward. This independently authored learning resource is not affiliated with the university and does not confer a degree or accreditation.

Chapter 13 multiple choice questions

Choose one best answer for each question. Open each answer panel after making your choice.

Which component primarily retains project files when the computer is powered off?
1. Working memory used for active calculations
2. A temporary in-memory analysis array
3. Persistent storage
4. A processor register holding an intermediate result
Answer and explanation
C. Persistent storage Persistent storage retains files, while working memory supports active computation.
A data table contains the value “32” without a label or unit. What is the most important improvement?
1. Define the variable, unit and measurement context.
2. Add more decimal places while leaving the quantity undefined.
3. Sort the values numerically without defining the measurement.
4. Calculate a mean before establishing which quantity was measured.
Answer and explanation
A. Define the variable, unit and measurement context. A measurement becomes interpretable when its quantity, units and context are documented.
A user renames a text file from .txt to .xlsx. What has definitely changed?
1. The file has become a valid spreadsheet automatically.
2. All original records have necessarily been converted into worksheet rows.
3. The original content has necessarily been converted into a formula-based table.
4. The filename extension, rather than necessarily the internal format
Answer and explanation
D. The filename extension, rather than necessarily the internal format Changing an extension does not convert the underlying file representation.
A sample density was not measured. Why should its field not be filled with zero?
1. Zero is the standard value for all unknown measurements.
2. Zero would be interpreted as an actual numerical observation and could bias calculations.
3. Missing observations never affect calculations.
4. A zero automatically stores a full explanation of the missing value.
Answer and explanation
B. Zero would be interpreted as an actual numerical observation and could bias calculations. Explicit missing-data handling preserves the distinction between an absent measurement and a true zero.
A working dataset has been cleaned. Which practice best preserves a traceable workflow?
1. Keep original observations separate and document each substantive transformation.
2. Replace the original file and discard the change history.
3. Keep only a screenshot of the final chart.
4. Use the name final-final-new as the only revision record.
Answer and explanation
A. Keep original observations separate and document each substantive transformation. Separate source and working records allow another analyst to reconstruct the processing decisions.

All 84 chapters

Search This Blog

Geology Hub