BAP621S - BUSINESS APPLICATION 2B - 1ST OPP - NOV 2024


BAP621S - BUSINESS APPLICATION 2B - 1ST OPP - NOV 2024



1 Page 1

▲back to top


nAm I BI A UnlVERSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTYOF COMMERCE;HUMAN SCIENCEAND EDUCATION
Department of Governance & Management Science
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Business Applications 2B
COURSE CODE: BAP621S
DATE: November 2024
DURATION: 2 Hours
SESSION: Practical Paper
MARKS: 100
EXAMINER(S)
MODERATOR:
FIRST OPPORTUNITY - QUESTION PAPER
Ms L Tripodi
Ms P Louw
INSTRUCTIONS
1. Answer ALL the questions.
2. Read all the questions carefully before answering.
3. Make sure your name, s.urname, question number and the date
appear in the Header and Footer.
THIS TEST PAPER CONSISTS OF 5 PAGES (Excluding this front page)

2 Page 2

▲back to top


Question 1
1" Opportunity
November 2024
Question 1
Total: 40
RetrieveQuestion 1 with the Track Changesfrom your folder and adhere to the
instructions.Type document in Calibri,font size 12, s/s. Insert page numbers(Bottom of
page - centre) except for the first page. Insertdiagonalwatermark: ORIGINAL (u/c,
default font. Use Automatic Table2 for the TOC. Insert Reference List.
!Hyphen Hydrogen !Energy{.................................................................................
·•::···· Commented [TL 1]: Pleaseformat asfollows:
Font Calibri, size 18, bold, cent
I4.0deritz,.a.historic town.on Namibia's.southwestern coast, is set to become.a ............ .
beacon of sustainable energy innovation with the establishment of the new Hyphen ··...
Commented [TL2]: Insert Logo (in folder) on the top right
corner next to the heading, height 0.5''
Hydrogen Energyjcampu~,..................................................................................
·. Commented [TL3]: Insert Drop Cap- 2 lines, bold
1. jlntroductio~ ............................................................................................
.
Commented [TL4]: Us the following link to inert an
This ground:breaking project marks a significant step in Namibia's journey towards \\
intext•citation.
becoming
resources
atogclorebaatleleaasduesr tainin.9a_brl:e~~e!"nle.hr.gYy~f~u~tu9r.eE.!!1..P.~O.d.l:J.~~!9.!"l,.l:IJ!li~i_r:i.9.i_\\~..Y. \\..~\\~U._~h2.t1tt"p2!s1~:0/~/0w4?w6.w8~8._scIi~encedirect.com/science/a
rticle/pii/S 136403
Commented [TLS]: Format as heading 1, Black
2.~ Vision for a Green Future l........................................_.......F.o.n.t size16
Hyphen Hydrogen Energy, a joint venture between global energy leaders and local · Formatted: Font: (Default) Arial, Bold
partners.is committed to developing Namibia's potential in the green hydrogen
Commented [TLG]: Format as Heading 1, black, font size
sector.
16 bold
2.1 jNUST LOderitz Campus L......................................................-..·.·.C.o.m.m.e.n.te.d...[T.L.7.]:..F.o.rm.at as Heading2, font size14,
The LOderitz campus is the cornerstone of this vision, serving as a hub for:
'--a1_a_c__k ___________
_
!research,
development, and
production of green hydrogen. l.................................................·.·..·C.·o.mi.m..e.nt.e.d..[.T.LB..J: Insert bullets,s/s
~.2Solar Resource~ .............................................................................................
This renewable energy source, produced using Namibia's abundant wind and
solar resources, is seen as a key solution to reducing global carbon
emanations emissions and meeting future energy demands.
•····(Commented [TL9]: Format as heading 2
~.The Impact on LOderitz and Beyon( .....................................................................
··iCommented [TL10J: For as Heading 1
The establishment of the ffYJ?.l?~~.ttY.~(9-9.~.fJ.g!?~rnY..<;:?.ri:t.P.~.~!-P!~.~.!~1~.cl_!9__l.?..f.!.~...g•···· Formatted: Font: (Default) Arial, Bold, Italic
transformative economic and social benefits to LOderitz and the broader region.
j3.1 Employment Opportunitie( ............................................................................
·····{ Commented [TL11]: Format as Heading 2
The project is eiq~ectedanticipated to create numerous employment opportunities,
I. .....•..····{ ranging from construction and engineering to research and administrative roles.
Commented [TL12J: Delete paragraph 3.1
·····1 j3.~Professionals and lnvestmen~········································································-:····· Commented [TL 13]: Replacenumbering with 3.1
Moreover, the influx of PrQ[~~~fQ!?~~~.~~~/f_1X~~~11J.~!?U~.li.~~1..Y.g.f._!9q.~~JPh..l.9:.l.!f.Jh~ commented [TL 14]: Format as heading 2
local businesses and services, further stimulating the regional economy.
1 ·•..._
>_F=o=rm=a=tte=d:==F=on=t:=(D=e=fa=ult=) =Ar=ia=l, =Bold, Italic
•·• Commented [TL 15]: Start Nr 4 on new page
'41..:..... R~~~?.~C::.h.?.r:i.cl.!?~Y.~]9.P.rn~~.tf.?..c.:.:.J..!.i...t.J..~..i........................................
••• Commented [TL16]: Format as Heading 1

3 Page 3

▲back to top


Question 1
1st Opportunity
November 2024
The campus will host.<_;_L_J~Jng~_~_~r_g~_~~?-~<;:-.~.q._.~~y1_11-*~~Rll)_~_r:i_t_f~~_W___-_t,_--i-~-s-{.Formatted: Font: (Default) Arial, Bold
where scientists and engineers can collaborate on advancing hydrogen
-----1Formatted: Font (Default) Arial, Bold
technologies. This environment will also foster partnerships with academic
institutions, research organizations, and industry leaders, creating a,yibrant _____--_-_{ Formatted: Font (Default) Arial, Bold, Italic
ecosystem for innovation.
/5. Conclusiorl _________________________________________________________--_-{_C_o_m_m_e_n_te_d__[T_L_1_7_]:_F_o_rm_a_t a_s_h_e_ad_in_g_1_________
The induction inauguration of the Hyphen Hydrogen Energy campus in
LOderitz marks a historic milestone for Namibia's green energy ambitions.
!A'~_t~R_Ce_<?j~~t_!~-~~-h~c~:1:1?_R~r,~_lil_)jt~_-~_-\\~<_t?_?rl11~_g__i_g!!i_~~?_r_l!_~_c~;-:9~~1i1__c9l!_,r_n9-l-_c--r;-:l-,d-_------- Commented [TL18]: Insert Drop Cap 2 line space,bold
environmental benefits to the region, setting a precedent for sustainable _________________Fo_r_m_a_tte_d_: _F_ont (Default) Arial, Underline
development in Africa and beyond.

4 Page 4

▲back to top


Question 2
TOTAL: 30
Retrieve the Project2024 and adhere to the instructions that follow:
INSTRUCTIONS
1. In the Database Project2024 use the Employees table to display the "Hiring Dates"
of all the employees.
2. Use the table for Employees to create an action query that will display the
employees that work on the project IRS Project X only.
3. Use the table Employees and Project. Create a joint table with that will display
the Project Titles of all the Employees who earn an hourly rate of N$20.
4
Use the tables Head of Department and Departments to create a Crosstabs view
that display the budgets of the Departments. Display table as follows: Head of
Department as rows, Departments as Columns and Budget as a sum and value.
In the Project2024 database, use the tables indicated below to create a form and report
respectively.
Form:
5. Use the table "Employees" to create a Multiple Items Form and format as follows:
Insert a Title: "Global Impact Academy" - Font: Algerian, font size 18, u/c, Text
Align: Centre. Resize all columns to fit on one sheet, Print landscape orientation.
Report:
6. Create a header titled "Global Impact Academy"- Font Arial, Size 16, Bold, u/c, Text
Align: Centre. Print portrait orientation.
7. Insert page numbers which shows the current page only, at the bottom right
position.
8. Insert the Date at the left bottom corner.
9. Insert a textbox for your name and student number in the top left corner.
10. Use the logo, saved in the folder, for "Global Impact Academy" to insert in the top
right corner next to the title.
11. Rename all queries accordingly.
12. Go to layout view and resize all columns to fit perfectly.
13. Print all queries as well as the form and the report.

5 Page 5

▲back to top


Question 3
1st Opportunity
November 2024
Question 3
Marks: 30
As an Office Administrator of the Khan Academy, you are tasked to design a flyer that
will advertise the Institution for the new academic year. Please create an informative,
attractive flyer, using Ms Publisher 2016.
INSTRUCTIONS:
1. Use the flyer under the heading Built it. Select
Arrows under the grouping Real Estate. Use the
option tear-offs for the contact information.
2. Use customize colour scheme Grove.
3. Please follow all instructions carefully to ensure an
attractive Flyer.
4. Delete place holders and replace with the
information given through the instructions.
5. Printyourflyer

6 Page 6

▲back to top


Questi0n 3
5
November 2024
Business Name _____
_., Khan Academy (Font size 14, Bold)
Organization
r
Replace:
............ Product Iservice }
InfOrmati On
Logo with Khan Academy Logo (in folder
Replace content with:
Online Education & Trainin Courses
(Font: Georgia, size 24, Le~ Align)
with height: 1.27cm),
Organization with Khan Academy (bold,
font size 10, cent)
In the content below in a
textbox (Font: calibri, size 8,
bullets)
Key Features of Khan Academy:
Wide Range of Subjects
Interactive Learning
K-12 Focus
SAT and Test Prep
User-Friendly Interface
Parent and Teacher Tools
Global Reach
Benefits of Using Khan Academy
Free Access
Self-Paced Learning
High-Quality Content
Place text here that introduces your organization and describes your specific
products or services. This text should be brief and should entice the reader
to want to know more about the goods or services you offer.
Delete content and replace with:
Khan Academy is a nonprofit educational organization that offers a
wide range of free online courses, lessons, and resources. Founded by
Salman Khan in 2008, the platform aims to provide a free, world-
class education for anyone, anywhere. (Font: Bell MT, Size 14, Cent)
How to Get Started:
Visit the Website
Create an Account
Explore Courses
Engage with Content
Insert Picture from Khan Academy
(In folder). Centre picture and re-size to 8.8cm
Delete and replace with:
Tel: 061-203 25258
lnfo.khanacademy@gmail.com
I
Tel: 555 555 5555
Business Tagline or Motto
Replace Business Tagline or Mato with:
"Empowering Learners, One Lesson at a Time." (Font size 9", Bold & Italics)
-------Insert
your full name and student nr as---------
tear-offs