מגמות
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
Find out more about Dr Nick White's ANU Supramolecular Chemistry Group at https://nwhitegroup.com.
For practice questions after each video, register an account to access our free senior science courses at https://courses.meristem.anu.edu.au. Teachers can access free lesson plans and in-class activities by joining our teacher community via http://meristem.anu.edu.au/ind....ex.php/new-to-merist
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
The table below shows the medical records of a certain clinic
(a) Create a database called Medical Details.
(b) Design a table with appropriate data types in the design view called Patients.
(c) Enter the given data in the table.
(d) Assign a UGX symbol to the treatment fee field and change the date to medium format.
(e) Create a query to display all the details of patients who come from either Jinja or Busia. Save it as Eastern Patients.
(f) Create a query to display all the details that were not diagnosed with Malaria. Save it as No Malaria.
(g) Create a form from the table and save it as Main form
(h) If the Government pays 40% of the treatment fee for all patients, create a query to calculate the discounted fee. Put only Fname, DoB, Diagnosis, and Treatment Fee on the display. Save it as a Discounted fee.
(i) Create a report to display the information in the discounted fee query. Save it as a Discounted Report.
Create a tabular form from the discounted fee query showing all details and save it as a Patient’s form.
(j) Print your work.
#microsoft #microsoftaccess #database
More Video Lessons On Database Access By Kakuru Benard
Lesson 1: https://youtu.be/dJaCGMqGJvc
Lesson 2: https://youtu.be/Y3W9DVcgEPU
Lesson 3: https://youtu.be/qNnvdX1ibRk
Lesson 4: https://youtu.be/41UWvApgg58
Lesson 5: https://youtu.be/REQESvACSSs
Lesson 6: https://youtu.be/RoXjFYqwcSo
Lesson 7: https://youtu.be/NIjSEl5Kopw
Lesson 8: https://youtu.be/FUdtRE4fKf8
Lesson 9: https://youtu.be/n5PDGCFKyLM
Wakisha 2023: https://youtu.be/U5-oYEIUn5o
UNEB 2023 Paper 2: https://youtu.be/jAgtwfS6OC8
UNEB 2023 Paper 3: https://youtu.be/E2bwpS-Gwgw
UNEB 2023 Paper 1: https://youtu.be/GWRXjetAjpg
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
This video is part of meriSTEM Australian senior science educational resources (CC BY-NC-SA 4.0). Email the team (contact.meristem@anu.edu.au) for further information, course access and curriculum links.
Digital Learning Gadgets Handling, Apps and Be
a) Due to inflation, the management increased the wages of employees who
earn 300,000 and below by 20% and for those who earn above 300,000 by
15% for month of September. Using an appropriate function, compute the
new wage for each employee in the month of September.
b) Add a columns for SEP PAYE, SEP NSSF, SEP NET PAY after SEP WAGES
c) Calculate the Pay as You Earn (PAYE) tax given that its rate is 8% of the
Gross wage. There after calculate the second oldest age in cell B9
d) NSSF is calculated at 3% of Gross wage. Calculate the NSSF savings for
September per employee.
e) Use a suitable formula to generate the NET PAY that will be available for
each employee.
f) In the TOTALS row, compute the Totals for all the columns having
currencies.
g) In cell C10 use the count if function to compute for how many are managers.
h) Add “Shs” symbol as a suffix to your values in the table.
i) Apply a green line colour “all borders” outline to all cells with data.
j) Select the Names Column September Wages column to generate a 3-D
clustered column graph with appropriate labels to be saved as Employee
Pictorial Data.
k) Fill your bars with a green horizontal brick pattern.
l) Add your name and class as a right aligned footer and print your work in a
landscape orientation.
More Video Lessons on Excel By Kakuru Benard
Video Lesson 1: https://youtu.be/x3I3hd5Yno8
Video Lesson 2: https://youtu.be/Pg0WhScI-Ro
Video Lesson 3: https://youtu.be/EsQqJMpibUo
Video Lesson 4: https://youtu.be/P4-YUw0Zt5M
Video Lesson 5: https://youtu.be/1h8ZWtuXtfQ
Video Lesson 6: https://youtu.be/AtUnAAzTmHI
Video Lesson 7: https://youtu.be/ABET0r0rRk4
Video Lesson 8: https://youtu.be/XHie9m8h9Ek
Wakisha 2023: https://youtu.be/U5-oYEIUn5o
UNEB 2023 Paper 2: https://youtu.be/jAgtwfS6OC8
UNEB 2023 Paper 3: https://youtu.be/E2bwpS-Gwgw
UNEB 2023 Paper 1: https://youtu.be/GWRXjetAjpg
