...by applying theories to your own behaviour. In this assessment, you will submit three (3) out of six (6) tutorial worksheets as part of a portfolio. You must submit worksheet 1 and then choose any two (2) from worksheet 2 to 6. The tutorial program has been designed to assist your learning and is directly linked to this assessment. You should aim to attend most of the tutorials if you seek a good mark. Consumer Behaviour List In the first tutorial, you will be select ONE consumer behaviour from the list below that you have done in the last three months. You will then complete worksheets in the tutorials of weeks 2 – 7 on that consumer behaviour. Once you have selected a behaviour you cannot change as your assessment requires to submit worksheets on the same behaviour. List of Consumer Behaviours * Buying a PC/laptop/high-technology item * Booking/arranging/going on an overseas holiday * Selecting a university * Going to the movies * Choosing a restaurant for a special occasion * Evaluating and selecting a mobile phone plan * Choosing to do volunteer work * Buying a fashion item * Going to a concert * Changing a bad habit (smoking, reducing alcohol intake, getting fit, eating better) Assignment structure and requirements You must follow this structure, do not change the order of the content of the worksheets in any way as this may result in reduced marks. This assignment requires the use of first-person language. The total...
Words: 608 - Pages: 3
...DIPLOMA IN PRE-PRIMARY TEACHERS TRAINING MID TERM ASSIGNMENT ON COMMUNITY HELPER Topic: Community Helpers Subject : Environment Studies Level / Class : GRADE II No. of students : 16 Time : 40 mins Age Group : 6-7 years Teaching Aids : Flash Cards, Marker, VCD, Reference Book “Hello Earth” Aim of the Lesson: a) Main focus - To develop understanding in young learners about Helpers in our community and how they help us? b) General Aim - To develop listening and speaking skills. To enhance their knowledge about community helpers. To enhance the volume of their vocabulary. To develop memorization and imaginative skills. Concepts Introduced: a. Identification of Community Helpers. b. Tools used by Community Helpers. c. Work Place of Community Helpers. d. Dress up of Community Helpers. e. Dramatization of Community Helpers. Time Allotted | Activity Planned | Teacher’s Activity | Student’s Activity | Anticipated Problems (Teacher’s Point of View) | 10 min | Warm...
Words: 682 - Pages: 3
...Math 100 Review for Test III As college students, you are expected to be able to review on your own, and carefully manage your time. That is, the primary responsibility for mastering the material is your own. Here are some suggestions that may help in preparing for your first test. As listed in the Course syllabus, you may bring one sheet of self-prepared notes. You are cautioned that spending too much time searching through notes can be fatal. You should know the material well enough that only a quick glance at notes will suffice. A very good source for review is the Worksheets that you have been printing during the term. Printing one or two Worksheets each week is a good study skill. Click on Worksheet in the blue bar in Aleks. This will show the Worksheets and answers. You can also get ALEKS to suggest Review problems for you. Click on Review in the blue bar in ALEKS. You should see something similar to what is below. You should look over the list, and decide for yourself which problems you had trouble with and need to review. Clicking on any topic listed will bring you to Practice on that topic. This test will cover Chapters 5. There are 23 possible topics that were covered. I will certainly not ask a question from every one of these topics, but ... you should be prepared to answer questions on any of them. And there might be a review topic from the first two tests. Based on your work to date, I expect all of you to do very well....
Words: 269 - Pages: 2
...Website Planning Worksheet n o This worksheet can help you to lay a solid foundation for your web sit e. It will help define your goals along with setting a o o r t p r guidelines to make sure your website is complete and useful for your visitors. If you don't know an answer or feel like it e k m s r o w l a t e doesn't apply to you, then simply leave it blank. If you have any quest ions; please call and I'll be happy to help you Name Address r City State Zip Code Business Phone n Home Phone Cell Phone Description of your business c o s (One Paragraph) e [Type a quote from the document o or the summa ary of an inte eresting point. You can t position t the text box a anywhere in the document t t. Use the Dra awing Tools t tab to change the e formattin ng of the pull quote text bo ox.] Description of services c e , (Separated by commas) Example: Pizza, Restaurant, Take Out, Salads, Italian, Entrees, Pasta, a m p s e [Type a quote from the u e document o or the summa ary of an interesting point. You can t anywhere in the document t. Use the Dra awing Tools tab to change e position the text box a the forma atting of the p pull quote tex xt box.] 1 What is your "Motto· or ·Slogan"? Do you want people to: ☐ Learn more about your business or organization? ☐ Hire you to perform a service? ☐ Buy products from you...
Words: 1820 - Pages: 8
...1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function...
Words: 7496 - Pages: 30
...Spreadsheet Modeling Assignment 1. Objectives The purpose of this assignment is to use some of the more advanced tools that Excel provides to develop a model of a complex business problem. In particular, you will use the following Excel features: 1. Importing data from text files 2. Sorting data 3. Database functions 4. Pivot Tables 5. Data Tables 6. Goal Seeking 2. What You Will Need 1. Access to a computer with a printer and Excel 2007. 2. Note that the instructions in this handout are written for Excel 2007. There are significant differences in user interface between Excel 2007 and 2003. 3. Download the following three files: Mymodel.xls, labor.txt, and demand.txt. 3. What You Will Hand In 1. a CD containing the model your group develops - on the outer label, write the course number, group number, the name of each group member 2. two full-page charts (with your course number and group number as a footer) 3. four worksheet printouts (with your course number and group number as a footer) 4. Make sure your CD is free of any computer virus. A contaminated CD will result in a 50% penalty in grade! 4. Due Date Check the course syllabus for assignment due date. A penalty will be assessed against assignments handed in late (including during class). 5. Background You work for the NOVA Corporation, a mid-tier supplier of hoses and hose assemblies...
Words: 4251 - Pages: 18
...USING MICROSOFT EXCEL 2013 Independent Project 4-4 Independent Project 4-4 Eller Software Services has received updated client information with sales numbers. You import the data into the worksheet, sort and filter it, and apply conditional formatting. You also format the data as an Excel table and create a PivotTable. Skills Covered in This Project Import a text file. Sort data Use an AutoFilter. Filter data by cell color. Copy, name, and move a worksheet. Use the Subtotal command. Apply Conditional Formatting. Clear filters and conditional formatting. Create an Excel table. Create a PivotTable. Protect a worksheet with a password. IMPORTANT: Download the resource file(s) needed for this project from the Resources link. Be sure to extract the file(s) after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-step instructions. Step 1 Download start file 1. Open the EllerSales-04 start file. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. 2. 3. Import the ClientInfo-04.txt file in cell A4. The text file is tab-delimited. 4. Unhide row 10. Fix the phone number in cell C12. 5. Set Conditional Formatting to show cells I5:I13 with Yellow Fill with Dark Yellow Text for values that are less than 1500. 6. Download Resources The file will be renamed automatically...
Words: 681 - Pages: 3
..." Using Spreadsheets and Graphing • in Excel In this case the independent quantity is Concentration and the dependent variable is Signal (we know the concentration, but we have to measure the signal that it causes). This means that Concentration should be on the X-axis and Signal should be on the Y-axis. In Excel, the X-axis values need to be to the left of the Y-axis values. Procedure 1: Basic Spreadsheet Entry 1. Open MS Excel on your computer. It will help to maximize the window so it fills up the screen. Your instructor will lead you through the steps in the following exercise. Follow along on the instructions as well as listening closely to your instructor and following directions. Computer programs are not very forgiving. If you are sloppy or make mistakes, your results will have· errors. You really have to pay attention to detail. 2. qreate a data table by copying the data from the Example on the previous page into the spreadsheet. t'JJ The first issue you have to deal with is the heading "Concentration (mol/L)" is too large to fit in • j cell AI. This must be fixed. You can either increase the column width or wrap text. l'j The second issue is that by default, data in the spreadsheet is not "centered" in the cells as shown in the figure. This must also be fixed. Follow the instructions of your instructor. o Notes: • 3. initial here: • 0 Your spreadsheet should look exactly like that in the example, including capitalization...
Words: 1308 - Pages: 6
...Acct 370 Excel Project Click Link Below To Buy: http://hwcampus.com/shop/acct-370-excel-project/ PART 1: Excel Project: Part V Instructions Common Sized Statements and Trend Analysis on WALMART Stores Inc. The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13. *PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me. PART 2: - Use WORD to complete this part COMPARITIVE ANALYSIS REPORT. - WALMART Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report: Compare and contrast the selected company, its competitors, and industry averages Identify the selected company’s strengths...
Words: 280 - Pages: 2
...ME Analysis Project #2 Christian Seymour Due Date: December 12, 2013 Abstract: The diameter for my shaft design was hand calculated to be 0.8756” for a factor of safety or 2. This factor of safety was expected to be the outcome in FEA SolidWorks and it was not. The reason for this is simply SolidWorks is not the best tool to use for complex designs and loads as ours was. It worked great for the simple beam deflection in the last project. Many times hand calculations are the long way of doing things. In this case, it took much longer to figure out the correct way of adding fixtures, load, and connections in SolidWorks. Many of the material properties in SolidWorks are also not the same as they are in our book. Simply said, choosing which method to use is the hardest decision to make. Sometimes FEA analysis is better, and in some cases, hand calculations are the easiest. Background: We have been given the task to design a shaft to specific guidelines using inch size pillow blocks. We will perform appropriate calculations using modeling techniques and verify the design in SolidWorks FEA program. The problem is 7-5 in the book and is shown below: The problem statement: A geared industrial roll shown in the figure is driven at 300 rev/ min by force F acting on a 3-in-diamter pitch circle as shown. The roll exerts a normal force of 30 lbf/in of roll length on the material being pulled through. The material passes under the roll. Design a shaft for the situation...
Words: 856 - Pages: 4
...Integration Feature Linking an Excel Worksheet and Chart 5/24/2011 Northwestern Business College Gloria Gallegos Table of Contents Introduction 3 Linking an Excel Worksheet and Chart 4 Excel Basics 4 To Link an Excel Worksheet to a Word Document 4 To Link an Excel Chart to a Word Document 7 Table of Figures 8 Index 9 Introduction With Microsoft Office, you can copy part or all of a project created in one Office program to a project created in another Office program. The item being copied is called the object. For example, you could copy an Excel worksheet (the object) that is located in an Excel workbook (the source document) to a Word document (the destination document). That is, an object can be copied from a source document to a destination document. You can use one of three techniques to copy objects from one program to another: copy and paste, embed, or link. * Copy and paste. When you copy an object and then paste it, the object becomes part of the destination document. You edit a pasted object using editing features of the destination program. For example, when you select an Excel worksheet in an Excel workbook, click the Copy button on Excel’s Home tab, and then click the Paste button on Word’s Home tab, each row in the Excel Worksheet become a separate paragraph in the Word document and each column in separated by a tab character. * Embed. When you embed an object, like a pasted object, it becomes part of the destination...
Words: 1322 - Pages: 6
...UNIT BRIEF Edexcel HND (Computing) Level 5 COMPUTER PLATFORMS 2011 EThames Graduate School. India 8-2-228 to 231 Punjagutta Cross Road Hyderabad 500082 Tel: +91 40 44432223 This handbook belongs to the following student; if found please hand in to Reception: NAME: ___________________________________________ Student ID: ________________________________________ |Unit Name: |Introduction to Computers | |Unit Number: | | |Course Duration: |09 Sessions | |Batch: |March, 2011 | |Tutor: |B Jagadish Chandra Reddy | A warm welcome to all the students enrolled for this unit. The unit handbook will give you a clear understanding of the aim and learning objectives of the unit. It will also portray the unit planning in terms of coverage, prerequisites for each session, tools and techniques used by the tutor and the level of efforts expected to be put by a student. It will make you aware of the assessment policy, assignment...
Words: 474 - Pages: 2
...Chapter 6 Reading Excel Worksheets 0.1 0.2 Introduction.............................................................................. Error! Bookmark not defined. A Section Title .......................................................................... Error! Bookmark not defined. Demonstration: .............................. Error! Bookmark not defined. Exercises .................................................................................. Error! Bookmark not defined. 0.3 0.4 Chapter Summary ................................................................... Error! Bookmark not defined. Solutions .................................................................................. Error! Bookmark not defined. Solutions to Exercises .............................................................. Error! Bookmark not defined. Solutions to Student Activities (Polls/Quizzes) .......................... Error! Bookmark not defined. 6-2 Chapter 6 Reading Excel Worksheets 6.1 Using Excel Data as Input 6-3 6.1 Using Excel Data as Input Objectives Use the DATA step to create a SAS data set from an Excel worksheet. Use the SAS/ACCESS LIBNAME statement to read from an Excel worksheet as though it were a SAS data set. 3 Business Scenario An existing data source contains information on Orion Star sales employees from Australia and the United States. A new SAS data set needs to be created that contains a subset of this existing data source. This...
Words: 4761 - Pages: 20
...1. Deleting the data and clearing the row. Deleting Cells and Data in Excel 2007 In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell. Clearing cell contents Clearing just deletes or empties the cell’s contents or formatting without removing the cell from the worksheet, which would alter the layout of the surrounding cells. To get rid of just the contents of a cell selection, just select the range of cells to be cleared and press the Delete key. If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, select the cell(s) and follow these steps: 1. Click the Clear button (the one with the eraser) in the Editing group on the Ribbon’s Home tab. 2. Click one of the following options on the Clear drop-down menu: * Clear All gets rid of all formatting, notes, and entries in the cell selection. * Clear Formats deletes only the formatting from the cell selection without touching anything else. * Clear Contents deletes only the cell entries, just like pressing the Delete key. * Clear Comments removes the notes in the cell selection but leaves everything else intact. Deleting cells, rows, or columns Deleting gets rid of the whole kit and caboodle...
Words: 5625 - Pages: 23
...Welcome to Microsoft Excel 2007 Introduction Level Prepared by: Ziad Azzi Sep , 2014 What is a Spreadsheet? A spreadsheet is a document that is entirely made up of rows and columns. It is used to list and analyze data. Editing and formatting – Excel works much like the tables in MS Word Formulas and functions – Excel allows you to perform calculations and analyze data. Common calculations include: finding the sum, average or total number of items in a list Creating Charts and Graphs – You can create colorful charts and graphs from the data in your worksheet. Excel will automatically update the chart to display any changes you make in your data. =sum(B6:B23) =AVERAGE(F4:F8) =count(B2:B25) Starting Excel Excel 2007 Workspace Made up of rows and columns Up to 1,048,576 rows and 16,384(XFD) columns Worksheet Sheets By default 3 but the total number of sheets are limited only by the amount of computer memory Excel 2007 Workspace WHAT IS A WORKBOOK? Multiple worksheets Creating and Opening workbook New Open Excel 2007 Workspace The workspace • includes the page area, the Main Menu and Toolbars. By default, the formatting and standard toolbar will be displayed. Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Excel 2007 Workspace Office button: When clicked, this button opens the Office menu, from which you can open, save, print, and exit as well as the Excel Options button that...
Words: 2286 - Pages: 10
