Computer Specialist in Spreadsheet & Database Level 1 case studies
Computer Specialist in Spreadsheet & Database Level 1 · Put your knowledge to work in context.
The Computer Specialist in Spreadsheet & Database Level 1 credential is an entry-level certification for candidates who need to prove they can work productively in a spreadsheet application and understand the basics of a relational database. It suits office administrators, data-entry and reporting staff, students entering business or IT programs, and career changers who want a verifiable marker of practical skill rather than a purely academic qualification. The Computer Specialist in Spreadsheet & Database Level 1 case studies are 5 cases and about 4,638 words.
1The Banded Price List That Charges the Wrong Band at the Boundary
A regional distributor publishes a banded price list: 0–99 units at 12.40, 100–499 at 11.85, 500–999 at 11.10, 1,000–2,499 at 10.60, and 2,500+ at $9.95. The list sits on a sheet named Rates in A1:C7 - a header row plus five bands - with the maximum quantity of each band in column A and the unit price in column C.
889 words, about 4 min2Goal Seek Says $61.20; the Residence Hall Contract Says Otherwise
The conference services office at a college models summer accommodation revenue in a single worksheet. Three room types - Standard, Suite and Apartment - have nightly fees in B4:B6 ( 89, 129, 165), variable costs per occupied night in B14:B16 ( 58, 81, 104) and modeled room-nights in B9:B11.
985 words, about 5 min3One Flat Schedule Sheet, Six Thousand Rows
A training company runs about 400 course sessions a year and has always tracked them in one worksheet named Schedule - roughly 6,000 rows with the columns CourseName, InstructorName, InstructorPhone, Room, StartDate, EndDate, StudentID, StudentName, StudentEmail and FeePaid. Every session repeats its course, instructor, room and student details on each row.
910 words, about 5 min4Freight That Tripled on the Way Through a JOIN
A warehouse database has two tables. Orders holds one row per order: OrderID (primary key), CustomerID, OrderDate, Freight.
893 words, about 4 min5The CSV That Lost Its Leading Zeros
Each month a benefits administrator receives a 12,480-row CSV from a third-party payroll bureau and loads it into a workbook used for reporting. The columns are MemberID, Surname, DateOfBirth, PostalCode, Amount, and a trailing empty column.
961 words, about 5 min