PRC 110: Software Skills Practicum — Pokhara University

Open Microsoft Word and create a new blank document. Apply the following page settings:

• Paper size: A4
• Margins: Top — 1 inch, Bottom — 1 inch, Left — 1.25 inches, Right — 1 inch
• Line spacing: 1.5 lines; Paragraph spacing: 6 pt After

Save the file as A_Word_[RollNo].docx. All remaining Word tasks must be done in this same file.

Type the following passage exactly as given and apply the formatting instructions:

• Apply Heading 1 style to the title; centre-align it
• Apply Normal style to the body paragraph; justify it
• Bold and underline the phrase "competitive edge through efficiency and innovation"
• Change the font of the entire body paragraph to Times New Roman, 12 pt
• Apply a yellow highlight to the phrase "word processors, spreadsheets, and presentation software"

Insert a table with 5 columns and 5 rows after the paragraph above. Use the data below:

• Shade the header row with a dark blue background and white bold text
• Set all cell borders to 0.5 pt solid black
• Add a new row at the bottom; merge all cells in column 1–3 and type "Total"; in column 4 type the sum (294)
• Centre-align all numeric cells

• Insert a header: course name "PRC 110: Software Skills Practicum" left-aligned; your full name right-aligned
• Insert a footer: the text "Model Lab Test — Set A" centred; page number in the format Page 1 of 1 on the right
• Enable Different First Page so the header/footer is suppressed on page 1

• Add a second Heading 1 section titled "Conclusion" on a new page and type two sentences of body text beneath it
• Place the cursor at the very beginning of the document (before your title) and insert a page break to create a blank page
• On the blank page, insert an automatic Table of Contents using References > Table of Contents > Automatic Table 2
• Update the TOC to ensure both headings appear

Create a mail merge to produce personalised invitation letters:

• Start a new document. Use Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard
• Select Letters as document type; use the current document as the starting document
• Create a new recipient list with three contacts using fields: First Name, Last Name, City
  • Rajan | Sharma | Pokhara
  • Sunita | Basnet | Kathmandu
  • Mohan | Karki | Butwal
• In the letter body, type: "Dear <<First_Name>> <<Last_Name>>, You are invited to the seminar in <<City>>." with appropriate merge fields inserted
• Preview all three letters and complete the merge to a new document
• Save the merged result as A_Merge_[RollNo].docx

Rename Sheet1 to Sales. Enter the following data starting from cell A1:

• Header row: bold, dark orange background, white text, all borders
• Format column C and D as Number with the thousands separator (e.g., 30,000)
• Set column widths to fit content using Format > AutoFit Column Width
• Freeze the header row using View > Freeze Panes > Freeze Top Row

• In column D (Revenue), calculate Revenue = Units Sold × Unit Price using a relative reference formula and fill it down for all 6 rows
• In cell B10, use =SUM(B2:B7) to total units sold; label cell A10 "Total"
• In cell D10, use SUM to calculate total Revenue
• In cell D11, use =AVERAGE(D2:D7) for average Revenue; label A11 "Average"
• In cell D12, use =MAX(D2:D7); label A12 "Highest"
• In cell D13, use =MIN(D2:D7); label A13 "Lowest"
• In cell H1, enter the value 1000 and label G1 "Bonus per Product". In column F labelled "Bonus", calculate Bonus = H1 using an absolute reference (=$H$1) for all 6 rows

• In column G labelled "Status", use a nested IF function:
  • Revenue > 25,000 → "High"
  • Revenue > 10,000 → "Medium"
  • Otherwise → "Low"
• In cell B15, create a product lookup: label A15 "Look up product:" and type any product name in B15. In C15, use VLOOKUP to return the Revenue for that product: =VLOOKUP(B15,A2:D7,4,0)
• In cell A17, label it "Count of High Revenue products:". In B17, use COUNTIF to count how many products have Status = "High"
• In cell A18, label it "Total Revenue of High items:". In B18, use SUMIF to sum Revenue where Status = "High"

• Sort the data (rows 2–7) by Revenue in descending order
• Apply an AutoFilter to the header row (Data > Filter)
• Filter the data to show only rows where Discount is greater than 0
• Apply a Green–Yellow–Red colour scale conditional formatting to the Revenue column (D2:D7)
• Apply a conditional formatting rule to the Status column (G2:G7): cells containing "Low" → red fill, "High" → green fill

• Select the Product (A1:A7) and Revenue (D1:D7) columns and insert a Clustered Column chart
• Add chart title: "Product Revenue Comparison"; label the X-axis "Product" and Y-axis "Revenue (NPR)"
• Move the chart to its own sheet named "Revenue Chart"
• Create a Pivot Table on a new sheet named "Pivot" using the Sales data:
  • Rows: Product
  • Values: Sum of Revenue AND Average of Revenue (add Revenue twice, change one to Average)
• Insert a Pie chart from the Pivot Table showing each product's share of total revenue

• Slide 1 (Title Slide): Title — "Benefits of MS Office for Business Students"; Subtitle — your full name and roll number
• Slide 2 (Agenda): Title — "Topics Covered"; 4 bullet points: MS Word, MS Excel, MS PowerPoint, Summary
• Slide 3 (MS Word): Title — "MS Word"; list 4 key benefits as bullets (e.g., Professional documents, Mail Merge, Track Changes, TOC)
• Slide 4 (MS Excel): Title — "MS Excel"; list 4 key benefits (e.g., Data analysis, Charts, Formulas, Pivot Tables)
• Slide 5 (Summary/Thank You): Title — "Thank You"; add your institution name and date

• Apply a built-in design theme from the Design tab (do not leave it as the default blank theme)
• Ensure the slide size is set to Widescreen 16:9 (Design > Slide Size)
• On Slide 1, increase the title font to 40 pt, Bold; change the subtitle font to 20 pt, Italic
• On Slide 2, set the bullet text to 24 pt and increase bullet indent level for any sub-points

• On Slide 3, insert a SmartArt graphic (choose List > Vertical Bullet List) and add the four Word benefits as SmartArt items
• On Slide 4, insert a shape (rounded rectangle) with the text "Data is Power"; apply a fill colour and text style
• On Slide 1, insert a relevant stock image from Insert > Pictures > Stock Images; resize and position it neatly

• Apply the Fade transition (duration: 0.70 s) to all slides using Apply to All
• On Slide 2 (Agenda), add an entrance animation to the bullet list: Wipe — From Left, triggered After Previous with 0.3 s delay between each bullet
• On Slide 3, add a Fly In animation to the SmartArt, direction: From Bottom, On Click

• Open View > Slide Master. In the Master slide footer area (Insert > Header and Footer), type "PRC 110 Lab Test — Set A" and enable slide numbers on all slides except the title slide
• Change the master body text font to Calibri if it is not already
• Exit Slide Master view and verify the footer appears on slides 2–5
• Open Slide Show > Set Up Slide Show: select "Presented by a speaker (full screen)", set advance to Manually, and enable Use Presenter View
• Add speaker notes to Slide 2 (at least one sentence of notes) using the Notes pane

Open Microsoft Word and create a new blank document. Apply the following settings:

• Paper size: A4; Orientation: Portrait
• Margins: Narrow preset (Top/Bottom 1.27 cm, Left/Right 1.27 cm) — use Layout > Margins > Narrow
• Line spacing: 1.5 lines; Paragraph spacing: 12 pt Before, 6 pt After

Save the file as B_Word_[RollNo].docx. All remaining Word tasks must be done in this same file.

Type the following passage and apply the instructions:

• Apply Heading 1 style to the title; left-align it
• Apply Normal style to the body paragraph; justify it
• Change the body paragraph font to Georgia, 12 pt
• Italicise and colour the phrase "digital literacy has become as essential as reading and writing" in dark red (Dark Red, Accent 1)
• Apply a Drop Cap (Dropped, 3 lines) to the first letter of the body paragraph via Insert > Drop Cap

Insert a table with 4 columns and 6 rows after the passage. Use the data below:

• Apply a built-in table style: Table Grid 5 — Accent 1 (or closest available dark-header style)
• Sort the table rows by Basic Salary in descending order (Table Design > Layout > Sort)
• Add a final row: merge cells in columns 1–2, type "Total"; in column 3, use a Word formula =SUM(ABOVE) to total Basic Salaries
• Centre-align all salary figures; right-align the Employee Name column

• In the body paragraph, insert a footnote (References > Insert Footnote) at the word "practicum". Footnote text: "A practicum is a practical training component embedded in an academic programme."
• Add two citations using References > Manage Sources (style: APA):
  • Lambert, J. & Frye, C. (2022). Microsoft Office Step by Step. Microsoft Press.
  • Habraken, J. (2021). Microsoft Office Inside Out. Microsoft Press.
• At the end of the document, insert an automated bibliography using References > Bibliography > Insert Bibliography

• Enable Track Changes (Review > Track Changes > Track Changes)
• Make the following edits while tracking is on:
  • Insert the word "highly" before "productive" in the passage
  • Delete the phrase "like PRC 110" from the last sentence
  • Change "vital" to "essential"
• Insert a comment on the word "spreadsheets": comment text — "Consider elaborating on Excel functions here."
• Accept the insertion of "highly" and reject the deletion of "like PRC 110"

• Create a new paragraph style named "MyBodyStyle": based on Normal, font Arial, 11 pt, line spacing 1.5, first-line indent 1 cm
• Add two more sections to your document:
  • Section 2 heading (Heading 1): "Key Software Tools" — add one paragraph using MyBodyStyle
  • Section 3 heading (Heading 1): "Conclusion" — add one paragraph using MyBodyStyle
• Add a Section 2.1 (Heading 2) titled "Spreadsheets" under Section 2
• Insert a page break before the title, create a blank first page, and on it insert an automatic TOC (Automatic Table 1) showing Heading 1 and Heading 2 levels
• Update the TOC so all headings appear correctly

Rename Sheet1 to Employees. Enter the following data starting from A1:

• Header row: bold, dark orange background, white text, all borders
• Apply Data Validation to column B (B2:B9): allow a dropdown list with values HR, IT, Finance, Admin
• Freeze the header row (View > Freeze Panes > Freeze Top Row)

• In cell I1, enter the tax rate value 0.10 and label H1 "Tax Rate:"
• Column E (Gross): =C2+D2 — relative reference, fill down for all 8 rows
• Column F (Tax): =E2*$I$1 — absolute reference for the tax rate cell, fill down
• Column G (Net): =E2-F2 — fill down
• In row 11: use SUM for columns C, D, E, F, G — label A11 "Total"
• In row 12: use AVERAGE for columns C, E, G — label A12 "Average"
• In row 13: use MAX for column G (Net Salary) — label A13 "Highest Net"
• In row 14: use MIN for column G — label A14 "Lowest Net"

• In cell A17, label "Employee count by dept:". Use COUNTIF in B17:E17 to count employees in HR, IT, Finance, Admin respectively (label B16:E16 with dept names)
• In A19, label "Total Gross by dept:". Use SUMIF to sum Gross Salary for each department in B19:E19
• In A20, label "Avg Net by dept:". Use AVERAGEIF for average Net Salary per department in B20:E20
• In cell A22, label "Employee lookup:". Enter any employee name in B22. In C22, use INDEX-MATCH to return that employee's Net Salary:
  =INDEX(G2:G9,MATCH(B22,A2:A9,0))
• In D22, use VLOOKUP: =VLOOKUP(B22,A2:G9,6,0) to also return Tax amount; verify both results match

• Apply conditional formatting to the Net Salary column (G2:G9):
  • Net < 25,000 → red fill with dark red text
  • Net > 45,000 → green fill with dark green text
• Sort the data (A1:G9) by Department A→Z, then by Net Salary descending
• Apply an AutoFilter to the header row; filter to show only IT and Finance employees (use custom filter or select those values from the dropdown)
• Apply a Data Bar conditional formatting to the Gross Salary column (E2:E9) using any colour

• Create a new sheet named "Summary". In A1, type a cross-sheet formula ='Employees'!A1 to pull the header; use similar references to pull the Department total from your SUMIF results in the Employees sheet into the Summary sheet
• Create a Pivot Table from the Employees data on a new sheet named "Pivot":
  • Rows: Department
  • Values: Sum of Gross, Sum of Net, Count of Name
• Insert a Stacked Bar chart from the Pivot Table comparing Gross vs Net salary by department
• Add chart title: "Department Salary Overview"
• Insert a Slicer (PivotTable Analyze > Insert Slicer) for the Department field; use it to filter the pivot table to show only IT employees

• Slide 1 (Title): "How MS Office Improves Business Productivity"; your name as subtitle
• Slide 2 (Contents): List 4 sections — MS Word, MS Excel, MS PowerPoint, Conclusion
• Slide 3 (MS Word): Title + bullet list of 4 ways Word improves productivity + one stock image
• Slide 4 (MS Excel): Title + SmartArt showing a workflow (e.g., Data → Analysis → Chart → Decision)
• Slide 5 (MS PowerPoint): Title + a table with 2 columns and 4 rows comparing "Basic User" vs "Advanced User" features
• Slide 6 (Conclusion): Title "Key Takeaways"; 3 bullet points summarising what you learned; your institution name and submission date in the text area

• Open View > Slide Master
• Change the master background to a gradient (Format Background > Gradient fill — light to white)
• In the master title placeholder, change the font to Trebuchet MS, 36 pt, Dark Navy colour
• Add the text "Pokhara University" in the footer area of the master slide so it appears on all slides
• Create a custom slide layout (click "Insert Layout" in Slide Master view), name it "My Layout", and add a text placeholder titled "Key Point" — use it on Slide 6

• On Slide 4, insert a SmartArt — Process > Basic Chevron Process with 4 steps: Collect Data → Enter in Excel → Analyse → Report
• On Slide 5, insert a Bar Chart with sample data: Feature (Y-axis): Documents / Spreadsheets / Presentations; Users (bars): Basic / Advanced
• On Slide 6, insert a hyperlink on the text "Back to Contents" that links to Slide 2 (use Insert > Link > Place in This Document)

• Apply Push transition (0.5 s) to all slides using Apply to All
• On Slide 3, add Wipe (From Left) entrance animation to each bullet item; set order to After Previous with 0.4 s delay
• On Slide 4, add an Emphasis animation (Pulse) to the SmartArt graphic, triggered On Click
• Add speaker notes to Slides 2, 4, and 6 with at least one sentence of notes per slide

• Use Slide Show > Rehearse Timings to run through at least 3 slides and record timings
• Open Set Up Slide Show: choose Browsed at a kiosk (full screen) and set it to use the recorded timings; then switch back to Presented by a speaker
• Enable Use Presenter View and verify speaker notes appear in the notes panel
• Export the final presentation as a PDF using File > Export > Create PDF/XPS; save as B_PPT_[RollNo].pdf
• Insert slide numbers on all slides except the title slide via Insert > Header and Footer