Lackawanna CIS210 Complete Course Latest 2022 February (Full)

CIS210 Computerized Spreadsheet

Module 1 Discussion

DQ1 The first Module in CIS210 will familiarize you with the basic parts of Excel and show you a very simple worksheet.

Think of each worksheet as a large sheet of paper in a book.

Describe the names of all the parts of the Excel window. These names will be used over and over again throughout the text, so their understanding of key terms will help you to build your knowledge and execute assignments with ease.

Share your previous experiences using Excel. Did you use the Microsoft desktop app? The online version, Google sheets? or other?

What features do you like and why? Did you try online collaboration?

Did you find any issues installing Microsoft Office from office.com using your falcons email?

DQ2 Think of examples where a worksheet would be beneficial (for example, to keep track of income for a fund drive for their club, budgeting, holiday gift tracker, etc).

Select a use for a worksheet and develop the planning and analysis, prepare a list of questions that need to be answered with the planning of the worksheet.

 

CIS210 Computerized Spreadsheet

Module 2 Discussion

DQ1 Now that you have created your first charts, repeat the process, only create a different type of chart. Go back to one of the charts you have previously created and repeat the steps for creating the chart but this time, you should explore the options and make other choices than those in the book. You can create any type of chart you want and you can choose any other options you want.

Describe what you did differently this time and why you made the choices you did.

DQ2 This week we have learned about how Microsoft Excel can specifically assist with helping a company.

Taking this as a jumping-off point for your own business (future business), please discuss a company that you would be interested in starting and what you would use Excel for to help with that.

You may like to review the link below or do your own search for ideas:

https://www.goskills.com/Excel/Resources/Uses-of-Excel-in-business

 

 

 

 

 

CIS210 Computerized Spreadsheet

Module 3 Discussion

DQ1 List 3 new skills and strategies you have learned in Excel during the past 2 weeks.

Identify collaboration and social business.

How do you think the systems, tools, and technologies discussed so far support collaboration and social business?

You may like to review the link below or conduct your own research to enrich your discussion ( Please share your resources):

https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

DQ2 This week we looked at the 'needs' of using Excel and how to write a formula.

Taking what you know about your work environment (or any experience you have using Excel), please describe how you determine the 'need' or using Excel.

Do you find it beneficial to create a complex set of formulas or is it best to create simple formulas?  Why or why not for either of the answers?

 

CIS210 Computerized Spreadsheet

Module 4 Discussion

DQ1 In one paragraph, describe one social impact of Excel on everyday life.

In a second paragraph, describe one ethical impact of Excel on everyday life.

Each paragraph should have a minimum of five sentences.

DQ2 This week we have looked at the idea of making Excel user-friendly.

Spreadsheet designers should invest time and effort in planning and developing the sheet to meet the Business's ultimate goals and requirements. Spreadsheet designers should test the functions, as well as the formulas, to ensure that the spreadsheet is functioning well, and it is visually appealing.

Review the instructional materials you have learned so far, and search the internet to answer the following questions:

Discuss 5 recommendations to build a reliable spreadsheet?

Discuss 5 tips you recommend to build a visually appealing spreadsheet.

 

 

 

 

 

CIS210 Computerized Spreadsheet

Module 5 Discussion

DQ1 By now, you are finding that Excel has a lot to offer in terms of applications to help boost a business.  From general accounting to inventory to the overall tracking of balances, Excel can be fully integrated into what a business needs.

Taking what you learned so far, what and how do you see Excel working in the business environment you currently work in (or want to work in)?

DQ2 Spreadsheet programs are used in most businesses today. Microsoft Excel, Google Sheets, or Apple Numbers have a lot of similarities.  Using any of the spreadsheet software, you can enter data, link workbooks, apply mathematical formulas, functions, and charts. Spreadsheets have a range of tools and features to save, manage, and analyze data.

What is Excel's what-if analysis tools:

Goal Seek

Scenario Manager

Data Table

PMT function

What are Pivot Tables?

Pivot Tables and What-if analysis have endless possibilities, list 3 of the most important uses of Pivot Tables and what-if analysis for business owners.

 

CIS210 Computerized Spreadsheet

Module 6 Discussion

DQ1 By now you have had multiple weeks working with Excel.

Thinking about what the software is (and what it isn't), what tool do you see as the most valuable and what tool do you see as having no value to you.

Explain both of your positions.

DQ2 This week, please discuss the following questions:

What do you think are some of the better functionality items that Excel has to offer for security?

Compare MS Excel 365 online, Google Sheets, and Apple Numbers. List at least 3 similarities and 3 differences.

 

 

 

 

CIS210 Computerized Spreadsheet

Module 7 Discussion

DQ1 This week you have learned how to create a macro with the macro recorder.

Initially, what are the limitations of the process?

Do you think you could create a recorded macro for almost any application? Why or why not?

DQ2

Watch the video below about adding hyperlinks and external page linkage to your Excel documents.

When do you think this would be a good idea for your line of work and what situations would this be bad?

https://youtu.be/2p6vFv0Ga4g

 

CIS210 Computerized Spreadsheet

Module 1 Assignment  

Watch the videos provided in this week's introduction and Lesson 1

Download the attached Excel file.

You will take two sets of data given to you and find the velocity (distance/time=velocity)

Once you have found the velocity of both sets of data you will make a marked scatter plot of the data with time on the x-axis and distance on the y-axis.

Both axis and the title of the charts should be labeled properly.

Format your spreadsheets with any style you like. Check this link for help in formatting:https://computers.tutsplus.com/tutorials/how-to-format-your-spreadsheets-in-excel-with-styles--cms-21041 (Links to an external site.)

 

CIS210 Computerized Spreadsheet

Module 2 Assignment  

Rico’s Cool Cream

GETTING STARTED WITH EXCEL

PROJECT STEPS

1.            Dora works for an ice cream chain called Rico’s Cool Cream, and uses Excel to calculate the company’s payroll expenses and profits. She is currently finalizing the Profit and Payroll worksheets to close out the week’s figures.

On the Payroll worksheet, cut the contents of the range B1:B2 and paste them into the range A1:A2.

2.            Adjust the width of column A using AutoFit.

3.            Change the width of column E to 15.00.

4.            Enter the values shown in Table 1 below into the corresponding cells in the range B18:C20.

Table 1: Data for the Range B18:C20

                B             C

18           741.78   4/2/1990

19           698.87   5/8/1982

20           421.48   7/2/1988

5.            In cell E6, type DG832133. Select the range E5:E20,and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.)

6.            Select cell A21, and then enter the word Total. Add cell borders to the range A21:E21 using the Top Border border format.

7.            In cell B21, create a formula using the SUM function to total the data in the range B5:B20.

8.            In cell B23, create a formula using the COUNT function to determine the number of people employed by Rico’s Cool Cream by counting the values in the range B5:B20.

9.            Switch to the Profit worksheet. Change the orientation of the Profit worksheet to Landscape.

10.          In cell A2, change the cell content to Profit -June 1-7, 2018 (instead of just reading “June 1-7, 2018”).

11.          Select the range A4:F4 and nonadjacent cell H8, and then increase the font size of the cells to 13 pt.

12.          To better display the content, manually change the height of row 3 to 20.00. (Hint: Do not use AutoFit.)

13.          In cell B7, enter a formula without using a function to determine the profit generated at the Riverside store by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of June 1-7, 2018. Copy the formula you created in cell B7 to the range C7:E7.

14.          After determining the total profits generated by each store, Dora is now interested in calculating the total sales, expenses, and profits for the company. Select the range F5:F7, and then apply AutoSum to calculate the totals for these categories across all four stores.

15.          Dora edited the worksheet after June 8, 2018, making the content in cell A11 unnecessary. Click on cell A11 and clear its contents.

16.          Apply the wrap text formatting to cell H8.

17.          Adjust the Zoom level of the Profit worksheetto 130%.

18.          After reviewing the Profit and Payroll worksheets, Dora typically generates some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting,and if necessary, move the new worksheet after the Profit worksheet.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Upoad your completed work to Canvas _ Weekly Assignent 2

Final Figure 1: Payroll Worksheet

Final Figure2: Profit Worksheet

 

 CIS210 Computerized Spreadsheet

Module 3 Assignment  

Watch the videos provided in the introduction and Lesson 3. You will use what you learned about 3D formulas from the videos and apply it to this week's assignment.

Download the attached Excel file.

Take the data provided and use two 3D formulas. The first one, shown in the video (from this week's module), will be a grand sum of all of the sales data across three years. The second 3D formula will be an average of the data across 3 years. Submit an excel file of your data with the calculated 3D formulas.

CIS_210_Week_3.xlsx

 

CIS210 Computerized Spreadsheet

Module 4 Assignment  

Watch the videos posted in the introduction 4 and Week 4 lesson. Apply what you have learned to build your personal budget plan in Excel; it does not need to match the videos' examples. Include budgeting items that apply to your life situation. Although your budget shouldn’t be an exact match to the video, make sure you include the following:

Predesigned spreadsheet templates are NOT accepted, please start with a blank document.

At least 2 formulas

One chart. Be sure to modify the chart title and the legend.

Use the strategies you have learned to format your workbook; you can use any theme, cell style, or color. You may like to review this video for more information:  https://youtu.be/NZJXNw_rzTQ (Links to an external site.)

Save the budget as a template, the first video in this week's introduction shows how to do this. Submit the template as an Excel file.

 

CIS210 Computerized Spreadsheet

Module 5 Assignment  

You will take the data provided in the attached excel file and link the raw unformatted data into a second worksheet.

You should use the strategy shown in the video below. Once you get the data into the second sheet make sure to format it correctly from general numbers to the accounting or currency format.

CIS 210- Week 5.xlsx

https://youtu.be/rDMfksI3n7M

CIS210 Computerized Spreadsheet

Module 6 Assignment  

Watch the video below, and use what you have learned to build your own database from given data CIS 210- Week 6.xlsx Download CIS 210- Week 6.xlsx

Once you have successfully constructed the database you will then have to go and use three out of the five database formulas shown in the video.

So, out of these five (DCOUNT, DAVERAGE, DMIN, DMAX, DSUM) you must find at least three in your data.

Once you have successfully built your database and have used three of the formulas, submit your Excel file.

https://youtu.be/91HzoJ_FNUY

 

CIS210 Computerized Spreadsheet

Module 7 Final Exam   

CIS 210 Final Exam

For your final Exam please complete only ONE of the 2 options below:

Final Exam _ Option 1 ( predesigned spreadsheet templates are NOT accepted)

During the past weeks, you have learned how to design a good excel workbook, how to insert functions & formulas, and how to link worksheets and external workbooks.

Now it is your time to apply what you have learned.

Start with a blank Excel workbook, and create an Excel workbook about any topic ( Do not use a predesigned spreadsheet template). You may like to  review the exercises provided in this course, search the internet and look at the following link for ideas: https://instanteduhelp.com/microsoft-excel-projects-spreadsheet-ideas/ (Links to an external site.)

Your workbook should have at least the following:

At least 5 formulas/ functions, for instance: sum, average, minimum, max, multiply, divide, subtract, or PMT

What if function (any rules)

Conditional formatting (any rules)

One chart/ graph. Be sure to modify the chart title and the legend

Sparklines (any kind)

Tab name and color ( any colors)

Printout ( header with your name)

Use the strategies you have learned to format your workbook, you can use any theme, cell style, or colors. You may like to review this video for more information: