Software Tools for Electrical Engineering and ITLaajuus (3 cr)
Code: ELA22GY07
Credits
3 op
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Qualifications
Applied Data Tools.
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Materials
Material on Moodle.
Enrollment
02.12.2024 - 31.12.2024
Timing
01.01.2025 - 30.04.2025
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Campus
Vasa, Wolffskavägen 33
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Electrical Engineering and Automation
Teachers
- Jan Berglund
Teacher in charge
Kaj Wikman
Groups
-
UIT24D-VIngenjör (YH), informationsteknik, 2024
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Qualifications
Applied Data Tools.
Enrollment
01.12.2024 - 05.01.2025
Timing
06.01.2025 - 16.03.2025
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Campus
Vasa, Wolffskavägen 33
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Electrical Engineering and Automation
Teachers
- Jan Berglund
Teacher in charge
Ronnie Sundsten
Scheduling groups
- ELA24-Y (Size: 40. Open UAS: 0.)
- ELA24-S (Size: 40. Open UAS: 0.)
- UIT24 (Size: 40. Open UAS: 0.)
Groups
-
ELA24D-VIngenjör (YH), el- och automationsteknik, 2024, dagstudier
-
UIT24D-VIngenjör (YH), informationsteknik, 2024
Small groups
- ELA24-Y
- ELA24-S
- UIT24
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Qualifications
Applied Data Tools.
Enrollment
30.11.2023 - 07.01.2024
Timing
08.01.2024 - 17.03.2024
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
Faculty of Technology and Seafaring
Campus
Vasa, Wolffskavägen 33
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Electrical Engineering and Automation
Teachers
- Jan Berglund
Teacher in charge
Ronnie Sundsten
Scheduling groups
- ELA23-S (Size: 40. Open UAS: 0.)
- ELA23-Y (Size: 40. Open UAS: 0.)
Groups
-
ELA23D-VIngenjör (YH), el- och automationsteknik, 2023, dagstudier
Small groups
- ELA23-S
- ELA23-Y
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Qualifications
Applied Data Tools.
Enrollment
30.11.2023 - 31.12.2023
Timing
01.01.2024 - 12.03.2024
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Campus
Vasa, Wolffskavägen 33
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Electrical Engineering and Automation
Teachers
- Jan Berglund
Teacher in charge
Kaj Wikman
Groups
-
UIT23D-VIngenjör (YH), informationsteknik
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Qualifications
Applied Data Tools.
Enrollment
01.12.2022 - 08.01.2023
Timing
09.01.2023 - 19.03.2023
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
Faculty of Technology and Seafaring
Campus
Vasa, Wolffskavägen 33
Teaching languages
- Svenska
Degree programmes
- Degree Programme in Electrical Engineering and Automation
Teachers
- Susanne Österholm
Scheduling groups
- Group A (Size: 30. Open UAS: 0.)
- Group B (Size: 30. Open UAS: 0.)
- Group C (Size: 30. Open UAS: 0.)
Groups
-
ELA22D-VIngenjör (YH), el- och automationsteknik, 2022, dagstudier
Small groups
- Group A
- Group B
- Group C
Objective
The student:
- can use spreadsheet programs in a variety of ways.
- can automate routines by using a spreadsheet program.
- masters the built-in programming capabilities of a spreadsheet program.
Content
Rehearsal of spreadsheet programs
Built in programming capabilities:
- Editor
- Objects, Collections, Properties, Methods
- The programming language
- Procedures and functions
- Exceptions
- Event-oriented programming
- User Forms
- Diagrams
- Connections to other programs
- Import and export of data
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.
Assessment criteria, good (3)
The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.
Assessment criteria, excellent (5)
he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.
Qualifications
Applied Data Tools.