Spreadsheet Operations

1. Have something to write with! Spreadsheet Operations Learning Target I can learn about spreadsheet operations.

2. Notes • Grab a sheet of paper • Fold as I am demonstrating • Labels • Spreadsheet Operations • Sorts • Freeze Panes • Fill Series • Print • Linking & Embedding

3. Spreadsheet Operations— increase. . . . . • theefficiency of data entry • the performing of calculations, and • the presentation of information.

4. Types of Spreadsheet Operations • Sorts • Primary Sort • Secondary Sort • Freeze Panes • Fill Series • Print • Print Preview • Print a Selection • Linking and Embedding • Target • Source

5. Sorts A Sort is used to arrangedata in alphabetical or chronologicalorder • data can be sorted in Ascendingor Descending Order Examples of: Alphabetical order—Ascending A to Z Alphabetical order—Descending Z to A Numerical order—Ascending 1 to 10 Numerical order—Descending 10 to 1

6. Sorts • Primary sort – indicates the primary sort range of data (i.e., last name) • also known as a single sort • Secondary sort – indicates the next sort range of data (i.e., first name) • also known as a multiplesort Examples of primary and secondary sort: Smith, Chris Smith, Ryan Stevens, John Can you answer this question?: Mr. Smith sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation? _________________________

7. Freezing Panes • Allows the user to work in multiple areas of a large spreadsheetand focus the view on specific cell ranges. • Freezing Panes allows the row and/or columns labels or titles to remain stationary on the screen while you scroll. Examples: (1) John arranged his spreadsheet so that he could view the cell range B1:B10 and Row 3 while he worked in cells on Row 180. He would Freeze the Panes so he could see Row 3 and Row 180 at the same time. (2) If Sue wants to keep rows and columns visible so they don’t scroll off the screen as she moves around on the worksheet, she would use the Freeze Panes operation.

8. Fill Series • used to fill a column or row with consecutive data • Examples: • the days of the week • Monthsof the year • numerical numbers • such as, check numbers that were deleted from a spreadsheet Important: these cells must be adjacent (next to each other)

9. Fill Handle • the Fill Handle is used to create the continuation of a data series. The Fill Handle is the square located at the bottom right of the cell. Click and drag on the Fill Handle to complete the series

10. Fill Examples Date Series Months Series Years Series

11. Printing a Spreadsheet • Printing is used to provide a hard copy. • Print preview is used to view how data is represented on paper. • Print a selection is used to print a portion of a spreadsheet

12. Printing Options To print all of the column headings at the top of each page: File, Page Setup, Sheet, Print Titles • Portrait— paper taller than wide • Landscape— paper wider than tall • To print with or without gridlines or with or without row and column headings:

13. Grab your foldable from yesterday & have something to write with! Happy birthday, Madison! Spreadsheet Operations Learning Target I can learn about spreadsheet operations.

14. Linking and Embedding Linking and/or Embedding are used to integrate spreadsheet data with other software applications. • Twoitems needed for either process: • Target document • Source document

15. Linking • Linkingmaintains a connection between two files or objects: 1. the Sourcein which it is created 2. the Targetinto which it is inserted The linked object in the Target file will be updated when the Source file is updated. Example: A word processing document (target) may contain a link to a spreadsheet (source) that will update anytime the spreadsheet data is edited.

16. Embedding • Embedding does NOTmaintain a connection between two files or objects: • theSourcein which it is created and the Targetinto which it is inserted are NOT linked and do NOT have any type of connection. • Unlike a linked object, once embedded, the object becomes part of the Target file (sometimes called Destination file). • Changes you make to the embedded object in the Target file are NOT reflected in the Source file.

17. Embeddingexamples: An embedded spreadsheet is converted into a graphic image when placed in a Target document and does NOT change to reflect edits made at the Source. (2) To ensure that an objectdoes NOT change in a word processing document when it is edited in the spreadsheet of its original creation, the object must be embedded in the word processing document.

18. Open a new spreadsheet! Spreadsheet Operations Learning Target I can execute the sort operation in Excel.

19. Excel It! #5: New Spreadsheet!

20. Excel It! #5: Sorting in Excel

21. Excel It! #5: Select “Custom Sort”

22. Spreadsheet Operations Learning Target I can perform the fill series operation in Excel.

23. Excel It! #6: • Go out on the server • LMS Files • Smith • 7A or 7B • Excel It # 6 • Complete #2 through #10. • ***DO NOT ENTER COLUMN D DATA*** • Remember to File-SAVE when you are finished.

24. Welcome Back! Grab a paper from the basket & go to my website….. Please have a pencil or pen ready! Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

25. Welcome Back! Grab a paper from the basket & open your spreadsheet from last week….. Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

26. Reminders….. • Be respectful • Be prepared • Be prompt • Be focused because……..

27. We are here Holiday Holiday Last Day with Mrs. Smith Holiday Exam?? 1st day with Ms. Wilson No School (Workday) No School (Workday)

28. Good morning! Grab a paper from the basket & go to my website….. Please have a pencil or pen ready! Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

29. Guided Practice-Operations: • Go to my website: • 7th Grade • GP Spreadsheet Operations • Enable Editing • Put your name in the header of the spreadsheet • Follow my instructions and stay with me!

30. Guided Practice-Operations: • Ir a mi sitio web: • 7th Grade • GP Spreadsheet Operations • Enable Editing • Poner su nombre en el encabezado de la hoja de cálculo • Siga mis instrucciones y Quédate conmigo!

31. Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

32. Open your Fortnite spreadsheet from yesterday…. Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

33. Open MS Excel. Find yesterday’s file….. Spreadsheet Operations Learning Target I can execute spreadsheet operations through guided practice.

34. Open your school gmail account….. Spreadsheet Operations Learning Target I can demonstrate mastery of spreadsheet basics.

35. Go to my website! Spreadsheet Operations Learning Target I can execute spreadsheet operations independently.

36. Independent Practice-Operations: Make sure you are on the server!!! Open a new spreadsheet File - Save as your first and last name ---On the server! Do this QUIETLY….raise your hand if you need help.

37. Spreadsheet Operations Learning Target I can execute spreadsheet operations independently.

38. Independent Practice-Operations: Make sure you are on the server!!! If you did notfinish yesterday, open your spreadsheet and continue working. If you did finish yesterday, come to the table and grab a “Wonders of the World” sheet to complete today. The websites are on my website: Useful Links - 7th Grade folder - Wonders of the World

39. Make sure your computer is on the server…..if not, please restart and check again!  Spreadsheet Basics Learning Target I can master spreadsheet operations and formulas.

40. Excel It! #10: Please work QUIETLY! • Make sure you are on the server!!! • Go to my website and open this spreadsheet: Useful Links – 7th Grade folder – Excel It! #10 • File – SAVE AS – in Excel It! #10 folder (on the server) as your first & last name • Remember to File-SAVE again when you are finished.

41. Spreadsheet Operations Learning Target I can review spreadsheet operations and formulas.

42. Spreadsheet Operations Learning Target I can demonstrate understanding of spreadsheet formatting, operations and formulas.

43. Test: Please work QUIETLY! • Part I: Google Form in your inbox (Gmail) • Part II: • Go to my website and open this spreadsheet: Useful Links – 7th Grade folder – Spreadsheet Basics Test • Follow the instructions! • Remember to File-SAVE again when you are finished.

44. Please log in and go to your school Gmail account! Spreadsheet Operations Learning Target I can demonstrate understanding of spreadsheet formatting, operations and formulas.

45. Today…. • Finish Spreadsheet Basics Test • Finish World Travels Research sheet • European City

46. Be sure you are on the server  Spreadsheet Basics Learning Target I can research the functions and formatting used in a spreadsheet.

47. Today: Please work QUIETLY! • Go to my website and open this spreadsheet: Useful Links – 7th Grade folder – Random Coin Tosses Spreadsheet

48. Spreadsheet Basics Learning Target I can format an Excel spreadsheet.

49. B-I-N-G-O! Please work QUIETLY! • Create a BINGO board in Excel • Look at my example….. • File – Save in 7A/7B – BINGO as your first & last name.

50. Spreadsheet Basics Learning Target I can format an Excel spreadsheet and understand spreadsheet vocabulary.