Excel Spreadsheet Calculation in Business (2op)
Toteutuksen tunnus: KD19CNTT012-3001
Toteutuksen perustiedot
- Ilmoittautumisaika
- 10.12.2016 - 16.01.2017
- Ilmoittautuminen toteutukselle on päättynyt.
- Ajoitus
- 09.01.2017 - 17.02.2017
- Toteutus on päättynyt.
- Opintopistemäärä
- 2 op
- Lähiosuus
- 2 op
- Toteutustapa
- Lähiopetus
- Opetuskielet
- englanti
- Koulutus
- Bachelor of Business Administration, International Business
- Gateway to International Business
- Opettajat
- Osmo Mäkiniemi
- Opintojakso
- KD19CNTT012
Tavoitteet
Students are able to plan, implement and utilise various calculation models. They are able to present the results graphically. Students are also able to make summaries of the information in tables and utilise other special features in the Excel software.
Sisältö
- Creating and editing spreadheets with Excel
- Writing formulas and using functions
- Processing/sorting information in a spreadsheet
- Using Pivot tables
- Creating and editing graphs and charts
- Goal Seek
- Basic macros
- Special features in the Excel
Oppimateriaalit
- Excel tutorials from Microsoft
- Tutorial from learnfree.org service
Opetusmenetelmät
- computer-based lessons and guided practice
- independent work
Tenttien ajankohdat ja uusintamahdollisuudet
Exam on computer at week 7.
Retake at week 10.
Toteutuksen valinnaiset suoritustavat
Doing assignments virtually and exam on computers without participation in classes. But this is not recommended.
Opiskelijan ajankäyttö ja kuormitus
- lectures and guided practice 24 h
- independent work 30 h
Arviointikriteerit, tyydyttävä (1)
The student is able to plan, implement and utilise calculation models with some help. The student is able to present the results using basic charts and is also able to make summaries of the information in tables and utilise some other essential features in the Excel software. In this work the student needs some help.
Arviointikriteerit, hyvä (3)
The student is able to plan, implement and utilise a variety of Excel tasks. The student is able to present the results using charts and is also able to make summaries of the information in tables and utilise other special features in the Excel software.
Arviointikriteerit, kiitettävä (5)
The student is able to plan independently, implement and utilise a variety of various calculation models. The student is able to present the results using excellent charts and is also able to make summaries of the information in tables, filter information and utilise very well other special features in the Excel software.
Esitietovaatimukset
Basics of mathematics and ICT skills