Programming and SDLC Module Assignment
Programming and SDLC Module Assignment
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 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 today’s date in cell 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 that 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 is 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)
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 favorite 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, A18, and A19.
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 thoughtful 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 A20. email substitute — place your answer in cell A21.
Instagram substitute — place your answer in cell A22.
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 A23, A24, and A25.
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 A26.