GUI for thinking
Whatever bad things some people say about Microsoft, in the olden days they brought to market a raft of products, which were accessible, easy to use, and useful. MS Access is an example. It may have limitations as a commercial database engine, but as a sketch pad, a tool for collecting one's thought's, it is, in my opinion, hard to beat. My current task is to design a set of iterations through scoring rate data to render the scoring rate as an objective measure of student ability and item difficulty. The raw data is set out in a single table, as shown in my last blog . On this I have written two queries: SELECT [HAItemB].[sessidx], Avg([HAItemB].[rate]) AS AvgOfrate FROM HAItemB GROUP BY [HAItemB].[sessidx]; and SELECT HAItemB.item, Avg(HAItemB.rate) AS AvgOfrate FROM HAItemB GROUP BY HAItemB.item ORDER BY HAItemB.item; These queries calculate the average raw scoring rate for each session and each item. The item query looks like this: Item AvgOfrate ...