Sunday, June 7, 2020

Dasar Excel Bagain I




Pengenalan Workbook, Worksheet, Baris,Kolom dan Cell




  • Workbook

Excel adalah program dari microsoft untuk mengentry data, menghitung, serta menganalisis data. Data data tersebut bisa berubah angka dan kata. Pada saat kita pertama kali membuka excel kita akan di melihat keseluruhan tampilan ini biasanya dinamakan dengan Workbook 1.




ilustrasi 1



  • Worksheet

Di sudut kiri bawah biasanya ada seperti kotak berupa tulisan “sheet”2 itu merupakan worksheet yaitu lembar dimana kita melakukan semua aktifitas kita, worksheet ini bisa berjumlah lebih dari satu dalam satu workbook biasanya disesuaikan dengan kebutuhan kita hal ini akan dibahas pada excel tingkat lanjut. 





ilustrasi 2



Sedangkan untuk baris dalam excel bisa kita lihat dari samping kiri ada angka 1,2,3 dst jumlah baris ini ada 1.048.576 dan untuk kolom bisa di lihat diatas ada huruf A,B,C kolom ini berakhir pada huruf XFD


ilustrasi 3

Ini semua  merupakan pengetahuan dasar excel yang perlu diketahui oleh kita untuk mempelajari excel. Selanjutnya kita akan mempelajari dasar fungsi fungsi excel.


Selanjutnya kita akan belajar tentang Tabel











 

Sunday, May 3, 2020

Cheesecake dan berbagai cara membuatnya.


      Cheesecake merupakan makanan penutup yang mempunyai lapisan lebih dari satu atau lebih. Lapisan utama atau yang paling tebal merupakan campuran cream keju, telur dan gula. Jika ada ada lapisan bawah biasanya remahan roti kering yang di campur dengan butter. Cheesecake bisa panggang dan tidak di panggang.
      
       Ada banyak cara membuat cheesecake. Utamanya campuran adonan di panggang tetapi ada juga yang hanya di dinginkan. Bahan cheesecake juga bisa menggungkan cream cheese yang sudah jadi tetapi ada juga yang mengganti cream cheese dengan parutan keju kraft dan susu full cream di lumerkan di dalam mangkuk hangat.
   
      Membuat cheesecake dengan dipanggang ampir sama dengan membuat cake - cake yang biasanya menggunakan telur dan gula kadang menggunakan tepung terigu tetapi dengan kuantitas yang sedikit. Pertama campuran creamcheese, butter, dan gula serta kuning telur di mixer ini biasanya kita sebut campuran A. Utk adonan B , ambil 3 putih telur di mixer dengan gula sehingga soft peak. Tips untuk memixer putih telur mulai dengan kecepatan satu masukkan 1/3 dari takaran gula di mixer hingga tercampur lalu di naikkan kecepatan masukkan sisa gula nya di mixer hingga soft peak. Tanda dari soft peak adonan relatif kaku, membentuk puncak-puncak adonan yang bentuknya membukit-bukit, alias tumpul. Selanjutnya adonan A dan B di campur menggunakan spatula di campur pelan jangan sampai ada udara dalam adonan lalu campuran adonan tersebut di masukkan ke dalam loyang yang sudah sekelilingnya sudah dikasi kertas roti lalu di panggang.
      
            
          

Sunday, March 22, 2009

TEst!

Testing yang dimana pada berbagai
yang disana disitu .. test ptr

mudah2an berhasil
ARtikel Ku

tulisan ini mengenai tidklsdmsd
kasdkakld;ld

Tuesday, May 29, 2007

Penggunaan Paragraf Kiri

Kebanyakan dari layouter memilih perataan paragraf sebagai suatu keformalan/tradisi sebagai contoh penggunaan rata kiri dan kanan pada sebuah paragraf sehingga paragraf tersebut terkesan rapi, Paragraf rata kiri dan paragraf rata kanana umumnya digunakan dalam penulisan Judul Paragraf ( Heading dan Subheading). Kondisi ini umumnya berlaku pada masyarakat pada umumnya. Namun disebabkan perkembangan typography modern yang melibatkan penggunaan komputer dalam pengerjaan penyusunan paragraf seorang layouter, desainer tidak harus mengikuti pola-pola tradisi yang sudah ada bisa saja dia menciptakan suatu ide baru yang mungkin belum pernah terpikirkan oleh desainer lainnya. Yang penting bagi seorang desainer, layouter pesan yang disampaikan harus jelas di mengerti oleh penerima pesan.

Paragraf rata kiri

Penggunaan paragraf ini sangat cocok untuk paragraf yang terdiri atas satu atau dua baris saja karena kurang enak dipandang dan manfaatnya terasa kurang apabila paragraf yang hanya berisi 1 atau 2 halaman tersebut harus diset dengan rata kiri dan kanan.

Ada beberapa pertimbangan yang perlu di pikirkan sebelum meng-apply paragraf kiri pada sebuat body text ( isi tulisan ) :

  1. Jarak antarhuruf dan antarkata menjadi rata, karena akan terhindar dari penyesuaian letak karena adanya setting paragraph rata kiri dan rata kanan. Pada paragraf rata kiri tidak ada ruang kosong atau dalam istilah kerennya disebut “rivers of white” yaitu celah kosong berturut - turut yang diakibatkan penyesuaian lebar jarak antarkata (arifical gab) pada pengaplikasian paragraph rata kiri kanan

  2. Pada paragraf kiri tidak ada pemutusan kata , ini dikarenakan jika panjang teks sebuah baris telah mencapai maksima, maka serta merta kata berikutnya akan diletakkan pada baris dibawahnya


  3. Paragraf rata kiri bagus dipakai pada halaman yang hanya memiliki paragraph tunggal.

Kerugian pada paragraph rata kiri pada bagian ujung yang tidak rata tetapi kerugian inilah yang membuat variasi dalam membaca sehingga mata tidak mudah capek, serta jika lebar kolom atau panjang baris pada suatu halaman tidak terlalu sempit, maka ketidakrataan pada bagian kanan tidak akan terlalu menyolok.

Coba anda Bandingkan dengan tulisan sama tetapi menggunakan paragraph rata kiri dan kanan. Mana yang lebih menarik bagi anda?

Kebanyakan dari layouter memilih perataan paragraf sebagai suatu keformalan/tradisi sebagai contoh penggunaan rata kiri dan kanan pada sebuah paragraf sehingga paragraf tersebut terkesan rapi, Paragraf rata kiri dan paragraf rata kanana umumnya digunakan dalam penulisan Judul Paragraf ( Heading dan Subheading). Kondisi ini umumnya berlaku pada masyarakat pada umumnya. Namun disebabkan perkembangan typography modern yang melibatkan penggunaan komputer dalam pengerjaan penyusunan paragraf seorang layouter, desainer tidak harus mengikuti pola-pola tradisi yang sudah ada bisa saja dia menciptakan suatu ide baru yang mungkin belum pernah terpikirkan oleh desainer lainnya. Yang penting bagi seorang desainer, layouter pesan yang disampaikan harus jelas di mengerti oleh penerima pesan.

Paragraf rata kiri

Penggunaan paragraf ini sangat cocok untuk paragraf yang terdiri atas satu atau dua baris saja karena kurang enak dipandang dan manfaatnya terasa kurang apabila paragraf yang hanya berisi 1 atau 2 halaman tersebut harus diset dengan rata kiri dan kanan.

Ada beberapa pertimbangan yang perlu di pikirkan sebelum meng-apply paragraf kiri pada sebuah body text ( isi tulisan ) :

  1. Jarak antarhuruf dan antarkata menjadi rata, karena akan terhindar dari penyesuaian letak karena adanya setting paragraph rata kiri dan rata kanan. Pada paragraf rata kiri tidak ada ruang kosong atau dalam istilah kerennya disebut “rivers of white” yaitu celah kosong berturut - turut yang diakibatkan penyesuaian lebar jarak antarkata (arifical gab) pada pengaplikasian paragraph rata kiri kanan

  2. Pada paragraf kiri tidak ada pemutusan kata , ini dikarenakan jika panjang teks sebuah baris telah mencapai maksima, maka serta merta kata berikutnya akan diletakkan pada baris dibawahnya

  3. Penggunaan paragraf kiri bagus di pakai untuk kolom-kolom yang sempit, karena kondisi seperti ini jika sudah di set dengan paragraf rata kiri dan kanan hasilnya malah kurang bagus. ( mata capek membacanya )

  4. Paragraf rata kiri bagus dipakai pada halaman yang hanya memiliki paragraph tunggal.

Kerugian pada paragraph rata kiri pada bagian ujung yang tidak rata tetapi kerugian inilah yang membuat variasi dalam membaca sehingga mata tidak mudah capek, serta jika lebar kolom atau panjang baris pada suatu halaman tidak terlalu sempit, maka ketidakrataan pada bagian kanan tidak akan terlalu menyolok.

Sunday, May 27, 2007

Typograpy (english)

Typography is the art and techniques of type design, modifying type glyphs, and arranging type. Type glyphs (characters) are created and modified using a variety of illustration techniques. The arrangement of type is the selection of typefaces, point size, line length, leading (line spacing) and letter spacing.

Typography is performed by typesetters, compositors, typographers, graphic artists, art directors, and clerical workers. Until the Digital Age typography was a specialized occupation. Digitization opened up typography to new generations of visual designers and lay users.

Etymology: Typography (from the Greek words τύπος type = "to strike" "That by which something is symbolized or figured..." and γραφία graphia = to write).

Typography traces its origins to the first punches and dies used to make seals and currency in ancient times. Typography with moveable type began in 11th-century China, and modular moveable metal type began in 13th-century Korea and was developed again in mid-15th century Europe with the development of specialized techniques for casting and combining cheap copies of letterpunches in the vast quantities required to print multiple copies of texts.

In contemporary use, the practice and study of typography is very broad, covering all aspects of letter design and application, including typesetting and typeface design; handwriting and calligraphy; graffiti; inscriptional and architectural lettering; poster design and other large scale lettering such as signage and billboards; business communications and promotional collateral; advertising; wordmarks and typographic logos (logotypes); apparel (clothing); vehicle instrument panels; kinetic typography in motion picture films and television; and as a component of industrial design—type resides on household appliances, pens and wristwatches.

Since digitization typography's range of applications has become more eclectic, appearing on web pages, LCD mobile phone screens, and hand-held video games. The ubiquity of type has led typographers to coin the phrase "Type is everywhere".

Typography generally follows four principles, using repetition, contrast, proximity, and alignment.

Text typography

In traditional typography, text is composed to create a readable, coherent, and visually satisfying whole that works invisibly, without the awareness of the reader. Even distribution with a minimum of distractions and anomalies are aimed at producing clarity and transparency.

Choice of font(s) is perhaps the primary aspect of text typography—prose fiction, non-fiction, editorial, educational, religious, scientific, spiritual and commercial writing all have differing characteristics and requirements. For historic material, established text typefaces are frequently chosen according to a scheme of historical genre acquired by a long process of accretion, with considerable overlap between historical periods.

Contemporary books are more likely to be set with state-of-the-art seriffed "text romans" or "book romans" with design values echoing present-day design arts, which are closely based on traditional models such as those of Nicolas Jenson, Francesco Griffo (a punchcutter who created the model for Aldine typefaces), and Claude Garamond. With their more specialized requirements, newspapers and magazines rely on compact, tightly-fitted text romans specially designed for the task, which offer maximum flexibility, readability and efficient use of page space. Sans serif text fonts are often used for introductory paragraphs, incidental text and whole short articles. A current fashion is to pair sans serif type for headings with a high-performance seriffed font of matching style for the text of an article.

The text layout, tone or color of set matter, and the interplay of text with white space of the page and other graphic elements combine to impart a "feel" or "resonance" to the subject matter. With printed media typographers are also concerned with binding margins, paper selection and printing methods.

Typography is modulated by Orthography and linguistics, word structures, word frequencies, morphology, phonetic constructs and linguistic syntax. Typography also is subject to specific cultural conventions. For example, in French it is customary to insert a non-breaking space before a colon (:) or semicolon (;) in a sentence, while in English it is not.


Readability and legibility

Readability and legibility are often confused. Readability is most often and more properly used to describe the ease with which written language is read and understood – it concerns the difficulty of the language itself, not its appearance. It is a psycholinguistic rather than a typographic issue. Factors that affect readability include sentence and word length, and the frequency of uncommon words.

In contrast, legibility describes how easily or comfortably a typeset text can be read. It is not connected with content or language, but rather with the size and appearance of the printed or displayed text.

Studies of legibility have examined a wide range of factors including type size, type design (for example, comparing serif vs sans serif type, italic type vs roman type), line length, line spacing, colour contrast, the design of right-hand edge (for example, justification (straight right hand edge) vs ranged left, and whether hyphenated). Legibility research was published from the late nineteenth century on, but the overall finding has been that the reading process is remarkably robust, and that significant differences are hard to find. So comparative studies of seriffed vs sans serif type, or justified vs unjustified type, have failed to settle the argument over which is best. (Serifs are the small cross-strokes at the end of letters in fonts such as Times; sans serifs fonts, such as Arial, are the ones without these cross strokes). Unfortunately, the fashion for legibility research was over by the time that revolutionary changes in printing and display technology (ie, laser printing and PC display screens) made it actually of potential interest.

Legibility is usually measured through speed of reading, with comprehension scores used to check for effectiveness (ie, not a rushed or careless read). For example, Miles Tinker, who published numerous studies from the 1930s to the 1960s, used a speed of reading test that required participants to spot incongruous words as an effectiveness filter.

These days, legibility research tends to be limited to critical issues, or the testing of specific design solutions (for example, when new typefaces are developed). Examples of critical issues include typefaces (also called fonts) for people with visual impairment, and typefaces for highway signs, or for other conditions where legibility may make a key difference.

Much of the legibility research literature is somewhat atheoretical - various factors were tested individually or in combination (inevitably so, as the different factors are interdependent), but many tests were carried out in the absence of a model of reading or visual perception. Some typographers believe that the overall word shape is very important in readability, and that letter by letter recognition (sometimes known as parallel letterwise recognition) is either wrong, less important, or not the entire picture. Studies that distinguish between the two models have favored parallel letterwise recognition, and the latter is widely accepted by cognitive psychologists (citation?).

Some commonly agreed findings of legibility research include: text set in lower case is more legible than text set all in upper case (capitals), presumably because lower case letter structures and word shapes are more distinctive, having greater saliency with the presence of extenders (ascenders, descenders and other projecting parts); regular upright type (roman) is found to be more legible that italics, contrast, without dazzling brightness, has also been found to be important, with black on yellow/cream being most effective; postive images (eg, black on white) are easier to read than negative or reversed (eg, white on black); the upper portions of letters play a stonger part than the lower portions in the recognition process; legibility is compromised by letterspacing, word spacing and leading that are too tight or too loose. Generous vertical space separates lines of text, making it easier for the eye to distinguish one line from the next, or previous line. Poorly designed fonts and those that are too tightly or loosely fitted can also result in poor legibility.

Newspapers, magazines, and periodicals

Typography is an element of all printed material. Headlines are often set in larger type to attract attention and are placed near the masthead. For example, USAToday uses a bold, colourful and comparatively modern style through their use of different fonts and colors; type sizes vary widely, and the newspaper name is placed on a coloured background. In contrast, New York Times use a more traditional approach with fewer colors, less font variation and more columns. Generally, every magazine, newspaper and periodical standardizes on a small collection of typefaces (fonts) to aid in the navigation of its content, to create a sense of familiarity, or create dramatic effects. Some publications such as The Guardian and The Economist, commission bespoke typefaces from a type designer, a specialist typographer who designs typefaces.


Display typography


Display typography is a potent element in graphic design, where there is less concern for readability and more potential for using type in an artistic manner. Type is combined with negative space, graphic elements and pictures, forming relationships and dialog between words and images.

Color and size of type elements are much more prevalent than in text typography. Most display typography exploits type at larger sizes, where the details of letter design are magnified. Color is used for its emotional effect in conveying the tone and nature of subject matter.

Display typography encompasses posters; book covers; typographic logos and wordmarks; billboards; packaging; on-product typography; calligraphy; graffiti; inscriptional and architectural lettering; poster design and other large scale lettering signage; business communications and promotional collateral; advertising; wordmarks and typographic logos (logotypes), and kinetic typography in motion pictures and television; vending machine displays; online and computer screen displays.

The wanted poster for the assassins of Abraham Lincoln was printed with lead and woodcut type, and incorporates photography.

Advertising

as long been a vital part of promotional material and advertising. Designers often use typography to set a theme and mood in an advertisement; for example using bold, large text to convey a particular message to the reader. Type is often used to draw attention to a particular advertisement, combined with efficient use of color, shapes and images. Today, typography in advertising often reflects a company's brand. Fonts used in advertisements convey different messages to the reader, classical fonts are for a strong personality, while more modern fonts are for a cleaner, neutral look. Bold fonts are used for making statements and attracting attention.

Inscriptional and architectural lettering

see also Epigraphy

The history of inscriptional lettering is intimately tied to the history of writing, the evolution of letterforms, and the craft of the hand. The widespread use of the computer and various etching and sandblasting techniques today has made the hand carved monument a rarity, and the number of lettercarvers left in the States continues to dwindle.

For monumental lettering to be effective it must be considered carefully in its context. Proportions of letters need to be altered as their size and distance from the viewer increases. An expert letterer gains understanding of these nuances through much practice and observation of their craft. Letters drawn by hand and for a specific project have the possibility of being richly specific and profoundly beautiful in the hand of a master. Each can also take up to an hour to carve, so it is no wonder that the automated sandblasting process has become the industry standard.

To create a sandblasted letter, a rubber mat is laser cut from a computer file and glued to the stone. The sand then bites a coarse groove or channel into the exposed surface. Unfortunately, many of the computer applications which create these files and interface with the laser cutter do not have many typefaces available, and often have inferior versions of typefaces that are available. What can now be done in minutes, however, lacks the striking architecture and geometry of the chisel-cut letter which allows light to play across its distinct interior planes.

Recently, there has been some rumbling in typographic circles over the proposed 9/11 memorial in New Jersey. Frederic Schwartz, the project architect, has chosen to render the names of the victims in "a familiar and easy-to-read typeface": Times New Roman. This democratic choice (the families of victims were closely involved with the design plan) could perhaps be echoing the controversial Emigre adage "People read best what they read most" in that Times is the default for many applications, but it seems to many that the choice is really a non-choice, or poor choice at best. These letterforms, originally designed for small print in newspaper setting, will be blown up to nearly four inches high.

Saturday, May 26, 2007

Pengaruh Typography terhadap Audiens

Dalam tulisan sebelumnya saya sudah mengungkapkan soal klasifikasi font serta beberapa sejarahnya. Pada tulisan kali ini akan saya jelaskan secara singkat bagaimana tipografi sebuah media mempengaruhi audiensnya. Dalam klasifikasi saya bagi menjadi beberapa klasifikasi :
  • Penggunaan Ukuran Font
  • Usia Pembaca
  • Kemampuan Membaca
  • Budaya Audiens
Masing - masing penjelasan tiap bagian sebagai berikut :
>Penggunaan Ukuran Font
Berdasarkan Tingkat Ukuran/Style Font
  • Taman Kanak - kanak ( tingkat pertama ) 24pt.bold
  • Tingkat Kedua 24pt.plain
  • Tingkat Ketiga-Keempat 18pt.plain
  • Tingkat Kelima 14pt.plain
>Usia Pembaca
Pembaca yang berumur >40 biasnaya mempunyai sedikit masalah dengan mata, teks dengan ukuran font paling kecil 14 pt lebih mudah dibacanya serta tidak memberatkan mata.Anak - anak khususnya yang baru belajar lebih mudah membaca tulisan yang lebih besar 24 pt serta di tebalkan agar mendapat kesan yang mendalam ini sengaja dilakukan agar dalam penyerapan huruf serta tulisan lebih cepat.

>Kemampuan Membaca
Kemampuan membaca mempengaruhi tipografi suatu media. Ini penting bahwa tipografi halaman tidak membedakan orang yang senang membaca atau yang tidak senang membaca. Desain suatu media tidak dibuat untuk desainer sendiri tetapi dibuat untuk menyampaikan komunikasi kepada orang lain. Perlu diperhatikan kebutuhan, kemampuan, dan Keterampilan yang dimiliki oleh audiens untuk membacanya.

>Budaya Audiens.
Perhatian juga perlu pada budaya audiens. Sebagai contoh budaya barat membaca dilakukan dari atas ke bawah dan dari kiri ke kanan, kemudian ke bawah. Tetapi budaya orang asia membaca dari atas ke bawah, kemudian ke halaman seberangnya. Kebiasaan membaca dari budaya berbeda-beda ini sulit diubah sehingga seorang layouter harus sangat-sangat memperhatikan hal ini.

King of Printers and Printer of kings

Gianbattista Bodoni

o one is obliged to share this elitist conception of typography. Gianbattista Bodoni (1740-1813), the most famous printer of his time, « king of printers and printer of kings », admired by the European princes for the solemnity of his books and by his alter ego for the elegance of his typefaces, is a keyman in the historical renewal of the « beautiful typography ».

Manuale tipograficoManuale tipograficoManuale tipograficoManuale tipograficoManuale tipografico


Jean-Baptiste BodoniHe was concerned not only with designing and making letters, but also with line layout, page harmony in terms of the choice and the size of face, the leading, the interplay of line lenght, spacing and column width. Bodoni brought printing back to Euclidean basics, where the interplay of black and white and the generous use of white space plays a major role. He recalled us if it is true that the book has a utilitarian function, it is also a masterpiece in itself.

This point said, it must be admitted that most of the readers and printed documents producers are ignorant of the typographic basics. The word typography refers to the art or skill of designing communication by means of the printed word. Because technology is changing rapidly with development of computer system, everyone working on a Mac or a PC has to practice the art of typography. With more or less talent…

The goal of this site is to present the principles of typography in a pedagogical way. It completes the typographic specimen: abc typography.

Dasar Excel Bagain I

Pengenalan Workbook, Worksheet, Baris,Kolom dan Cell Workbook Excel adalah program dari microsoft untuk mengentry data, menghitung, serta me...