|
.............................. .........(45 marks)
In order to make sure that you understand how to manipulate spreadsheet documents and create graphic images, students
will be required to complete the following review documents.
Worksheet 16.1 - Aztec Cafe
Worksheet 16.2 - Diet
Worksheet 16.3 - Activity
Worksheet 16.1 - Aztec Cafe
.......................................(15 marks)
Mr. Hernandez, owner of the Aztec Cafe has decided to use a spreadsheet to keep track of the number of hours his employees
work.
a) In a new spreadsheet, enter the employee data, resizing the days of the week columns as required:
b)Save the spreadsheet naming it AZTEC.
c) In column I enter formulas to display the total number of hours worked by each employee. Enter an appropriate label
in cell I3
d) Bold all the titles. Format the days and the titles to be right aligned.
e) Create a Line Chart that displays the total hours worked for each employee.
f) Save the Aztec spreadsheet file.
g) ** E-MAIL YOUR "AZTEC" SPREADSHEET FOR GRADING ONCE YOU HAVE COMPLETED ALL OF THE SPREADSHEET REVIEW ASSIGNMENTS
... After "Activity"
Worksheet 16.2 - Diet
..........................................(15 marks)
You are to produce a spreadsheet to help determine your caloric intake for a week.
a) In a new spreadsheet,
enter data for the calories you consume in a typical week. Include appropriate labels and formatting. Your spreadsheet may
have different numbers but should look similar to:
b) Save the spreadsheet naming it DIET
c) Have the spreadsheet calculate the total number of calories consumed each day, the total for the week, and the average
number of calories consumed per day. Round your totals and averages to 1 decimal place. Be sure to include appropriate labels
and proper formatting
d) Create a Pie Chart that displays the total of each catagory
e) Save the Diet spreadsheet file.
f) ** E-MAIL YOUR "DIET" SPREADSHEET FOR GRADING ONCE YOU HAVE COMPLETED ALL OF THE SPREADSHEET REVIEW ASSIGNMENTS
...After "Activity"
Worksheet 16.3 - Activity
......................................... (15 marks)
Spreadsheets can be helpful in personal time management. You are to plan and create a spreadsheet to help determine the time
spent on different activities during the week
a) In a new spreadsheet store the number of hours you spend each day of them week at each of the following activities:
School Classes
Athletics
Extracurricular activities or clubs
Studying and doing homework
Eating
Sleeping
Watching TV or listening to music
Talking on the phone
Working / playing on a computer
Doing chores at home
Working at a part time job
b) Save the spreadsheet naming it "ACTIVITY".
c) Have the spreadsheet calculate the total hours spent for the week on each activity. Also calculate the average number
of hours spent per day on each activity for the week.
d) Most peoples schedules do not account for all 24 in a day. Add a row that calculates and displays the amount of unaccounted
time in your schedule for each day.
e) Create a Bar Chart that displays the total of each category
f) Save the Activity spreadsheet file.
g) ** E-MAIL ALL YOUR SPREADSHEET EVIEW ASSIGNMENTS FOR GRADING
Once you feel confident that you have completed this lesson, e-mail your document as an attachment to your iinstructor
at the following address:
aujla_m@.sd36.bc.ca
Your document should include the appropriate file extension in order for the formating to remain in transmission.
For sending documents from Apppleworks, use the extension ".cwk". A correct file name and extension would look
similar to:
L16aztec.cwk
L16diet,cwk
L16activity.cwk
Notice that any spaces in the file name have been removed and an indicator of which lesson (L16) has been added.
The assigned value for this assignment will be returned once it has been graded.
|
