Course Outline:

• Database and List Management
  1. Generate Formula for Subtotals and Grand Totals With a Few Clicks
  2. Filtering data Using Complex Criteria
  3. Expanding and Collapsing Data Using Outline
  4. Database Category
• Data Analysis
  5. Create Scenarios
  6. Use What-if Table
• Auditing Worksheets
  7. Use the Formula Auditing
  8. Tracing Precedents and Dependents
  9. Evaluate Formulas
  10. Trace Errors
• PivotTable and PivotChart Reports
  11. Create PivotTable
  12. Change Summary Function and Format Numbers
  13. Change PivotTable Report Layout
  14. Group and Ungroup Data
  15. Data Refresh and Change Data Source
  16. Create PivotChart
• Workbooks Collaboration
  17. Share Workbooks
  18. Compare and Merge Workbooks
• Workbooks Security
  19. Set Password to Open a Document
  20. Allow User to Ranges

This workshop aims to let teaching staff be more familiar with using GradeBook on UMMoodle. In the workshop, ICTO introduced how to setup a GradeBook and how to use grading tools, such as quick grading, aggregation & calculation of grading and grader reports.

This workshop aims to let teaching staff be more familiar with using Quiz activity on UMMoodle. In the workshop, ICTO introduced how to create a Quiz activity with different question types and how to manage question bank.

Topics:

• Endpoint Devices
• GPU and Hard disk partitioning
• RFID Asset Management System
• Construction/Engineering/Multimedia/VR
• Managed Print Services

This workshop aims to let teaching staff be more familiar with using Assignment activity and plagiarism checking tools on UMMoodle. In the workshop, ICTO introduced how to create an Assignment activity and how to collect & grade students’ submissions. ICTO also invited Library for giving an introduction to plagiarism checking tools, Turnitin and VeriGuide.