Haryana BSEH Senior Secondary NSQF IT-ITeS study plan

Build a four-sheet workbook that uses relative, absolute and mixed references to compute totals, percentages and growth rates with no hard-coded results.

Write nested IF, SUMIF, COUNTIF, ROUND and TEXT formulas to grade 20 student records and auto-flag pass or fail.

Apply VLOOKUP and INDEX-MATCH to pull marks from a separate lookup table, then repair three #N/A errors by checking data types and range boundaries.

Practise the home-row keys for 10 minutes daily and log speed and accuracy each day, aiming for 25 wpm at 92 percent accuracy by day seven.

Create column, pie and line charts from the week-1 workbook, add axis titles, data labels and legends, then move two charts to a dedicated chart sheet.

Sort a 50-row dataset on two levels, apply AutoFilter plus one custom numeric filter, and set the filtered result as the print range.

Format a three-page report in the word processor using heading styles, an automatic table of contents, headers, footers and page numbering.

Configure orientation, margins, print area and fit-to-page scaling, then export to PDF and compare the PDF against print preview.

Design three related tables with correct data types and assign a primary key to each and a foreign key to the child table.

Enforce referential integrity, then prove it works by attempting to delete a parent record and recording the exact error shown.

Write six SELECT queries using WHERE, ORDER BY, BETWEEN, IN and LIKE, including one calculated field and one alias.

Build a GROUP BY summary query with COUNT and SUM, and a second query that uses HAVING to filter the grouped result.

Create a keyboard-driven data-entry form with bound controls and a grouped report that sorts on one field and totals a numeric field.

Write five pseudocode solutions with matching flowcharts for sequence, selection and iteration problems, and dry-run each with sample values.

Code in Java or Python a program that reads five marks, computes the average and prints a grade using if-else-if ladder logic.

Test both programs against three input sets, including one invalid entry, and note how each handled the bad input.

Implement for, while and do-while loops to solve multiplication table, factorial and digit-sum problems, tracing each with a dry-run table of variable values.

Declare, initialise and traverse one-dimensional and two-dimensional arrays, then write programs to find the largest element and reverse an array in place.

Code linear search and bubble sort on an array of ten numbers and count the comparisons each makes on the same input.

Debug three faulty programs by reading the compiler or interpreter messages, correcting syntax errors first and logic errors second.

Run a mail merge from a spreadsheet data source to 15 recipients using three merge fields, a conditional greeting line and one filtered subset.

Save the merged output as individual documents and print two records to PDF to confirm field placement and no blank lines.

Create a reusable template with saved styles, placeholder text and a fixed header so a new letter can be produced in under two minutes.

Hand-code an HTML page with doctype, head, headings, paragraphs, an image, an ordered list and a hyperlink, then verify correct tag nesting and closing.

Build a six-slide presentation on a slide master with a consistent theme, one native chart, one inserted image and speaker notes for every slide.

Add transitions and entrance animations, set automatic slide timings, and rehearse the deck aloud to finish under four minutes.

Embed an audio narration or a video file plus an external hyperlink, then test both in full-screen slideshow mode on the exam-style setup.

Complete a one-page data-entry exercise at 30 wpm with 95 percent accuracy and fill 20 form fields using only Tab, Enter, arrow keys and Ctrl shortcuts.

Map the IT-ITeS sub-sectors to six job roles, stating the NSQF level, entry qualification, core skill and next promotion step for each.

Explain ergonomic workstation setup, electrical and fire safety steps, and four green IT practices covering e-waste, power management, duplex printing and recycling in a one-page note.

Draft a 60-second self-introduction and a one-page CV targeted at a data-entry operator or junior developer opening.

Assemble the portfolio from weeks 1 to 7 with a three-line reflection per artifact and rehearse answers to six likely viva questions without notes.