Lab Activity: Application Packages
Comprehensive Laboratory Work Guide
Grade XI • Computer Science ⏱️ ~25 minBy the end of this lab activity, you will be able to:
- Create and format professional documents using word processing tools
- Build spreadsheets with formulas, functions, and data visualization
- Design effective presentations with multimedia elements
- Create and manage database structures using MS Access
- Apply office productivity tools to real-world business scenarios
Real-World Application: These skills are essential for office administration, business management, academic work, and any professional environment requiring document and data management.
Task: Open a word processing program (e.g., Microsoft Word) on your computer, type the following exact text into a new document, and perform the actions listed below.
Computer in Near Future
Today the computer has affected all aspects of people's lives. It has become a need in our daily activities. In this century, computer has changed the style of our daily activities. In near future, we shall totally depend on the computer. In the near future, the advancement in computer technology will occur in the following areas:
- Hardware
- Software
- Communication and Networks
- Robotizes
Hardware
In future the nanotechnology will be used to build molecular devices. The molecular devices will have an extra ordinary computing speed of power. The following hardware devices will be commonly used in near future:
- Atomic Quantum Computer: In future the personal computer (PCs) will be replaced by quantum computer (Qcs). The speed of Qcs will be up to a billion times faster than today's Pentium IV computers. In these computers quantum mechanics will be used rather than digital technology.
- Optical computers: In future the optical technology will be used in computer. Due to this technology the computing speed will increase and physical size of computers will also reduce.
- Storage Device: In future the storage capacity will be in terabytes. The holographic video storage devices are also intercedes. Its storage capacity will be up to 1000 terabytes or more. Its life will be 50 years or more.
- Select the first paragraph and copy it to the very end of the document.
- Select the second paragraph ("Hardware..."), cut it, and paste it at the beginning of the document.
- Delete the current first paragraph.
- Use the Undo command repeatedly until the document returns to its original state (how it looked before Step 1).
- Use the Redo command once to re-apply the very last action.
- Check the entire document for spelling and grammar mistakes and correct them (e.g., *computere*, *live*, *phisical*, *storrage*).
- Use the Find and Replace feature to change all instances of the phrase "near future" to "future".
- Save the document with the filename:
Computer in near future
Task: Create and design a professional one-page publication notice layout containing the following details:
Einstein Academy
Announces admission open for the Bachelor of Business Studies (BBS) programs
Affiliated to Tribhuvan University
Einstein College was established in 2001 AD, as a modern and dynamic education institution imparting quality education in an affordable and conducive environment.
Eligibility:
| Passed level | Preferred grade |
|---|---|
| 10+2 | At least 'D+' grade |
Application Process:
The admission form is available at the college reception. The admission must be filled up and submitted along with following documents:
- Academic Transcript of grade 11 and 12
- Character Certificate
- Migration Certificate
Salient Features:
- Founded & run by a team of veteran academicians with decades of working experience in Nepal & abroad, accompanied by a team of well-qualified, dynamic & dedicated faculty.
- Excellent Academic Environment in a unique system at state-of-art facilities with scholarship scheme.
- Outstanding BBS result and Top Ten +2, honored by NEB.
For Details Contact:
EINSTEIN ACADEMY
Thasikhel, Mahalaxmi Chowk, Ring Road, Lalitpur-14
Tel - 5170418, 5171139
Task: Prepare a structured professional two-column resume template. Organize your layout to match professional standards including sections for: Contact Info, Career Objective, Technical Skills, Experience/Academic Background, Hobbies, and Languages.
View Modern Resume Sample (Professional Blueprint)
Kedar Pd. Bhandari
Computer Science Teacher & STEAM Specialist
Technical Skills
- Languages: C/C++, Python, HTML5, CSS3, SQL
- Tools: MS Office, Google Workspace, Git/GitHub
- Core: Hardware Troubleshooting, STEAM Pedagogy
Education
MPhil in STEAM Education
Kathmandu University | 2025
B.Sc. in CSIT
Amrit Campus, TU | 2013
Languages
English (Fluent), Nepali (Native)
Professional Summary
Dedicated Educator & STEAM Specialist with over 10 years of experience. Expert in student-centered learning and pedagogy. Committed to bridging the digital divide through innovative teaching and continuous academic research.
Experience
Faculty of Computer Science
2020 – PresentEinstein Academy, Lalitpur
- Modernized CS curriculum with activity-based learning.
- Mentored students through technical projects.
Head of Computer Science
2018 – 2019Yangrima Boarding School
- Managed CS department and updated IT literacy program.
Task: Create a formal student's final report following the strict formatting requirements below. This task tests your ability to manage long documents with consistent styling, sections, and automated features.
Part A: General Formatting Requirements
- Font: Times New Roman, Size: 12 pt.
- Line Spacing: 1.5 line spacing.
- Margins: 1 Inch on all sides.
- Paragraphs: Left Alignment and 0.5 Inch Indentation (Except for Abstract/Front Matter sections).
- Page Numbering: Starting from cover page but not visible on the cover page. Position: Top right.
Part B: Heading Levels & Style Definitions
- Heading One: Centered, Bold, Capitalize First Letter of major words. Spacing: 0pt before/after.
- Heading Two: Left Aligned, Bold, Capitalize First Letter of major words. Spacing: 0pt before/after.
- Heading Three: Left Aligned, Bold and Italicized, Capitalize First Letter of major words. Spacing: 0pt before/after.
- Heading Four: 0.5" indentation, Left Aligned, Bold, Capitalize First Letter, Period at end. Text follows immediately after title.
- Heading Five: 0.5" indentation, Left Aligned, Bold and Italicized, Capitalize First Letter, Period at end. Text follows immediately after title.
Part C: Document Structure
Your paper must include the following sections in order:
- Title Page
- Letter of Approval
- Acknowledgements
- Table of Contents
- Introduction
- Chapters (with sub-headings)
- Conclusions
- References
- Appendixes (if applicable)
View Sample Formatting & Layout (Expand to check)
Video provides a powerful way to help you prove your point. When you click Online Video, you can paste the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document. To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other.
Video provides a powerful way to help you prove your point. When you click Online Video, you can paste in the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document. To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other.
Video provides a powerful way to help you prove your point. When you click Online Video, you can paste in the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document. To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other.
Heading Four. I could not write in any other way because this was not a dissertation in a conventional sense; this was the crystallization of my lived experiences. These experiences might be viewed as a science teacher's transformation and present reality for me.
Note: The same system will be followed throughout all chapters.
Task: Create the worksheet layout below and enter the correct multiplication and sum formulas into Column D and Cell D6.
| Cell | A (ITEM) | B (RATE) | C (QTY) | D (TOTAL) |
|---|---|---|---|---|
| 1 | ITEM | RATE | QTY | TOTAL |
| 2 | Book | 300 | 10 | =B2*C2 |
| 3 | Copy | 100 | 20 | =B3*C3 |
| 4 | Pencil | 10 | 100 | =B4*C4 |
| 5 | Pencil | 50 | 50 | =B5*C5 |
| 6 | =SUM(D2:D5) |
Task: Build a complete hardware sales invoice with dynamic parameters.
| S.N. | Particulars | QTY | Rate | Amount Formula |
|---|---|---|---|---|
| 1 | monitor | 5 | 12000 | = QTY * Rate (e.g., =C2*D2) |
| 2 | printer | 3 | 7000 | |
| 3 | scanner | 6 | 3500 | |
| 4 | keyboard | 10 | 300 |
Required Calculations:
- Total Amount: =SUM(E2:E13)
- VAT (13%): =Total_Amount * 13%
- Grand Total: =Total_Amount + VAT_Amount
Sub-Tasks:
Q. 2(a): Add a column labeled "Delivery Charge" (Column F). Assign a flat value of Rs. 50 to each line item row, then revise your formulas to incorporate it into the row's total amount.
Q. 2(b): Modify your VAT parameter cell from 13% to 15% and verify the dynamic updates across your Grand Total field.
Task: Prepare a school terminal result ledger sheet supporting columns from A to M. Input records for 8 to 10 students and apply the following exact logical definitions:
=SUM(D2:I2)
PERCENTAGE (Cell K2):
=J2/600*100
RESULT (Cell L2): (Pass marks criteria: >32 across all individual subjects)
=IF(AND(D2>32, E2>32, F2>32, G2>32, H2>32, I2>32), "PASS", "FAILED")
DIVISION (Cell M2):
=IF(K2>79, "DISTINCTION", IF(K2>59, "FIRST", IF(K2>44, "SECOND", "THIRD")))
*Subjects: D: English, E: Maths, F: Science, G: Computer, H: O.B.T, I: Social.
Task: Input the following sample data array into an empty grid sheet and generate a combined Column-Line chart with legends mapping series performance metrics.
| Category | Series One | Series Two |
|---|---|---|
| alpha | 1 | 2 |
| beta | 3 | 4 |
| gamma | 2 | 3 |
| delta | 4 | 5 |
| epsilon | 3 | 4 |
| zeta | 5 | 6 |
Requirement: Create a 10–12 slide deck using presentation software (e.g., PowerPoint).
- Topic: Your CS educational path or a domain you're passionate about
- Features: Text layouts, graphics, charts, animations, transitions
Objective: Design a relational database named Einstein_Academy.accdb to manage student and faculty information.
- Table Definitions: Create Student Details table with fields: StudentID (PK), FirstName, LastName, DateOfBirth, ContactNumber, EmailAddress.
- Relational Configurations: Link tables using primary/foreign keys with "Enforce Referential Integrity" enabled.
- Forms Design: Create an input form to log 5-10 student records.
- Queries: Build filters to fetch records (e.g.,
Marks > 70orLastName = "Rai"). - Report Generation: Use Report Wizard to create printable layouts.
Integration Challenge: Office Suite Workflow
Create a complete workflow demonstrating integration between office applications:
- Extract student data from your Access database into Excel
- Create a summary report in Word with embedded Excel charts
- Build a 5-slide presentation summarizing your findings
- Include data from all three applications in your final output
What to Expect in the Assessment:
- 10 canvas tasks testing your knowledge of all four application packages
- Multiple-choice questions on concepts and features
- Visual verification tasks for formatting and design
- Real-time score tracking and submission to Google Forms
Key Points to Remember:
- Know keyboard shortcuts for common operations
- Understand the difference between absolute and relative cell references
- Remember document formatting best practices
- Review database relationship concepts
Practice Recommendations:
- Complete at least one task from each part
- Practice the challenge integration task
- Review formulas and functions used in spreadsheet tasks
- Ensure all software is properly installed before assessment