Exp19_Access_Ch04_Cap – Foodies Forms and Reports 1.2

Project Description:

You will create a form so that users of the database can enter and  edit suppliers of products to your business easily. You create an  attractive report that groups the products that you purchase by their  suppliers, and then export it to PDF format for easy distribution.  Finally, you create a Navigation Form so that database users can switch  between major objects in the database readily.

   You will create a form to manage the data in the Suppliers table.  Use the   Form tool to create the form, and then modify the form as  required. You will   also remove the layout control from the form so  that the controls can be   repositioned freely.
 

  Select the Suppliers table as the   record source for a form. Use the Form tool to create a new form with a default   layout.

Change   the form’s title to Enter/Edit Suppliers.   Change the width of the text box controls to approximately 3.4″.

Delete   the Products subform control from   the form. View the form and the data in Form view. Sort the records by   CompanyName in ascending order.

In   Layout view, set the background color of the CompanyName text box to Blue, Accent 1, Lighter 80%, and set   the font size to 14. Save the form   as  .   Close the form.

Open   the Edit Suppliers form in Design   view.  Select all controls in the Detail section of the form, and then remove    the layout. View the form in Layout view. If necessary, arrange the  fields on   the form one below the other in the following order: SupplierID, CompanyName, ContactName, ContactTitle, Address, City,   Region, PostalCode, Country, Phone, and Fax. Ensure that the left edges of the labels and the text boxes   align. Delete the Contact Title label   from the form and move the text box   up and to the right of ContactName so that their top edges are aligned.

Delete the Country label from the form and move the text box up and to the right of PostalCode so that their top   edges are aligned. Move the Phone   and Fax labels and text boxes  up to below PostalCode so   that they close in the white space, keeping  the spacing close to that of the   rest of the controls.

View   the form in Print Preview and set the orientation to Landscape. Switch to Form view, and then save and close the form.

You   will create a report based on the Company by Product List  query. You decide   to use the Report Wizard to accomplish this task.  You are planning to email a   copy of the report to your business  partner who is not conversant in Access,   so you will export the report  as a PDF file prior to sending it.
 

  Select the Company by Product List   query in the  Navigation Pane as the record source for a report. Activate   the Report  Wizard and use the following options as you proceed through the    wizard steps:
 

  Select all of the available fields for the report. View the data by   Suppliers. Accept the default grouping levels and click Next. Use ProductName   as the primary sort field in ascending order.
 

  Accept the Stepped and Portrait options. Save the report as Products by Suppliers.

Switch   to Layout view and apply the Organic   theme to this report only. Set the width of the ProductCost label  to approximately 0.8″ so that the entire   text of the label is  visible. Switch to Report view to determine whether all   the columns  fit across the page. Switch to Layout view and drag the left edge   of  the ProductName text box to the   left so that the column width is wide enough to display the values in the   field (approximately 2.5″).

Delete   the ContactName label and text box from the report. Drag the   right edge of the CompanyName text box    to the right so that the column width is wide enough to display the  values in   the field (approximately 2.6″). Save the report.

Switch   to Print Preview and export the report as a PDF file named ProductsbySuppliers. Close the reader program that   displays the PDF report and return to Access. Close Print Preview. Close the   report.

You   realize that the Country field was not included in the query  that is the   record source for your report. You add the field to the  query and then modify   the report in Layout view to include the missing  field.
 

  Open the Company by Product List query   in Design view. Add the Country field   from the Suppliers table to the query design grid, after the ProductCost   field. Run, save, and close the query.

Open   the Products by Suppliers report in Layout view. Add the Country field from the Field List pane by dragging it into the   report layout. Click the selection handle at the top of the Country column and move the column   immediately to the left of the Phone field. Resize the Country text box so  that the column width is wide enough to   display the values in the  field (approximately .75″). Switch to Print   Preview, then save and  close the report.

You   will create a Navigation Form so that users can switch between objects in the   database readily.
 

  Create a Vertical Tabs, Left   Navigation Form.
 

Drag   the Edit Suppliers form icon from   the Navigation Pane onto the [Add New]   tab at the left of the form.

Drag   the Products by Suppliers report icon   from the Navigation Pane onto the second   [Add New] tab at the left of the form. Save the Navigation form with the   default name, Navigation Form.

• Explain three possible uses of a SPAN port that you might use as a forensic investigator.
• Explain two disadvantages of a SPAN port you might encounter as a forensic investigator.
• Wireshark supports two types of filters. Research, and in a full paragraph for each, address the following:
  • Explain each and when you might use each.
  • Describe three non-Ethernet protocols Wireshark can capture.
• Many brute force programs will use dictionary words. Describe how you could build a dictionary for such use in a program like Bruter®.

 What are your expectations from INT 1010? 

Download The Attachment and Message Me Please for Detailed Instructions

Due: No Later Than Sunday this week.

Assignment Description

Please read chapter 2 of your  textbook and review lecture slides/ and library resource and reputable articles/journals and in your own word explain your understanding of the following Software Process Models:

A) The waterfall model and  its problems

B) Incremental development model AND Incremental development benefits AND Incremental development problems.

 Topic:  Heart Disease among older adults

In week 1, you selected a topic and developed a research question for that topic. Then, you developed a data gathering instrument to measure the question either quantitatively or qualitatively. Now that you have had the opportunity to read how scholarly methodologies are written, you will write a condensed 3-4 page methodology section for your research question using the required headings from the University of the Cumberlands Dissertation Handbook.  Like we discuss in class, each university has unique parameters for what they expect in chapter 3, so you may see papers from other universities that look slightly different. The importance here is to focus on the content, not necessarily the organization. This assignment will help determine your readiness to write a full-length chapter three.

Directions:

1. Review your notes from class on the different methodologies and instruments used to measure. Also, review the examples:
   1. Approaches Expectations.docx
   2. Meets Expectations.docx
   3. Exceeds Expectations.docx
   4. Finally, review the rubric: Rubric for Methodology.docx
2. Develop a 3-4 page (more is fine) methodology section that includes the following:
   1. Introduction
   2. Research Paradigm (qualitative or quantitative)
   3. Research- or project- Design
   4. Sampling Procedures and
   5. Data Collection Sources
   6. Statistical Tests Summary (quantitative) OR Data Organization Plan (Qualitative)

Last.fm, one of the oldest organizations for online music, was founded in 2002 as a radio and social music discovery platform, offering music streaming and personal recommendations to its users.

The consumption of music was perceived at Last.fm as a social behaviour: a data-driven approach made it possible to discover the music taste of users, constructing detailed user’s listening profiles by tracking listening habits and suggesting new songs by analyzing the listening profile and similarities between songs.

In this project, you will analyze excerpts of some real datasets publicly released by Last.fm.

Goal: finding the “top” song-authors by tag

You are given as input a CSV file containing a list of song tracks and additional details. Each line has:

track_id, song_title, author_name, tags

where tags is a string with one or more text user-provided labels that characterize the song,

separated by “;” (e.g. “rock;indie;female vocalist”).

Your task is to design and implement a Python code that reads the CSV file, extracting the relevant information which must be then stored in a suitable data structure. The data structure should make it possible to answer queries of the form:

Which are the top K song-authors matching a given list of tags L?

as fast as possible. The list of tags L and the integer value K are given as input to your query algorithm.

Example

In the small CSV dataset that you will be provided (see below), there are 2526 “rock” songs and 1762 “pop” songs, among the other tags. Only 1340 songs have both “rock” and “pop” in their tags (in any order). Among these 1340 songs, the top authors are:

• The Police, with 148 songs

• U2, with 110 songs

• The Cure, with 109 songs

• Elvis Presley, with 106 songs

• Michael Jackson, with 101 songs

Hence, if K=2 and L=[“rock”, “pop”] (or L=[“pop”, “rock”]), your algorithm should return the ordered list of strings [“The Police”,”U2″], where items appear in the list in decreasing order of number of songs. If two authors have the same number of songs, they should appear in alphabetical order.

If K=4 and L is the same as above, your output list should be [“The Police”, “U2”, “The Cure”, “Elvis Presley”].

Datasets

You are given four datasets: small.csv, medium.csv, large.csv, and full.csv:

• The small dataset has about 3000 songs (20 authors, 7 tags).

• The medium dataset has about 10000 songs.

• The large dataset has about 100000 songs.

• The full dataset has about 500000 songs.

We will run your query algorithm on the different datasets: the larger the dataset you can handle (correctly), the better the evaluation of your project! We will also consider the running time of your code on the datasets that you can solve.

Python implementation guidelines

We are providing you a skeleton of the code. You can modify the code we provide, adding the missing parts.

In the project folder, you will find a file main.py (used to run the project) and the input file small.csv. You should not change the main file, except for the variable group_id (as specified below).

Change the name of folder group0 to match the group id that we will assign you after the registration on Luiss Learn, and also change the group_id value in main.py.

Implement your code in file project.py, that contains two functions (you can add more functions, if needed, but you must at least implement these ones). Function prepare will be called once per song list: use prepare to read the input file and store the relevant information in suitable global data structures of your choice. Function top_authors should implement your query algorithm, as described above.

You can use additional files, if needed, but all of them have to be in the group folder. There is a file utils.py where, if you want, you can implement auxiliary algorithms and data structures.

You can use Python lists, dictionaries, and string functions, but no specific algorithm from any Python library. If you need any algorithms (e.g., for searching, sorting, or selection) you have to implement your own version from scratch. If in doubt, just ask.

Project report

You should write a report on your implementation (about 2 pages) describing your code, how it works, and the main reasons of your implementation choices (e.g., why did you use a sorted list instead of a dictionary? How does your query algorithm work?).

As a bonus, you should try to analyze the asymptotic cost of your implementation assuming that:

• Each song a O(1) tags, each of length O(1). Hence, any string processing on the “;” separated

tags string (such as a split) requires constant time.

• Function top_authors is called with exactly 2 tags [t1, t2] and there are n1 songs with tag t1,

n2 songs with tag t2, and n songs with both tags where n < min(n1, n2). Keep in mind that n is much smaller than the total number of songs in the input file.

Deadline and what to send us

You should send us (Caminiti and Finocchi) an e-mail with a pdf file containing your report and a zip file with your group folder. The subject of the email should be: “Algorithms project 2021 group X”, where X is your group id.

Project deadline: May 25, 2021.

We will run your code and let your implementations compete against each other: which groups are the fastest? Which groups can solve the largest datasets? We plan to release the results of the contest on the course Web site before the first exam session (June 3).

 Week 6 is here! Posted on: Sunday, February 12, 2023 11:59:00 PM EST Hello Students. Week 6 is here! There is a connection between chapter three and chapter one in the dissertation writing process. Therefore, as an extension of our week in the mock chapter three from last week, you will write a mock chapter one. It is very important to use and follow the required headings from the University of the Cumberlands Dissertation Handbook. Click the link in the course … the START HERE tab – Dissertation Resources section – choose Doctoral Research Handbook Have a wonderful week and see you at the LIVE class 7pm central Monday evening. Dr. Babb Week 6 Assignment: Develop a 3-4 page (more is fine) mock chapter one to include the following expectations from the university: Overview (1-2 well developed paragraphs) Background and problem statement (1-2 well developed paragraphs) Purpose of the study (1 well developed paragraph) Significance of the study (1 well developed paragraph) Research Questions (numbered list) Theoretical Framework (1-2 well developed paragraphs) Limitations of the Study (1 short paragraph) Assumptions (1 short paragraph) Definitions (list) Summary (1 well developed paragraph) 

1

   Download and open the file named exploring_e06_grader_Capstone2.xlsx.
Rename it LastNameFirst_Assignment5__   ValentineBudget.xlsx

2

Use   Goal Seek to achieve a $0   balance by changing the Ticket Price per Person.
 

  Hint: -Use of the correct cells in Goal Seek dialog box
  -Apply Goal Seek correctly
  -Correct solution

3

Beginning   in cell E3, complete the series of substitution values ranging from 200 to 500   at increments of 20   students vertically down column E.
 

  Hint:
  On the Home tab, in the Editing group, use the Fill tool to complete the   substitution values.
  -Series begins in E3
  -Correct incrementation
  -Values range from 200 to 500

4

Enter   cell references to the Total Income, Total Expenses, and Balance formulas (in   that order) for a one-variable data table in cells F2, G2, and H2   respectively.
 

  Hint:
  Create linking formulas to C20, C32, and C34. Cell references are preceded by   the =   sign.
  Correct cell references to
  -Total Income formula
  -Total Expenses formula
  -Balance formula

5

Apply   custom number formats to make the formula references appear as the following:   F2- Revenue,   G2 – Expenses,   H2 – Balance.
 

  Hint: Custom number formats make formula references to
  -F2- as Revenue
  -G2- as Expenses
  -F2- as Balance

6

Create   a one-variable data table for the range E2:H18 using the Number of Attendees   as the column input cell. Format the results with Accounting Number Format   with two decimal places.
 

  Hint:
  -One-variable data table created for range E2:H18
  -Number of Attendees used as column input
  -Results formatted with Accounting number format
  -Format has two decimal places
  -Correct values in Data table

7

Copy   the Number of Attendees substitution values from the one-variable data table   (in cells E3:E18), and then paste the values starting in cell E22.
 

  Hint: -Number of Attendees from one-variable data table copied correctly
  -Pasted values starts from E22

8

Type   $50   in cell F21 and complete the series of substitution values from $50 to $100 at $10   increments.
 

  Hint: -Correct value in cell F21
  -Correct incrementation
  -Values from $50 to $100

9

Enter   the cell reference to the Balance formula (C34) in the cell E21 for a   two-variable data table, then complete the table using cell B9 as the row   input cell and B4 as the column input cell. Format the results with   Accounting Number Format with two decimal places.
 

  Hint: -Cell reference to Balance formula (C34 )in cell E21
  -Two-variable table completed with cell B9 as row input
  -Two-variable table completed with cell B4 as column input
  -Results formatted with Accounting number format
  -Format has two decimal places
  -Correct values in Data table

10

Apply   a Red, Accent 2, Lighter 60% fill color to the three cells closest to   break-even without creating a deficit.
 

  Hint: -Correct color fill used
  -Correct 3 cells highlighted

11

Apply   custom number format to cell E21 to display # Attend.
 

  Hint: -Custom number format applied to cell E21
  -#Attend displayed on cell

12

Create   a scenario named 500 Attend   using the Number of Attendees, Caterer’s   Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables   as the changing cells. Deselect Prevent changes. Enter these values for the   scenario: 500,   15.95,   75,   and 12500.
 

  Hint: -Scenario created with correct values for
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

13

Create   a second scenario named 400 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 400,   17.95,   85,   and 12500.
 

  Hint: -Scenario created with correct values for:
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

14

Create   a third scenario named 300 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 300,   19.95,   90,   and 11995,   respectively.
 

  Hint: -Scenario created with correct values for
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person:
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

15

Create   a fourth scenario named 200 Attend,   using the same changing cells. Deselect Prevent changes. Enter these values   for the scenario: 200,   22.95,   95,   and 11995,   respectively.
 

  Hint: -Scenario created with correct values for :
  -Number of Number of Attendees
  – Caterer’s   Meal Cost per Person
  -Ticket Price per Person
  -Ballroom Rental
  -Prevent changes deselected
  -Correct scenario name

16

Generate   a scenario summary report using the Total Income, Total Expenses, and Balance   as the results. Mac users should click OK in any error messages that are   displayed until the summary report is generated.
 

  Hint: Scenario Summary report created using as results
  -Total Income,
  -Total Expenses,
  -Balance
  -Correct scenario summary

17

Load   the Solver add-in if it is not already loaded. Click the Budget worksheet and   launch Solver. Set the objective to calculate the highest balance possible.
 

  Hint: -Budget worksheet selected
  -Solver launched
  -Objective set to calculate highest balance possible

18

Use   the Number of Attendees and the Ticket Price per Person as changing variable   cells.
 

  Hint: -Changing variable cells set to
  -Number of Attendees
  -Ticket Price per Person

19

Set   a constraint so that the Number of Attendees entered in the Input Section of   the workbook does not exceed the specified limitation in cell B12.
 

  Hint: -Constraint set properly with correct cells
  -Number of Attendees does not exceed the specified limitation in B12
  -Correct formula used in the constraint

20

Set   constraints so that the Ticket Price per Person entered in the Input Section   meets the requirements set in the range A14:B15.
 

  Hint: -Constraint set properly with correct cells
  -Ticket Price per Person meets the requirements range A14:B15
  -Correct formula used in the constraint

21

Set   an appropriate integer constraint.
 

  Hint: -Constraint set properly with correct cell
  -Correct formula used in the constraint

22

Set   a constraint that ensures the Valet Parking expense is less than or equal to   the product of the Maximum Parking Stalls and the Valet Parking per Car (in   that order). Note, Mac users should NOT perform this step.
 

  Hint: -Constraint set properly with correct cells
  -Valet Parking expense is less than the product of the Maximum Parking Stalls   and the Valet Parking per Car
  -Valet Parking expense is equal to the product of the Maximum Parking Stalls   and the Valet Parking per Car
  -Correct formula used in the constraint

23

Solve   the problem, but keep the original values in the Budget worksheet. Generate   the Answer Report.
 

  Hint: -Solver used to solve the problem
  -Answer Report generated
  -Original values kept in the Budget worksheet

24

Ensure   that the worksheets are correctly named and placed in the following order in   the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook.   Close the workbook and then exit Excel. Submit the workbook as directed.

PowerPoint_3G_Travel

PowerPoint_3G_Travel

PowerPoint 3G Travel

#PowerPoint_3G_Travel #PowerPointCh3 #PowerpointCh3GTravel #GraderProject 

Open   the PowerPoint file Student_PowerPoint_3G_Travel.pptx   downloaded with   this project.

Change the Colors for the   presentation to Blue Green.

On Slide 1, format the   background with the Water droplets texture, and then change the Transparency   to 50%.

Select Slides 2 through 4, and   then apply a Solid fill to the  background of the selected slides—in the   second to last column, the  third color.

On Slide 2, hide the background   graphics.

On Slide 2 insert a Table with 3   columns and 4 rows. Apply table  style Medium Style 3 – Accent 3, and then   type the information below  in the inserted table.
Trip   Type Day One Day   Two
Adventure   Seeker Kayak and Snorkel Nature Preserve Hike
Family-Friendly Pacifica Bay Zoo Beach Day and Horseback   Riding
Arts   & Culture Pacifica Bay   Art Museum Artisan Walk

Resize the table so that its   lower edge extends to 3 inches on the  lower half of the vertical ruler   (height 4.72″), and then distribute  the table rows. Align the table text   so that it is centered  horizontally and vertically within the cells.

In the table, change the Font   Size of the first row of text to 24. Apply a Divot Cell Bevel to the first   row.

On Slide 3, animate the picture using the Wipe entrance effect    starting After Previous. Change the Duration to 01.00. Apply the Split    entrance effect to the bulleted list placeholder, and then change the  Effect   Options to Vertical Out.

On Slide 4, insert a Clustered   Column chart. In the worksheet,  beginning in cell B1, type the following   data. After typing the last  number in the worksheet—67300—press ENTER. Do not press TAB.
   In row 1, beginning in cell B1: Year   1, Year 2, Year 3
   In row 2, beginning in cell A2: Spring, 75600, 72300, 81460
   In row 3, beginning in cell A3: Summer, 105300, 128730, 143600
   In row 4, beginning in cell A4: Fall,   35900, 58300, 58320
   In row 5, beginning in cell A5: Winter, 41600, 58430, 67300
 

Apply Chart Style 8 to the   chart, and then remove the Chart Title  element. Apply the Wipe entrance   effect to the chart and change the  Effect Options to By Series.

On Slide 5, apply the Style 1   background style to this slide only.  (Mac users, format the background using   Solid Fill color White,  Background 1.) 

From your downloaded grader   files, insert the video p03G_Video.mp4.   Change the Video Height to 6 and use the Align Center and Align Top options to position the   video. Apply the Simple Beveled Rectangle video style.

On the Playback tab, change the   Video Options to Start the video  Automatically. Trim the video so that the   End Time is 00:09 and then  compress the media in Standard Quality or Low   Quality depending on  your version of PowerPoint. (Mac users, the Compress   Media feature is  not available in the Mac version of PowerPoint.)

On Slide 6, hide the background   graphics, and then format the slide  background by inserting a picture from   your downloaded project files—  p03G_Background.jpg.   Set the Transparency to 0%

Insert a Header & Footer on   the Notes and Handouts. Include the  Date and time updated automatically, the   Page number, and a Footer  with the text 3G_Travel
   Display the document properties. As the Tags type travel, tourism

Save and close the file, and   then submit for grading.