Projects

Change needs sense of urgency

  1. 職+專+學+正+系
  2. WSUS + java
  3. AD audit report and policies
  4. AD RFS
  5. Performance reporting
  6. 生改單 – 圖及版本看系統
  7. 料號變更跟蹤
  8. 訂單電子審核
  9. OA – 樣板單
  10. CACTI SNMP server
  11. SQL backup and restore
  12. Wechat programming
  13. tax expense profile
  14. Economist
  15. Scrap rates and quantity
  16. Stock level
  17. BI at sharepoint and Tablet / mobile
  18. 8S correction with scrap alerts
    1. Launch date: 10Oct2016
    2. Status: Not yet
  19. Quality level
  20. Offsite backup with docoumentations
  21. Windows perfmon automation / syslog / SNMP
  22. IT system applications in Manufacturing and various industies
    1. Logic / flow
    2. Requirements
    3. Critical success factors
  23. Wikis:
    1. Documents library with version control,
    2. co-authering with approval,
    3. knowledge searching
Projects

MSc resources

A. BSc 1st Class means nothing (too many out there…), the importance is what you learned and how do you sustain to break through!

B. MBA for business; Specialist in MSc but not of MSc IT…

Roadmap (v. 20170625)

BSc 1st -> MSc of LMU ->  UST / Edinburg -> PgD Acc / digital marketing-> MBA -> Research Degree & PhD

  1.  UoG
    1. UoG Infonet: http://infonet.glos.ac.uk/
      1. Library online resources -> ScienceDirect
  2. Academic writing:
    1. MDX resources: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources
    2. Using-academic-language: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources/using-academic-language
    3. Academic vocabulary: http://www.nottingham.ac.uk/alzsh3/acvocab/
  3. Time management
  4. Research methods for Business Student – 5/e:
  5. Basic Business Statistics – 12e:
    1. Statistics e-resources: http://unihub.mdx.ac.uk/your-study/learning-enhancement-team/online-resources/maths-stats-and-numeracy/statistics
  6. Harvard referencing
    1. https://infonet.glos.ac.uk/departments/lis/Guides/Harvard%20Referencing.pdf
    2. http://ist.glos.ac.uk/referencing/harvard/
  7. Academic reference letter:
    1. http://www.strath.ac.uk/careers/uni_staff/writingacademicreferences/exampleofacademicreference/
  8. Further MSc study:
    1. MSc Big Data Technology, HKUST: https://www.sengpp.ust.hk/programs/bdt/en/application.html
    2. (NCC L7DSBIT) University of Gloucestershire (89th): http://www.glos.ac.uk/courses/postgraduate/cit/pages/computing-it-management-postgraduate-diploma-msc.aspx
    3. (NCC L7DSBIT) London Metropolitan University (120th): http://www.londonmet.ac.uk/courses/postgraduate/information-technology-distance-learning—msc/
    4. University of Edinburg (19th):
      1. MSc Data Science, Technology and Innovation (Medical Informatics).  http://www.ed.ac.uk/studying/postgraduate/degrees/index.php?r=site/view&id=906
      2. MSc in Digital Education. http://www.ed.ac.uk/studying/postgraduate/degrees/index.php?r=site/view&id=106
    5. University of Leicester, MSc Computer Science, SoftEng, WebTech (32nd): https://le.ac.uk/courses/advanced-software-engineering-msc-dl
    6. University of Aberdeen, MSc PM, MSc IT & MBA Digital Marketing (42nd): https://www.abdn.ac.uk/study/postgraduate-taught/degree-programmes/52/digital-marketing-leadership/ 
    7. Royal Holloway Univeristy of London (37th): http://www.londoninternational.ac.uk/courses/postgraduate/royal-holloway/information-security-msc-postgraduate-diploma#overview
    8. Edinburgh Napier University (92nd): http://www.napier.ac.uk/courses/msc-advanced-security-and-digital-forensics-postgraduate-distance-learning-part-time
    9. Advanced Manufacturing system by Brunel University London (52nd): https://www.brunel.ac.uk/study/postgraduate/Advanced-Manufacturing-Systems-MSc
    10. DeMontfort University (54th): http://www.dmu.ac.uk/study/courses/postgraduate-courses/data-analytics-msc-degree/data-analytics-msc-degrees.aspx
    11. Northumbria University, Information Science – Data Analytics(59th): https://www.northumbria.ac.uk/study-at-northumbria/courses/information-science-msc-data-analytics-dl-dtdinv6/#year-two
    12. Distance Learning postgraduate program, Lancaster University. http://www.lancaster.ac.uk/study/postgraduate/distance-learning/
    13. MSc PM, Liverpool John Moores University (74th): https://www.ljmu.ac.uk/study/courses/postgraduates/project-management
    14. University of Hertfordshire (79th):
      1. http://www.herts.ac.uk/courses/search?collection=herts-courses&f.Course%20Type|T=Postgraduate&query=!padrenullquery&f.Method+of+Study%7CS=Online+-+Part+Time
      2. MSc E-learning technology (online), http://www.herts.ac.uk/courses/e-learning-technology-online
    15. MSc PM, Salford University (95th, 4 intakes/yr): http://www.salford.ac.uk/pgt-courses/project-management
    16. MSc PM, Birmingham City University (95th, but cheap): http://www.bcu.ac.uk/courses/int-project-management
    17. MSc IT, University of Derby (91st): https://www.derby.ac.uk/online/course/information-technology-msc/course-fees
  9. Further MBA study:
    1. UST: https://www.sengpp.ust.hk/programs/bdt/en/program_details.html
    2. Duram University (6th): https://www.dur.ac.uk/business/programmes/mba/online-mba/
    3. MBA with Data Analytics, Nottingham Trent University (63rd): http://online.ntu.ac.uk/online-courses/mba/data-analytics?cmgfrm=https%3A%2F%2Fwww.ntu.ac.uk%2Fstudy-and-courses%2Fcourses%2Fdistance-learning-online
    4. Middlesex University (78th):
    5. Leicester University (32nd): https://le.ac.uk/courses/the-leicester-mba-dl?uol_r=6641cede
    6. Heriot-Watt University (34th): https://www.hw.ac.uk/study/uk/postgraduate/master-business-administration.htm
    7. University of Derby (91st): http://www.derby.ac.uk/online/course/online-mba-global-master-business-administration-degree-course
    8. Most affordable:
      1. Agnlia Ruskin University (110th): https://distancelearning.anglia.ac.uk/courseDetail.php/MBA-Master-of-Business-Administration-16/
      2. Leeds Beckett University (103rd): https://courses.leedsbeckett.ac.uk/mba_executive_online/#Coremodules
    9. Strategic Planning / Strategic Sustainble Business
  10. Further other studies:
    1. Leicester University: https://le.ac.uk/courses/human-resource-management-and-training-msc-dl?uol_r=d65bd40d
    2. Digital Brand Marketing by GLASGOW CALEDONIAN UNIVERSITY (79th): http://www.gcu.ac.uk/study/courses/details/index.php/P02994-1DLA-1718/Digital_Brand_Marketing?utm_source=YYYY&utm_medium=web&utm_campaign=courselisting 
  11. Further Acc Study (exempt basic knowledge application / future route?):
    1. HKICPA non-Acc routes: http://www.hkicpa.org.hk/en/become-a-hkicpa/how-to-apply/entry-routes/#route2 
    2. HKU SPACE (fast / low price): http://hkuspace.hku.hk/prog/postgrad-dip-in-prof-accounting
    3. PolyU (Most expensive / best): http://www.af.polyu.edu.hk/programmes/detail/7
    4. CUHK (High entry requirements with QR registers/ best): http://www.bschool.cuhk.edu.hk/index.php/programs/postgraduate-diploma-in-professional-accountancy/program-overview
    5. Lingnan (Deposit / Sat only, not available at 2017/18): http://www.ln.edu.hk/acct/macc/pgda.php
  12. Distance Learning materials:
    1. Leicester University: http://www2.le.ac.uk/departments/management/distancelearning/courses
    2. The University of Strathcylde:
      1. MSc Operational Research (Distance learning). https://www.strath.ac.uk/courses/postgraduatetaught/operationalresearchdistancelearning/
      2. Business Analysis & Consulting (Distance Learning). https://www.strath.ac.uk/courses/postgraduatetaught/businessanalysisconsultingdistancelearning/ 
    3. University of Hertfordshire:
      1. MSc Operations and Supply Chain Management (Online). http://www.herts.ac.uk/courses/operations-and-supply-chain-management-online
      2. MSc Manufacturing Management (Online). http://www.herts.ac.uk/courses/manufacturing-management-online
    4. Robert Gordon University: http://www.rgu.ac.uk/areas-of-study/subjects/information-communication-and-media/study-options/distance-and-flexible-learning
  13. Research Degrees (distance learning)
    1. LMU, Research Degree – MPhil / Phd. http://www.londonmet.ac.uk/courses/postgraduate/research-degree—mphil–phd/
  14. NCC references:
    1. NCC contact: http://www.nccedu.cn/onepage-10.html
    2. Middlesex sent official transcript to Education institute: http://www.onlinestore.mdx.ac.uk/browse/extra_info.asp?compid=1&modid=1&catid=23&prodvarid=84 
  15. Others
    1. Manufacturing: MSc Manufacturing Systems Engineering and Management (MSEM). http://www2.warwick.ac.uk/fac/sci/wmg/education/wmgmasters/courses/manufacturing_systems_engineering_and_management/
  16. USA online Masters
    1. Masters in Predictive Analytics Online, NORTHWESTERN UNIVERSITY.    http://sps.northwestern.edu/program-areas/graduate/predictive-analytics/index.php
    2. Master of Science in Applied Business Analytics Degree, Boston University. http://www.bu.edu/online/programs/graduate-programs/applied-business-analytics/
MSc resources

Tableau BI study log

  1. Objectives
    1. Establish formal procedures
    2. Establish advanced wiki for development
      1. OA + ERP db calculation
    3. Wide Access control by SharePoint
  2. Resources
    1. Tableau Data Visualisation Cookbook:
      1. DataSets: http://biostat.mc.vanderbilt.edu/wiki/pub/Main/DataSets/titanic.txt
    2. Tableau Getting start: https://onlinehelp.tableau.com/current/pro/online/mac/en-us/gettingstarted_overview.html
    3. Learning:
      1. Videos: http://www.tableau.com/learn/training
      2. Learning path to Tableau expert: https://www.analyticsvidhya.com/learning-paths-data-science-business-analytics-business-intelligence-big-data/tableau-learning-path/
      3. Tableau tutorials: https://www.tutorialspoint.com/tableau/index.htm
      4. Tableau: How Fast You Can Learn It?https://www.concentra.co.uk/blog/how-fast-can-you-learn-tableau
      5. Tableau user Doc by edu: http://casci.umd.edu/wp-content/uploads/2013/12/Tableau-Tutorial.pdf
    4. Scenario with 8 steps and library: http://onlinehelp.tableau.com/current/guides/get-started-tutorial/en-us/get-started-tutorial-home.html
    5. SQL by
      1. https://www.codecademy.com/learn/learn-sql
      2. http://www.w3schools.com/sql/
  3. Terms
    1. Tableau Server
    2. Tableau Desktop 8.2: http://www.tableau.com/support/esdalt
    3. Project
    4. Workbook
    5. KPI / metrics
    6. Views
    7. Dashboard
    8. Story
  4. BI literature review
  5. Study log
  6. Dashboard research
    1. Actions in Dashboard: https://public.tableau.com/en-us/s/blog/2015/06/rough-guide-dashboard-actions
    2. 7 Business Dashboards – http://www.cio.com/article/2369201/business-intelligence/151486-7-Business-Dashboards-That-Offer-Striking-Data-Visualizations.html#slide2
    3. 用数据说话,R语言有哪七种可视化应用?http://www.leiphone.com/news/201701/wiDDwAAEJ87zoji9.html
    4. Tableau and SharePoint Integration: https://www.youtube.com/watch?v=ElyH9iJd-4c
    5. PMC Report samples by Tableau: https://public.tableau.com/profile/unoviz#!/vizhome/PMCreport/ChannelDashboard
    6. Monitor production quality with a single manufacturing dashboard: https://www.tableau.com/stories/workbook/monitor-all-relevant-production-data-single-dashboard
    7. Add Reference Line: https://onlinehelp.tableau.com/current/pro/desktop/en-us/reflines_addlines.html
      1. Dynamic reference line: http://kb.tableau.com/articles/knowledgebase/creating-dynamic-reference-lines
    8. Creating Error Bars: http://kb.tableau.com/articles/howto/creating-error-bars
    9. Creating Bars in Bar chart in Tableau: https://www.youtube.com/watch?v=-qXfjweVuqQ 
Tableau BI study log

Troubleshooting Network Throughput, Latency, and Bandwidth Issues with a SonicWall UTM

  1. MTU (Maximum Transmission Unit): increments of 8 bytes
    1. Common values are: 1492 SDSL / 1460 ADSL / 1404 Cable;
    2. Interface MTU: default value of WAN in SonicWall is 1500 bytes;
      1. determine optimum MTU size to prevent unnecessary fragmentation;
  2. References:
    1. SonicWall. https://www.sonicwall.com/en-us/support/knowledge-base/170504563958424
    2. Use iPerf to measure Throughput on a SonicWall device. https://www.sonicwall.com/en-us/support/knowledge-base/170505719364304
  3. Connection Monitoring (real time): Dashboard > Connection Monitor
    1. Filtering
Troubleshooting Network Throughput, Latency, and Bandwidth Issues with a SonicWall UTM

IELTS writing practices

Read-Read-Read;

IELTS WP0001A (29Jun2017)

The first figure provided reveals the global water consumption by sector between 1900 and 2000. The first figure provided reveals the variations of water consumption worldwide between 1900 and 2000.

The agricultural usage has the most significant volume in Km3, and it grew from 500 Km3 in 1900 and rose gently to 1000 in 1950, then its demand soared to 3000 Km3 until 2000. Throughout the century, the largest quantity of water was used for agricultural purposesand it grew gently from 500 Km3  to 1000 Km3 between 1900 and 1950, then its soared to 3000 Km3 in 2000.

On the other hand, industrial and domestic consumption stayed at low usage level from nearly 0 between 1900 and 1940. Then, the industrial grew to 1000 Km3 and domestic rose to around 2000 Km3 in 2000 respectively. Water used in the industrial and domestic sectors also increased, but consumption was minimal until mid-century.  From 1950 onwards, industrial usage grew steadily to just over 1000 Km3, while domestic use rose more slowly to only 300Km3, both far below the levels of consumption by agriculture.

The second table reveals a comparison of water usage by Brazil and Congo in 2000. Brazil has the highest population at 176 million and 16500 km2 of irrigated land. In contrast, Congo has less number of citizens at 5.2 million and 100 km2 of farmland. As expected, Brazil has a higher figure of water consumption per person at 359m3 and the number in Congo in 8m3. The table illustrates the differences in agricultural consumption in some areas of the world by contrasting the amount of irrigated land in Brazil (26500km2) with that in the DRC (100km2). This means that a huge amount of water is used in agriculture in Brazil, and this is reflected in the figures for water consumption per person: 359m3 compared with only 8m3 in the Congo. With a population of 176 million, the figures for Brazil indicate how high agricultural water consumption can be in some countries.

IELTS WP0002A (11JuL2017)

 

IELTS writing practices