《Advanced Application of Office System》Syllabus

Course Number:     2110030901 

Course Name:       Advanced Application of Office System

Instructors:          Zhang Fan

Required Text:       Lin F. Advanced Application of Office Software (Office 2019) Hangzhou: Zhejiang University Press, 2021

Course Description:   Advanced Application of Office software is a course of office software for undergraduates, which plays an important basic role in the training system of economic and management undergraduates. In other words, through the study of this course, especially the teaching and practice of common software such as WORD, EXCEL and PPT, students can master the operation skills of common office software. It provides a solid foundation for the subsequent thesis writing and work. The main knowledge points of the course lie in the editing, revision and advanced processing of WORD system, the editing, calculation and advanced application of EXCEL, and the editing, design and advanced application of PPT, which together constitute the practical content of commonly used office software, in order to achieve the exercise and improvement of operational skills, and lay a good foundation for learning and applying theoretical knowledge.

Credit/Teaching Hours

Outline of UG CPC Topics Covered in this Course:    (2Credits/32 Teaching Hours)

I. Word document creation and design                         2 teaching hours

−   Word document creation and editing and other basic operations

−   Set the document page layout and view mode

−   Master common print Settings         

II. Word, Text, Text and Beauty                             2 Teaching hours

−   Insert and edit pictures and SmartArt graphics and other operations

−   Insert art words and text boxes

−   Arrangement of objects and text

−   Insert and edit tables

Ⅲ. Advanced Word Documents                            4 Teaching hours

−   Document page layout;

−   Make catalogues and covers.

−   Separator, header, footer, page number Settings

−   Review document content

IV. Making a Simple Excel System                           2 Teaching hours

−   Basic operations of cells and worksheets

−   Edit and print Excel

−   Filtering and sorting of data

V. Common Functions                                     2 Teaching hours

−   Mathematical function, logical function

−   Statistical function

−   Time and date functions

−   Find and reference functions

VI.  Analysis of Excel Data                                 4 Teaching hours

−   Edit and beautify diagrams

−   pivotchart

−   Pivot table      

VII. The production of PPT                                 2 Teaching hours

−   Create and edit PPT documents

−   Use of tables and charts

−   Use of SmartArt graphics

−   Chinese practice of learning organization and organizational innovation

Ⅷ. Set Multimedia and animation                          2 Teaching hours

−   Adding multimedia objects

−   Set animation effect

−   Projection and output of presentations

−   Development trend of organization and new organization

Ⅷ. Integrated Application of the Three Components of Office    2 Teaching hours

−   Use Word to compile a survey and analysis report

−   Use Excel to calculate and analyze sales statistics

−   Create and project the system plan using PowerPoint 

               Total (Teaching Hours)                                                                  32  

Summary of UG CPC Topics Covered in this Course:                   (32Teaching Hours)