OCR Nationals Level 3 Unit 3 Problem Solving

  • Slides: 10
Download presentation
OCR Nationals Level 3 Unit 3 – Problem Solving AO 3 Collect data and

OCR Nationals Level 3 Unit 3 – Problem Solving AO 3 Collect data and store it using a spreadsheet Summer Term 2010 D. Garey

Important Note: • THIS IS THE SPREADSHEET JUST FOR COLLECTING/COMPILING YOUR RAW DATA!!!!! •

Important Note: • THIS IS THE SPREADSHEET JUST FOR COLLECTING/COMPILING YOUR RAW DATA!!!!! • Don’t worry about any scary calculation, graphs etc yet, its not on this sheet!!! Summer Term 2010 D. Garey

Safety, Security, Efficiency • Conduct some brief research into different interfaces and identify design

Safety, Security, Efficiency • Conduct some brief research into different interfaces and identify design features that will improve speed, safety and accuracy • Think input messages, macros, protection and validation!!!!!! • Screen shots for evidence • For distinction- show understanding of security measures through typed document D. Garey Summer Term 2010

How to create an interface in Excel Write your questions in the cells Write

How to create an interface in Excel Write your questions in the cells Write the relevant answers elsewhere on the worksheet Summer Term 2010 D. Garey

Validation… • Click on the cell where you want the answer to be, go

Validation… • Click on the cell where you want the answer to be, go to DATA then VALIDATION Ensure “LIST” is selected under “ALLOW” Click on Source icon and highlight the possible answers on the spreadsheet Click back on the icon to return to the validation menu Summer Term 2010 D. Garey

Validation… • If you’ve done it properly, you will see a drop down menu

Validation… • If you’ve done it properly, you will see a drop down menu next to your question You can also specify numbers i. e. age range Summer Term 2010 D. Garey

Rename the Sheets • Right click on the sheet tabs to rename the questionaire

Rename the Sheets • Right click on the sheet tabs to rename the questionaire “HOME” and sheet 2 as “RESULTS” • You also need to hide those values on the home sheet Summer Term 2010 D. Garey

Linking the Two Sheets • Go to TOOLS, MACRO and RECORD NEW Fill in

Linking the Two Sheets • Go to TOOLS, MACRO and RECORD NEW Fill in the fields, click record and simply switch from HOME to RESULTS tab and click STOP Enable the FORMS toolbar setting and create a button to link the pages using your macro Summer Term 2010 D. Garey

Recording a Record • • • Create a new macro on the results page,

Recording a Record • • • Create a new macro on the results page, called individual record Click on RECORD, ensuring you are on RESULTS sheet Insert a new row Copy the first cell answer on the home sheet Paste the cell into the RESULTS sheet Continue copying and pasting the answers Press STOP Create a new command button on the home sheet called SUBMIT Try it out!!!! Now write a macro to clear the form, create a button and link it up Summer Term 2010 D. Garey

Video Tutorials • formatting spreadsheet • Validation • protecting cells Summer Term 2010 D.

Video Tutorials • formatting spreadsheet • Validation • protecting cells Summer Term 2010 D. Garey