After completing the course, student
can create SharePoint communication site in Office365 Online environment.
is competent on basic SharePoint site admin tasks: permissions, creating and modifying libraries and list, changing their settings (columns, permissions, views)
is able to modify the SharePoint site appearance with WebParts and pages
is able to automate the document set up by creating and using templates, themes, styles and building blocks
is able to save, upload, share files in SharePoint document libraries
is able to use Excel professionally in management account context
is able to use Travel management software (M2)
Contents
Microsoft Word: Use and creation of styles, themes, building blocks, and templates
SharePoint: Creation of SharePoint site in SharePoint online, using permissions, permissions inheritance, permission groups, different types of apps in SharePoint site: Libraries & Lists, Columns, metadata & properties and views in the context of lists and libraries, Editing SharePoint pages using Web parts & Quick launch
Microsoft Office Excel
IF-function, conditional formatting, consolidations, templates
percent calculations, management accounting basics, per diems, M2
Implementation methods, Demonstration and Work&Study
Contact lessons and weekly assignments
Individual learning assignments
Independent studies
Exam
Assessment of one’s own learning
Learning materials
Classroom materials and other materials informed and distributed by the teachers.
Further information
The course is offered only in spring semesters.
Starting level and linkage with other courses
Office Applications 1 (TOO1LE201), Business environment and assistant’s work (BUS1LE201)
Assessment criteria
Assessment criteria - grade 1
Student can satisfactorily complete basic tasks with SharePoint site creation but is not able to solve more demanding tasks independently.
Student has command of some concepts related document set up automation of Microsoft Word but lacks a full understanding of how to be productive in document production.
Student can satisfactorily complete basic tasks related to percent calculations, basic management accounting and per diem calculations with Excel but needs assistance with more demanding tasks.
Student shows poor time management skills.
Assessment criteria - grade 3
Student has command of key concepts of SharePoint site creation, permission set up, is able to add and set up apps to store information in SharePoint site and modify the sites with professional looks.
Student can create new templates, building blocks, themes and styles to automate document set up in Microsoft Word and knows how to apply them in practice.
Student can independently complete basic tasks related to percent calculations, basic management accounting and per diem calculations with Excel.
Student has relatively good time management skills and completes most assignments on time.
Assessment criteria - grade 5
Student has strong skills and can independently use the applications to find new solutions.
Student can independently complete basic tasks related to percent calculations, basic management accounting and per diem calculations with Excel and knows how to apply them in practice.
Student has good time management skills and completes assignments on time.