Data dictionary

Item Number

: This field is a sequential number assigned during the year. The year was added to

the item number to create a unique identifier for each transaction.

Category of Gov

: This field indicates whether the transaction relates to Education, General

Government, or Public Works, the three divisions of government for the City of Somerville.

Vendor Name

: This field contains the name of the entity related to the transaction.

Amount

: This field is the amount of the check.

Check Date

: This field is the date that the check was written.

Department

: This field is the department within the Category of Government related to this

transaction.

Check #

: This field is the sequential check number.

Org Description

: This field gives additional detail about the specific organization within the

general Department related to this transaction.

Account Desc

: This field provides additional detail about the purpose of the transaction.

Item Class

: This is the only fictitious field that was added to Somerville's dataset. This field

attempts to classify Somerville's checkbook items into broad classes for ease of analysis and

interpretation.

Requirements

For each of the following requirements, create a new pivot table in a new worksheet. Name each new

worksheet as "Req 1," "Req 2," etc. Format the dollar amounts in each pivot table or pivot chart using

the accounting format with zero decimal places. Format non-currency numbers in each pivot table or

pivot chart using the accounting format with zero decimal places.

1.

From 2013 - 2016, what was the total spending in each of the four calendar years? Is spending

trending up, trending down, or remaining stable