PRC 110: Software Skills Practicum — Pokhara University

Faculty of Management Studies • Year 1, Semester I • Credit hours: 1.0 • Total hours: 16 • Level: Bachelor (BBA/BBA-Finance)

Course code: PRC 110 Nature: Practical • Continuous Evaluation (No Semester-End Exam) Pass marks: 45 (Full marks: 100)
4 Units
18 Notes
10 Slides
Assignments
ℹ️ Overview

Four practical units covering fundamental software skills essential for business students.

Unit 1: Installing Software in a Computer (2 Hours)

Understanding software types, installation procedures, and network configuration.

2

Introduction to Software and Types

Understanding different types of software and their roles in computer systems

⏱️ 30 minutes
3

Installing Software on Windows

Step-by-step guide to installing software including MS Office and SPSS

⏱️ 45 minutes
4

Network Setup and Configuration

Setting up network connections, IP addresses, firewall, antivirus, internet, and email

⏱️ 45 minutes
✏️

Unit 1 Practical Assignment: Software Installation and Network Setup

Hands-on practical assignment for installing software and configuring network settings

⏱️ 2 hours

Unit 2: MS Word (4 Hours)

Master document creation, formatting, and advanced features in Microsoft Word.

6

MS Word: Font and Paragraph Formatting

Master font styles, sizes, colors, and paragraph formatting in Microsoft Word

⏱️ 45 minutes
7

MS Word: Inserting Charts, Hyperlinks, and Other Elements

Learn to insert and format charts, hyperlinks, headers, footers, page numbers, text boxes, equations, and symbols

⏱️ 45 minutes
8

MS Word: Page Layout and Formatting

Master page margins, orientation, size, indents, spacing, page breaks, and section breaks

⏱️ 45 minutes
9

MS Word: Advanced Features

Create automated table of contents, footnotes, citations, bibliography, table of figures, and mail merge

⏱️ 1 hour
10

MS Word: Proofing and Collaboration Tools

Use spelling and grammar check, comments, and track changes for document collaboration

⏱️ 30 minutes
✏️

Unit 2 Practical Assignment: MS Word Mastery

Comprehensive practical assignment covering all MS Word formatting and features

⏱️ 4 hours

Unit 3: MS Excel (6 Hours)

Learn data management, analysis, and advanced functions in Microsoft Excel.

12

MS Excel: Data Management Basics

Master sorting, filtering, conditional formatting, text-to-column, data validation, print titles, and freeze panes

⏱️ 1 hour
13

MS Excel: Pivot Tables and Charts

Create and customize pivot tables and pivot charts for data analysis

⏱️ 1 hour
14

MS Excel: Cell Referencing and Types

Understand relative, absolute, and mixed cell references in Excel formulas

⏱️ 45 minutes
15

MS Excel: Essential Functions

Master logical, lookup, statistical, mathematical, financial, and date/time functions

⏱️ 2 hours
16

MS Excel: Linking Workbooks and Worksheets

Link data between worksheets and workbooks for dynamic reporting

⏱️ 30 minutes
✏️

Unit 3 Practical Assignment: MS Excel Mastery

Comprehensive practical assignment covering all MS Excel features and functions

⏱️ 6 hours

Unit 4: MS PowerPoint (4 Hours)

Create professional presentations with advanced features and animations.

18

MS PowerPoint: Presentation Design Guidelines

Learn best practices for creating effective and professional PowerPoint presentations

⏱️ 30 minutes
19

MS PowerPoint: Slide Layout and Formatting

Master slide layouts, font and paragraph formatting in PowerPoint

⏱️ 45 minutes
20

MS PowerPoint: Inserting Tables, Charts, and Hyperlinks

Insert and format tables, charts, hyperlinks, slide numbers, footers, and date/time

⏱️ 45 minutes
21

MS PowerPoint: Advanced Features

Master animations, transitions, slide show setup, narration, rehearse timings, and master slides

⏱️ 1 hour
✏️

Unit 4 Practical Assignment: MS PowerPoint Mastery

Comprehensive practical assignment covering all MS PowerPoint features

⏱️ 4 hours

Complete collection of course notes organized by order.

U

Course Syllabus: PRC 110 Software Skills Practicum

Complete syllabus for PRC 110 Software Skills Practicum - Pokhara University

U1

Introduction to Software and Types

Understanding different types of software and their roles in computer systems

⏱️ 30 minutes
U1

Installing Software on Windows

Step-by-step guide to installing software including MS Office and SPSS

⏱️ 45 minutes
U1

Network Setup and Configuration

Setting up network connections, IP addresses, firewall, antivirus, internet, and email

⏱️ 45 minutes
U2

MS Word: Font and Paragraph Formatting

Master font styles, sizes, colors, and paragraph formatting in Microsoft Word

⏱️ 45 minutes
U2

MS Word: Inserting Charts, Hyperlinks, and Other Elements

Learn to insert and format charts, hyperlinks, headers, footers, page numbers, text boxes, equations, and symbols

⏱️ 45 minutes
U2

MS Word: Page Layout and Formatting

Master page margins, orientation, size, indents, spacing, page breaks, and section breaks

⏱️ 45 minutes
U2

MS Word: Advanced Features

Create automated table of contents, footnotes, citations, bibliography, table of figures, and mail merge

⏱️ 1 hour
U2

MS Word: Proofing and Collaboration Tools

Use spelling and grammar check, comments, and track changes for document collaboration

⏱️ 30 minutes
U3

MS Excel: Data Management Basics

Master sorting, filtering, conditional formatting, text-to-column, data validation, print titles, and freeze panes

⏱️ 1 hour
U3

MS Excel: Pivot Tables and Charts

Create and customize pivot tables and pivot charts for data analysis

⏱️ 1 hour
U3

MS Excel: Cell Referencing and Types

Understand relative, absolute, and mixed cell references in Excel formulas

⏱️ 45 minutes
U3

MS Excel: Essential Functions

Master logical, lookup, statistical, mathematical, financial, and date/time functions

⏱️ 2 hours
U3

MS Excel: Linking Workbooks and Worksheets

Link data between worksheets and workbooks for dynamic reporting

⏱️ 30 minutes
U4

MS PowerPoint: Presentation Design Guidelines

Learn best practices for creating effective and professional PowerPoint presentations

⏱️ 30 minutes
U4

MS PowerPoint: Slide Layout and Formatting

Master slide layouts, font and paragraph formatting in PowerPoint

⏱️ 45 minutes
U4

MS PowerPoint: Inserting Tables, Charts, and Hyperlinks

Insert and format tables, charts, hyperlinks, slide numbers, footers, and date/time

⏱️ 45 minutes
U4

MS PowerPoint: Advanced Features

Master animations, transitions, slide show setup, narration, rehearse timings, and master slides

⏱️ 1 hour

Interactive Reveal.js presentation slides for classroom learning and review.

U1

Unit 1: Introduction to Software & Network Setup

Lecture slides for PRC 110 Unit 1: Software Installation and Network Setup.

U2

Unit 2.1: MS Word Basics - Formatting

Lecture slides for PRC 110 Unit 2.1: MS Word Font and Paragraph Formatting.

U2

Unit 2.2: MS Word Layout & Inserting

Lecture slides for PRC 110 Unit 2.2: Page Layout and Inserting Elements.

U2

Unit 2.3: MS Word Advanced Features

Lecture slides for PRC 110 Unit 2.3: Mail Merge, References, and Collaboration.

U3

Unit 3.1: MS Excel Fundamentals

Lecture slides for PRC 110 Unit 3.1: Excel Interface, Formatting, and Referencing.

U3

Unit 3.2: Formulas and Functions I

Lecture slides for PRC 110 Unit 3.2: Basic Excel Formulas and Functions.

U3

Unit 3.3: Advanced Formulas & Data Management

Lecture slides for PRC 110 Unit 3.3: Logical Functions, VLOOKUP, and Sorting.

U3

Unit 3.4: Data Visualization & Reporting

Lecture slides for PRC 110 Unit 3.4: Pivot Tables, Charts, and Summary Reporting.

U4

Unit 4.1: PowerPoint Fundamentals

Lecture slides for PRC 110 Unit 4.1: Design Guidelines and Basic Slides.

U4

Unit 4.2: Advanced PowerPoint

Lecture slides for PRC 110 Unit 4.2: Animations, Transitions, and Master Slides.

Practical assignments for each unit to reinforce your learning.

Unit 1

Unit 1 Practical Assignment: Software Installation and Network Setup

Hands-on practical assignment for installing software and configuring network settings

⏱️ 2 hours
Unit 2

Unit 2 Practical Assignment: MS Word Mastery

Comprehensive practical assignment covering all MS Word formatting and features

⏱️ 4 hours
Unit 3

Unit 3 Practical Assignment: MS Excel Mastery

Comprehensive practical assignment covering all MS Excel features and functions

⏱️ 6 hours
Unit 4

Unit 4 Practical Assignment: MS PowerPoint Mastery

Comprehensive practical assignment covering all MS PowerPoint features

⏱️ 4 hours

📘 Course Description

This introductory course is intended for students interested in learning to use the computer as a productivity tool. Course content includes the fundamentals of basic software like Operating System, MS Word, MS PowerPoint and MS Excel.

🎯 General Objectives

  • To familiarize the students with fundamental computing software and their basic functions.
  • To equip the students with practical knowledge of MS Windows, MS Word, MS Excel and MS PowerPoint.

🧭 Methods of Instruction

Interactive sessions, discussion, group work, role plays, feedback and coaching.

✅ Evaluation & Students' Responsibilities

Evaluation System

Both internal and external evaluations will be based on attendance, assignment, class participation, self-reflection, project work, and presentation of the project report learning and practicals. The faculty will provide final grades of the students.

Note: There will be no semester end examination and all evaluations will be conducted continuously throughout the semester.

Pass marks: 45/100 • Attendance requirement: 80%

Students' Responsibilities

  • Attend all classes/sessions
  • Complete all assignments within specified time
  • Cover missed topics independently if absent
  • No provision for re-exam if formal exam/quiz is missed

📚 Reference Materials

Text Books: None prescribed.

References:

  • Tillery, N. (2023). Excel 2023 Essentials: A Step-by-Step Guide. Smashwords.
  • Lambert, J. & Frye, C. (2022). Microsoft Office Step by Step Office 2021 and Microsoft 365. Microsoft Press.
  • Habraken, J. (2021). Microsoft Office Inside Out (Office 2021 and Microsoft 365). Microsoft Press.