Skip to main content

Downloads

The published teaching files contain the same dataset in different formats. Each format supports a different kind of class work. The SQLite file, Excel workbook, and CSV package all reflect the same company, the same business cycles, and the same posted accounting.

Students usually download the package first, learn the company and the process flow, and then choose the format that fits the assignment. That sequence keeps the same business visible across SQL work, Excel review, and table-by-table exports.

Tool Guides

  • SQL Guide for opening the SQLite file, running starter queries, and tracing posted accounting in the database
  • Excel Guide for workbook-based review, pivots, filters, and reconstruction work from the Excel package

The File Package

FileWhat it represents in the learning flow
CharlesRiver.sqliteThe same dataset in the strongest format for tracing documents, joins, subledgers, and GLEntry in SQL
CharlesRiver.xlsxThe same dataset in the strongest format for workbook-based review, pivots, charts, and filters
CharlesRiver_csv.zipThe same dataset in a table-by-table export for external tools and imports

How the Files Fit the Business Story

The files support the learning path in a clear order:

  1. the company story explains what kind of business this is
  2. the process pages explain how sales, design services, purchasing, manufacturing, payroll, and close create the data
  3. the files become the detailed record of those business cycles
  4. the analytics pages help students interpret what those cycles mean

Next Steps

  1. Read Start Here.
  2. Read Company Story.
  3. Read Process Flows.
  4. Then open SQL Guide, Excel Guide, Analyze the Data, or Reports Hub.