Track 13. Whiteboards: exercise sheet
For everyone who sketches concepts, workshops or briefings. One practice task and a few questions per chapter, to work through after each video. Print this page from your browser, or work on screen. The answer key starts on a new page at the end.
Before you start
- Take first
- Chapter 1.1 The Holarch Workspace.
- Plan
- Free
- Project
- The Bike-Share Dock: each chapter has its starting file.
13.1 Shapes and Lines
Watch chapter 13.1 (3:15)
Practice
On Bike-Share Dock:
- Open the chapter's starting file, or any project of your own, and open Plan → Whiteboards. Click + New Whiteboard and name it
Dock Concept. - Click the rectangle tool and drag a box. Press Enter, type
Rental Kioskand press Esc. - With the box selected, click the plus handle below it and type
Docking Bay. - In the Shapes panel, search
cloud, click it, drag it to the right and typeBack Office. Press O, draw an ellipse on the left and typeRider. - Press Esc, then A. Drag from the kiosk to the back office. Press A again, choose Elbow in the Line options bar and draw from the docking bay to the back office.
- Move the back office and watch both lines follow.
You're done when the board has four labeled shapes, an arrow and an elbow line, and both lines stay attached when you move a shape.
Questions
- Why press Esc before a tool key such as A or O?
- Where do you choose a line's type and arrowheads before drawing it?
- What happens when you release a line's end on the body of a shape rather than on a connection point?
13.2 Curves and Line Labels
Watch chapter 13.2 (3:09)
Practice
On Bike-Share Dock:
- Open the chapter's starting file and the Dock Concept whiteboard.
- Press A, choose Curved in the Line options bar and drag from the rider to the docking bay.
- Drag the yellow diamond toward one end, then back until it snaps to the middle. Drag it away from the line with Shift held.
- In the inspector's Line section, tick Square to the edge for Start and End, then move the rider.
- Double-click the line, type
returns a bikeand press Enter. Drag the label along the line, away from it, and back on; rotate it with its round knob. - Add a second label and delete it with its ×.
You're done when the curved arrow meets both shapes square to their edges and carries one label that follows the line.
Questions
- What does the yellow diamond on a curved line show?
- How do you place the peak anywhere without the snap to the middle?
- What keeps a label turned along its line when the line moves?
13.3 Charts
Watch chapter 13.3 (3:32)
Practice
On Bike-Share Dock:
- Open the chapter's starting file and the Dock Concept whiteboard. Click + in the Boards strip.
- Open Tables and Charts and click Column. Double-click the chart, click Import from File… and choose a workbook of your own with a label column and two number columns.
- Right-click the chart → Change Chart Type… → Stacked Column → OK.
- In the Chart section, click Select Data…, try Switch Row/Column twice, move a series up and click OK.
- Tick Data labels, set the legend to Top, click the value axis and set Maximum and Major.
- Click Import Chart from Excel… and insert a chart from a workbook that has charts.
You're done when the board has a stacked column chart with data labels, a legend on top and fixed axis bounds, and one chart imported from Excel.
Questions
- When is a 100% stacked chart better than a stacked one?
- What does Switch Row/Column do?
- How do you go back to an automatic axis bound after setting one?
13.4 Live Data, Model Items and Clipart
Watch chapter 13.4 (3:17)
Practice
On Bike-Share Dock:
- Open the chapter's starting file and the Dock Concept whiteboard. Click + in the Boards strip.
- In Excel, copy a small block of cells with a header row. Click the board, press ⌘V / Ctrl+V (or Ctrl+V), choose Live spreadsheet and click Paste.
- Insert a Bar chart, open Select Data… → Link to Spreadsheet Range…, choose the new spreadsheet, type the range and click Link, then OK.
- Double-click the table, change one number in the spreadsheet and go back to the board with its editor tab.
- On Board 1, select the Rental Kiosk shape, click Link to… and choose the Rental Kiosk asset. Select Rider, click Convert to Model…, choose Asset and click Convert.
- Open Clipart, search
bicycle, star one picture and click it to insert it.
You're done when the table and the chart show the number you changed, both shapes carry a class badge, and a bicycle picture is on the board.
Questions
- What is the difference between pasting cells as a Chart and as a Live spreadsheet?
- How does a chart follow spreadsheet cells?
- What is the difference between Link to… and Convert to Model…?
Answer key
13.1 Shapes and Lines
- When a shape is selected, letters type into it. Esc clears the selection, so the key picks the tool.
- In the Line options bar, which opens above the board when you pick a line or arrow tool.
- The end floats: it attaches to the nearest side and moves around the shape as the shapes move.
13.2 Curves and Line Labels
- The peak: the point of the curve farthest from the straight line between its ends. Dragging it along the line moves the peak; dragging it away bends the curve more.
- Hold Command (Mac) or Control while you drag the diamond.
- Follow the line, in the label's row of the Line panel.
13.3 Charts
- When the shares matter more than the totals: each bar fills the height, and the segments show each series' part.
- It swaps series and categories: the rows become the series and the columns the categories, or the other way round.
- Empty the box in Format Axis.
13.4 Live Data, Model Items and Clipart
- A Chart keeps a copy of the values and does not change. A Live spreadsheet creates a spreadsheet with the cells and shows them as a live table that changes with them.
- Link it in Select Data with Link to Spreadsheet Range…; the chart then draws from that range.
- Link to… ties the shape to an item that already exists. Convert to Model… creates a new item from the shape, named after its text, and links it.
Published by Holarch