Print & Graphic Design Production: Resolution, Bleed, Imposition, Paper & Type Scales
Prepare print-ready files and quotes for a fictional design studio: PPI checks, bleed sizes, items per press sheet, paper weights and postage, booklet page counts and spine widths, type scales, layout grids and a digital-vs-offset break-even, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run the production checks of a fictional design studio in a spreadsheet, one job per lab. You turn pixels into effective PPI and flag low-resolution images, add bleed and safe margins and convert between millimetres and inches. You count items per press sheet upright and rotated with INT and MAX and add overs with ROUNDUP, turn paper gsm into grams and look up postage bands with XLOOKUP. Then you round booklet pages to multiples of 4 and 16 with CEILING, calculate spine widths, build a modular type scale with POWER, set up a column grid with a baseline step and find the break-even quantity between digital and offset printing.
Lessons
- Pixels to Print Size: Effective PPI, Low-Resolution Flags and Maximum Print Width Pro
- Bleed and Safe Area: Document Sizes, Safe Zones and mm–Inch Conversions Pro
- Imposition: Items per Press Sheet, Rotated Layouts and Sheets Needed with Overs Pro
- Paper Weight: gsm to Grams, Mailing-Piece Weight and Postage Bands Pro
- Booklets and Books: Page Counts in Multiples of 4 and 16, Blank Pages and Spine Width Pro
- Type Scales: Modular Sizes with POWER, Leading and Characters per Line Pro
- Layout Grids: Column Widths, Spans across Gutters and the Baseline Grid Pro
- Print Quotes: Setup plus Unit Cost, the Cheaper Process and the Break-Even Quantity Pro