UPMSP Vocational IT/ITeS study plan

Type a 3-minute passage at 25+ words per minute with at least 95% accuracy using correct home-row finger placement, and log the score for three separate attempts.

Set up and demonstrate at least eight keyboard shortcuts (cut, copy, paste, undo, redo, save, find, select-all) during a timed editing drill without touching the mouse.

Enter 100 mixed alphanumeric and numeric records into a prepared table in under 12 minutes with no more than 3 errors, then verify the entries against the source list.

Identify five IT-ITeS sub-sectors (IT services, BPO, KPO, GIS/remote sensing, engineering and design) and match each to one typical entry-level job role.

Describe the difference between IT services and IT-enabled services in five sentences, giving one real work example of each.

Produce a two-page word-processed report using heading styles, a title page, 1.5 line spacing, justified body text and consistent margins.

Insert and format a 5-column data table, two bulleted lists, one numbered list and one image with square text wrapping inside the report.

Run spell-check, use find-and-replace to correct one repeated term, turn on track changes, accept all changes, and export the finished file to PDF.

Explain in three sentences why a consistent folder structure and file-naming convention (name, date, version) matter when several people edit office documents.

Build a 30-row worksheet with a header row, frozen top pane, data validation on two columns and correct cell formats for currency, date and percentage.

Write working formulas using SUM, AVERAGE, COUNT, COUNTA and IF, and demonstrate why absolute references ($A$1) behave differently from relative ones when copied.

Sort the dataset by two columns, apply an AutoFilter for one criterion, and build a column chart plus a pie chart with titles, axis labels and data labels.

Compare relative and absolute cell references in a short written note with one worked example of each.

Clean a supplied comma-separated data file by removing duplicate rows and blank records, then summarise it with a pivot-style table or SUMIF totals.

Define table, record, field, primary key and foreign key, and sketch a three-table schema for a small library or retail case with keys marked.

Create the sketched tables in a database tool using appropriate data types, set a primary key, and insert at least 10 valid records.

Write and run four SELECT queries that use WHERE filtering, ORDER BY sorting and one aggregate function such as COUNT or SUM.

Write a valid HTML5 page from scratch containing doctype, head metadata, heading levels, paragraphs, an ordered and an unordered list, hyperlinks and an image with descriptive alt text.

Create an external stylesheet that applies a font stack, colour scheme, padding, margin and border, and demonstrate at least one class selector and one id selector.

Break a sample URL into protocol, domain, path and query string, and explain in four sentences when HTTPS matters and how to check a site certificate.

Use three advanced search operators (site:, filetype:, quoted phrase) to find a specific document and judge two candidate sources for credibility and recency.

Validate the week-5 website with an HTML/CSS validator and correct at least five reported errors or warnings until the pages pass.

Build a six-slide presentation using a single theme, a title slide, one slide with a table or chart, and speaker notes on at least three slides.

Apply one slide master edit, one transition applied to all slides, and one entrance animation; then export the deck as a PDF handout.

Insert an image and a short audio or video clip, resize the image without distortion, and state file-size limits that affect sharing by email.

Draft three workplace communications - a formal email with subject line and signature, a short memo, and a 60-second self-introduction - using tone and register appropriate to each audience.

Script and perform a customer telephone role-play that demonstrates active listening, paraphrasing, hold etiquette and a clear closing summary.

Identify five workplace hazards (loose cabling, electrical overload, poor posture, glare, blocked fire exit) and state one corrective action for each.

Apply an ergonomic workstation check covering chair height, monitor top at eye level, wrist position and the 20-20-20 rule, recording the result as a pass or fix item.

List four green IT practices (power-management settings, duplex printing, safe e-waste disposal, virtual meetings) and two data-security habits (strong unique passwords, two-factor authentication).

Write five SQL queries against a two-table database covering WHERE filtering, ORDER BY, COUNT, GROUP BY and a simple inner join on the primary and foreign key.

Explain three entrepreneurial traits and three customer-service standards, giving one concrete example of how each affects an IT-ITeS client relationship.

List four IT-ITeS career pathways (data entry operator, technical support, web designer, database assistant) with the entry qualification and one next-step certification for each.

Complete one full-length timed mock test covering all ten domains, score every section, and write a corrective plan for the two weakest domains.