{"id":5302,"date":"2017-06-15T09:33:30","date_gmt":"2017-06-15T08:33:30","guid":{"rendered":"http:\/\/www.mrsphysics.co.uk\/bge\/?p=1109"},"modified":"2025-12-03T00:23:25","modified_gmt":"2025-12-03T00:23:25","slug":"using-excel","status":"publish","type":"post","link":"https:\/\/mrsphysics.co.uk\/index.php\/2017\/06\/15\/using-excel\/","title":{"rendered":"Using Excel"},"content":{"rendered":"\n

Graphs and Tables in Excel<\/h3>\n\n\n\n

Mrs Physics is keen to get everyone using software to aid their Physics, so as part of the forces topic you will complete a Hooke’s Law experiment and write this up and use Excel to create your table and graph. The instructions are given in the booklets below. GLOW users and other users of Office 365 will be using the Excel 2016 version, but users of Office 2010 can use the booklets marked 2010.<\/p>\n\n\n\n

If you missed the lesson and want to practice use this data here.<\/p>\n\n\n\n

Raw data no headings<\/a> Excel file of data for you to practice with.<\/p>\n\n\n\n

CREATING TABLES IN EXCEL<\/h2>\n\n\n\n

I’ve done a crude fix! I do know the link between mass and weight!<\/p>\n\n\n\n

Excel Tables Hookes Law 2020<\/a>   word<\/h3>\n\n\n\n

Excel Tables Hookes Law 2020<\/a> pdf<\/h3>\n\n\n\n

I’ve broken the videos up, but the third one is still large!<\/p>\n\n\n\n

\n
http:\/\/www.mrsphysics.co.uk\/wp-content\/uploads\/bge\/2021\/01\/EXCEL-P1-How-to-download-EXCEL.mp4<\/a><\/video><\/div>\n<\/div>
Part 1<\/figcaption><\/figure>\n\n\n\n
\n
http:\/\/www.mrsphysics.co.uk\/wp-content\/uploads\/bge\/2021\/01\/EXCEL-P2-Learn-Excel-enter-data-wrap-text.mp4<\/a><\/video><\/div>\n<\/div>
Part 2<\/figcaption><\/figure>\n\n\n\n
\n
http:\/\/www.mrsphysics.co.uk\/wp-content\/uploads\/bge\/2021\/01\/EXCEL-P3-Averages-Extension-and-Force.mp4<\/a><\/video><\/div>\n<\/div>
Part 3<\/figcaption><\/figure>\n\n\n\n
\n
http:\/\/www.mrsphysics.co.uk\/bge\/wp-content\/uploads\/2021\/01\/EXCEL-P4-Finishing-and-Printing-the-table.mp4<\/a><\/video><\/div>\n<\/div>
Part 4<\/figcaption><\/figure>\n\n\n\n

CREATING GRAPHS IN EXCEL<\/h2>\n\n\n\n
Plotting Graphs in Excel word<\/a>Download<\/a><\/div>\n\n\n\n
Plotting Graphs in Excel pdf<\/a>Download<\/a><\/div>\n\n\n\n
Covering lots of SALs Significant aspects of Learning!<\/h6>\n\n\n\n

plan investigation<\/a> word  plan investigation<\/a> pdf<\/p>\n\n\n\n

Mrs Physics is keen to get everyone using modern software, so as part of the forces topic you will complete a Hooke’s Law experiment and write this up like an old National 5 Outcome 1 and use Excel to create your table and graph. The instructions are given in the booklets below. GLOW users and other users of Office 365 will be using the Excel 2016 version, but users of Office 2010 can use the booklets marked 2010.<\/p>\n\n\n\n

Excel Tables 2020<\/a>\u00a0 word\u00a0 Excel Tables 2020<\/a> pdf<\/h3>\n\n\n\n

Excel Tables 2010 <\/a>\u00a0\u00a0\u00a0 pdf\u00a0\u00a0 Excel Tables 2010<\/a>\u00a0word<\/p>\n\n\n\n

Plotting Graphs 2010\u00a0<\/a> pdf\u00a0\u00a0 Plotting Graphs 2010<\/a>\u00a0word<\/p>\n\n\n\n

If you were absent when doing the experiment you can use this data to plot your own graph.<\/p>\n\n\n\n

example Hookes<\/a><\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
mass added<\/th>length 1<\/th>length 2<\/th>length 3<\/th>length 4<\/th>\n<\/tr>\n<\/thead>\n
(grams)<\/td>(cm)<\/td>(cm)<\/td>(cm)<\/td>(cm)<\/td>\n<\/tr>\n
100<\/td>5.5<\/td>6.0<\/td>6.0<\/td>5.7<\/td>\n<\/tr>\n
90<\/td>5.0<\/td>5.6<\/td>5.6<\/td>5.1<\/td>\n<\/tr>\n
80<\/td>4.8<\/td>4.8<\/td>5.3<\/td>4.9<\/td>\n<\/tr>\n
70<\/td>4.4<\/td>4.5<\/td>5.0<\/td>4.5<\/td>\n<\/tr>\n
60<\/td>3.9<\/td>4.0<\/td>4.5<\/td>4.1<\/td>\n<\/tr>\n
50<\/td>3.6<\/td>3.6<\/td>4.4<\/td>3.8<\/td>\n<\/tr>\n
40<\/td>3.0<\/td>3.2<\/td>3.4<\/td>3.5<\/td>\n<\/tr>\n
30<\/td>2.7<\/td>2.9<\/td>2.9<\/td>3.0<\/td>\n<\/tr>\n
20<\/td>2.5<\/td>2.5<\/td>2.6<\/td>2.5<\/td>\n<\/tr>\n
10<\/td>2.2<\/td>2.3<\/td>2.1<\/td>2.1<\/td>\n<\/tr>\n
0<\/td>2.1<\/td>2.1<\/td>2.0<\/td>2.0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n
\"\"<\/figure>\n\n\n\n

We are not expecting you to be competent the first time through (as you can see from this student’s data), but hopefully by the time you get to S4 you’ll be quite happy to plot graphs this way.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n
\"Signature\"\/<\/figure>\n\n\n\n

June 2020<\/em><\/p>\n\n\n\n

\n","protected":false},"excerpt":{"rendered":"

Graphs and Tables in Excel Mrs Physics is keen to get everyone using software to aid their Physics, so as part of the forces topic you will complete a Hooke’s Law experiment and write this up and use Excel to create your table and graph. The instructions are given in the booklets below. GLOW users…<\/p>\n","protected":false},"author":3,"featured_media":1122,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"page_builder":"","footnotes":"","_ppma_block_editor_authors":""},"categories":[434,439,1292],"tags":[432,433,435,436,437,438,440,441,442],"ppma_author":[1267],"class_list":["post-5302","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-forces","category-other","category-physics-notes-bge","tag-excel-2010","tag-excel-2016","tag-forces-topic","tag-graph-skills","tag-hookes-law","tag-learning-how-to-plot-graphs","tag-plotting-data","tag-sals","tag-significant-aspects-of-learning","vs-blog blog-single wow fadeInUp"],"acf":[],"authors":[{"term_id":1267,"user_id":3,"is_guest":0,"slug":"n5","display_name":"Mrs Physics","avatar_url":"https:\/\/mrsphysics.co.uk\/wp-content\/uploads\/2025\/12\/OK-scaled.png","author_category":"","first_name":"Mrs","last_name":"Physics","user_url":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/5302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=5302"}],"version-history":[{"count":6,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/5302\/revisions"}],"predecessor-version":[{"id":9341,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/5302\/revisions\/9341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/media\/1122"}],"wp:attachment":[{"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=5302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=5302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=5302"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/mrsphysics.co.uk\/index.php\/wp-json\/wp\/v2\/ppma_author?post=5302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}