Wiki Page, BLT Sem 2: Excel - Unit G Objectives and Introduction-3

Wiki Page
2023-01-19T11:15:19-07:00

After completing this unit, the student will be able to:

Navigate a Workbook | Enter labels and values | Work with columns and rows | Use formulas
Use AutoSum | Change alignment and number format | Enhance a Worksheet | Preview/Print a worksheet

Follow these instructions in order:

1. Interactive Document - Getting to Know Excel 2013

2. Textbook - pgs. 180-185 - work together on the screen

3. Watch the video: Excel 2013_ Cell Basics

4. Textbook - pgs. 186-189 - work together on the screen

5. Excel Spreadsheet Formulas and Functions (Quiz over this later)

6. Watch the video: Excel 2013_ Simple Formulas_(720p).mp4

7. Practice Lessons for Formulas

Practice Formulas.xlsx | Lesson 1.xls | Lesson 2.doc
Lesson 3.xlsx | Lesson 4.xlsx | Lesson 5.xlsx

8. Textbook - pgs. 190-195 - work together on the screen

9. Watch the video:Excel 2013_ Formatting Cells_(720p).mp4

10. Book Assignments: Continue by Clicking the Next Button

 Extra Assignments:

11. Probability Lab - will need dice from Mr. Long

12. In The Lab 1 - BONUS - (Handout)

13. Stock Market Game - we will all do together in class

14. Prepare for Final Test by Studying Unit G Powerpoint