Computer Applications for Business – Week 7 AssignmentMS Excel: Querying (Web)Week 7 AssignmentStart with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. A local company would like to be able to search their inventory in an easy manner. They have given you data in table above, then:Create the table above in excel. oAdd two more rows of inventory data of your choice. oFormat the column headings to be bold.oIn Cell A14 put your name and GID numberSave workbook before filters as CS155Week7LastnameFirstName.oEnsure you use your own lastname and firstname in filename.Perform the following filters. oAll inventory items with more than 10 in stock.§Save as CS155Week7ALastnameFirstNameoAll inventory items from the manufacturer, Boles.§Save as CS155Week7BLastnameFirstNameoAll inventory items under $100.§Save as CS155Week7CLastnameFirstNameoAll inventory items with 5 or less in stock and a list price of less than $300.§Save as CS155Week7DLastnameFirstNameFive files will be attached and submitted in one submissionFile one –Saved before beginning extractions. Save as CS155Week7LastnameFirstNameFile two—Saved after Filter A. Save as CS155Week7ALastnameFirstNameFile three— Saved after Filter B. Save as CS155Week7BLastnameFirstNameFile four-- Saved after Filter C. Save as CS155Week7CLastnameFirstNameFile five-- Saved after Filter D. Save as CS155Week7DLastnameFirstName

ScenarioKiva is very pleased with the way you have gotten to know their needs and customer base; now they are ready for you to take the next steps! They need you to create a digital wireframe for the Kiva borrower’s interface, explain your design decisions, and make a plan for development of a cloud-based system in service of Kiva’s lenders. Recall that Kiva crowdfunds loans and unlocked capital for the underserved, improving the quality and cost of financial services and addressing the underlying barriers to financial access around the world, so your understanding of work in this space is very valuable.Previously, you explored Kiva’s Data Snapshots page and analyzed the data found in the Kiva Snapshots CSV file that was provided. This allowed you to start considering how you would address the following two user stories:As a Kiva borrower, I want to access information about Kiva and about borrowing from Kiva with my flip-phone (which is an embedded device), so that I can stay informed, request loans, and track my loan payback process.As a Kiva lender, I want to explore borrower requests, analyze my and others’ lending data, and follow borrower loan payments (in a cloud application) so that I can forecast how I will loan funds and plan the recycling of previous paid funds.You will continually reference these user stories, along with the work you have already completed, as you develop the wireframe for the UI design of the embedded system and a plan to build the cloud application using UI and UX best practices.DirectionsYour wireframe should be completed in Lucidchart. You may reference the CS Lucidchart Tutorial, linked in the Supporting Materials section, while you are creating your designs.As you work, keep in mind that the Kiva website only has general information that allows borrowers to fill out an application and lenders to explore options for individuals they can lend to. However, the design you create is going to be informed by your own data and user story analysis. This means it will be more detailed in the way it displays Kiva’s provided information and will be organized to serve your specific users. The research you already completed will have opened up new options for functionality, such as ways for users to monitor projects, share projects with friends, or use any number of other features you might decide are important for your application.Borrower Embedded Digital WireframeCreate appropriate features for your digital wireframe to address the goals of the project. Design a wireframe for the entry page of your embedded system and one secondary page that addresses borrower priorities and goals. Your design should be expressive, accessible, and intuitive, with suitable interactions given the user stories and system limitation considerations. Your wireframe should accomplish the following:Identify all necessary features.Include realistic content.Present information in a visually appealing way that is consistent.Enhance the user’s comprehension of the data that is accessed.Create clear navigation and actions for users of your wireframe. Your wireframe design should indicate clear actions and flows that apply to the needs of the customer. Ask yourself the following as you design:How should users move through interactions with an individual screen in the design?Is user navigation between screens intuitive?Is it clear which elements are “clickable” and which are not?Have you considered the impacts of screen orientation?Apply design best practices to your digital wireframe. Think about the many best practices in design principles for UX/UI that you could employ as you complete your design. The references linked in the Supporting Materials section can provide useful, comprehensive guidance on these best practices. Be sure to pay particular attention to accomplishing the following:Adhere to Android and Apple UI guidelines for visual design and user interaction.Use consistent elements in typography, color, spacing, and so on.Be error-free in spelling, symbol use, labeling, and spacing.Explanation and Lender Cloud-Based System RecommendationExplain the rationale behind your design choices. Clients may not immediately understand the utility and intent behind your wireframe design when looking only at the visuals you provide. You will also need to be able to discuss the design choices you made and the concept behind each element and screen. Use the following questions for guidance as you justify your choices.What is the purpose and function of each element and screen in the wireframe?How does your design benefit the borrower?How does your design benefit the customer (Kiva)?What kind of innovative solutions did you develop to adapt to challenges?How did previous research support your decisions?Recommend how your design could be adapted for a cloud-based system. Now it is time to transition from thinking about the borrower persona to thinking about the lender persona. Consider their different needs, but also where there is overlap in the kinds of content they might want to access. Describe what next steps you recommend for planning and building your lender cloud application. Note that you will not actually be building a cloud application. Consider the following in your recommendation:How can you ensure your design will align with the Kiva business vision and mission?What kind of communication between application components is necessary, based on the priorities that you have previously assessed?How can you optimize communication among the different components?What are the varied goals that different kinds of lenders might have?What to SubmitTo complete this project, you must submit the following:Borrower Embedded Digital WireframeComplete your digital wireframe design in Lucidchart and then download and submit it to the Learning Management System. Your submission should include a Lucidchart wireframe of the entry page and secondary page for your embedded system.Explanation and Lender Cloud-Based System RecommendationYour submission should be formatted as a Microsoft Word document that is 2–3 double-spaced pages in length. Include your explanation of the digital wireframe you created along with a recommendation for the cloud-based system.Supporting MaterialsThe following resource(s) may help support your work on the project:CS Lucidchart TutorialThis tutorial will show you how to create a Lucidchart account, as well as how to create different types of documents and diagrams.Design for AndroidThis website details the material design guidelines for visual and navigation patterns and details the quality guidelines for compatibility, performance, security, and more.Android User Interface and NavigationYour app's user interface is everything that the user can see and interact with. Android provides a variety of pre-built UI components such as structured layout objects and UI controls that allow you to build the graphical user interface for your app. Android also provides other UI modules for special interfaces such as dialogs, notifications, and menus.Apple Human Interface GuidelinesThis resource contains information and UI resources for designing apps that integrate seamlessly with Apple platforms, including the Apple watch.Apple UI Design Dos and Don’tsConsider these common design concepts to enhance the usability and appeal of your app, including contrast, text size, touch controls, format of content, and more.

This week we focus on globalization concepts. The world continues to utilize technologies to remain connected instantly, drive business and finance, and perform a myriad of other functions. For this discussion, please explain the concept of globalization and the role information technology has in the global market. If you work with an organization that operates globally, please share what they do and any challenges they may face in global operations from a technology standpoint. If you do not work in an organization with global operations, please select a company like Amazon, UPS, Facebook, etc., and research what they have done with technology to operate globally and any challenges this presents.Your response should be 250-300 words.