Unit 6: Spreadsheets
6.01 Spreadsheet Basics
1. Key p. 241 - 242 (use disk as appropriate). Basic Tables.
2. Key page 244.
3. Key 88A Page 245-246.
4. Key 89B p. 246-247.
5. Slides 6.01
6. Complete Lesson 126 Spreadsheet skills on pages 336 - 339 using Excel (The one with the Green X).
7. Complete 127F on page 341.
8. Complete pages 342 - 344 (128D - F). When you see a picture of a disk in the margin that means you will open the assignment from the disk in the back of your binder.
9. Complete 6.01 Quiz. Redo if less than 85% on quiz.
6.02 Formulas and Functions.
1. Slides 6.02
2. Complete worksheet D6-7 in your folder. Indicate whether each one is a value, label, function or formula.
3. Complete D6-9 in your folder.
4. Complete D6-15 - Writing Formulas.
5. Complete pages 345-346 in book (Lesson 129B to D).
6. Complete page D6-37 in Binder after creating spreadsheet in Excel.
7. Complete pages D6-39 and 41.
5. Quiz 6.02. Retake if less than 85% is earned on the quiz.
Test 6.0
If you earned an 85% or above go onto your midterm. If not, complete the assignments below:
1. page 447 Activity 2.
2. page 448 Activity 3.
Don't forget to use formulas in all the missing cells. .
3. Complete Activity 2, page 457 together in class for formulas!
4. Redo Quizzes 6.01 and 6.02.
5. Retake Exam 6.0. If you earned 85% or more go on to your midterm exam. If not, then see Mrs. Ray for additional coursework.
Mid-Term Exam
1. Take your mid-term exam.
2. If you achieved 85% or better move on to Unit 7.
3. If you did not achieve 85% or better then review each individual quiz.
4. Retake your mid-term exam. If you did not achieve 85% see Mrs. Ray for specific review and retest.
5. Move on to Unit 7
