 |
BAP621S - BUSINESS APPLICATION 2B - 2NDOPP - JAN 2025 |
|
|
1 Page 1 |
▲back to top |
nAm I BIA un IVERSITY
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: January 2025
DURATION: 2 Hours
SESSION: Practical Paper
MARKS: 100
EXAMINER{S)
MODERATOR:
SECOND 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, surname, question number and the date
appear in the Header and Footer.
THIS TEST PAPER CONSISTS OF\\:;,PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
\\
Question 1
2"d Opportunity
January 2025
Question 1
Marks: 40
Retrieve Question 1 with the Track Changes from your folder and adhere to the
instructions. Type document in Calibri, font size 12, s/s. Insert page numbers except
for the first page (Bottom of page - center). Insert diagonal watermark:
CONFIDENTIAL (u/c, font: default). Use Automatic Table2 for the TOC. Insert
Reference List.
Students, please ensure that you pay attention to the layout of the document by
aligning the numbering correctly.
~~novation Development _______·_--_-_------------------------------------------------------------------------------
Commented [TL 1): Insert Word Art with the following
detail:
Fill: BlackText Colour 1; Outline White Background Colour 1;
j1. The Status of Innovation Developmen{ _________________________________________________H_ar_d_S_h_ad_o_w_B_l_u_e,_A_c_cent Colour 5, font size 30
Innovation Development is a 6PElef,jy-systematic investigation into and study of
Commented [TL2]: Insert as Heading 1, Black, font size 14
materials, sources, and topics in order to .~!i_t~-~E~h_f_~c::_t!i_Cl_')~I'~-~~~_-_-c')::!~?_1\\_Y1~l_~~_j~_l_-_l-!i-_-{· Formatted: Font Comic Sans MS, 11 pt, Bold
------1 It is a fundamental aspect of human progress and is integral to the development and
Formatted: Font Comic Sans MS, 11 pt, Bold
growth of knowledge across all ~iscipline~------------------------------------------------------------------
2. Intellectual Advancement
1
At its core, innovation is about discovering new information and expanding our
understanding of the world.
Commented [TL3J: Use the following link to insert the in-
text citation reference:
https://wwresearc hgate.net/ publication/33 2246566_ Book_
Review_CreswelI_J_W_2014_Research_Design_QuaIitative_
Quantitative_and_Mixed_Methods_Approaches_ 4th_ed_Th
ousand_Oaks_CA_Sage
[2.1 Discovering Topic~_!_ ______________________________________________--_--_-_--_--_-_--_--_:_:__._--___C_o_m_m_e_n_te_d [TL4): Insert as Heading 2, Black,font size 14
----1 By systematically discovering new topics, researchers can._~f_l~<>_Y_f:_~l~!"l':1-'_[n~i9!J~~-Cl_')~------- Commented [TLSJ: Correct line spacing
contribute to the body of knowledge in a particular field.
--- Formatted: Font Comic Sans MS, 11 pt, Bold, Italic
j2.2 Conceptual Development[__________________________________________________________C_o_m_m_e_n_te_d___[T_L_6)_: _I_ns_e_rt_a_s_H_e_a_di_ng 2, Black,font size 12
jThis advancement of knowledge is crucial for the development of new theories,
concepts, and practices.
Whether it's uncovering the secrets of the universe in astroph'r.'.sics or understanding
human behaviour in psychology, research fuels intellectual growth and curiosityl_ __________C__om_mented [TL7J: Create one paragraph
j3. Data-driven Decision{ ___________________________________________________________.-_-·_-__C_o_m_m_e_n_te_d___[T_L_8)_: _I_ns_e_rt_a_s_H_e_a_ding 1, Black,font size 14
Innovation plays a critical role in informed decision-making, particularly in policy-making
and business strategy. By providing ~vidence-based informatiorl,_r~-~~_ar~~-he_lp_~-----------------·- Commented [TL9J: Type in bold and underline
policymakers understand the potential impacts of their decisions and create policies
that are beneficial for the public.
IR the busi1<1eswsorld, marlmt research allows comfJaRiesto u1<1dersta1c<o11d<1sumer
beha¥iour, ide1<1tifymarl<et tre1<1dsa,1<1mdake strate9ic decisie1<1thsat e1<1ha1<th1ecier
comf3etitive1<1esWs. ithout research, decisio1<1wsould be based 01<a1ssumf3tie1<a11s<1d
SfJeculatioR,leadi1<1t9o f30te1<1tialld)'isastrous outcomes.
|
|
3 Page 3 |
▲back to top |
' ,I
2
~- Social Impact of Research ~~~~~!".<:~h~~-'=r~'-c:>_to_~!1-~_(1)1p_c;i~_t_e>!!_~c:>_<:\\~_~y_1:1_C~o_mcm;ie_n~tehde>[)TeL_1.O_J;:tI_nst_er_t ~as--H-e--a-ding 1, Black,font size
addresses critical issues such as health, education, and the environment, leading to · 14
improvements in the quality of life. fop e1fample,PeseaPchiR pl:lblic health helps iR
Commented [TL 11): Insert new paragraph
l:lRdePstaRdiRgaRd ceRtPelliRg diseases, leadiRg te healthieP pepl:llatieRS.Educational
research informs teaching methods and learning processes, enhancing educational
outcomes. ER~·iPeRmeRtaPleseaPchceRtPibl:ltes te l:lRdePstaRdiRgclimate chaRgeaRd
fiRdiRg Sl:lStaiRablesell:ltieRs te em•iPeRmeRtalchalleRges. The beRefits ef PeseaPch
e1fteRd beyeRd the iRdi>t'idl:latle seciety at laPge,malEiRgit aResseRtial tee I fep secial
pPegPeSS.
~-_____P_e_rsonaiand Career_Growtt_-l________________________________________________-:_-_--_--__C_o_m_m_e_n_te_d__[T_L_1_2_):_P_l_ea_s_e_st_ar_t paragraph nr son the
Engaging in research also offers significant personal and professional benefits. For
individuals, research develops critical thinking and analytical skills, enhances problem-
next page
Commented [TL 13): Insert as Heading 1, Black, font size
14
solving abilities, and fosters a sense of curiosity and exploration.
[6.
Innovationand TechnologicalDevelopmen{____________________________________________C_om_m__en_te_d___[T_L_1_4)_: _In_s_er_t _a_s H_eading 1, Blackfont size
[lnnovatio{ ____~_- _______-_~_!a_nsformationj_________________________________________1_4_______________________________
Commented [TL 15): Use Block Arrow Right, height 0.09,
Innovation is the backbone of Transformation. It provides the foundation for
developing new technologies, products, and processes that can improve the quality of
width 0.62"
\\:·>· ,, Commented [TL 16): Insert Rectangular, height 0.36"
.....Text: Calibri size 11
life.
','
Commented [TL 17): Insert the Equal Equation Shape,
[6.1 RecogniseChallenge~_________________________._.________________________________________-_._,_____h_e_ig_ht_0_.2_3_"_a_nd width 0.59"
',
Through investigation, scientists and engineers can identify problems and create
Commented [TL 18): Insert Oval, height 0.36"
Text: Calibri size 11
solutions that lead to technological advancements. For instance, research in medicine
Commented [TL 19): Insert as Heading 2, Black font size
has led to the development of life-saving drugs and medical procedures.
12
[6.2 Devicesand Application~______________________________________________________-_-__C_om__m_en_t_ed___[T_L_20_)_: _In_s_e_rt_a_s H_e_a_d_in_g_2_, B_lackfont size
12
1. [statistical Analysis Software
2. Data Mana ement Software
3. Digital Recorder~
4. Drones
5. Wearable Technolog}{_________________________________________________________C_o_m_m_e_n_te_d__[T_L_2_1_):_R_e_p_la_c_ew_i_th__ro_un_d__bu_ll_ets, s/s
[7. KnowledgeManagementand Preservation_l __________________________________________C_o_m_m__en_t_ed__[_T_L_2_2)_:_In_se_r_t a_s_H_e_ading 1, Blackfont size
14
Innovation ensures that valuable knowledge is documented and preserved for future
generations. By recording findings and results, PeseaPchePScPeate a PepesiteP','ef
iRfePmatieR that caR be accessed aRd bl:lilt l:lpeRby ethePS. This deCl:lmeRtatieRis
vital fep maiRtaiRiRgthe ceRtiRl:lity ef IERewledgeaRd eRSl:lPiRtghat iRsights aPe Ret
lest e·,•eptime. It else provides a reference point for future research, allowing new
generations of researchers to learn from past work and avoid duplicating efforts.
|
|
4 Page 4 |
▲back to top |
3
3
l±G~- Conclusio~---------------------· ·-·----------------------------------·---------------·-------------------------·-·
Innovation is a powerful tool that drives human progress. Its importance is evident in
the advancement of knowledge, innovation, informed decision-making, societal
benefits, personal and professional development, preservation of knowledge, and
economic growth.
Commented [TL23]: Insert as Heading 1, Black,font size
14
|
|
5 Page 5 |
▲back to top |
Question 2
2nd Opportunity
January 2025
Question 2
TOTAL: 40
Retrieve the Spreadsheet named "Weight Loss" and adhere to the following
instructions.
Sheet 1 - Weight in June
Sheet 2 - Weight in August
INSTRUCTIONS:
1. , The participants of the "Kyknet" show "The Biggest Loser" are having their first
weigh-in show. These participants are part of this programme for the last 6
months. We would like to calculate their weight for the of June and August
together.
2. Open another sheet, sheet 3 and rename it as Total Weight. Copy the sheet of
Weight in June to sheet 3. Delete the columns for Hobby & Towns. Please
calculate the weight for both months for each participant and insert the results in
the Total Weight sheet.
2.
Formatting - Total Weight sheet:
2.1 Insert two rows:
1st Row- Insert Heading - Total Weight (u/c, Bold, font Calibri, size 16, merge &
centre)
2.2 Row Height:
Column Headings row height - 40 pixels
Rest of rows - 30 pixels
2.3 Column Headings (Calibri, Bold, Font size 14) with background color of White
background 1, 15%.
Formatting:
3. Copy the Sheet named Weight in June from the workbook to a new workbook
and rename the sheet as Original.
3.1 Change the font to Arial, Font size 12.
3.2 Insert two-line space on top and add the heading - Total Weight in the first line
(Merge and Centre, Bold, Font Size 16, Font Arial).
3.3 Insert All Borders (excluding the Main headings)
|
|
6 Page 6 |
▲back to top |
Question 2
2nd Opportunity
3.4 Row Height:
Column Headings - 40 pixels.
Rest of table - 35 pixels.
January 2025
3.5 Column Headings - bold the column headings and insert background color -
White Background 1, Darker 15%.
Filter:
4. Copy the Original sheet four times and do the following filtering with the renaming
accordingly:
4.1 Sheet 1 - Display the first names that contains the letter "o".
4.2 Sheet 2 - Show only the participants whose hobby does not contains an "e".
4.3 Display all the towns that starts with the letter "k"
4.4 Sheet 3 - Please display the weight in Junes of the participants between 55 and
60.
5. Insert the header for each sheet.
6. Print all filtered sheets in portrait.
|
|
7 Page 7 |
▲back to top |
QUESTION 3 - PUBLISHER
Question 3
January 2025
[30]
Create the following Academic Achievement Ceremony invitation card for some special
guests. Please adhere to the instructions below.
Under the Built It Templates, select Greeting Card, Occasions & Events, Anniversary 1.
Colour Scheme: Mist
Font: Georgia
Page Size: Quarter-Sheet Top Fold
Page 1 -Top Front Cover
Delete default picture and replace with "Class of 2024" picture in folder. Resize to 5.4cm,
centre position. In the space below, delete the words Best Wishes and replace with -
"Celebrating Success" (font: Georgia, 14cm, centre)
Page 2 (top inside)
Delete top part- insert the following content:
Celebrating Academic Excellence!! (Font: Aparajita, size 24, cent)
1st and 2nd block. Insert graduation picture (saved in folder).
Page 3
1st Place holder: Delete content
2nd Place holder: Delete content and replace with the following:
Type
headings
in bold
Join Us fora
Night of Celebration
~1Font: Geor gia, 16, cent
-Date
* : 15 November 2024
}
Time : 19:00
Location: NUSTHotel School, Windhoek-west,
II
Aldhabi, 20
* "Turning Tassels, Embracing Tomorrow!"---+[
Font: Georgia, 12, cent, bold, italics I
Page 4: Back of Invite
Insert in textbox: "Yesterday's Students, Today's Graduates, Tomorrow's Leaders!". Type
in font: Agency FB, 18, underneath each other, center position,
Please delete DBTS and replace with your name and student number in brackets in a
centered position.