Using excel spreadsheet to record and track expenditure in shared drive.

-

Contributed by CHAN YUET KUEN

Present Situation:

Library expenditure was recorded on the physical payment record book for submission to the accounts department before the discontinuation of the record book on 2 Mar 2021. Total expenditure spent was done manually and not easy to monitor and check that the library expenditure is spent within our budget.

Improvement:

Using excel spreadsheet to record and track library expenditures in shared drive and to check that the library expenditure is spent within our budget. This saves time and effort on manual calculation and other dept can also adopt this method to record and track their department's expenditure.



Comments

Post a Comment

Popular posts from this blog

Dragon Chinese( Longwenhuayu) 龙文华语

-
Image
Name of Team 龙文华语 (longwenhuayu) Title of Project Dragon Chinese( Longwenhuayu) 龙文华语 Facilitator Zhu Haibin Team Leader Zhu Haibin Secretary Zhu Haibin Members Zhu Haibin Zhou Liang Wu Guangzhi Initiated on ( date ) 1 January Completion date Ongoing Objectives/Targets To raise students' interest in and awareness of the Chinese Language learning.   To provide a platform to help students learn Chinese by themselves . Implementation Process 1 Set up a public account at Wechat and open for students to subscribe. 2 We post a well selected Chinese article every day and push to the subscribe students. Until now, we had posted more than 200 Chinese articles. It includes Chinese essays, poems, news, and subject related materials. Subscribed students read and post their
Read more

Vouchers as birthday gifts for all staff

-
Image
Contributed by Dilys Tan Puay Miow,  Junita Wong, Luis, Fan Kaideng, Yao Ling Yun What was the current need/gap that you were addressing? Presented the idea of giving vouchers to all staff for their birthdays instead of a physical gift. The existing model of giving physical gifts contribute to wastage & environmental unfriendliness, should gifts not be to staff's liking. Vouchers allow staff flexibility to buy whatever they require. Staff can also opt to donate vouchers to charity in the school's name which contribute to NYGH CSR efforts. How had it been experimented and enacted? Had a meeting with SWC chairman, SWC advisor & SH community Development to discuss the idea. SWC chairman brought the idea to Bursar. And she discussed with management team and was agreed and approved on 12/7/2023. It was implemented in 2024. What was the positive impact? 1) reduced wastage of gifts 2) flexibility for staff to buy what they need.
Read more

INTERNAL HCL ORAL EXAM

-
Image
Contributed by CHEN HSUAN CHIEH, SAM CHOON JUEN, ALEX TEO What was the current need/gap that you were addressing? Before 2023, the internal advanced Chinese oral examinations for Secondary Three and Secondary Four were conducted over three afternoons, from 1:30 pm to 5:00 pm. This approach posed several issues: Conducting exams over three afternoons disrupted afternoon classes. 1. Staffing arrangements were challenging, as a significant number of teachers were needed to serve as assistant oral examiners (AOE). The availability of AOE teachers did not always align with the designated oral examination times as they have other lessons in the afternoon, resulting in difficulties in staffing arrangements. 2. The time spent by AOE in performing their duties was considered part of the year-end exam invigilation time. Deducting their time during the scheduling of year-end exam invigilation not only made the timetable creation process tedious but also contributed to a shortage of invigilators f
Read more