For IT153 Unit 7, a 180-row maintenance log becomes three readable answers through custom sorts, filtered copies and conditional formatting rules, all shown finished. Searches like "it 153 unit 7 assignment example", "it153 unit 7 sample" and "it153 unit 7 example" land here.
What a finished IT153 Unit 7 data filtering exercise looks like
The Log sheet holds the requests as an Excel table named tblRequests: request number, building, unit, category, priority, vendor, date opened, date closed, cost and a calculated days-open column that counts to today for requests still open. A custom sort orders priority as Urgent, High, Normal, Low, then by date opened within each level. Three conditional formatting rules run on the table: open requests older than fourteen days fill light red through a formula-based rule, cost carries data bars, and days open shows a three-symbol icon set. A total row uses SUBTOTAL, so cost and count respond to whatever filter is applied. Three copies of the table, each on its own sheet, carry one filter apiece: Plumbing by Building, Open Over 14 Days and Vendor Response Times.
How a IT153 Unit 7 example is structured
The workbook treats every question as a view of the same data rather than a new data set. Converting the range to a table supplies the filters, banded rows and structured total row at once and keeps formulas readable, so days open refers to column names rather than cell addresses. Sorting uses a custom list because alphabetical order would put High first and Urgent last. Conditional formatting is rule-based rather than painted: the red fill comes from a formula comparing days open with 14 and checking that the close date is blank, so it updates tomorrow without anyone touching it. SUBTOTAL rather than SUM sits in the total row, since SUM keeps counting hidden rows. Each filtered sheet is named for its question, and a notes tab records the filter criteria behind each one so the views can be rebuilt exactly.
Table and calculated column
One hundred eighty composite rows in tblRequests, with days open calculated from the open date to the close date, or to today where the close date is blank. Structured references keep the formula readable.
Custom sort by priority
Priority sorted as Urgent, High, Normal, Low from a custom list, then by date opened. Alphabetical order would have listed Urgent at the bottom, exactly backward for a maintenance team reading from the top.
Three formatting rules
A formula rule fills open requests older than fourteen days in light red, data bars show relative cost, and an icon set grades days open. The rules manager lists all three, each applied to its table column.
Filters and a SUBTOTAL row
The total row uses SUBTOTAL, so count and cost describe only the visible rows. Filtering to plumbing in Building C, for instance, changes the total to that subset rather than the whole log.
Question sheets and criteria notes
Three copies of the table, each filtered for one question and named after it, plus a notes tab recording the exact criteria behind each view so the answers can be reproduced.
Where marks go in IT153 Unit 7
Filtering exercises tend to lose points on answers that do not survive scrutiny. A total built with SUM beneath a filtered list keeps counting the hidden rows, so the plumbing cost reported is really the whole year's cost; that single substitution is among the most common deductions in this unit. Sorting only one column, rather than the whole table, scrambles the records, a mistake that may go unnoticed until a grader reads across a row. Conditional formatting applied by hand, cells colored red one at a time, does not update and usually earns nothing on the formatting row. Filters applied and then saved over, so the file opens showing one answer while the prompt asked for three, lose the other two. The strongest files keep each answer visible, named and reproducible from stated criteria.
Get a IT153 Unit 7 example written to your instructions
The questions your IT153 prompt asks of the Unit 7 data, plus the data itself and the rubric, shape the sample. Where the instructions specify particular sort orders, filter criteria or formatting rules, those are followed exactly. The finished workbook returns within 24-48h with its criteria notes, and the first custom sample is free.
IT153 Unit 7 questions, answered
Why doesn't my total change when I filter the list?
Because SUM includes hidden rows. SUBTOTAL with function number 9 sums only the rows a filter leaves visible, and 109 also skips rows hidden by hand. The total row of an Excel table uses SUBTOTAL automatically, and for counts, 3 or 103 do the same job. Graders often filter the list precisely to test this.
What is the difference between sorting and filtering?
Sorting reorders every row by one or more columns and hides nothing. Filtering hides the rows that do not meet a condition and leaves the order alone. Many IT153 prompts ask for both, often in sequence: a filter to narrow the list to one question, then a sort to rank what remains. Each graded view should say which was applied.
Can conditional formatting use a formula?
Yes, and many prompts in this unit expect it once the built-in highlight rules are covered. A formula rule applies formatting wherever the formula returns TRUE, which allows conditions that combine columns, such as a request that is both open and older than fourteen days. The formula is written for the first row of the range and adjusts for the rest, much like a copied formula.