Spreadsheet+Unit




 * **COURSE ** |||| 6207 Computer Skills & Applications  || Spreadsheets – Basics and Formulas  ||
 * **Essential Standard ** |||| Understand the basics of spreadsheets. ||
 * **Essential Question** |||| * What formatting options are used in spreadsheets and why?
 * What operations and formulas are commonly used in spreadsheets? Why?
 * What results are produced by the operations and formulas? ||


 * SWBAT;**
 * **Organize values and labels within a spreadsheet in a useful format**
 * **Format spreadsheet data appropriately for type of data**
 * Spreadsheet Introduction**
 * What is a spreadsheet? Do you or your family use spreadsheets at work or home? For what purposes? Why might businesses use spreadsheets?**
 * What does a spreadsheet look like? How do spreadsheets work?**
 * What does a spreadsheet look like? How do spreadsheets work?**

A. Log in to Quia.com. Take the pretest
 * Pretest Spreadsheets-Basics and Formulas-6207 **

B. View this video on teacher tube:

[|A First Look at Excel]

Activity 1--Download the Anatomy of a Spreadsheet document and save into your My Documents folder on your drive. Open the Spreadsheet basics ppt and save that also. Use what you discovered from the excel video and the ppt to define items on page 12 of the Anatomy of a Spreadsheet document. When you have completed this assignment, show to Mrs. Orbison for credit.





Activity 2--Formulas and Functions



Discussion

Activity 3--Fun with Basic Formulas and Functions




 * 1) 1-10--write formulas
 * 2) 11-test formulas
 * 3) 12-15 reflection questions

Note--use CTRL + ~ to view formulas.

Activity 4--Data that is presented in a uniform and consistent format is much easier to read and understand than data presented with random formats. Formatting can be applied to pages, columns, rows, cells ranges, and cells.

Actividad 4: datos que se presentaron en un formato uniforme y coherente están mucho más fáciles leer y entender que los datos presentados con formatos al azar.

Puede aplicar formato a páginas, columnas, filas, rangos de celdas y celdas

4a. Guided Practice Spreadsheet Formatting

english/spanish version



Complete above together as a class. Save the file as 'Invoice".

Review--Why is formatting important?

4b Activity -Independent Practice Spreadsheet Formatting

Complete the Item above then show to teacher for grade credit. Save the file as "Technology Advancements"

Activity 5--Guided Practice: Use Basic Formulas & Functions



Use Technology Advancements for the assignment above or the file below

Activity 6--Open the GP More Student file Complete together as a class.



Why might a column need to be added or deleted? Why might a spreadsheet need to be moved or renamed?

Key:

Activity 7--Independent Practice-Use Basic Functions Open the "Invoice" spreadsheet Use the following document to complete the actitivy

Activity 8--Guided Practice Spreadsheet Operations Open the file below.Use the document from Activity 6 above to complete exercise.





Activity 9--Independent Practice--Spreadsheet Operations

Do not print, only use print preview.

Activity 10--Capstone Open the following document. Follow directions to prepare a spreadsheet budget.


 * Spreadsheet-Advanced Functions and Charts **
 * **What functions are commonly used in spreadsheets?**
 * **What is the difference between a chart and a graph?**
 * **How is the type of chart determined?**


 * Download both documents below. We will use these to discuss advanced functions.**




 * Practice IF statements: download this file. part I: For each condition, write an IF statement (you may discuss with your elbow partner). Create you own condition and IF statement in #10.**

Open the following spreadsheet. Key the if statements in column C which correspond with the appropriate data.


 * Open and save the following file. We will use this to practice using IF statements:**





Independent Practice-Use IF page 23-Beverages





GP-The Date Function pg. 26-Accounts Receivable

IP-The Date Function pg. 29



GP and IP Page 32. LOOKUP



GP and IP Page 37- LIST



GP COUNT p. 45



GP-The LOOKUP Function p 32

IP-Open the spreadsheet from the previous activity. Use the page below to complete the spreadsheet.