This course mainly teaches students how to use Microsoft PowerPoint to create PowerPoint presentation and how to use the software effectively for presentations. Besides processing text, adding pictures, forms, diagrams, sound effects, animations with the software, students will also be able to play video clips with Microsoft PowerPoint.
This course mainly teaches students the operating interface, features, functions, diagram creation and data processing of Microsoft Excel. Students will be able to use the techniques they learned to analyze data and create charts and reports by using Microsoft Excel.
Through this course, students are expected to learn about the principles and steps of the relational database management system. With Microsoft Access as the classroom practice environment, students will be able to understand the construction of an entire database from theoretical analysis to actual operation.
This course teaches the usage of various function keys of Microsoft Word. Students will be able to process word documents, prepare letters and reports effectively upon completion of this course.
Upon completion of the course, students will be able to:
• Identify the scope of Power BI application
• Operate Power BI Desktop software
• Search and integrate timely information
• Analyze visual information
• Use data and apply trend forecasting techniques
Upon completion of the course, students will be able to:
• Use the R data structure
• Operate the basic R programming techniques
• Take advantage of R to enter, save, retrieve, manipulate, and summarize data
• Run descriptive statistics and create basic plots
• Use the statistical models to analyze data
Upon completion of the course, students will be able to
• Compare the usage of different data structures in Python
• Write the syntax of flow control in Python and provide an example of its application
• List all regular expressions and methods of filtering data
• Use Python to obtain large-scale data from web pages
Upon completion of the course, students will be able to:
• perform financial data visualization
• scrape simple web data
• cleanse data
• conduct basic financial data analysis
Upon completion of the course, students will be able to:
• Operate Adobe After Effects interface
• Describe file format for various digital videos
• Practise the workflow for animation and visual effects production
• Create short promotional videos
Upon completion of the course, students will be able to
• Use various types of cash flow services
• Compare the characteristics of the current major products of e-commerce cash flow
Upon completion of the course, students will be able to
• Monitor the development of a system by means of project management
• Control the time and quality for developing an information system project
• Follow up on every step of a system development workflow
Upon completion of the course, students will be able to
• use DaVinci Resolve software
• perform post-production workflows for event promotional short videos
• convert digital video formats
• edit short videos, audios, photos, graphics and other media content
• make animated titles and motion graphics for short videos
• make use of raw footage to produce a final short video
Upon completion of the course, students will be able to
• design online surveys, registration forms and test papers through Google Forms
• publish forms through the internet to obtain useful data for analysis
Upon completion of the course, students will be able to
• edit videos, audios, photos, graphics and other media content
• create animated titles and motion graphics for short videos
• export videos to play on various devices
Upon completion of the course, students will be able to
• incorporate live streaming into business marketing strategy
• carry out promotions to drive traffic before live streaming
• manage interactions during livestream sessions
Upon completion of the course, students will be able to
•build complex DAX formulas using functions
•use variables to simplify DAX formulas
•create date tables and add them to data models
•manipulate data using time periods and build and compare calculations over those periods
Upon completion of the course, students should be able to
• analyse the form of the new media market
• make use of basic short video editing techniques
• identify the various promotion methods of brand stores
• explain the cooperation mode with Key Opinion Leaders (KOLs) and Key Opinion Consumers (KOCs)
• describe the business mode of Douyin platform
Upon completion of the course, students will be able to
• explain the system and rules of We-media
• carry out planning for content of short videos
• perform the overall process of setting up an account
• describe the business and model of Douyin platform
Upon completion of the course, students will be able to
• identify the common cybersecurity threats
• explain the common methods for maintaining information security
• develop policies and procedures to keep digital information safe