Spreadsheet CalculationsLaajuus (3 cr)
Code: LT00CL10
Objective
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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet
Content
Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionnaire
- Special features in the Excel
- implementing online survey
Qualifications
Information and Communication Technology
Assessment criteria, satisfactory (1)
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.
Assessment criteria, good (3)
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.
Assessment criteria, excellent (5)
The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.
Materials
Will be announced at the beginning of the cource
Enrollment
13.11.2024 - 15.01.2025
Timing
07.01.2025 - 25.05.2025
Credits
3 op
Virtual proportion (cr)
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Raija Kangassalo
Student groups
-
MLITA24Bachelor of Business Administration, Business Management, Multimodal implementation
Objective
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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet
Content
Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionnaire
- Special features in the Excel
- implementing online survey
Materials
Material assigned by the teacher in Moodle
Teaching methods
Distant learning (Teams)
Student workload
Student workload 108 h
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.
Assessment criteria, good (3)
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.
Assessment criteria, excellent (5)
The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.
Assessment methods and criteria
Independent assingments, Moodle exam
Qualifications
Information and Communication Technology
Enrollment
13.11.2023 - 08.01.2024
Timing
18.01.2024 - 31.03.2024
Credits
3 op
Virtual proportion (cr)
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Leo Sippola
Student groups
-
EXLI24Excel as Business Support Tool
-
MLITA23Bachelor of Business Administration, Business Management, Multimodal implementation
Objective
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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet
Content
Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionnaire
- Special features in the Excel
- implementing online survey
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.
Assessment criteria, good (3)
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.
Assessment criteria, excellent (5)
The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.
Qualifications
Information and Communication Technology
Enrollment
14.11.2022 - 03.04.2023
Timing
13.04.2023 - 14.05.2023
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Marja Erkkilä
Student groups
-
MLITA22
Objective
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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet
Content
Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionnaire
- Special features in the Excel
- implementing online survey
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.
Assessment criteria, good (3)
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.
Assessment criteria, excellent (5)
The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.
Qualifications
Information and Communication Technology
Enrollment
15.10.2021 - 07.01.2022
Timing
18.01.2022 - 25.02.2022
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Leo Sippola
Student groups
-
MLITA21
Objective
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, filter information and utilise other special features in the Excel software. Students can carry out internet poll and use the results in spreadsheet
Content
Creating and editing spreadheets with Excel
- Writing formulae and using functions
- Processing/sorting information in a spreadsheet
- Filtering, summarising, linking
- Using Pivot tables
- Creating and editing graphs and charts
- Printing
- Goal Seek
- Creating an internet questionnaire
- Special features in the Excel
- implementing online survey
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student will do the job of the course requirements successfully. The student is able to plan, implement and utilise calculation models satisfactrorily. The student is able to present the results using charts and is also able to make summaries of the information in tables, filter information and utilise some other special features in the Excel software. Student can carry out internet poll and bring the results to spreadsheet.
Assessment criteria, good (3)
The student will do the job of the course requirements well. The student is able to plan, implement and utilise well a variety of various calculation models. The student is able to present the results using good charts and is also able to make summaries of the information in tables, filter information and utilise other special features in the Excel software. Student can carry out internet poll and use the results in spreadsheet.
Assessment criteria, excellent (5)
The student will do the job of the course requirements perfectly. 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. Student can independently carry out internet poll and use the results in spreadsheet.
Qualifications
Information and Communication Technology