Office Applications 1 - Study guide

After completing the course, student
is competent to use collaboration software when working in project team
is able to study efficiently in Haaga-Helia IT enviroment.
knows key features to produce business documents efficentrly.
can produce documents following Finnish document standard.
is able to create presentations using presentation graphics software.
knows basics of spreadsheet software and is able to perform basic calculations with it.

No prerequisites.

Microsoft 365 calendar and email and Teams
OneDrive file storage & file sharing
Using Teams in team collaboration
Haaga-Helia IT environment: Saving and sharing files
Access to Haaga-Helia IT enviroment using VDI-desktop
Moodle basic use
Microsoft Office Word:
Modify document settings including margins, tabs, headers, footers, fonts according to given specifications
Enrich the document content with images, SmartArt, tables and graphics.
Create reports with automatic table of contents

Finnish Document Standard :
Apply Finnish document standard in business letters

Microsoft Office PowerPoint:
Create and modify presentations using PowerPoint themes and slide layouts
Enrich the presentations with SmartArt, tables, and images
Use speaker notes
Use slidemaster
Add narration and save presentation as a video.

Microsoft Office Excel
Create and modify Excel workbooks and worksheets
Data entry and formatting
Recover from most common errors: #DIV, #REF, #VALUE, #NAME, #####
Write formulas using absolute and relative references
Use basic functions: MIN, MAX, AVERAGE, SUM, IF
Calculate percentages
Create and modify graphs
Prepare Excel worksheets for printing
Sort and filter data with table functionality

Student can satisfactorily complete basic study related collaboration task in Haaga-Helia's ICT environment (Moodle, Microsoft365, using network drives, remote access tools) but is not able to solve more demanding tasks independently.
Student has command of some concepts related to basic use of Microsoft Word, PowerPoint and Excel but lacks a full understanding of how the different Office applications work.
Student is aware of basic concepts of Finnish Document Standard.
Student shows poor time management skills

Student can complete study related collaboration tasks in Haaga-Helia's ICT environment (Moodle, Microsoft365, using network drives, remote access tools) relatively independently.
Student has command of key concepts of Microsoft Word, PowerPoint and Excel and makes use of basic functionalities with purpose.
Student is able to apply Finnish Document Standard when creating a business letter.
Student has good time management skills and completes assignments on time.

Student can complete study related collaboration tasks in Haaga-Helia's ICT environment (Moodle, Microsoft365, using network drives, remote access tools) independently.
Student has command of key concepts of Microsoft Word, PowerPoint and Excel, has a solid grasp of software functionalities and knows how to apply them in practice.
Student has strong skills and can independently use the applications to find new solutions.
Student is able to apply Finnish Document Standard when creating a business letter.
Student has good time management skills and completes assignments on time.

The course is offered only in autumn semesters.

Virtual contact lessons according to Lukkarikone-schedule (Zoom/Teams-links available in course Moodle), individual hands on assignments, exam, and team work.

All material available at the course site.

Pasila Campus

November 26, 2020

English

24.08.2020 - 18.12.2020

Learning assignment 1: Creating a folder for course portfolio & returning read only link to Moodle. Learning assignment 2: Word, Finnish Document Standard & TOC Learning assignment 3: Following Office Applications 1 Teams for course communications (on-going in both in period 1 and 2). Learning assignment 4: Creating Microsoft Teams to facilitate your school group work & ability to change the team settings (at least team theme & member permissions). Demonstrating successful team collaboration with Microsoft Teams for group work & demonstrating the use of conversations, channels, files and co-authoring. For first year Sebba students the content and outcomes for this assignment are part of either Effective Communications in Organisations (COM1LE101) or Business Environment (BUS1LE201) course. Details in Moodle

17.08.2020 - 28.08.2020

Detailed course schedule is available at Moodle

LE1B

Heli Lankinen

15 - 24

SEBBA Degree Programme in Business Service Solutions and Languages

0.00 cr

H-5