Forecasting in Excel: Trend, Seasonality and When Not to Trust the Result
A backtest of four forecasting methods in Excel (straight line, manual and automatic ETS, and seasonal naive), with measured errors, the seven most…
Step-by-step Excel and Word tutorials and technology for the classroom.
A backtest of four forecasting methods in Excel (straight line, manual and automatic ETS, and seasonal naive), with measured errors, the seven most…
How to build a short, applicable AI policy for a school, with three categories of use, a matrix of 16 uses for teachers, students and principals, a…
Six ways an integration fails without warning, five steps to prevent it, an executed Python demo (idempotency, retries and alerts) and an Excel…
Seven concrete signs your Excel file has fallen short, an example with tested SQL code, a comparison of Excel, database and web application, and a…
What technology debt is in a school, what the data say about tool accumulation and three criteria (integration, pedagogical value and…
The real three-year cost of buying a license, subscribing or building your own application, with a numeric case, explicit assumptions, break-even…
Five Excel chart mistakes (truncated axis, different scales, cherry-picked data, correlation without cause and dual axes) with corrected versions, a…
Technological assistance versus replacing professional judgment: what UNESCO evidence and the Colombian framework say, and a matrix of decisions…
Synchronization, redundancy, backup and recovery are different things. Seven myths about the cloud and backups, the 3-2-1 rule and a script to check…
The same task (consolidating 12 workbooks of 120,000 rows) solved with Power Query, VBA, Python and Office Scripts, with measured times, real…