Category Archives: Civics Through Spreadsheets

Statistics of US Senate Disciplining Its Members

The controversial senate candidacy of Roy Moore has resulted in some discussion of how the US Senate would respond if he won the election. Senate Majority Leader Mitch McConnell has mentioned the possibility of expulsion. I could not recall hearing of anyone being expelled from the Senate recently, so I decided to grab some data from the Senate web site and summarize it here. Continue reading

Posted in Civics Through Spreadsheets | 3 Comments

Fact Checking: Comparison of Military Budgets

I heard a news commentator say that the US defense budget is larger than the combined defense budgets for the next ten largest spenders. I thought that this would be easy to check and would provide my staff a beginner's example to use for their Excel self-training. Continue reading

Posted in Civics Through Spreadsheets, Fact Checking | 2 Comments

History Through Spreadsheets: Executive Orders

During my recent seminar on Excel's Power Query feature, I showed my team how to grab data executive order data from the web and generate a simple plot (Figure 1). After generating the plot, I asked the audience what we could learn from this graph. I was expecting to hear that the early 1900s – the time between Teddy Roosevelt and Franklin Roosevelt – was a time of massive use of executive orders. Continue reading

Posted in Civics Through Spreadsheets, Excel, History Through Spreadsheets | 3 Comments