Advanced Spreadsheets for Business and Economics

Week # 1 - Chapter # 1 Assignment

This week we cover the Level 2 and 3 of Chapter One of your textbook. Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 23. Power Points are available in Blackboard Lectures and, video tutorials guiding you through the Learning part of each level of each chapter are available on youtube.com. See your course Syllabus for the link.

WATCH THE VIDEOS-- WATCH THE VIDEOS -- WATCH THE VIDEOS. Use the Chapter # 1 – Videos presentation to see the videos if you prefer. Let's get started: ==========================================================================================

NOTE: Create a Word Document named: 1-Essay-Chapter1-YourName for

all the essay parts (Answer questions).

If you have difficult with EXCEL or you have not practice with

EXCEL, I recommend that you check the Level # 1 of Chapter # 1

before you continue.

Week # 1 - Chapter # 1 Assignment

Level 2: Objectives  Work with multiple worksheets  Calculate total, average, minimum, and maximum values with functions  Understand how functions work: syntax, arguments, and algorithms  Use the AutoSum feature to perform calculations quickly  Calculate the number of values using both COUNT and COUNTA

Level Two: LEARNING Open CH01 Level 2 Figures.xlsx This file is the same as the figures in your textbook for Level 2 Starting on 43 of your textbook. You should read the learning material covered on pages 43-51 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: Calculating and Comparing Data Using Simple Functions. or use the link: https://www.youtube.com/watch?v=7BgYlPeEeuo After you understand the material: Answer the following question in the Word Document 1-Essay-Chapter1-YourName Question for Chapter 1 - Level # 2: (10 POINTS)

1- Define the syntax of the function COUNT and COUNTA. What is the difference between these two functions?

Level Two: PRACTICE

Using the “Week # 1 - Chapter 1 - Exercises.pdf” document, make the Exercise Ch1-3: Level 2 – Labor Comparison

Post your completed file to Blackboard for review and grading. The file Name should be 1-3-Labor Comparision-Your-Name.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Level Two: APPLYING

Using the “Week # 1 - Chapter 1 - Exercises.pdf” document, make the Exercise Ch1-4: Level 2 – Job Analysis

Post your completed file to Blackboard for review and grading. The file Name should be 1-4-Job-Analysis-Your-Name.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 1 - Chapter # 1 Assignment

Level 3: Objectives  Organize a workbook  Understand relative, absolute, and mixed cell referencing  Write formulas with different types of cell references  Copy formulas with different types of cell references  Name a cell or cell range

Level Three: LEARNING Open CH01 Level 3 Figures.xlsx. This file is the same as the figures in your textbook for Level 3 Starting on 54 of your textbook.

You should read the learning material covered on pages 54-67of your text book and the youtube.com video tutorial for this level.

Use the attached presentation in Level 3 to see the video Level 3: Analyzing Cell References When Writing and Copying Formulas. or use the link: https://www.youtube.com/watch?v=s7ZgikkMxS0

After you understand the material: Answer the following question in the Word Document 1-Essay-Chapter1-YourName Question for Chapter 1 - Level # 3: (10 POINTS)

1- Define the relative, absolute and mixed cell referencing? Part Three: PRACTICE

Using the “Week # 1 - Chapter 1 - Exercises.pdf” document, make the Exercise Ch1-5: Level 3 – Job Analysis

Post your completed file to Blackboard for review and grading. The file Name should be 1-5-Texture-Budget-Your-Name. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

Part Three: APPLYING

Using the “Week # 1 - Chapter 1 - Exercises.pdf” document, make the Exercise Ch1-6: Level 3 – CKG Sales

Post your completed file to Blackboard for review and grading. The file Name should be 1-6-CKG-Sales-Your-Name.xlsx POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (20 POINTS)

==================================================================

Week # 1 - Chapter # 1 Assignment

Let me know if there is anything you don't understand -- the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.

The solution files that you need to attach are: 1-3-Labor Comparision-Your-Name.xlsx (20 points) 1-4-Job-Analysis-Your-Name.xlsx (20 points) 1-5-Textured-Budget-Your-Name.xlxs (20 points) 1-6- CKG Sales-Your-Name.xlsx (20 points) 1-Essay-Chapter1-YourName.docx (With the answer of the questions proposed) (20 points)