NOTE: Images can be expanded by clicking on them
———————————————————————————————————————————————-
Welcome to the Project 1 Page. This is a team Project including myself and Scott Griffin. This page contains all the information to do with the module aids.
Project aim: to provide information and resources about the Me544 module through the use of different formats to aid with study.
Here is a link to Scott Griffin’s website: blogs.brighton.ac.uk/scottdesignengineeringcourse/
Context
The ME544 studies various material properties using different laboratory sessions and lectures. Within this module students learn about stress, strains, beams, bending moments, shear moments and other topics. For this project, we will discuss, find and provide ways of aiding students with the ME544 materials engineering module and their studies.
Project objectives:
- Perform research to understand how to make profession leaflets, posters and videos.
- Produce posters for each machine of the materials lab.
- Produce an all in one excel spreadsheet for all laboratory session in the module.
User requirements
- The information needs to be easily understood and readable.
- The information needs to not become boring to read or look at.
- The information needs to attract and intrigue the person studying the module.
- The resources need to be easily used.
- The resources need to be widely accessible.
- The resources need to act as a guide to its specific topic.
Project requirements:
- The resources and information should be widely accessible.
- The resources and information need to be clear, readable and understandable.
- All information and resources should be neat and well organised.
Project Outcomes/Deliverables
Webpage/portfolio and presentation. A PowerPoint presentation of the module. Posters about the module and machines involved. Excel spreadsheets. Videos of module.
———————————————————————————————————————————————-
Discussing the Project
A big problem with this project is the delivery of the information and whether or not it will actually be received properly. If we deliver this information as a sheet of paper with lots of paragraphs, the reader would become uninterested and bored meaning they would be less likely to take in the information, not helping them in the ME544 module. Because of this, it is important that we select the correct formats for the information to be delivered.
To start this project off, Scott and I discussed different ways that we could provide information which can be used to aid in studying the module. From this discussion we decided on a couple of formats that would work. We aim to help students with the ME544 module through:
- Posters – Having posters, showing and explaining the different machines that are used in the module. The posters could contain information on how to obtain data and how it can be used to produce graphs.
- Leaflets/Flyers – This would provide information on the module, formulas used within, graphs and other information handy to have.
- An all in one excel spreadsheet – this would cover all the laboratory session but instead of them being on separate excel spreadsheets, people can access them from one location. This can also be used as a reference or as a template for students own works.
- A potential video – a guide of the laboratories and how the machines function.
Download link click here: Project 1 allocated tasks
———————————————————————————————————————————————————————-
Posters
Tensile testing initial poster
I started by creating an initial poster that consisted of information on the machine and what it can be used for. I worked with Scott so that the designs of the posters can match and be designed using the same styles. Because of this the text font is the same and the photo layout on the poster is in the same place. Also there is a graph in the centre of the poster. To make the poster slightly different, I have highlighted some parts in blue. On Scott’s torsion poster the highlighted parts are yellow/orange.
Here is a photo of the initial poster.
Here is a download link to the initial poster: Tensile testing poster
To improve this poster I am going to change around the information boxes at the bottom. I may also change up the information here for some that are more useful for the readers and users. I will also make the boxes more uniform and straight. Having the box on the left slanted, makes it look a bit awkward and I feel it throws the rest of the poster off. I may also add highlights to the outside of boxes so it matches more with Scott’s posters and so the information stands out individually.
Learning outcomes involved
DE502 LO5: collaborative team work in order to ensure similarity within the designs of the poster
———————————————————————————————————————————————————————-
Tensile testing improved poster
here is a photo of the tensile testing poster that I improved. Download link here: Tensile testing poster v2
To improve the tensile testing poster I started by removing and changing some of the writing below the graph. I noticed that one of the sentences at the bottom was the same as one above the graph, so I removed it as it was not needed. I also decided to change the uses of machine section into a sentence to make it shorter and more uniform. I also highlighted the righting in blue to match the top. Another improvement that I have made is adding some writing which explains why it is good to test materials.
———————————————————————————————————————————————————————-
Latest version of tensile testing poster
For the latest version of the tensile testing poster, I worked with Scott to improve upon the graph and the information on the poster. We felt as though the poster didnt provide enough detail and aimed to improve this and make the poster more valuable. Here is a photo and download link of the latest version of the poster:
Download link Click Here: Tensile testing poster v3
For this version we changed up the graph so that it only shows the stress strain curve for steel but it shows more aspects of it. This new version shows the different zones, and the locations of yield strength, Ultimate tensile strength and the fracture point. Another thing we changed to improve the posters was removing the photos. This was because some of them were not necessary, for example, we previously had a photo of the universal testing machine. This would be wasting space on the poster especially since the poster is intended to be placed next to the machine. We also added a table of different materials and their properties. To find these figures we used Edupack and selected a range of materials.
———————————————————————————————————————————————————————-
All in one excel spreadsheet
The aim of this task is to create an excel spreadsheet that contains all the labs from the ME544 module, allowing them to be accessed from one location and students can use this spreadsheet to obtain quick and easy result whilst also being able to use the sheets to create there own. This will also be designed to help students understand how different parts are calculated.
Current version
Currently I have not finished the all in one excel. I plan on writing a full description on what the different sheets are and what they can be used for. I also planned on adding gifs or images which show the user how to use the spreadsheet. To use this spreadsheet you have to already have some data that you have collected. For an example I have added some pre-collected data to the tensile testing spreadsheet. This was also used to help make sure the spreadsheet was functioning correctly.
Here is a download link to the current All in one excel spreadsheet:
All in one Excel spreadsheet for ME544 lab session v2
Previous versions of the all in one excel
All in one Excel spreadsheet for ME544 lab session
——————————————————————————————————————————————————————–
Environmental factors
This project could use a lot of paper if we are not careful. If we use too much paper then we are contributing to global warming and deforestation. The paper that we use should be recyclable paper. This way we are preventing more trees from being chopped down and only using stuff that has already been used. Here should also limit the amount of poster that we make. This is because printing uses electricity and this can come from coal power station which ultimately contribute to global warming. When printing we should limit the amount we are or we can ensure that we are printing from better sources of power. For example, the electricity for print could come from wind turbines which is much healthier for the environment.
Social context
This project could be advertised on the university social media sites. This would allow students to know about the all in one excel and the posters. This could also act as a way for people to access the downloads without struggle. The leaflets can be handed out in person to the people studying the topics. This would allow for another resource and questions could be asked to the distributers.
——————————————————————————————————————————————————————–
Reference list
How to highlight biggest value:
How to look up a value and return it:
https://www.extendoffice.com/documents/excel/4159-excel-return-value-below-or-above.html
How to ignore blank cells:
https://www.excelhow.net/how-to-ignore-blank-cells-in-a-formula-in-excel.html
https://exceljet.net/formula/if-cell-is-blank
https://exceljet.net/formula/unique-values-ignore-blanks
Finding the location of data:
https://www.lifewire.com/find-location-of-data-with-match-function-in-excel
Finding closest value:
https://www.extendoffice.com/documents/excel/1050-excel-find-closest-value.html
Value of last non-empty cell:
https://exceljet.net/formula/get-value-of-last-non-empty-cell