Attendance for thirty-one days and three sessions, summarized with SUM, AVERAGE, MIN, MAX and COUNT beside the data they read: the IT153 Unit 2 exercise, completed. Searches like "it 153 unit 2 assignment example", "it153 unit 2 sample" and "it153 unit 2 example" land here.
What a finished IT153 Unit 2 core formulas exercise looks like
The July sheet lists dates down column A, rows 5 to 35, with attendance for lap swim, open swim and lessons in columns B, C and D and a daily total in column E. Two days closed for storms are left blank rather than zeroed. Beneath the table, a summary block gives each session's monthly total with SUM, its average day with AVERAGE, its quietest and busiest days with MIN and MAX, and the number of days it actually ran with COUNT, which returns 29 because the blanks are skipped. A second block uses COUNTA on the date column to show 31 calendar days, so the gap between the two is visible. Averages display one decimal place; counts show none. A Formula Notes sheet explains each formula beside its text.
How a IT153 Unit 2 example is structured
The summary block is laid out as a small grid, sessions across and statistics down, so every result can be read against its neighbors and every formula in a row follows the same pattern. Each formula reads its own column's full date range, B5:B35 and so on, rather than a hand-picked subset, which keeps the results honest when a value changes. The blank storm days are a deliberate teaching point: AVERAGE and COUNT skip them, while a zero would drag the lap swim average down by more than two swimmers a day. That difference is spelled out in the Formula Notes. Daily totals in column E use SUM across each row, so the sheet demonstrates both directions of a range. A two-sentence conclusion under the grid states which session needs extra lifeguards on its busiest days.
Daily attendance grid
Thirty-one dated rows, three session columns and a row-wise SUM in column E. Only the attendance counts are typed; every total is calculated, and the two closed days hold empty cells.
Monthly totals and averages
SUM and AVERAGE for each session over rows 5 to 35, with averages rounded for display to one decimal. The formulas share a pattern across the row, differing only in the column letter.
Busiest and quietest days
MAX and MIN locate the extremes for each session. Open swim peaks on the holiday weekend, lap swim barely moves, and lessons dip in the final week, all visible in six cells.
COUNT against COUNTA
COUNT on a session column returns the days that session ran; COUNTA on the dates returns every day in the month. Two cells, side by side, make the difference between the functions impossible to miss.
Formula Notes sheet
Every formula displayed with FORMULATEXT beside a plain sentence saying what it reads and why, including a short explanation of why blanks and zeros produce different averages in this data.
Where marks go in IT153 Unit 2
Core-formula exercises lose the most points to ranges. A SUM that stops at row 34, missing the last day of the month, or an AVERAGE that runs into the totals row, produces results that look plausible and fail when a grader checks one figure against the data. Zeros typed into days with no activity change every average and every minimum; a MIN of zero on a session that never had an empty day is a common giveaway. Hand-counted days typed into the count cell, instead of COUNT, break as soon as a date is added. Smaller deductions follow averages shown to seven decimal places and summary cells with no labels beside them. The sheets that score well pair every result with a label and every formula with a range matching the data exactly.
Get a IT153 Unit 2 example written to your instructions
A data file from your IT153 section, the Unit 2 instructions and the rubric are what the sample is built from. If your prompt names particular functions or a required layout for the summary, point to them. The completed workbook, Formula Notes included, arrives within 24-48h, and the first custom sample is free.
IT153 Unit 2 questions, answered
What is the difference between COUNT and COUNTA?
COUNT tallies only cells holding numbers, while COUNTA tallies every cell that is not empty, text included. In an attendance sheet, COUNT on a session column gives the days that session ran, and COUNTA on a date or name column gives how many rows exist. Mixing them up returns a number that looks reasonable, which is why the slip is easy to miss.
Should an empty day be left blank or entered as zero?
It depends on what the zero would mean. If the pool was open and nobody came, zero is accurate and belongs in the average. If the pool was closed, a blank is more honest, since AVERAGE, MIN and COUNT skip blanks. Your prompt may settle it; if not, a note in the workbook saying which choice was made and why earns credit.
Can I use AutoSum, or does the formula need to be typed?
AutoSum produces an ordinary SUM formula, so graders see the same result either way. What matters is the range it chose. AutoSum guesses from nearby cells and can stop early at a blank or pull in a total, so the range in the formula bar is worth checking every time. The grade depends on the formula being right, not on how it was entered.