Being clear and accurate
This page is full of tips about how to make the best use of technology when you are doing your internal assessment. It is highly recommended that you do use technology to be both accurate and clear and tell help tell the story of your investigation. That said, technology is not accurate and clear by default SO do make sure that you are careful what you do so that you avoid some of the common pitfalls. IMAGE OF TECH required
Pros and cons
Here are some of the things to think about when using technology
Reasons to use technology
- Keep your work organised
- Produce good looking statistical diagrams and tables for your write up
- Get accurate statistics done quickly so you can focus on discussing them
- Make easy comparisons
- Easily edit your work
- Huge saving on labour
- Much more realistic in terms of what you might do in the future.
Things to watch out for
- Technology will only do what you tell it to.
- Still work for you to do on making sure that information is clear, legible and well labelled
- All the different packages have their own issues in terms of appearence. you have to be aware of them and take action accordingly.
A note about software - there are lots of applications available. Here I have focussed on the three that I see most often.
Excel (google sheets of apple numbers or other) - Spreasheets are truly brilliant and few us actually know their full porential. You wont get near it for this project. Most of us have access to one kind of spreasheet or another and there are a number of key skills and processes you should use for this project. for organising data, making simple charts and calculating summary stats, spreadsheets are indespensible.
I am cautious about their use for some of the techniques. and think that there are other tools you could consider at that point.
This is not free and so perhaps you don't have access. Depending on time, you can always download a 30 free trial. Otherwise ask your teachers. I think the statistics unti is still one of the best tools for students doing this course and highly recommend it. It looks good, allows for easy transfer to a publishable file and performs all the functions you need.
This software is so regularly updated, that these videos will need changing! Geogebra is free and can be used for lots of the skills needed in this context (along with untold amounts of other things!).
Excel for organising
This video is just some advice and key skills for keeping work and information organised as you go. Little things that can end up making quite a big difference.
Advice on the following...
- Organising information
- Using filters
- Freezing panes
- Formatting number cells
- Sperating work in to different worksheets
Using Excel to calculate summary data statistics
This video shows how to calculate mean and standard deviation using excel.
Using Excel for Scattergraphs and Regression
I am not convinced that excel is the best tool fo rthis BUT everything can be done here if you are careful for a few pitfals. Itv also integrates nicely for publishing. Here you can see how we do all this with excel. For reminders on scatter diagrams and regression, visit this Correlation and Regression page.
Using Excel for other summary Charts
Making bar charts and pie charts for visualsing information. These should be used carefully, not rpetetitively and only if they help to acheive the goals you ste out. The video goes over some basics of producing these diagrams.
1 variable analysis with Autograph
These videos go over one variable analysis using autograph. It is an excellent pieece of software for this purpose. (See note above about software)
2 variable data analysis with Autograph.
Scatter diagrams, correlation and regression lines. this video talks you through this process with ayutograph and goes over the key points to think about. For reminders on scatter diagrams and regression, visit this Correlation and Regression page.
1 Varibale data with Geogebra
Geogebra - Processing one varibale data and producing box plots and histograms
2 Variable data with Geogebra
Processing bivariate data, scatter diagrams, correlation and regression using Geogebra. For reminders on scatter diagrams and regression, visit this Correlation and Regression page.
How to use technology to help with further processes
Chi Squared tests as a further process
Using a spreadsheet to construct a chi squared test whilst doing the sumary parts by hand.
PMCC as a further process
Using a spreadsheet to carry out calculations for correlation and regression whilst doing the sumary parts by hand.