|
Spreadsheets are very important software applications in business environments,
but they can also be used to effectively manage any data that can be arranged in
a single row. For instance, a list of wedding invites. You would
store items like frst_nme, lst_name, addrss, pstl_cde, and phne. See if
you can identify some of the rules that I am using for my field naming
convention. For example, an underscore character is used between words
separated by a space
Businesses use spreadsheets to maintain information that requires calculations.
Spreadsheets have a capacity to store many numbers and perform many math and
statistical calculations depending on the problem to be solved.
For the first part of the spreadsheet module, you will become familiar with
aspects of Microsoft Works. Then will will challenge your skills with a
project.
Task 1 - Review of Notes and Theory
Please Review Notes very
carefully. You are responsible for this content on quizzes. Task 2 - Manual
 |
Create a folder in your account called
SPREADSHEET using maintain your files |
|
Use the following manual on-line
521_801_spreadsheet_manual.pdf |
|
Read the notes and instructions in each of
the 7 assignments/labs. |
|
SAVE file accordingly in your SPREADSHEET
folder. |
|
Complete exercises 1, 2, 3 in the lab manual. Don't worry about the charts.
Save as per the instructions. |
|
DO NOT PRINT as the instructions indicate
in Lab #7. Just make sure to save your work each day. |
Task 3
Answer questions
using WordPerfect. You may use the Internet, application, or help to
help you answer the questions.
Save your file as: ss_theory_questions.wpd in the spreadsheet
folder Task 4 - Naming Ranges and Cross Tabs
Complete this exercise.
naming_ranges_cross_tab_reports.pdf Task 5
- Ice Cream Survey
Instructions on how to do this will be given in class. You should try to
use some of the features of the application that you have learned so far.
Specifically, you will need to complete the following operations.
|
calculate the average scoops per month for the class |
|
calculate the total number of scoops |
|
find the total money spent on ice cream by the class if each
scoop costs $1.25 |
|
create a pie chart with the percentage of student and the type
of ice cream |
|
create cross tab of the favorite ice cream data |
Task 6 - Data Analysis
-
do a search in help and look up information about the min and
max functions
-
read help on importing comma delimited files
-
right click on the file link and save target as:
class_survey_data.csv and save to your G
drive
-
Open Quattro Pro
-
Open class_survey_data.csv
-
Save as a Quattro Pro worksheet
-
for all numerical data, calculate averages, min, max, sums
-
try the cross tab report under the tools menu - try to come up
with the following reports below.
You can put a new cross tab on each tab of the workbook. Make sure to
put a cross tab report title at the top of the sheet. For the first
report, you might use a title like "How CMP521 Students Rate School Spirit"
-
percentage breakdown of school spirit
-
average hours of sleep: male vs female
-
average hours of homework: male vs female
-
percentage breakdown of ice cream favorites
-
percentage of total: students with part-time jobs
-
percentage of total: male vs female with part-time jobs
-
average number of books read: male vs female
-
average hours of fitness: male vs female
-
average heart rate: male vs female
-
average movie trips: male vs female
-
percentage of total breakdown of transportation mode
-
percentage of total breakdown of driver license
Make sure to save your work. Task 7 - Mail
Merge from a Spreadsheet to WordPerfect
pizza_party_quattro_to_wordperfect_merge.pdf | 
