Excel spreadsheet using intermediate skills **SEE ATTACHED INSTRUCTIONS FOR REQUIREMENTS**
Programming and SDLC – Module Assignment
(be sure to review all three pages below )
INTRODUCTION: In this assignment you will create a special Excel worksheet. By doing so, you will earn
points in two ways: (1) by using the Excel formatting techniques that you learned about in the Atomic
Learning tutorials, and (2) by demonstrating what you learned from the Programming and SDLC content
in this module.
INSTRUCTIONS (Excel formatting, 50 pts ) Note: The formatting and functionality you are being asked to
perform were covered in the Atomic Learning videos. If you need to go back and review a tutorial,
please do so.
1. Open Microsoft Excel and create a new blank workbook. Save the workbook with your own
name as its filename . For example, a student named Jane Doe would save the file as “JaneDoe. ”
Make sure you save your file in a location where you can find it later!
2. In your worksheet, enter your Full Name in cell A1 (feel free to make column A wider).
3. Enter t oday’s date in c ell A2 .
4. In cells A5 through A14 enter 10 numbers between 1 and 100. (You can choose any numbers
between 1 and 100 and enter them in any order. The numbers should all be different. When
you’re done you should have 10 different numbers between 1 and 100 in cells A5 through A14.)
5. In cell A15 , use the average function to calculate the average of those 10 numbers.
6. In cell A4 , type a name for your column of numbers (you can make up any name you wish).
7. Create a new chart (you choose the type) to show the data tha t you entered in cells A4 -A14 .
Place the chart anywhere on the worksheet where it’s visible and doesn’t cover up any data on
the worksheet.
8. Apply Conditional Formatting to cells A5 through A14 . You can choose Data Bars, Color Scales,
or Icon Sets.
9. Type the word “Mood ” in cell B4 .
10. In cells B5 through B14 use the “if” function to determine if the values in cells A5 through A14
are greater than 50. If the value is greater than 50 in a particular cell in A5 -A14 then the
corresponding cell in B5 -B14 should show “Happy” otherwise it should show “Sad.”
11. Find a picture of an animal whose name starts with the same letter as your first name. For
example, if your name is Amanda you might look for an image of an antelope . Insert that image
into your worksheet (anywhere i s fine as long as it doesn’t cover up any of the other info in the
worksheet).
12. Use what you’ve learned so far about Excel formatting to make your worksheet more
professional looking or more visually pleasing. Feel free to change the fonts, add borders, add a
graphic or two, or do anything else (as long as it doesn’t reduce the readability of the
information presented ). INSTRUCTIONS (Programming and SDLC, 50 pts )
Your answers MUST be in the correct cells in order to receive credit.
1. In this module we learned that Babbage’s Analytical Engine is often considered to be the first
mechanical computing device. However, people clearly had the ability to count and do
arithmetic using other means before this device was invented. Using your fav orite Web search
engine, identify at least THREE methods or devices that people used hundreds (or even
thousands) of years ago to count things and/or do arithmetic. Place your three answers in cells
A17 , A 18 , and A 19 .
2. Computers and software have automated many things that were done manually in the past. For
each of the following modern technologies, describe how the same task might have been
accomplished 100 years ago. The old method may not exactly match the new, technology -
based method, but be thoughtfu l and creative in identifying ways that one could have
accomplished the same function in the pre -computing days using “old -fashioned” materials and
resources. Place your answers for the following three items in the three indicated cells:
GPS substitute – place your answer in cell A2 0.
emai l substitute -- place your answer in cell A2 1.
Instagram substitute -- place your answer in cell A2 2.
3. List, and briefly describe the purpose of, the three primitive control or logic structures. (Hint:
These structures are given in the Programming Methodologies section of this module’s reading,
titled programming and sdlc.pdf.) Place your three answers in cells A2 3, A2 4, and A2 5.
4. Given what you’ve learned so far about programming and the Software Development Life Cycle,
try to think of a new or interesting job/application that could be done by a computer,
smartphone, or similar. Use your imagination for this one! Place your answer in cell A2 6.
Submit your assignment – When you’re satisfied with your formatting and answers su bmit your Excel
file by accessing the dropbox that is part of this module. EXAMPLE – Below is an example of a mostly completed worksheet (minus the animal) . Note that yours
may look somewhat different. However, it’s important that you include the requested data (and
answers) in the exact cells noted in the assignment.
