Computer science and mechanics laboratory

stacjonarne

I stopnia

obowiązkowy

Laboratory Classes / 38 / z

Project Classes / 6 /z

Total 44 hours

3 point of ECTS

1. Engineering Graphics

2. Computer Science

3. Materials Science

Matlab, Ansys, MS Access

Michał Grązka

Katarzyna Sarzyńska

Kamil Rajkowski

Activity/student workload in hours:

1. Participation in laboratory classes / 38

2. Participation in project classes /6

3. Individual studying of lectures` topics/ 4

4. Individual preparation for project classes / 6

5. Realization of the project / 12

6. Participation in consultations / 8

7. Preparation for the lessons test /16

Total student workload: 90 hours / 3 ECTS

Lectures with the participation of professors (1+2+3+6): 52 hours/ 2 ECTS

Execute applications in MATLAB that use conditional, selection, and iterative statements; construct functions in MATLAB, manage files, and display calculation results on graphs. Use ANSYS Mechanical to solve simple structural and dynamic problems with the finite element method (FEM), e.g. for a planar truss and for the initial stability (buckling) of a compression member. Prepare a logical data model, verify and document the model. Individually design and build a database, and develop user manuals and database documentation.

Laboratory Classes — Verbal and Practical Method Using Computers

1. Testing Conditional Statements in MATLAB (2 h)

Check students’ preparation. Create arithmetic and logical expressions. Apply the if–elseif–else–end conditional statement, of varying complexity, to write a program according to the laboratory exercise instructions. Find and correct errors in the code of a program stored in an .m file.

2. Creating an Application in MATLAB Using Selection Statements (2 h)

Check preparation. Use switch–case–otherwise–end selection statements to develop a program that performs chosen calculator operations on numbers entered from the keyboard. Implement selection control for both text and numeric input.

3. Working with Iterative Statements in MATLAB (2 h)

Check preparation. Practice the operation of iterative statements (loops) such as for–end and while–end. Use loops to compute strength for a number entered from the keyboard and to calculate the sum of a given number series. Ensure correct program operation when incorrect input is provided.

4. Constructing and Calling User Functions in MATLAB (2 h)

Check preparation. Create .m files with the source code of functions with different numbers of input and output parameters according to the laboratory instructions. Use the return command. Call the functions in the main program.

5. Input/Output Operations in MATLAB (2 h)

Check preparation. Load data into a program from the keyboard and from a text file. Display formatted calculation results on the monitor. Save variables to disk files in binary and text formats.

6. MATLAB Graphical Capabilities — Visualizing Results (2 h)

Check preparation. Create applications that display two-dimensional graphs in a graphical window. Generate several function plots on a single graph. Split the graphical window to illustrate multiple plots. Format and annotate charts.

7. Solving Simple Computational Tasks in MATLAB (2 h)

Test your own programming skills in MATLAB based on a randomly selected set of three tasks.

8. Creating Websites in HTML (4 h)

Check preparation. Design and develop a website on a given topic. Use HTML to create a site containing text (with varied typefaces, sizes, and colors), graphics, and links to other websites.

9. Creating a Relational Database Model (2 h)

Verify the model, define data types, and prepare model documentation. Practice creating a database using printed instructions from the teacher.

10. Building a Database for a Book Rental System (4 h)

Create a database for a book rental system using printed instructions. Propose and implement original modifications to the logical model to improve functionality.

11. Developing a Database for Personnel Support in a Design Office (6 h)

Create a database for personnel support in a design office using printed instructions. Propose original modifications to improve the logical model’s functionality and to enhance the user interface.

12. Applying ANSYS Mechanical — Finite Element Method (FEM) (2 h)

Become familiar with the program environment. Select the appropriate element from the library. Prepare a computational model, determine boundary conditions and loads. Solve the task and display both unloaded and loaded layouts.

13. ANSYS Mechanical — Solving Simple Statics Tasks (Flat Bar Grating) (2 h)

Check preparation. Determine the type of rod element from the element library. Define geometric features and material constants; save the database. Draw a flat bar grating, create nodal points, restraints, and loads. Solve the task using FEM and analyze the results.

14. ANSYS Mechanical — Solving Simple Dynamics Tasks (Beam Example) (2 h)

Check preparation. Determine the natural vibration frequency and mode shapes of the beam. Use the Meshing option to create a grid of beam elements. Define degrees of freedom at nodes and display modeling results.

15. ANSYS Mechanical — Stability of a Straight Rod (2 h)

Check preparation. Determine the critical force causing loss of stability of a straight rod loaded axially. Set nonlinear solution options. Animate the deformation process. Create displacement vs. load graphs and validate numerical calculations.

Project Classes — Verbal and Practical Design Method Using Computers and Presentation Tools

1. Individual Database Design and Construction (2 h)

Develop and present the assumptions and requirements for the proposed database. Construct a logical data model.

2. Database Programming (2 h)

Build database components, design a graphical user interface, and prepare support and maintenance tools.

3. Database Documentation (2 h)

Create a user manual for the database and submit the final report.

1. Matlab Help Guide - website of MathWorks

2. Fritsche King, MICROSOFT OFFICE 365 ALL-IN-ONE FOR BEGINNERS & POWER USERS 2022: The Complete Microsoft Office 365 A-Z Mastery Guide for All Users Updated for 2022, wyd. 2+3D, 2022.

3. Michael J Hernandez, Database Design for Mere Mortals: 25th Anniversary Edition, wyd. Addison-Wesley Professional, 2020.

4. Marc DeLisle, Creating your MySQL Database: Practical Design Tips and Techniques: A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily, Packt Publishing (November 25, 2006), ISBN-13: 978-1904811305.

5. Nathan George, Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data, GTech Publishing (March 28, 2022), ISBN-13: ‎ 978-1916211391.

6. Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Addison-Wesley, 2011, ISBN 13: 978-0-136-08620-8.

7. Ansys Help Guide

Symbol and out-come number / Description of the assumed learning outcomes

W1/ K_W05 - Has a structured knowledge of computer architecture, algo-rithmisation, programming methodology and technique, and database construction.

W2 / K_W07 - Has elementary knowledge of computer systems and networks architecture and operating systems, necessary to install, oper-ate and maintain computer tools for the design, engineering calculations and manufacturing of mechatronic components, systems and systems.

U1 / K_U01 - Is able to obtain information from literature, databases and other sources; is able to integrate information obtained, interpret it, and draw conclusions and formulate and justify opinions.

U2 / K_U04 - Is able to prepare a note and give a short presentation on an engineering task.

U3 / K_U07 - Can apply mathematical apparatus appropriate to the scientific disciplines taught in the mechatronics major, can solve basic mathematical problems occurring in the process of designing mechatronic systems.

U4 / K_U09 - Can carry out strength calculations of structural components and determine accelerations and speeds of machine compo-nents; can carry out measurements of basic strength properties of materials.

The course is credited on the basis of: a graded pass.

A prerequisite for receiving a positive grade in the course is obtaining at least 3.00 both for the laboratory and for the project.

The laboratory grade is calculated as a weighted average of: MATLAB laboratory (weight 0.3); database laboratory (weight 0.3); mechanics laboratory (weight 0.3); and HTML laboratory (weight 0.1).

The final grade for the course is issued as a weighted average of the laboratory grade (weight 0.7) and the project grade (weight 0.3).

Achievement of learning outcomes W1 and U4 is assessed during the MATLAB laboratory. Achievement of outcomes W1, U1 and U2 is assessed during the database laboratory and the project. Achievement of outcomes W2 and U4 is assessed during the mechanics laboratory. Achievement of outcome U5 is assessed during the HTML laboratory.

A very good grade is awarded to a student whose weighted average of grades is at least 4.70, who has acquired the knowledge and skills defined by the learning outcomes, and who additionally shows interest in the course, approaches assigned tasks creatively, and demonstrates independence in acquiring knowledge and skills.

A good plus grade is awarded to a student whose weighted average of grades is at least 4.30, who has acquired the knowledge and skills defined by the learning outcomes, and who additionally shows interest in the course, approaches assigned tasks creatively, and demonstrates independence in acquiring knowledge and skills.

A good grade is awarded to a student whose weighted average of grades is at least 3.80, who has acquired the knowledge and skills defined by the curriculum to a good degree, and who is able to solve tasks and problems of medium difficulty.

A satisfactory plus grade is awarded to a student whose weighted average of grades is at least 3.30, who has acquired the knowledge and skills defined by the curriculum to a fairly good degree, and who is able to solve tasks and problems of medium difficulty.

A satisfactory grade is awarded to a student whose weighted average of grades is at least 3.00, who has acquired the knowledge and skills defined by the curriculum to a sufficient degree, and who can independently solve tasks and problems of low difficulty. The student’s knowledge and skills show noticeable gaps, but they are able to fill them under the teacher’s guidance.

An unsatisfactory grade is awarded to a student who does not meet the above requirements.

No