《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.

                                                                                                   Credits/Teaching Hours

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

Chapter 1 Creation and Design of Word Documents             2 Teaching Hours

Section 1 Basic operations such as creating and editing Word documents

Section 2 Setting the Page Layout and View Methods of a Document

Section 3 Master common print settings                                                            

Chapter 2 Word Graphic Mix and Beauty                     2 Teaching Hours

Section 1 Inserting and Editing Pictures and SmartArt Graphics

Section 2 Inserting WordArt and Text Boxes

Section 3 Arrangement of Objects and Text

Section 4 Inserting and Editing Tables

Chapter 3 Advanced Applications of Word Documents          4 Teaching Hours

Section 1 Page layout of the document  

Section 2 Preparation of Catalogue and Cover

Section 3 Separator, Header and Footer, and Page Number Setting

Section 4: Review the content of the document

Chapter 4 Making a Simple Excel System                     2 Teaching Hours

Section 1 Basic Operations of Cells and Worksheets

Section 2 Editing and Printing Excel

Section 3: Screening and Sorting of Data

Chapter 5 Common Functions                              2 Teaching Hours

Section 1 Mathematical Functions and Logical Functions

Section 2 Statistical Functions

Section 3 Time and Date Functions

Section 4 Finding and Referencing Functions

Chapter 6 Analysis of Excel Data                           4 Teaching Hours

Section 1 Editing and Beautifying Charts

Section 2 Pivot Chart

Section 3 Pivot Tables                                                                                       

Chapter 7 PPT production                                 2 Teaching Hours

Section 1 Creation and Editing of PPT Documents

Section 2 Use of Tables and Charts

Section 3 Use of SmartArt Graphics

Section 4 China's Practice of Learning Organization and Organizational Innovation

Chapter 8 Setting Up Multimedia and Animation               2 Teaching Hours

Section 1 Adding Multimedia Objects

Section 2 Setting up animation effects

Section 3 Screening and Output of Presentations

Section 4: Organizational Development Trends and New Organizational Trends

Chapter 9 Comprehensive application of the three major components of Office

2 Teaching Hours

Section 1: Use Word to Arrange Survey and Analysis Reports

Section 2 Use Excel to calculate and analyze sales statistics tables

Section 3 Use PowerPoint to create and project a system proposal

Total (Teaching Hours)                                                                  32 

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