MATH 1031 - Spreadsheet Assignment #1 To complete the spreadsheet assignments, you should create a GoogleSheet from your

[answerhappygod]

Math 1031 Spreadsheet Assignment 1 To Complete The Spreadsheet Assignments You Should Create A Googlesheet From Your 1 (328.3 KiB) Viewed 88 times

MATH 1031 - Spreadsheet Assignment #1 To complete the spreadsheet assignments, you should create a GoogleSheet from your UMN Google account and share it with your TA. The instructions on how to do so are included in the video "How to Create a Spreadsheet in Google Sheets”. There will be another spreadsheet assignment later. You should use the same Google Sheet and open a new tab for the second assignment. That will all be described later. You will only need to share the Google Sheet with your TA once. The second spreadsheet video "Getting Started with a Google Sheets" covers how to perform calculations with formulas. A third spreadsheet video "Copying and pasting Formulas” covers how to quickly copy formulas into multiple cells. The first assignment is to create a spreadsheet which creates a table of values for one of the Visual Patterns from visualpatterns.org. Your TA will assign which two problems you should complete. One problem will be an arithmetic sequence. (Visual Pattern #10, 11, 14, 15, or 17). You should have three columns, one labelled 'Step', one labelled 'Recursive' and one labelled 'Explicit'. You should build a table that has the step values 1 through 43 in the 'Step' column. The 'Recursive' column will begin with a specific value (a number) which you will enter, and then below that initial value should be a formula that refers to the previous entry in the 'Recursive column. The ‘Explicit column should contain formulas that refer to the step number. Your completed table should correctly calculate the number of objects for each step twice, The numbers in the 'Recursive column should match the numbers in the ‘Explicit' column. For the second problem (Visual Pattern #8, 13, or 16), you likely will only be able to do the recursive formula. You have have two columns, one for the ‘Step’, and one for the number of objects (Penguins, Footballs, Triangles).