Twenty-two supply items counted, valued with one formula each and formatted for print: this is IT153's Unit 1 workbook, finished, with a notes tab explaining it. Searches like "it 153 unit 1 assignment example", "it153 unit 1 sample" and "it153 unit 1 example" land here.
What a finished IT153 Unit 1 first workbook looks like
Two tabs. The first, renamed Stock Count, opens with a title in cell A1, the shop name and count date beneath it, and a header row in row 4: item number, description, unit, quantity on hand, unit cost and extended value. Twenty-two composite items fill rows 5 to 26, from letter paper by the ream to toner cartridges and spiral coils by the box. Quantities are whole numbers aligned right; unit costs and extended values carry the accounting format with two decimals. Column F multiplies quantity by unit cost in every row, and a single total at the foot adds column F. Text wraps in the description column, widths fit their contents, and the header row repeats if the list prints onto a second page. The second tab, About, explains the sheet in plain sentences.
How a IT153 Unit 1 example is structured
A first workbook is really a lesson in where things belong, and the example is arranged to show that. Identifying information sits at the top, separated from the data by a blank row so that sorting or selecting the table never drags the title along. Every column has one kind of content and one format: text left, numbers right, money in accounting format so dollar signs align. The only calculation, extended value, follows one pattern down the whole column, and the About tab states what it does in a sentence naming the cells involved. Units of measure get their own column rather than being typed into quantities as text, since 12 reams stored as text cannot be multiplied. Print settings, margins, orientation and a footer carrying the file name, are part of the finished file rather than an afterthought.
Title block above the data
Shop name, sheet title and count date in the first three rows, with a blank row separating them from the table so the data range stays clean for sorting and for the calculations later units add.
Six columns, six formats
Item numbers stored as text so leading zeros survive, descriptions wrapped, units as short labels, quantities as whole numbers, and both money columns in accounting format with matching decimals. No column mixes kinds of data.
The one formula
Extended value multiplies quantity on hand by unit cost, row by row. Changing a quantity changes its value and the total at once, which is the behavior a grader tests first in a first workbook.
Total and print layout
A SUM at the foot of column F with a top border above it, repeating print titles, one-inch margins and a footer carrying the file name and page number, so a printed copy identifies itself.
About tab
Four short paragraphs: what the workbook records, where each column's data comes from, what the extended value formula calculates, and the date the count reflects. This is where the formula explanation lives.
Where marks go in IT153 Unit 1
First workbooks lose points to structure more than to arithmetic. Numbers stored as text, often because a unit was typed into the same cell, as in 12 reams, break the one formula the sheet contains and show a small warning triangle a grader recognizes at once. Columns that mix formats, some costs with dollar signs and some without, some with three decimals, read as careless even when every value is right. Titles placed inside the data area, so the table has no clean edge, cause trouble later and are marked down in sections that grade layout. Tabs left as Sheet1, headers missing from printed pages and columns too narrow to display their values each cost a little. The strongest first workbooks are plain, consistent and explained in writing.
Get a IT153 Unit 1 example written to your instructions
Your IT153 section's Unit 1 data file, if one was provided, plus the instructions and rubric, give the sample everything it needs. When the prompt asks for a list of your own choosing, say what kind of items and roughly how many. Expect it within 24-48h, notes tab included; the first custom sample is free.
IT153 Unit 1 questions, answered
What does a first IT153 workbook usually need to include?
Most Unit 1 prompts ask for the basics done cleanly: a descriptive title, headed columns, correct number formats, a renamed worksheet and at least one formula that updates when an input changes. Some add print settings or a second sheet. Your rubric lists the exact items, and each one is usually a separate line, so nothing on it is safe to skip.
Why does Excel show a green triangle in some of my cells?
That marker usually means a number is stored as text, often because it was typed with a unit or pasted from another source. Excel cannot calculate with text, so any formula using that cell returns an error or ignores it. Converting the value back to a number, or moving the unit into its own column, clears the warning and restores the calculation.
Is the notes tab something my instructor expects?
Not always. Some IT153 sections ask for a short written explanation of the formulas, others grade the workbook alone. The sample includes one either way, because explaining each formula in words is the fastest route to understanding the file, and it can be removed or adapted if your instructions do not call for written documentation.